Dear Experts,
Please refer attached file,
Column A Contains my Product Code,
Column B Contains Customer Seq. by FIFO
Column C Needed Qty by Individual Customer
Column D Current Stock Against the Product Code (Please Be Informed, Product Code 123456789 – Available Stock is 4100 Pcs and by lookup it is duplicated against all same Product Code)
Column E – Looking for a Support as below
Against Each Product Code Line, Current Stock to be distributed as per Customer Needed Qty
Example: -
Product 123456789 Customer A Need 152 Pcs, 4100 Pcs can be distributed to this line.
The Balance stock of 3948 Pcs to be allocated to next line in a same Product Code
The Expected Results is been manually updated in Column F
Please review and provide your valuable feedback on the same!
Thanks & Regards,
Rajeshkukmar R
Bookmarks