I'm looking to create a script that will run through data on a table that will allocate incoming stock of a part to customers Back order and give a stock balance before moving on to the next row.
please see the below table where I have the customer orders and the purchases that we ordered to supplier.
I need to check the ordered parts then check the incoming orders then allocate the quantity based on FIFO then put the ETA date accordingly.
