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
It would be great if Sage could have a live exchange rate connected to a third party service - either updated daily/hourly etc for a live exchange rate for different currencies - rather than having to manually update.
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
In v2015 a euro invoice of €1038679 @ 0.725 shows a control account posting of £753042.46 In v2015 posting a payment for €1038679 @0.70 shows a control account posting of £727075.30 You would therefore expect the currency gain to be £753042.46-£72...
We use Sage 200 Standard. We would find it very useful to be able to upload the daily FX rates via CSV file. We use a large number of FX rates and we manually input them on a daily bases. Also as we have several companies, we need to do this in ev...
Is it possible to use more decimal places in the exchange rate box. If possible at least 8 places that our bank uses! Or a button to say how exact it is needed.
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
Change Euro to base in Accounting System Manager Sage 200
Could the Euro to base calculation used in Accounting System Manager for entering currency exchange rates be changed from 'euro to base' to 'base to euro'. ie £1 equals like non euro currencies.
