Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Sales amount origin not correct in GL journal when using more than one currency

Posted on by 41

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

  • Suggested answer
    Ana Teles Profile Picture
    Ana Teles on at
    RE: Sales amount origin not correct in GL journal when using more than one currency

    Hi Teodora,

    Please check doc below with explanation and examples: learn.microsoft.com/.../marginal-base-field

  • TeodoraS Profile Picture
    TeodoraS 41 on at
    RE: Sales amount origin not correct in GL journal when using more than one currency

    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

  • Suggested answer
    Ana Teles Profile Picture
    Ana Teles on at
    RE: Sales amount origin not correct in GL journal when using more than one currency

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans