Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Error in multicurrency during Purchasing>Transaction entry

Posted on by 400

We use GP2010 and have been experiencing a random problem with entering Purchasing  Transaction entries

We've been seeing this :

(Please excuse my crude redaction).

What you can see in the top line of this distribution report is that we seem to have an originating credit in Yen, with actual reporting currency credit in GBP with it using a 1-1 currency translation.  The system is then spitting out a very big rounding error (which is how we spotted the problem).

Worse still, entering the same numbers again does not lead to the same results - one of 'those' errors !

Anyone else seen any similar behavior or have ideas for a fix ?

I've  now got my finance team checking every journal line from a transaction entry before allowing them to be posted, but that's a damning indictment of a financial system and will be a joy to try to explain to our auditors !

Cheers, Alan

*This post is locked for comments

  • Alan Lee 2 Profile Picture
    Alan Lee 2 400 on at
    RE: Error in multicurrency during Purchasing>Transaction entry

    and exchange rate details on the same transaction :

     

    I also checked that all the two accounts involved were set up for JPY and they were; they wouldn't be accepted at the point of trying to save the transaction if they weren't.

    Cheers, A.

  • Alan Lee 2 Profile Picture
    Alan Lee 2 400 on at
    RE: Error in multicurrency during Purchasing>Transaction entry

    In originating currency it looks like this :

    6558.multicurrency3.gif

    and in reporting currency (GBP) it looks like this :

    Cheers, Alan

  • Olaf Laos Profile Picture
    Olaf Laos 1,890 on at
    RE: Error in multicurrency during Purchasing>Transaction entry

    What does the purchase transaction itself look like and what is the exchange rate being used on the transaction?

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans