The Idler Part Number functionality allows for the setting up of a global part number list for Idlers, which can then be used when configuring individual conveyors to assign specific idler part numbers to frame ranges on that conveyor, or have a default part number that is assigned to all carry or return idlers on a conveyor. It also allows for reporting on how many of each part is needed for rectifying idler failures on a conveyor.
Configuring part numbers is a two step process:
- Setting up the part numbers and associated information in Administration, and
- Adding part numbers to individual conveyors in Asset Management.
Setting Up Idler Part Numbers
Log into the web application and follow the left slider menu to Administration > Asset Management > Idlers (Rollers) > Idlers.
Within the Idlers popup screen, you can either create individual idler part number entries or import multiple part number entries.
Creating Idler Manufacturer Part Numbers (MPNs)
In the Idlers pop-up, select Create and populate text fields with idler specifications.
The MPN, Business and Type fields are all mandatory. The remainder are optional. Once all applicable information has been added select the Save icon on the left of the row. These records are created at a Business level, so all available part numbers should be entered. At this stage the usage (e.g. what set they belong to) of the idler isn't important, only the MPN, Business, Type and any other available specifications.
Importing Idler Part Numbers
In the Idlers pop-up, select Import. Select import template from the Idler Part Number Bulk Import pop-up.
Open the Import Template, which is an Excel file, and enter your idler information. The MPN, Business and Type fields are mandatory. The remainder are optional. Once all the available information has been added, save the spreadsheet. A sample spreadsheet is attached to this article, but you should always download the most recent one using the import template link.
Back in the web software, on the same Idlers pop-up screen, select Import again if the pop-up is not showing. Either drag the saved file to the upload area, or select Import Lookups and browse for the file.
Adding Part Numbers to Individual Conveyors
Follow the left slider menu to Navigation> Asset Management> To Required Conveyor > Idlers (Rollers). Select Create, choose the Position or Position Group from the drop downs. Select the MPN from the Idler drop down. This displays the MPN and idler type. The remaining fields will then populate with the information saved when configuring the MPN. A local Site/SAP Part Number can be added. This is the part number that is shown in reporting, so if there is no different number, the MPN should be used in this field as well.
Adding Frame Locations to Part Numbers
The Idler that is most frequently used on that conveyor can be left without a frame range (Frame and to numbers). It will be the default selection, as shown below with the 3 Roll Trough & 2 Roll V-Return. For other idlers on the system, add the frame locations using the Frame and to fields. An example of this is shown below as well, with a 3 Roll Rubber Impact used on frame 3 to frame 11, and a Flat Return used on frames 1, 42 and 66.
If you wish to edit the frame locations or part numbers for a location, select the Edit icon on the left side of the record. Edit as required and save again.
Once this configuration has been done, when an idler failure is created for that conveyor, the part number will show on the Work Management - Idlers Report beside the failure, and the Picking List will show the quantity of each idler needed.