web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Ana Teles Profile Picture
    on at

    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.

  • TeodoraS Profile Picture
    on at

    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

    Hi Teodora,

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans