topic Re: Stock Allocation by Order Date (FIFO) in Developer

Stock Allocation by Order Date (FIFO)

AAMD123 — Sat, 02 Jul 2022 18:06:32 GMT

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, etc.

Kindly find below snapshots for my report:

- This Relationship for 2 sheets:

- This Piovate Table to All Orders against 1 product with the requested delivery date:

- THIS IS an EXAMPLE of WHAT I NEED TO SHOW UP

Note: I tried to find a solution such my case, but I tried but not succeed 😞

https://community.powerbi.com/t5/Desktop/Stock-distribution-by-order-date/m-p/1976772#M747937

Re: Stock Allocation by Order Date (FIFO)

v-chenwuz-msft — Tue, 05 Jul 2022 02:37:50 GMT

Hi @AAMD123 ,

Please copy your formula here, some parts are not visible. Please share your files that do not contain sensitive information. Or a table, not a picture.

Or give some sample data and expected results like the case of the link you provided.

Best Regards

Community Support Team _ chenwu zhu

Re: Stock Allocation by Order Date (FIFO)

AAMD123 — Fri, 08 Jul 2022 22:51:33 GMT

Hi Chenwu,

Thanks for your replay and support !!

Please find the link for the file so you can check it

https://docs.google.com/spreadsheets/d/1V38oEuXf2SeGk_Cy86ThH1q1yMcP6EDE/edit#gid=1035349882

Best regards,

Re: Stock Allocation by Order Date (FIFO)

v-chenwuz-msft — Tue, 12 Jul 2022 03:04:36 GMT

Hi @AAMD123 ,

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

Best Regards

Community Support Team _ chenwu zhu

Re: Stock Allocation by Order Date (FIFO)

AAMD123 — Tue, 12 Jul 2022 20:03:20 GMT

@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

Re: Stock Allocation by Order Date (FIFO)

adoble0214 — Thu, 22 Dec 2022 03:15:00 GMT

I am also needing this type of allocation assistance!