Relationship Between Receiving Date And Delivery Date To Control FIFO

[tran780]

Hi Everyone,

I made a excel file using power pivot to control FIFO of inventory. To manage FIFO I care about "receiving date" but when I link receiving date with delivery date, the power pivot shows all delivery date but not link with receiving date
For example: Item A11 received on Aug 1st 200 pcs, on Aug 11th delivered 50 pcs of receiving date Aug 1st. Item A12 delivered 4 pcs on Aug 16th and doesn't has any A11 delivered on Aug 16th => the pivot also link A11 with delivery date Aug 16th as well (I just want A11 link with Aug 11th only)
I attached the file for your reference
Please help me
Thank you so much

 

[vletm]

tran780​

Please check Your For example ... how do it match with Your sample file?

 

[tran780]

tran780​

Please check Your For example ... how do it match with Your sample file?

It's just example, I modified content by the way. Please help me

 

[vletm]

... even original just example should be something real ...
If just example forget Power's
then I could offer something like below
based Your sample file.

... if based FIFO then it could look something like below...

'the oldest A11' goes out first or how?

 

[tran780]

Anybody can help me, please

 

[tran780]

... even original just example should be something real ...
If just example forget Power's
then I could offer something like below
based Your sample file.
View attachment 87788
... if based FIFO then it could look something like below...
View attachment 87789
'the oldest A11' goes out first or how?

Thank you but it could not help