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 18

Alphabetical order, instead of id for adding members into companies or company access into users - sage 200 administration

When trying to add members into companies or company access into users its all in ID order and not in alphabetical name order. Would be good if this could be updated for quick adding purposes
Guest over 5 years ago in Companies 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

Create new company/database template

A lot of customer come across the need to create a new company / database using the same Report Categories / Chart of Accounts / Settings etc. from an existing company, however they don&t always have access to the original import files. For a ...
Guest almost 10 years ago in Companies 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

Narrative field to exist in trader ledger transaction tables

To display the narrative on reports and layouts, e.g. Purchase Remittance, requires the inclusion of the NLPostedNominalTran/NLDeferred NominalTran/NLPendNominalTran table(s) (depending on system configuration) by joining on the UniqueReferenceNum...
Guest almost 8 years ago in Database 0 Idea Accepted - Gauging Support

Expand SYSNominalAuditTrail table to Include SYSAccountingPeriodID

Expand SYSNominalAuditTrail table to Include SYSAccountingPeriodID as this would allow us to determine what Period a transaction was posted to which currently isn't possible in this area.
Andrew Siddles over 8 years ago in Database 0 Idea Accepted - Gauging Support

Data Cleansing

An option to allow the data to be cleaned in a single routine where the company can be sent back to just static data, for example All transactions removed leaving just Accounts with no balances, Stock Items with no Balances, Clear all Sales and Pu...
Andrew Siddles over 8 years ago in Companies 0 Idea Accepted - Gauging Support

Improve traceability in SYSFeatureErrorLogging when deleting a bin location

When a bin location is created against a stock item, SQL SYSFeatureErrorLogging shows &Add New Location for item: ABBuiltIn/15/0/2& If you amend the name of the bin, SQL SYSFeatureErrorLogging shows &Edit Location for item: ABBuiltIn/1...
Guest almost 11 years ago in Database 0 Idea Accepted - Gauging Support