Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Inventory Dec Places are 3 and AR are 2

Posted on by 505

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.

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    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:

    1. 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).
    2. 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans