aging report

[kohlivinayak]

Hi Members

I have a scenario where i have recieved certain goods and have issued them in two different table, i want to show as of current date how qty of a certain item is pending and is pending from how many days.

GR Table

Item   |    Date       |   QTY

AA      |    jan 1      |   100

AA      |    jan  7     |    100

Issued Table

Item   |    Date      |   QTY

AA      |    jan 10    |    50

want to show

Item   |    Date       |  Pending QTY

AA      |   jan 1       |    50

AA      |   Jan 7       |   100

There are many more items and we are working in direct mode so some of the functions do not work

Thanks in advance

[v-chuncz-msft]

@kohlivinayak,

You may start from the code generated by Quick measure Running total.

[kohlivinayak]

Can you explain how running total will help ?