Skip to main content

Hello, I would like to have in a specific line the discrepancy between the price order and the invoice price pour the inventory purchase order.

So i would like to have in the line M18 the purchase price and in the line M19 or M20 the discrepancy.

 

I think that a parameter is missing but i don’t know where.

 

Thank for your help,

Hi @FPOC 

having these M19 / M20 postings depend on settings in inventory part. 

Please attach a screen with inventory part window and tab Misc Part Info.

What values there are set in parameters Inventory Valuation Method and Supplier Invoice Consideration ?

 

Best regards,

Małgorzata


 


Hi, Fabien
Look at your part definition, “supplier invoice consideration” field. 
“Transaction based” value means that difference between order and invoice price is to be integrated into inventory value.

System will not then book variation using M19/M20 postings; instead, it will create additional postings in inventory transactions (M1/M10) to adjust receipt value to invoiced value; and then will trigger inventory revaluation process recalculating weighted average and adding adjustments postings to subsequent inventory issues. This way, difference between invoice and receipt will be booked as receipt revaluation from inventory transaction transfer voucher, and not from invoice voucher.


Reply