Dynamics GP2010 Currency Decimal point

(1) Share

Report

Posted on by Community Member

Hi Experts,

I am facing an issue on the functional currency decimal place in GP. Our management decided to have 5 Decimal points for our currency and I have made the changes from 2 to 5. We entered and posted many transactions under 5 decimal points. But My management wanted this to be 2 again. Could you please help me to change my currency decimal point from 5 to 2? I dont mind if the amount is changing from 1.15365 to 1.15.

thanks,

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Manikandan 2,845 on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

Hi,

Please refer the following link, hope this can help you.

http://support.microsoft.com/kb/865702

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Dynamics GP2010 Currency Decimal point

Hello UBaid

welcome to the community as this seems to be your very first post.

The issue represented with the currency decimals is usually ruled by the fact that you can not "decrease" the number of decimals once a currency is setup. This is usually stated through a warning message which pops up on the application level as you try to decrease the number of decimals.

Therefore, you will have to modify the number of decimals on the database level taking into consideration that any open transactions will not be automatically corrected.

The essence of the support article above is represented with the update statement below:

UPDATE MC40200 SET DECPLCUR=3 where CURNCYID='#CurrencyID'

A very important note to keep in mind is the number in your update statement. If you want to have a two decimal places, set the decimal places to equal (3) not (2). The index in the table is increased by one.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Suggested answer

Joshua Page on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

I would like to point out one big problem that can occur because of transactions already being in the system with the extra decimal precision in place.

You will need to go through and manually correct EVERY transaction that has extra precision in SQL, this also includes tax records booked against AP and AR, transactions in the GL, and a great deal of the other modules as well.

If every transaction is not corrected you will have issues. This includes reporting problems (reports will be off by a few cents), problems running bank rec (bank reconciliations will not balance), and documents will not move to history correctly in some modules. For example.

1) A payables invoice for $100.10734 is in the system.

2) You switch back to 2 decimal points but the document is not corrected. On the front end it appears as 100.10 even though the value is still 100.10734.

3) A payment is entered for the document and it is fully applied. The system is only going to look at the first two decimal places because of the change (100.10). The amount gets applied but the document will not move to history. This is because, even though on the front end it appears to be fully paid off, it's not. there is still an outstanding .00734 left on the document.

The supported solution in your situation is going to be to setup a new company, make the decimal place changes, import beginning balances and master records into the new company(s) and then use the originals for historical purposes. If possible you could also restore to before the decimal precision was changed to 5 and then renter the needed transactions.

If you have any questions please feel free to let me know!

Joshua

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

Hi Joshua,

As I understand the problem we are going to face on the WORK status transactions. So what if I train my end users to make the changes before they post any open transactions? do you think thiss will solve my problem?

Was this reply helpful? Yes No
Joshua Page on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

Unfortunately it's really hard for me to say one way or the other without looking at the data. Is there anything in history or open that has the extra precision or is everything since the extra precision was put in place still in work? What all modules have been used since the extra precision was put in place? Has a revaluation been ran since the extra precision has been put in place? There are a lot of variables and a lot of places records can become damaged when lowering the currency decimal precision after transactions have been entered with the extra precision.

This is why the only sure fire ways (and the only supported methods after transactions have been entered with extra precision) of preventing damage is to either restore to before the change occurred or create a new company and set beginning balances\ import master records.

If nothing has been posted (everything is still in work) you should be able to correct the records to the needed decimal precision on the front end and then use the KB referenced by another poster to bring the system back to 2 decimals, however there's no way to guarantee that something doesn't slip by.

You can use a scripts like the following two examples to check tables for extra precision as well to help determine the best course of action in your specific circumstance. The scripts can be altered to be used on pretty much every table as needed.

select TRXAMNT,* from CM20200 where TRXAMNT<> (ROUND(TRXAMNT*100,2))/100

select DOCAMNT ,* from PM30200 where DOCAMNT <> (ROUND(DOCAMNT*100,2))/100

If you have any other questions please feel free to let me know!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

Hi Joshua,

Its been more than few weeks that we used 5 decimal places. And many transactions are posted already.

I have used Finance, Sales, Purchase and Inventory Modules after making the changes. There are still many transactions under WORK status and OPEN status.

Restoring the Database with the previous date will not be possible for us as we have covered many days already.

Was this reply helpful? Yes No
Joshua Page on at

Like (0)

Report

RE: Dynamics GP2010 Currency Decimal point

Hello!

Thanks for the update!

Unfortunately the only fully supported method then will be to setup a new company and bring over the beginning balances and master records from the current companies, change the currency precision as per the KB, and then use the originals for historical purposes. An alternative would be to void all transactions with the extra precision that are in history and open, and delete\correct the ones in work but that would essentially be twice the work of just restoring so I doubt that would be an option either in your case.

At this point you will either want to use the supported methods or make the changes as per KB support.microsoft.com/.../865702 (posted by another user and expanded on by Mahmoud) and then see how off your records are\ make corrections in the tables as needed. The second option though has a high chance for problems and is in no way supported and I can't recommend using that route.

I'm sorry I don't have better news for you on this one.

Joshua

Was this reply helpful? Yes No