In the development of fiscal solutions within Microsoft Dynamics 365 Business Central, the VAT Amount Line table (Microsoft.Finance.VAT.Calculation."VAT Amount Line") has for years been a key component for calculating and breaking down VAT in sales and purchase documents.
However, Microsoft has announced that this table will be replaced starting with version 2025 wave 2, marking an important change for developers and partners.
What is the VAT Amount Line table?
This table contains lines that represent the taxable base amounts, VAT amounts, and VAT‑included totals, grouped by the combination of VAT Posting Group and Customer/Vendor VAT Posting Group. It is used in:
• Sales and purchase documents.
• Reports such as invoices and drafts.
• Subforms such as the VAT Specification Subform.
Key fields of the VAT Amount Line table
|
Field |
Description |
|
VAT Identifier |
Type of VAT applied. |
|
VAT Base |
Taxable amount on which VAT is calculated. |
|
VAT Amount |
VAT amount. |
|
Amount Including VAT |
Total amount including VAT. |
| VAT % |
Applied percentage. |
Replacement of the table in Business Central version 26.0
According to Microsoft’s official documentation, the VAT Amount Line table will become obsolete starting with Business Central version 26.0. Instead of using this table directly, developers will need to work with procedures based on the Source Record, which provide a more flexible and extensible way to obtain VAT calculation results.
Implications for developers
• Avoid direct dependencies: If your code depends directly on this table, consider migrating it to the new procedures.
• Review custom reports: Many reports use this table to display the VAT breakdown. They will need to be adapted.
• Prepare for migrations: Future versions of Business Central will remove this table, so the code must be refactored as soon as possible.
AL code usage example
Conclusion
The VAT Amount Line table has been an essential tool for VAT calculation in Business Central, but its lifecycle is coming to an end. It is crucial for developers to begin adapting their solutions and stay informed about the new structures that Microsoft will introduce to replace it in the 2025 wave 2 release.
For more information, you can consult the official Microsoft documentation, where the VAT Amount Line table, its current functionality, and its future replacement by Source Record-based procedures starting from Business Central version 26.0 are explained in detail.
ABD Consulting: Your expert partner in Business Central
At ABD Consulting and IT Solutions, we have a team of specialists in Microsoft Dynamics 365 Business Central ready to help you adapt your developments to version changes like this one.
Does your company or your client need support with migrations, report adaptation, or AL code refactoring? Contact us and we will help you be fully prepared for the 2025 wave 2 release with complete confidence.