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

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

Balance ledgers - change the way you "fix" things (when you shouldn't!)

ONLY MAKE CHANGES TO THE STOCK FILE ALLOCATED QUANTITY WHEN YOU ASK IT TO "FIX" AND NOT WHEN YOU ASK IT TO "VALIDATE-ONLY" AND ALWAYS PRODUCT A REPORT FOR EITHER OPTION. By way of detailed explanation, yesterday I was advised to run Balance Ledger...
Guest about 10 years ago in Verify Data 0 Idea Accepted - Gauging Support

Balance Ledgers - Stock Items - Fixing and Reporting

1) Have Balance Ledgers always produce a report even if it's to say "No errors". It should also indicate if it was a Validate Only or a Validate and Fix. This is an audit trail and *may* be of use when discussing a problem with the Sage Support Te...
Guest over 10 years ago in Verify Data 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 over 7 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 about 8 years ago in Database 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