Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

sales amount rounding off issue

Posted on by 19,790

Hi All ,

Client uses standard cost for the all materials and defined the one item cost price as 29.45 and activated price.

User posted sales invoice for 80 Pcs , then system should update the financial cost amount as 2356 (80 * 29.45) in the inventory transaction form ,but it updated as 2356.33 and same amount posted to Consumption account (COGS account ) also .

Several transactions posted same way ,I did not understand why it is posting 0.33 extra amount and what would be cause to post that extra amount ,which setup ?

Thanks in advance.

*This post is locked for comments

  • NDK.365 Profile Picture
    NDK.365 33 on at
    RE: sales amount rounding off issue

    Hi Pioneers,

    Any help on this issue?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: sales amount rounding off issue

    Hi Lally,

    To be sure: check the field in SQL directly. Also standard might have sometimes a rounding bug.

  • lally Profile Picture
    lally 19,790 on at
    RE: sales amount rounding off issue

    Thanks Andre for  reply,

    Cost prices setup through the BOM Mass caluclation functionality as the items are finished goods.

    BOM mass caluclation is a standard functionality , no customization.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    RE: sales amount rounding off issue

    Hi Lally,

    Can you tell us how the price was entered in the system? Was it typed as 29.45 or did someone use the decimal field as online calculator? If someone used a calculation where the outcome was e.g. 29.4541, you will see only 2 decimals within AX, but the database could have more decimals. Posting logic is using the not rounded amount.

    These issues can also occur if someone for example used a script on the SQL database to recalculate some amounts. Or a customization did not round properly.

    Can you check the unit price of this item in the database directly? Then you know if this customer is a victim of not rounded database amounts.

  • lally Profile Picture
    lally 19,790 on at
    RE: sales amount rounding off issue

    Thanks for your support & replies ludwig,

    I have gone through the Costing sheet , All the lines Node type - Cost group only and cost group types are Direct materials and Direct manufacturing only.

    No overhead rates in the costing sheet , hence no surcharge.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: sales amount rounding off issue

    Hi lally,

    Please check

    Inventory management-setup-costing-costing sheets

    It might be the case that there is a surcharge node that adds a special % on top of your costs.

    Best regards,

    Ludwig

  • lally Profile Picture
    lally 19,790 on at
    RE: sales amount rounding off issue

    Thanks for the reply ,

    Could you please guide me the exact path which you refer or screen shot , so that i can check from my end ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: sales amount rounding off issue

    Hi lally,

    Can you check whether a surcharge has been specified in your costing sheet?

    It might be the case that a special % is added on top of your costs that you cannot directly see because this % is specified in the costing sheet.

    Can you check that and let us know if this is the underlying reason for the difference you identified?

    Many thanks and best regards,

    Ludwig

  • lally Profile Picture
    lally 19,790 on at
    RE: sales amount rounding off issue

    Hi All ,

    Any help on this issue ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: sales amount rounding off issue

    Hi lally,

    Could you share some screen prints of the inventory transaction? What would be interesting here is if you could also show the cost explorer form.

    Many thanks,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans