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 17

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

SOP - New Return From Order allows you to return higher Qty than what was originally sold

I've noticed that Sage will allow you to create returns which then exceed the Qty originally sold. For example if you have a sales order which you sold 4x of something. You can create a return linked to the SO by using the "New Return From Order" ...
John Wilkins almost 2 years ago in New/Amend Return 0 Idea Accepted - Gauging Support

Sales Return - Copy from order to exclude order lines not despatched

In New Sales Return, when selecting to "Copy Order", only order lines with quantities that have been despatched should be copied. This is to prevent a return of an item or quantity that has not yet been despatched.
Kate Hutchinson over 1 year ago in New/Amend Return 0 Idea Accepted - Gauging Support

When doing a SOP Return it would be great for the system to generate a document that can be sent to the customer in the same way it does when you enter an order.

No description provided
Sarah Lancaster almost 8 years ago in New/Amend Return 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

Print Sales Returns

Our customers like us to issue an RMA number and returns paperwork. You can create a Sales Return in Sage200 but you cannot print it? Even though, for the most part, it would use the same template as the Sales Order? It would be super helpful to b...
Guest almost 6 years ago in New/Amend Return 0 Idea Accepted - Gauging Support

Save & Print SOP Returns

When entering a Sales Order onto the system, you have the ability to 'Save & Print' but this option is not available on SOP Returns.
Guest over 5 years ago in New/Amend Return 0 Idea Accepted - Gauging Support

Stock - Debit Note

Debit note, virtual return to impact the invoice value initiated by a customer e.g. when goods have been returned by the customer and they have discarded goods rather than returning them i.e. perishable items Similar to https://www.sagecity.com/gb...
Kate Hutchinson over 6 years ago in New/Amend Return 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