Forum Discussion
Need to allocated stock based on delivery date
Hi,
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
2 Replies
Ravindu94 , it looks like duplication of https://techcommunity.microsoft.com/t5/Excel/Need-to-allocate-stock/m-p/502959#M29995
- SergeiBaklan , 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
