RE: Inventory Dec Places are 3 and AR are 2
Hi Laura,
First, I don’t think the decimal settings in Inventory are causing a problem. When Inventory values are posted, they are always rounded to match the currency setting when flowing to other modules.
I think it’s more likely transactions were imported incorrectly. This is the most common reason I see records on the backend that don’t match the decimal place settings on the front end.
Here are your options:
- If you want to see the third decimal place on the front end, you’ll have to increase the appropriate currency decimal places to do that (Microsoft Dynamics GP >> Tools >> Setup >> System >> Currency). **Important to Note: This is a system wide setting AND GP will not let you change the decimal places ‘back’ once they’ve been increased – and for a good reason – GP now knows you have transactions in the system with more than 2 decimals and because of that it won’t let you change the decimals back to 2 because you won’t be able to ‘see’ the 3rd decimal on the front end (which is your current problem).
- You can find the transactions on the backend and test (in a test company) removing the 3rd decimal updating the amount up/down according to what it ‘should’ have been. Updating the data on the backend like that is not supported, but you could run a script similar to the following to find problem records:
SELECT * FROM RM20101 WHERE right (ORTRXAMT,3) <> 0 OR RIGHT (CURTRXAM, 3) <> 0 OR RIGHT (TAXAMNT,3) <> 0
Any of the of the fields that contain currency values may have more than 2 decimals worth of data, so you’d have to check those fields in your scripts to ensure you’re covering all bases. The script above is just a quick example.
Hope this is helpful!
Thank you for using Dynamics Communities,
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP