Hello everyone,
We are facing a bit of a strange issue.
When a general journal is created (amounts include sales tax=yes) and it contains more than one currency (example EUR and CHF), the sales amount origin in posted sales tax is incorrect for the currency that is entered second. Sales tax amount is always correct.
To explain in more detail: If we enter a line in EUR, the amount origin and posted sales tax is correctly calculated according to the sales tax code %.
If we enter a second line in CHF for example, the calculation of the posted sales tax is correct, but the sales amount origin is incorrect.
What I could gather from the calculation, the sales amount origin is being converted from CHF to EUR according to the given date's rate and then the percentage of the sales tax code is applied.
On the other hand, if we enter a journal where the first line is in CHF, the amount origin calculation is correct. Then, if we enter the second line in EUR, the amount origin is incorrect.
Basically, I think it is not based on a currency specification but rather on which currency is entered first in the journal.
I wasn't able to find a parameter that would influence this and I think this may be standard AX behavior.
I checked in D365, this is not the case there.
Has anyone experienced anything similar?
Regards,
Teodora
Hi Teodora,
Please check doc below with explanation and examples: learn.microsoft.com/.../marginal-base-field
Hi Ana,
After a more detailed analysis, I noticed that if I change the calculation method from Total to Line in GL parameters and set the marginal base to net amount per line instead of net amount of invoice balance on the sales tax codes, the issue does not appear.
Could you please elaborate what is the exact difference between these two types of calculations?
Regards,
Teodora
Hello TeodoraS,
I cannot see this behaviour in D365. I will leave this for the community to answer. Let's see if anybody has experienced the same and can advise you anything.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156