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
Hi Pioneers,
Any help on this issue?
Hi Lally,
To be sure: check the field in SQL directly. Also standard might have sometimes a rounding bug.
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.
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.
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.
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
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 ?
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
Hi All ,
Any help on this 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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156