Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Database
Created by Rustum Khedkar
Created on May 7, 2024

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 Transaction table. Similarly, SL, PL, CB transaction tables must have NL Period and Financial Year ID saved against each transaction.

In addition, if all types of transaction tables, as well as other such types of tables in Commercials module must be extended for additional 15-20 fields, this will help for customisation purposes.

Idea Benefit Reporting and data analysis/reconciliation would become much easier.
How do you solve for this problem today? Lots of manual work, and where required adding external databases/tables.