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 16

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

Invoicing List to deduct Credit Notes from total

In the Invoicing list when you select invoices they display a total on the bottom of the list. If you select a Credit Note it is shown as a positive value and added to the Invoice total when it should be a deduction.
Sandra Wallace over 2 years ago in List 1 Idea Accepted - Gauging Support

Invoicing list Paid flag / credit taken flag

it would be really useful to see from the invoicing list which invoices are unpaid/Credits not taken
Victoria Hanley about 2 years ago in List 0 Idea Accepted - Gauging Support

Add a note or memo from the invoicing list screen and a flag to say there are notes present

It would be useful to add / view the notes memo notes added in to the Sales Transaction enquiry screen from the invoicing list, this would speed up entering any queries
Victoria Hanley about 2 years ago in List 0 Idea Accepted - Gauging Support

Show the Sales Order number in the columns on the Invoicing List screen

I often get given only the Sales Order number and on the other side reports are run giving me the sales invoice number and I would like to be able to quickly match the two numbers.
Beverley Wintle almost 2 years ago in List 2 Will not implement

Invoicing Module List - Analysis Codes

Would be great to have the Analysis Codes Fields available as columns on the Invoicing List Similar to how they are available in the Sales Order List I've managed to create a new Workspace of the invoice list to show these columns, but this is not...
Paul Daly almost 7 years ago in List 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

Introduce an invoice status of paid

When in the invoice list it would be really helpful to either have the status change to paid when it is paid or the option to have a date paid column selectable. This would make it easier when viewing this screen to be able to see all invoices out...
Guest about 8 years ago in List 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 almost 9 years ago in Database 1 Idea Accepted - Gauging Support