Forum Discussion

unais's avatar
unais
Helper V
6 years ago

Stock Aging Report

Dear Team,   Please Refer below document and please help me create Report   https://1drv.ms/w/s!AnNpoBzguZmmgeMcQJOWTuE06eSmXw  
Need Help
unais's avatar
unais
Helper V
6 years ago

@team please 

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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's avatar
    unais
    Helper V
    6 years ago

    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's avatar
      unais
      Helper V
      6 years ago

      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