Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by

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
    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
    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
    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,978 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,821 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans