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

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

Sage 200 Standard - BOM allocation

We need to be able to allocate stock from a BOM and build when the item is physically built. Without this function we have only 2 options (1) build at the start but if the physical build is then not for a few weeks the physical stock quantities fo...
Guest about 3 years ago in Processing 0 Idea Accepted - Gauging Support

Opportunity to substitute items out of stock when processing a BOM to an alternative

Would it be possible to amend BOM to give users the opportunity to substitute any component items which are out of stock to use an alternative when processing the build, rather than users having to go into the BOM record and change it manually?
Guest over 9 years ago in Processing 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

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

Add a Deselect option for unassigning batch/serial numbers from a BOM Build

Currently, when building a BOM within Record Built Items, serial numbered components are auto-selected. Sometimes this is fine but sometimes it is not correct. Although you can manually change these if you have 600 (in the case of my client) they ...
Michelle White almost 8 years ago in Processing 0 Idea Accepted - Gauging Support

BOM rounding errors in units of measure

This can create error in works order processing and needs resolving
Guest about 10 years ago in Processing 0 Idea Accepted - Gauging Support

Stock return to deal with by products

A means to send by-products to stock. If we modify a build item and a modification done, i.e. the removed component could be re-used, through the build process and the bill of materials, effectively have two complete build parts. We buy a bike, we...
Guest over 3 years ago in Processing 0 Idea Accepted - Gauging Support