Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

ADD A NEW IDEA

Clear

Ideas

Showing 21

Change date on posted invoice, journal and bank transaction

Is it possible to change the date of an invoice after it has been printed and posted in Sage 200 Professional, also change the wrong date on a bank transaction instead of having to do a payment/receipt to correct, and also change date on journals....
Janine Holloway 9 months ago in Corrections / Corrections / New/Amend Invoice / New/Amend Order / Payment/Receipt 0 Idea Accepted - Gauging Support

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

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

An undo/reverse button for all transactions in Sage 200

I work for an Education Trust so we use the Sage 200 software. I have recently seen that Sage 50 offers an undo button which means that a payment or receipt, which has been posted incorrectly, can be instantly reversed with no problems. I was just...
Guest almost 5 years ago in Corrections / Corrections 2 Idea Accepted - Gauging Support

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

Correcting allocated purchase and sales invoices

Allow posting of changes to a purchase/sales ledger even when it has been allocated? Sometimes whilst reviewing the month end invoices we find some which have been posted to an incorrect nominal - if they have already been allocated we have to una...
Guest over 4 years ago in Corrections / Corrections 0 Idea Accepted - Gauging Support

Correct Transaction routine to update Audit Trail

When amending the Reference and 2nd Reference fields on a SI or PI via the Correct Transaction routine, this is not updated through to the Audit Trail table. Would be useful if this could be updated to reflect the SL or PL transaction.
Kathleen Leask about 6 years ago in Corrections / Corrections 0 Idea Accepted - Gauging Support

Ability to Reverse Settlement Discount That Was Entered Accidentally

Our customers would like the ability to Reverse Settlement Discount that was entered accidentally. At the moment it doesn't appear in the list in Sales Ledger or Purchase Ledger Adjust Transactions Reverse Transaction. The only way to do it is to ...
Guest over 8 years ago in Corrections / Corrections 0 Idea Accepted - Gauging Support

Edit Foreign Currency Transactions

To be able to edit/correct Foreign Currency Transactions; payments, receipts, invoices etc
Guest almost 3 years ago in Corrections / Corrections 0 Idea Accepted - Gauging Support

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 over 8 years ago in Database 1 Idea Accepted - Gauging Support