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

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

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

Can all dropdown menu size changes be retained

If you go into most forms, you have a dropdown menu (to select a code, item, customer/supplier), you can click and drag the corner to make this bigger. This is retained until you close the form. One of my customers wants this change to be retained...
Guest over 7 years ago in Menu 0 Idea Accepted - Gauging Support

Quick navigation to return to previous screen

Quick navigation to return to previous screen
Guest almost 5 years ago in Menu 2 Further Information Required

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

Re-instate Remove Favourites Option - eg removal of reports from Favourites

The only way to remove reports from Favourites is to edit the menu,not all users will have access rights to edit the menu.
Saeed Malik almost 8 years ago in Menu 0 Idea Accepted - Gauging Support

Can Sage 200 online be modified to allow you to add a .layout to the menus (currently this only works for reports so cant add layout reprints etc).

currently you can only add .report files and run these off the menus. nbsp;If you add a .layout this cant be seen by the program
Guest over 10 years ago in Menu 0 Idea Accepted - Gauging Support

To be able to hide Menu headers in Menu Design

In older version (Sage 200 2013 and prior), in the menu design mode you could hide individual modules (eg Business Intelligence, Price Book) by right clicking on the section and selecting Hide. On 2015 and above you cannot do this. If you untick t...
Guest over 8 years ago in Menu 0 Idea Accepted - Gauging Support