Hey all,
Trying to put a sheet together to track backorders, and was wondering if someone can give me a little direction.
In the sheet i have dates (cell A8-A10) when a purchase order is due, and based on how many units are coming in, to populate the ETA (cell J3-J6) of the corresponding sales orders. If there is not enough to cover that sales order, it would recognise it, and use the next date from the purchase orders.
Purchase order dates can change (A8-A10) as well as the quantities (E8-E10). Here's a layout of what it looks like now :
Thanks in advance.
Trying to put a sheet together to track backorders, and was wondering if someone can give me a little direction.
In the sheet i have dates (cell A8-A10) when a purchase order is due, and based on how many units are coming in, to populate the ETA (cell J3-J6) of the corresponding sales orders. If there is not enough to cover that sales order, it would recognise it, and use the next date from the purchase orders.
Purchase order dates can change (A8-A10) as well as the quantities (E8-E10). Here's a layout of what it looks like now :
Thanks in advance.