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
Highlighted
@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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies