Forum Discussion

AAMD123's avatar
AAMD123
Regular Visitor
4 years ago

Stock Allocation by Order Date (FIFO)

I have a problem that I can't solve with Power Query. In the work there is an SAP report in which the orders of all the customers are, with quantities ordered, reference stock, date of the order, et...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi AAMD123 ,

 

I don't see how the results you want are calculated. Can you explain it?

 

Best Regards

Community Support Team _ chenwu zhu

 

  • AAMD123's avatar
    AAMD123
    Regular Visitor
    4 years ago

    v-chenwuz-msft thanks for your replay

     

    I try to explain to you by below capture,

     

    Let say an example in my sheet ( Report ) there are several products and per each product there are several orders against it,

     

    and these orders there are delivery dates for it,

    and I calculate the produc's stock as mention dublicated against each order,

    what i want is to allocate product stock per each order but should be allocating as per order delivery date

     

     

    I hope that I deliver my point