Home

Need to allocated stock based on delivery date

%3CLINGO-SUB%20id%3D%22lingo-sub-503398%22%20slang%3D%22en-US%22%3ENeed%20to%20allocated%20stock%20based%20on%20delivery%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-503398%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehere%20attached%20my%20file%20which%20i%20need%20to%20allocate%20my%20stock.%3C%2FP%3E%3CP%3Ein%201st%20table%20i%20have%20order%20number%20%2F%20delivery%20date%20%2F%20items%20and%20required%20qty%20.%202nd%20table%20i%20have%20mentioned%20closing%20stock%20.%20i%20need%20to%20allocate%20that%20closing%20stock%20to%201st%20table%20items%20on%20available%20qty%20column%20based%20on%20delivery%20date%20(%20with%20delivery%20date%20priority-%201st%20qty%20for%201st%20delivery)%20any%20one%20can%20help%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-503398%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-505858%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20allocated%20stock%20based%20on%20delivery%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-505858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329467%22%20target%3D%22_blank%22%3E%40Ravindu94%3C%2FA%3E%26nbsp%3B%2C%20it%20looks%20like%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FNeed-to-allocate-stock%2Fm-p%2F502959%23M29995%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FNeed-to-allocate-stock%2Fm-p%2F502959%23M29995%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-510392%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20allocated%20stock%20based%20on%20delivery%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-510392%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%20%2C%20here%20product%20duplicated%20for%20several%20delivery%20dates.%20that%20i%20need%20to%20be%20allocate.%20there%20are%20lot%20of%20items%20under%20one%20order%20number.%20i%20need%20to%20allocate%20it%20from%20closing%20stock%20based%20on%20delivery%20date%3C%2FLINGO-BODY%3E
Ravindu94
Contributor

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
@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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies