Got a tech that insists on holding on to parts they haven't used in a year, even though they have no models they service that use that part but you can't easily prove that? This alert sends a pdf report to the technician of parts to turn back in. Report shows warehouse/bins so warehouse staff know where to restock the items. Also shows what quantity of equipment in the technicians' territory and/or the entire company MIF can use the "stale" item as well as Min/Max settings for tech's warehouse. Note: we look at all items used and not related items, so a new part not yet used could generate a false positive.
This process requires that ID72 be running as well.
ID # | Description | Notes | Required |
---|---|---|---|
ID72 | Technician CarStock All Inventory Report, highlights stale items | ID72 shows inventory not used including what equipment in the field use it, ID694 requires the tech to turn back in unused inventory. The proc rpt_ZCJ_ICInvValCurDetailTech is required from 72 and must have @vs_mode = 'StaleEmail' to drive the report proc for 694 | Yes |
ID872 | Technician Overstock Pull Back Report | ID872 is a bring back report for OVERSTOCK items, ID694 is bring back for NOT USED. | No |
ID434 | Subreport for ID72 | Required subscription to subreport for SSRS Version | Yes |
ID435 | Subreport for ID72 | Required subscription to subreport for SSRS Version | Yes |
Juice Agent - Powered by GPT4 and augmented with everything we know