Ideas

Showing 12

SQL Triggers

I know it is not allowed to be able to use SQL Triggers on the Sage 200 databases but I believe this should be considered

Andrew Siddles over 1 year ago in Database 2 Will not implement

9 VOTE

The Nominal Transaction table must have VAT Code/VAT Period ID fields against each NL Posting

When it comes to reconciling VAT Transactions for a submission period Vs Nominal posted transactions, there is no direct link between the two. It will be useful to have each transaction's VAT Code, VAT Type, VAT Period ID stored in Nominal Transac...

Rustum Khedkar over 1 year ago in Database 0 Idea Accepted - Gauging Support

3 VOTE

Prevent duplication of URNs

On very rare occasions you may see duplicate URNs posted to the Sales Ledger due to environmental issues (deadlocks etc), this could possibly be prevented by setting a constraint on the SLPostedCustomerTran URN field field in the database to preve...

Tim Critchley over 1 year ago in Database 0 Idea Accepted - Gauging Support

5 VOTE

User correct DateTimeCreated in the database!!!

We create a number of reports in Sage based on data directly from SQL. We use the DateTimeCreated field in a number of tables to provide KPIs and time triggered reports. DateTimeCreated has always been generated from the Server time that SQL is ru...

Guest almost 9 years ago in Database 1 Idea Accepted - Gauging Support

4 VOTE

Retrospective Stock Write Off

Currently, the stock write off is only entered on the date that you enter the adjustment. If any adjustment is entered, an additional journal then has to be entered if you wish to have the date, say, in line with a month-end. However, it would be ...

Daniel Burke over 9 years ago in Write off stock 0 Idea Accepted - Gauging Support

4 VOTE

Flag imported items in the SQL Database

This will assist support on the product, I needed to on several occasions try to find how data has got into the system when a customer is sure the data was not imported. It would be great if when a item is imported into sage via one of the standar...

Guest over 10 years ago in Database 0 Idea Accepted - Gauging Support

1 VOTE

Add Stock

The stock 'Write Off' routine has the option to create categories to change which nominal account the write off gets posted to but the 'Add Stock' routine does not. Please can you add the categories feature to the 'Add Stock' routine.

David Selvage about 3 years ago in Write off stock 0 Idea Accepted - Gauging Support

3 VOTE

Add stock addition categories as a mirror of stock write-off categories

Customer with a significant number of stock items and product groups would like the ability to record stock addition categories, to allow them to analyse the reasons for the stock additions. The functionality would simply mirror the current functi...

graham.anderson@datelgroup.com graham.anderson@datelgroup.com about 10 years ago in Write off stock 0 Idea Accepted - Gauging Support

2 VOTE

Update Free Stock quantity when writing off stock

A customer has noticed that the 'Free stock quantity' is now static when writing off stock. It brings through the current Free stock when you enter the Stock Item Code and Warehouse but doesn't update when you enter the amount you want to write of...

John Dunn about 7 years ago in Write off stock 0 Idea Accepted - Gauging Support

1 VOTE

Narrative field to exist in trader ledger transaction tables

To display the narrative on reports and layouts, e.g. Purchase Remittance, requires the inclusion of the NLPostedNominalTran/NLDeferred NominalTran/NLPendNominalTran table(s) (depending on system configuration) by joining on the UniqueReferenceNum...

Guest almost 8 years ago in Database 0 Idea Accepted - Gauging Support

Please enter your email address

FILTER BY FIXED IN VERSION

FILTER BY CATEGORY