Skip to Content
0
S S
May 29, 2020 at 04:30 PM

Link Purchase order and sales order

48 Views Last edit May 29, 2020 at 04:38 PM 2 rev

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