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
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
It seems that the supplier alerts in 2023 R1 aren't automatically displayed in Generate Purchase Orders - there is just an Alerts column in the Shortfall Details screen which has to be clicked to show the alert(s). See screenshot. So if the alert ...
Geoff Turner
almost 3 years ago
in Generate orders
0
Idea Accepted - Gauging Support
Generating purchase orders using supplier part number/supplier stock code
We have two Item Codes that use the same part number/supplier stock code but they are actually the same item. We sell them at different prices to the same customer and wish to continue doing so and would like to continue with the two different Ite...
Guest
about 6 years ago
in Generate orders
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
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
