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. |