Microsoft Dynamics AX (Archived)

sales amount rounding off issue

(0) Share

Report

Posted on by lally

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

All responses (16)

Answers (0)

NDK.365 33 on at

Like (0)

Report

RE: sales amount rounding off issue

Hi Pioneers,

Any help on this issue?
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 19,790 on at

Like (0)

Report

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 Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 19,790 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 19,790 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 19,790 on at

Like (0)

Report

RE: sales amount rounding off issue

Hi All ,

Any help on this issue ?
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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