To allocate stock against pending order by formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1765834%22%20slang%3D%22en-US%22%3ETo%20allocate%20stock%20against%20pending%20order%20by%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1765834%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei've%20tried%20lots%20of%20times%20to%20get%20a%20solution%20for%20my%20problem.%20but%20still%20not%20sorted%20that.%20here%20attached%20my%20sheet%20with%20three%20tables.%20in%20first%20table%20i%20have%20mentioned%20order%20number%20delivery%20date%20of%20that%20order%20number%20%2F%20required%20items%20order%20number%20wise%20and%20required%20qtys.%26nbsp%3B%20in%20my%202nd%20table%20i%20have%20mentioned%20bill%20of%20materials%20(%2029%20to%2032%20item%26nbsp%3Brequired%20for%20make%20one%20model).%26nbsp%3Bin%20my%203rd%20table%20i%20have%20mentioned%20items%20wise%20closing%20stock%20details.%20most%20of%20the%20items%20common%20for%20every%20order%20number.%20i%20need%20to%20allocate%20stock%20to%20against%26nbsp%3Border.%20i%20need%20to%20prioritize%20delivery%20date.%20as%20a%20example%20if%20i%20have%20800%20pcs%20of%20closing%20stock%20in%20one%20item.i%20have%20500%20wise%20two%20deliveries.%26nbsp%3B%20i%20need%20to%20allocate%201st%20500%20for%20first%20delivery%20and%20balance%20300%20for%26nbsp%3B%20second%20delivery.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20one%20can%20help%20for%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1765834%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

HI Guys,

 

i've tried lots of times to get a solution for my problem. but still not sorted that. here attached my sheet with three tables. in first table i have mentioned order number delivery date of that order number / required items order number wise and required qtys.  in my 2nd table i have mentioned bill of materials ( 29 to 32 item required for make one model). in my 3rd table i have mentioned items wise closing stock details. most of the items common for every order number. i need to allocate stock to against order. i need to prioritize delivery date. as a example if i have 800 pcs of closing stock in one item.i have 500 wise two deliveries.  i need to allocate 1st 500 for first delivery and balance 300 for  second delivery. 

Any one can help for me?

0 Replies