here attached my file which i need to allocate my stock.
in 1st table i have order number / delivery date / items and required qty . 2nd table i have mentioned closing stock . i need to allocate that closing stock to 1st table items on available qty column based on delivery date ( with delivery date priority- 1st qty for 1st delivery) any one can help me
@Sergei Baklan , here product duplicated for several delivery dates. that i need to be allocate. there are lot of items under one order number. i need to allocate it from closing stock based on delivery date