web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

(0) ShareShare
ReportReport
Posted on by 2,438

Hi All, 

I have 920 transactions that I have successfully uploaded into AX through GL journal (screenshot 1).  When I tried to validate the journal, I had the currency error (screenshot 2).  My journal is EUR currency.  I have the currency set up (screenshots 3 & 4).  All of my transactions have the dates range within October 2019.  Screenshot 4 has a start date on the exchange is October which covers all dates within October, or does it matter since it's a GL journal instead of the AR or AP.  Does anyone have a suggestion on how I can fix this exchange error? Thanks so much!

2860.Journal.png

5228.CUrrency.png

Currency-set-up.png

Currency-exchange.png

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hi Kim,

    Why did you enable the triangulation parameter?

    About the rounding issue: Can you test the following - ideally in a demo/test environment first:

    Make use of the post and transfer button/function. This usually takes care of the rounding and transfers the 'problematic' vouchers into a new journal. Once those vouchers are available there, try to post them once again.

    If this does not work then double check the data in your excel document that you upload. Please ensure that the data in excel are rounded to two decimal places before uploading.

    Would be great if you could test and let us know the result.

    Many thanks,

    Ludwig

  • lmai Profile Picture
    2,438 on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hi Ludwig,

    Triangulation is not applicable for us, but the box Reference currency for triangulation is checked as default.  I'm not sure if there is a calculated/think through default.

    There was a post suggesting to check on another currency that you don't use as Triangulation and come back to the EUR and check it off.  It did not do that for EUR. It didn't take off the checkmark Reference currency for triangulation for EUR.

  • lmai Profile Picture
    2,438 on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Should I convert the data from EUR to USD (Parent company's currency is USD), then upload the data as USD?  

    If the Oanda is used, the checkmark on the Reference currency for triangulation on or off wouldn't matter, correct? 

    Thanks!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    I see.

    Have you tried the 'post and transfer' option and/or tried to apply rounding in Excel before uploading the data?

  • lmai Profile Picture
    2,438 on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hi Ludwig,

    The rounding issue is now resolved

    The accounting currency and reporting currency differences issue remains.  I have used the Post and transfer option, but "No vouchers in the journal can be posted or checked".   So it didn't work.  

    Thanks

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hi Kim,

    So after uploading the Excel data you still get the message that the vouchers don't balance.

    Is that right?

    Can you share details of the new error message as well as details of the uploaded transactions?

    Many thanks,

    Ludwig

  • lmai Profile Picture
    2,438 on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Yes, this is right.

    All the transactions on the 2nd screenshot are in EUR.  The accounting currency for this legal entity is EUR.  The reporting currency is USD.  Thanks

    415734.Error.png

    415734.Error.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hello Kim,

    I can see that you use a single voucher (No. GL...31) for recording multiple invoices.

    The way how the voucher is setup does not seem to make sense to me because in the invoice tab we have a special field for the invoice number field where you should add the number that you added in the descriptive field.

    Also the offset account is missing.

    Rather than posting all against a single vendor account, post each line - that is each individual invoice - in a separate voucher.

    The accounting standards I am familiar with do not allow posting multiple invoices in a single voucher.

    Would be great if you could change your upload file correspondingly and try that again with a different way how those invoices are recorded.

    Best regards,

    Ludwig

  • lmai Profile Picture
    2,438 on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hi Ludwig,

    Although this journal has many lines, it's actually one journal which adds up to:

    AR  495,609.60 (debit)

    VAT 11,025.6 (debit)

    Sales  506,635.20 (credit)

    It's the same way we upload the Payroll transactions.  All debits equal credits.  The system creates one voucher.  We just want to get the data in the system to run a report as a test.  Thanks

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Transaction currency and reporting currency are different when I tried to upload a GL journal entry.

    Hello Kim,

    You are right with the voucher and your amounts might seem to balance before posting.

    Yet, common accounting practice does not allow recording different invoices with the same voucher.

    What kind of transactions are these?

    Do you record invoices somewhere outside and need to create the vouchers in AX?

    Before continuing with this kind of transaction / voucher, I would highly recommend that you double check with your accounting team whether this kind of posting is ok for them.

    Also think about how you want to pay the invoices.

    Do you plan to pay them later on in a vendor payment journal?

    If this is the case then the way how this voucher is uploaded won't allow you doing that!

    Best regards,

    Ludwig

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans