PGI value capture from GRN actual value not average price.
In our system we maintain the below process.
Sales Order - Purchase Order - MIGO - MIRO - Outbound Delivery - PGI - Billing.
Purchase Order assign with Sales Order. so, when we get GRN the stock value capture against Sales Order.
We maintain Moving Average Price.
When we get PGI then it capture the Stock value against Material Moving Average price. My requirement is, how it capture the same value (Stock) from MIGO.
Example in current process :
Sales Order SO value Purchase Order PO Value MIGO Value
SO01 1000 PO01 600 600
SO02 1200 PO02 800 800
when we get PGI against SO01 & SO02 the PGI stock value 700 for both case. but out requirement, for SO01 it will be 600 & for SO02 it will be 800.