Dynamics 365 Business Central: Financial Management - Calculate taxes for plastic and sugar

Business Central introduces new capabilities in excise journals to calculate tax amounts for plastic and sugar based on legislation requirements that use weight, content, and transaction quantities as the basis for excise taxes. The new Excise Tax Type , Qty. for Excise Tax , and Excise UOM fields on the Item Card and Fixed Asset Card pages let you define material composition and the relevant quantity basis for each product or fixed asset.

For tax on plastic, Business Central calculates excise quantities by aggregating item ledger entries from purchases, positive adjustments, production output, assembly output, and fixed asset ledger entries related to an acquisition. To determine the tax basis, it multiplies the calculated quantity by the defined excise quantity.

For tax on sugar, Business Central uses Item ledger entries from sales and negative adjustments to determine the total sugar content for the reporting period. The tax basis is derived by multiplying the excise quantity per unit by the total quantity sold or consumed.

These calculations generate the core data needed to report tax on plastics and sugar, while the specific country‑level tax declaration forms remain out of s…