Skip to Main Content
Sage 200 UKI Ideas Portal
ADD A NEW IDEA

Database

Showing 13

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 6 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 7 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 over 9 years ago in Database 0 Idea Accepted - Gauging Support