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
Nominal transaction reports to include a correct brought forward figure
Customers migrating from Sage 50 to Sage 200have requested the ability to run a nominal transaction report that includes a correct brought forward value of transactions prior to the period running the report from. Brought forward values are shown ...
Keith Carver
over 3 years ago
in Nominal
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
To have a Nominal report showing Net & VAT amounts
Business scenario: HMRC VAT inspection - HMRC requires a break down of what transactions I have processed claiming VAT on for a specific Nominal Code. In Sage 50 Accounts the Financials/ Transactions area gives me this breakdown. I can then filter...
Guest
almost 9 years ago
in Nominal
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
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
Nominal Reports - Transaction Listing report needs to show PO numbers please.
For ease of controlling department budgets, and explaining where the money has gone, it would be good to have a nominal transaction report that also included PO numbers / supplier name showing Budget, actual expenditure and commitment to give an o...
Guest
over 8 years ago
in Nominal
1
Will not implement
The facility to add Nominal codes onto VAT Reports to aid reconciliation between Sales & VAT Outputs (not always the same thing)
Auditors amp; HMRC Vat inspectors always want to see the reconciliation between Sales Invoices & Credit Notes which are not always coded to Sales within the P&L; these are sometimes posted to the credit of costs e.g. recharges, but the inv...
Guest
over 9 years ago
in Nominal
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
over 7 years ago
in Database
0
Idea Accepted - Gauging Support
