Picking the last issued date for an item in a report

[Shabeeha]

Hi
I need to pick the last issued date for an item and display it in a report.
It can be dispayed as part of the level break header or as column in the main section of the report.
The last issue date of an item would probably be the Max transaction date of documents type II in the item ledger, but how can i fetch this data item in a ERW ?
thanks for your help!

 

[aidy]

There are a couple of ways that you could experiment with.

1. Use an index on date which is sorted descending, this way the 1st II record will be the most recent.

Or

2. Loop through all II records storing the most recent date in a variable.

Hope this helps