Forum Discussion
Stock Aging Report
Dear Team, Please Refer below document and please help me create Report https://1drv.ms/w/s!AnNpoBzguZmmgeMcQJOWTuE06eSmXw
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
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