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 14

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 about 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

SOP Reprint Invoices - Add Button to Amend Customer Order Number

eg The customer order number is not known or is missed when the order is created. Once the invoice has been posted you cannot change the Customer Order Number, Some organisations will not pay invoices until a purchase order number is shown on an I...
Saeed Malik over 10 years ago in Reprint Invoice 0 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

Reprint Invoices

When reprinting invoices in SOP, you open the form select a single invoice to print and then it closes the form Can it either: 1) allow select of multiple invoices to print or 2) return to the reprint invoice form after printing the invoice
Guest about 7 years ago in Reprint Invoice 0 Idea Accepted - Gauging Support

SOP Reprint Invoices - Keep window open after printing

As you can only select an individual Invoice number / date / order number / customer account - if you need to reprint multiple invoices that do not have anything in common, it would be handy to keep the window open after printing an invoice so the...
Guest almost 10 years ago in Reprint Invoice 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

Modification of Invoices

Could we have a feature that enables us to modify and reprint invoices without it displaying copy invoice at the top? We sometimes have to add last minute items or even remove them if the customer changes their mind, but once the invoice has been ...
Guest about 2 years ago in Reprint Invoice 0 Idea Accepted - Gauging Support

Select invoice layout when re-printing invoices

Having more than one invoicing department, it would be extremely useful to be able to choose the invoice layout when reprinting the invoices from the Sales Ledger enquiry screen - as canbe done when originally printing the invoices fromSOP.
Guest about 9 years ago in Reprint Invoice 0 Idea Accepted - Gauging Support

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