Stock Aging Report

[unais]

Dear Team,

Please Refer below document and please help me create Report

https://1drv.ms/w/s!AnNpoBzguZmmgeMcQJOWTuE06eSmXw

[unais]

Team any update

[unais]

team,

here is real data

MSEG_SAMPLE.xlsx

[unais]

@team please 

[v-xuding-msft]

Hi @unais ,

I'm not clear about your requirement. Can you please share the expected output?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[unais]

@v-xuding-msft 

my expected output in the second table marked with yellow.. refer 90+ values  its should be Zero as in table but while generating report its coming 10 

[unais]

here much in detailes,  i need to create new column (le say its ' X' )   and if the column 'movement type '  value is 'GRN (Stock in)' then the value of new column 'X' will be same 'Quantity '

if Movement type column value is ' Delivery (issue out )' then to find the oldest Record of  Same material ( first record) with 'X' not equal to Zero and Reduce the Value based on Quantity