Business requirement
1. There is a purchase order 450001 in transit for total 100 qty for material X at lets say $10.
There are 10 sales orders, each for qty 20 for Qty 200. I can give 100 qty at current price lets say 11 to 5 sales orders on FIFO basis.
2. Now, I have a next purchase order 450002 for the same material for 100 qty at $12 and my pricing would increase to $13 for remaining sales order Qty.
Is there any way to tell these remaining 5 sales orders will have increased pricing because landed cost is more.
Right now, we have to do this manually because of recent COVID-19 situation there is a lot of Price change from vendors and we have to keep changing our sales order pricing.
Thanks in advance