Good morning all. I need some help understanding this request. This might be something that already exists.
The first part went: “Please run a report for us that shows component inventory report filtered with last used date or touch date so we can identify dead inventory.”
So for this I just used an existing aging inventory report and just sorted by touch date, and filtered on PartClass.Description = ‘Components’
After generating that report, the request was “Can you look at the component inventory data and advise what can be made from them based on available BOM/Methods?”
This is where I got stuck. At Jose’s suggestion, I looked at PartMtl instead. So for instance, the very first record in my original report looks like this:
If you look at this in Method Tracker, you get these unpainted parts:
So do I actually want a query off of PartMtl, sorted by touch date, with the Revisions where they are used? Does anything like this already exist in Epicor?