An alert for warehouses and bins that have had no activity in the last W months.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
Inventory control can sometimes be a challenge because it's obvious when you need a new Warehouse or Bin, but not as obvious when you no longer need an existing one. This alert will provide you with a list of Warehouses and Bins that have seen no activity (stale) in the past W months. You have the option to choose to have it review ALL warehouses (and their bins) or only TECH warehouses.
In addition to providing warehouses and bins that are stale, you will also know how many months since last used. Very beneficial in deciding how to further evaluate the information provided.
Run Schedule: Monthly on the 3rd
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Number of Months - The number of months with no activity to trigger the alert.
Variable X: Tech or All - Enter 'Tech' to only report on Tech warehouses or 'All' for all warehouses.
* * *
Alert Functionality
Alert Functionality
1. When variable X is set to 'Tech', the alert will only trigger for warehouses where the type = Technician:
2. The alert checks for any transactions into or out of the warehouse and bin and reports on those warehouses and bins where the last transaction in more than the number of months set in variable W.
* * *
Best Practices & Tips
Best Practices & Tips
1. Run the ID75 Dead Inventory on the warehouse(s) on the alert to determine if the parts in the warehouse are stale.
2. Are these warehouses linked to sales reps/techs who are no longer active in your company? Maybe there's inventory in them that needs to be transferred, or if there's no inventory, the warehouse or bin could be made inactive.
3. Cleaning these up will make your data selection(s) easier, your reports process faster, and could yield Dead Inventory that needs to be written off.
4. You may also find discrepancies to clean up.
* * *
Related Alerts
Related Alerts
ID75 - Dead Inventory
* * *
0 Comments