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
over 1 year ago
in Database
0
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
over 1 year ago
in Database
0
Idea Accepted - Gauging Support
It would be helpful for this to be updated for v2018, the last revision was v2015 eg Data Capture Document Links have been added to the database and it would be useful to understand the underlying data structure
Saeed Malik
over 6 years ago
in Database
0
Idea Accepted - Gauging Support
When you access the Sage 200c help files the web pages relate to the latest of 200c. So a user running Sage 200c Summer 2017 will see the same help files as a user running Sage 200c Summer 2019. As there are features that are present in the later ...
Nat Evans
almost 6 years ago
in Version Specific
2
Will not implement
I understand there is the understanding the Sage 200 Database pdf which is very usefully however it is mainly an overview, what would be really useful is the full database documentation on table relationships as well as documentation on the tempor...
Guest
over 10 years ago
in Database
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
over 8 years ago
in Database
1
Idea Accepted - Gauging Support
When we download files from the Sage web site, it is luck or judgment if the file has downloaded correctly. Can we have either a SHA1 or SHA256 file or hash value supplied with each download so that we can check/verify that a download is complete?...
Guest
over 3 years ago
in Downloads
0
Will not implement
I am new to sage and there had been a gap between our training and using sage, one of the features I liked on sage was the F1 help function and videos, some of these need updated as I followed the help menu in posting journal entries. The video us...
