Change in Amount after posting Item journal

subhadynamics

Hi All,

We have entered the records in Item Journal with Entry Type as Negative Adjmt. After that we have manually changed the Amount and posted the Item Journal. When we check the Item Ledger Entry and Value Entry table , the Cost Amount (Actual ) is not showing the same Amount which we have entered in the Item Journal before posting .


For Eg. We have entered Qty = 5000 and Unit Price = 50 and Amount is 25,0000.

Then we manually change the Amount as 25,2505.75 and the Unit Price is changed according to the Amount entered automatically. But After Posting the Amount in Item Ledger and Value Entry is updated as 25,2515.

Please let us know what is the reason and how we can resolve the above issue.

Thanks in Advance.

Subha

violeta

You have another purchase on the same date and costing method is average?

subhadynamics

Hi ,

Please let me know where do we setup this Costing Method.

Thanks

violeta

You setup costing method on Item card, Invoicing tab

GeoRa

When you post Negative Adjmt. is not necessary to insert unit cost / amount because this values will be calculated by NAV using CMP, FIFO, LIFO etc. (same for sales, internal consumption, transfer shipment etc).

Even if you manually insert unit cost for Negative Adjmt. in Item journal after posting and runing Adjust Cost - Item Entries NAV will modify again the value (additional lines in Value Entry) based on Costing Method.