Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lally kani]

Hi All ,

In General ledger , we have the rounding off option to general , Sales orders , purchase orders and Prices .

Rounding off setup for prices as mentioned below.

Prices :

Rounding Price : 0,0001  Rounding form : Normal

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 .

Cost prices setup using BOM mass calculation functionality as these are Finished goods. Item price does not have the additional decimals after .45 , The cost price is 29.45 only .

There are no more than 2 decimals .

Any help why it calculates 0.33 extra ?

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 ?

——————————
Lally
——————————

[Girish V. Nair]

Hi Lally,

Please check how the cost price have been input in AX, for example if it is manual update or it is uploaded.  

Please check the cost price available in InventItemPrice table in SQL database directly.  It could be that the values are stored with more than two decimals in the SQL database but displayed only as two decimals in AX.

When the cost amount is calculated, AX will take the values available in SQL database and hence the values are different. May be that could be one of reason. Pls do check

Regards,

——————————
Girish V
Senior Advisory Consultant
Tectura India

——————————
——————————————-

[Dave Phillips]

Hi Lally –

I agree with Girish V’s line of thinking. Let me add this….

There are other causes as well.  Are these manufactured items?

Thanks….Dave

Scripts to check for extended decimals.

select VERSIONID, PRICE from INVENTITEMPRICE

where floor(PRICE * 100) != (PRICE * 100)

select VERSIONID, PRICE from INVENTITEMPRICEACTIVE

where floor(PRICE * 100) != (PRICE * 100)

select VERSIONID, PRICE from INVENTITEMPRICESIM

where floor(PRICE * 100) != (PRICE * 100)

select ITEMID, INVENTDIMID, POSTEDVALUE from INVENTSUM

where floor(POSTEDVALUE * 100) != (POSTEDVALUE * 100)

——————————
Dave Phillips
MSFT Senior PFE
Microsoft
Fargo ND
——————————
——————————————-