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
Is there a quicker way of viewing all operations and components of a BOM?
Currently, to check the operations times and components list for a BOM, I have to make a construction report which is quite long winded and difficult to read. All I need is a table with operations and there times and a list of all the components. ...
Guest
over 2 years ago
in New/Amend BOM
0
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
Is it possible to have something similar to Excels find and replace option for Bill of materials, so you could update a components on all BOM with the same component Instead of finding all the BOMs that need updating and manually changing each one?
Guest
over 2 years ago
in New/Amend BOM
1
Already Exists
BOM View Cost Breakdown Roll up Sub Assemblies into Cost Headings option available for reporting
At the moment the option Roll up Sub Assemblies into Cost Headings is available on the BOM View Cost Breakdown screen. When customers are wanting to report on this on mass they tend to go to the Costing History (With Breakdown) report however this...
Guest
over 10 years ago
in New/Amend BOM
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
