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 :
Microsoft Dynamics GP (Archived)

Strange Currency Problem

(0) ShareShare
ReportReport
Posted on by 4

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

I have the same question (0)
  • Suggested answer
    Nancy Chavez Profile Picture
    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.

  • Suggested answer
    Bron Profile Picture
    4 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.............

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans