we need to fetch the initial date received of item irrespective of it's current organization.
As part of our business requirement, we need to fetch the initial date received of item on-hand quantity to calculate the inventory aging when it is currently stored in the inventory organization. As part of the report, we need to fetch the current inventory organization along with other details but the initial date received should be the first time when the that item was received (irrespective of which org it was received and where it is currently).
Attaching the sql query i am using and the output template in which data is required. Any help will be much appreciated.