Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Strange Currency Problem

(0) ShareShare
ReportReport
Posted on by 2

Okay - client is on V10 - has been for quite sometime - had a power outage over weekend which apparently has resulted in this problem.........

Symptom -

In Sales Transaction entry the system is not displaying any currecny decimal places. Everything is in whole numbers - very strange!

I began troubleshooting and quickly noticed it was system wide - Inventory transactions also displaying whole numbers..........then I went into the functional currency setup - Tools > setup > financial > multicurrency.

The functional currency is $USD. Reporting Currency is $USD. The exchange rate was showing/displaying as 1.'000000 (instead of 1.000000)

I assumed that an end user must have inadvertently changed - I thought I had found the problem. I went to change it back...................and this is very strange...........the system would not let me!!!

I then drillback to the Functional Currency setup screen - I notice there is no ISO code for the $USD - I enter USD and click save - go back to the multicurrency screen - and now the system will let me make the change..........

I make the change from 1'0000 to 1.0000 and I assume I'm home free......

Everything worked for a couple of hours - several sales orders successfully entered. User calls back - the problem is back...

Further troubleshooting - my solution - that is change something on functional currecny setup screen - allows me to correct/change exchange rate on multicurrency setup - but as soon as I close GP client and re-login the problem re-occurs........

Has anybody seen anything like this? I am opening a case with MBS - but I would love to hear if anything similar has occurred..........

What can cause system to automatically change the exchange rate field on multicurrency setup? By the way - the SQL table that stores that value always has the correct value - 1.00000. In other words. it's the form which is changing - without human intervention!!!!!

Appreciate any thoughts on what might be causing this..........

 

 

*This post is locked for comments

  • Suggested answer
    Bron Profile Picture
    Bron 2 on at
    Re: Strange Currency Problem

    FYI - The problem turned out to be a 'blank' currencyid record in the master currency setup table. I think it got created by checklinks - once I deleted it - everything worked perfectly...........

    Still don't know a blank record in that table effects the 'form' so to speak...........but it does...........

    At least we're back in business..........

    Thanks Nancy for the reply.............

  • Suggested answer
    Nancy Chavez Profile Picture
    Nancy Chavez 195 on at
    Re: Strange Currency Problem

    Hi

    Have you check the regional settings on the computer? If a power outage ocurrs, maybe the configuration on regional settings change and its taking the decimals in other way.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans