Daily report showing changes to the min and max set on item warehouse records.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
This alert will review all stock min and stock max changes to warehouse item records and send a daily report of changes. The report will also show whenever the effective quantity (quantity on hand + ordered - allocated) exceeds the stock max, where the stock max is greater than zero. The report only monitors warehouses that are either customer or technician types.
Run Schedule: Daily at 8:30 PM
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Quantity > Stock Max - Enter 'Exclude' to exclude the report from showing items where the effective quantity is greater than the stock max. Default option is 'Include', which will include these items on the report.
* * *
Alert Functionality
Alert Functionality
1. The warehouse type must be either Customer or Technician.
The alert creates a snapshot table of all item warehouse stock settings at the end of each day, and the report compares the values from the previous day to the current settings when it runs.
The stock min and max for the warehouse are set on the Warehouses tab of the item record:
Changes are reported if:
2. The stock max set for the warehouse on the item record does not equal the stock max from the previous day.
3. The stock min set for the warehouse on the item record does not equal the stock min from the previous day.
4. Variable W is set to 'Include', and the quantity on hand + ordered - allocated is greater than the stock max.
* * *
Best Practices & Tips
Best Practices & Tips
1. See documentation here on managing dead inventory.
2. We have documentation here on best practices for using the Inventory Logistics Console.
* * *
Related Alerts
Related Alerts
None at this time
* * *
0 Comments