Dynamics Community Forum Thread Details

Inventory Dec Places are 3 and AR are 2

Client has 3 decimal places in Inventory but GL is 2 places. They have a few transactions in AR that have balances that need to be written off however, it displays as 00 BUT there is a small balance of a few pennies.

How can I credit those balances if I can't see the 3rd decimal place?

Thank you.

Categories:

Microsoft Dynamics GP

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 3^rd 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 3^rd 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

Quick Links

Leaderboard