News:Improved handling of VAT percentage in Queries
| Published | 2025-03-13 |
|---|---|
| Module | Accounting |
| Version | 546W2503 |
| Revision | 0 |
| Case number | CORE-6764 |
Improved handling of VAT percentage in Queries
The method to calculate VAT percentage in the Queries programs for Client- and Supplier's invoices has been improved.
The reasoning for the change is that with the earlier method, rounding differences could occur in the calculation.
For the column for VAT percentage to display correct values, all VAT rates used for both input- and output tax needs to be registered in Base registers, General, VAT.
Please contact KASE Technologies support desk if you need help with doing this
Below, both the old and new method for calculating VAT percentage in Queries, are described.
==== Changes in handling of VAT for Client invoices ====
Earlier calculation method
The VAT was calculated based on how much was posted to accounts for output tax in Base registers, G/L, Parameters.
The VAT rate was then determined from the VAT amount's share of the total invoice amount.
This could then lead to rounding differences.
For example, a VAT rate of 25% would be displayed as 25,01%.
New calculation method
The system runs through all VAT rate codes in Base registers, G/L, Parameters that starts with the companys country code (two-digit code) and retrieves posted VAT for all accounts connected to these.
The system then runs through all invoices which do not have the main VAT rate (VAT rate surcharges in Base registers, G/L, Parameters) or 0% VAT.
For these invoices the VAT is calculated with the VAT rates (Amount excluding VAT * all applicable VAT rates).
If the calculated VAT amount conforms with the invoice's posted VAT amount, the matched VAT rate is displayed.
If no VAT rates matches exactly, * is displayed as the VAT rate.
==== Changes in handling of VAT for Supplier's invoices ====
Earlier method
VAT amount is retrieved from the invoice.
The VAT rate was then determined based on the VAT amount's share of the total invoice amount.
Also here, rounding differences could occur.
For example, a VAT rate of 25% could be displayed as 25,01%.
New calculation method
The new method for Supplier's invoices functions similary as for Client invoices:
The system runs through all invoices that do not have the Main VAT rate or 0% VAT.
For these invoices, the VAT is calculated by using the VAT rates (Amount excluding VAT * all applicable VAT rates).
If the calculated VAT amount conforms with the invoice's VAT amount, the matching VAT rate is displayed.
If no VAT rate matches exactly, * is displayed as the VAT rate.
