Hi everyone,
I am searching for al solution/workaround to post sales tax depending on the delivery date.
The situation is as follows:
In month of March, the sales tax for an Item has to be calculated with 16% (100 EUR net + 16 EUR Sales Tax = 116 EUR gross)
Due to a change in sales tax by legal authorities, the sales tax increases in April to 19 % (100 EUR net + 19 EUR Sales Tax = 119 EUR gross)
So for the same customer/item-relation, the tax is different depending on the delivery date.
I have seen, that there is a possibility in the sales tax codes to give date ranges for the tax percentage:
This helps when posting the invoice: the system finds the correct percentage to post - oriented by the incoice date or document date.
So far, so good.
The problem in this case is, that in the current year, there have to be two different accounts for the tax itself (e.g. 1234 VAT Payable 16% and 5678 Vat Payable 19%) and two different reporting codes in the sales tax declaration (e.g. line 5 for sales tax 16% and line 10 for sales tax 19%).
As the described solution in giving date ranges for different percentages in one and the same sales tax code, there is no possibility to distinct between two different tax accounts nor two different reporting lines in the tax declaration.
Is there any smart solution or workaround how the system automatically adapts the correct sales tax percentage and uses different main accounts/reporting lines (except creating two differnt lines in the sales order for the same item)?
thanks in advance!
18.04.2021
Microsoft Update 10.0.15 PU42 brougt out an interesting-looking feature for this:
https://docs.microsoft.com/en-us/dynamics365-release-plan/2021wave1/finance-operations/dynamics365-finance/tax--using-packing-slip-date-as-tax-calculation-date
