Thank you so much for this solution, it really helped me at work and saved alot of time and space. We didn't need to develop an on hand inventory table thanks to this measure
• ex3. We have 3 rolls of fabric A in stock, 2m, 3m, 8m. We have 4 SOs for fabric A come in, all for 3m. ○ The 3m roll fulfills 1 SO, with 0m remaining ○ The 8m roll fulfills 2 SO, with 2m remaining ○ This leaves 2 rolls each with 2m remaining for total quantity 4m. As the final SO is for 3m we would be able to take the order (CTP sees as available despite known fault at picking) but above report would only highlight issue once SO 3 has been fulfilled
very clear but in reality you don't have have only the Ins you have both the INs and Outs so it is bit difficult to create the report when you have both,i have tried i failed but your i am able to come with results, my wish is that you example with both in and out , Thanks in Advance
Thank you so much for this solution, it really helped me at work and saved alot of time and space. We didn't need to develop an on hand inventory table thanks to this measure
Excellent! I am glad to hear that.
Great model. But what if you have a start inventory already in the warehouse?
I love it - thanks - beautifully avoiding now my previous, much heavier technique - Thanks!!!
• ex3. We have 3 rolls of fabric A in stock, 2m, 3m, 8m. We have 4 SOs for fabric A come in, all for 3m.
○ The 3m roll fulfills 1 SO, with 0m remaining
○ The 8m roll fulfills 2 SO, with 2m remaining
○ This leaves 2 rolls each with 2m remaining for total quantity 4m. As the final SO is for 3m we would be able to take the order (CTP sees as available despite known fault at picking) but above report would only highlight issue once SO 3 has been fulfilled
very clear but in reality you don't have have only the Ins you have both the INs and Outs so it is bit difficult to create the report when you have both,i have tried i failed but your i am able to come with results, my wish is that you example with both in and out , Thanks in Advance
truhan u i was looking for this solution many days , this works with acumumulate volume too
Thank you very much
How would i know that I only have 2 x 2 m left? - or that i don't have enough?
DAX is so complex. Isn’t there a simpler way ? Since only MS has it, surely there are easier alternatives ?