Skip to main content
Question

HOW USE M18 AND M20


Forum|alt.badge.img+5
  • Do Gooder (Partner)
  • 7 replies

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,

3 replies

Malgorzata Palatynska
Hero (Employee)
Forum|alt.badge.img+10

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


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Partner)
  • 7 replies
  • May 20, 2022

 


Forum|alt.badge.img+16
  • Hero (Customer)
  • 712 replies
  • May 20, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings