Announcements
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.
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:
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156