Hi,
I'm using GP 2015.I want 2 values after decimal but t displays 4 . I doesn't look good.So is there anyway I can change decimal place to 2 instead of 4 and save the record.
Thanks in advance.
*This post is locked for comments
Usually, GP allows you to increase your currency decimal places, so you can go from 4 to 5 in your case, but doesn't allow to decrementing. The reason behind this is simple: if you already performed transactions and you happen to have recorded some that 3 or 4 decimal positions, you would run into rounding issues and reports -- especially trial balances -- won't tie.
If you still insist that this is what you want to do, you will need to update the MC40200 system database table as follows:
USE DYNAMICS; -- replace dynamics for the name of your system database if different
GO
UPDATE MC40200 SET DECPLCUR = 3 WHERE CURNCYID = 'Z-US$' -- replace for the correct currency ID
GO
Once you complete this, you will need to run check links on your Multicurrency tables:
- From the System series, choose the Multicurrency System Setup
- From the Financial series, choose Multicurrency Setup
You will need to run check link on the latter table group for each company in your system
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,253
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
