Reduce The Number Of Records In The tblAudit Table
Over time the tblAudit table within the Sage200Configuration database can grow to be an unmanageable size. Within System Administrator it would be helpful if there were an option to be able to only keep entries which are x days old. Ideally this w...
Alison Alison
almost 2 years ago
in Event Logs
2
Idea Accepted - Gauging Support
The Nominal Transaction table must have VAT Code/VAT Period ID fields against each NL Posting
When it comes to reconciling VAT Transactions for a submission period Vs Nominal posted transactions, there is no direct link between the two. It will be useful to have each transaction's VAT Code, VAT Type, VAT Period ID stored in Nominal Transac...
Rustum Khedkar
almost 2 years ago
in Database
0
Idea Accepted - Gauging Support
When reviewing what has happened via SysFeatureAreaLogging in would be very useful to have an additional field that stores the primary reference for the related action e.g. for Action "Sage.MMS.SOP.ConfirmDespatchForm" the SO No field could be added
Andrew Dunn
about 1 year ago
in Event Logs
9
Idea Accepted - Gauging Support
On very rare occasions you may see duplicate URNs posted to the Sales Ledger due to environmental issues (deadlocks etc), this could possibly be prevented by setting a constraint on the SLPostedCustomerTran URN field field in the database to preve...
Tim Critchley
almost 2 years ago
in Database
0
Idea Accepted - Gauging Support
It would more helpful to have the parent SysFeatureAreaLoggingID recorded against child forms Without it, we cannot do a query that joins child forms to parent forms
Andrew Dunn
about 1 year ago
in Event Logs
1
Idea Accepted - Gauging Support
Following on from Add Reference, it would also be really useful to have the SessionInfoID (as per the config DB) as per of the logged data We see data inconsistency problems usually related to uses doing an action and reversing it multiple times (...
Andrew Dunn
about 1 year ago
in Event Logs
0
Idea Accepted - Gauging Support
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
Split the Sage 200 System Event Logs into Daily Files for Troubleshooting and Archiving.
Split the Sage 200 System Event Logs into Daily Files for Troubleshooting and Archiving. At the moment theSage200SelfService,Sage200SecuredServices,Sage200Services are cumulative, are the only file in each of these folders and can grow to GB's. Ca...
Jeff Smith
about 6 years ago
in Event Logs
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
