Scheduling Min/Max Range Reports Based on Location and Alert Mechanism in purchase order
Requirement for scheduling Min/Max range reports for item availability based on location daily. Big wants to define minimum and maximum range values for each inventory item in the inventory details section or inline-level. When the available quantity at a specific location drops below the minimum range, a background report should be generated and emailed daily. In addition to the existing requirements of setting minimum and maximum range values for each inventory item and generating daily availability reports, BigRig has requested an alert mechanism to notify users when they attempt to purchase quantities that exceed the maximum range, considering the available quantity.
Deliverable
As a part of the feature implementation, two new fields, “Min” and “Max,” will be added to the item record. Users will have the ability to input values in these fields representing the desired minimum and maximum quantity for each item.
A search functionality will be implemented to identify items whose location based available quantity is less than the value specified in the Min field. The system will then schedule notifications to the respective persons responsible for these items, alerting them about the need for replenishment .
This feature enhances inventory management by proactively identifying items that fall below the desired minimum threshold and automating the notification process to ensure timely action is taken.
Alert Mechanism in purchase order
After adding an item to the purchase order, we will check the specified location at the line level. We’ll retrieve the available quantity at that location, along with the values from the “min” and “max” fields. Based on this information, we will determine the required quantity. If the quantity added in the purchase order does not match the required quantity, an alert will be shown to notify the user.
Assumptions
The proposed solution is based on the following assumptions:
- We are considering only Inventory items for scheduling process.
- The alert mechanism in the purchase order will be validated in both the editing and creation contexts.
- There will be no restriction for adding the line items inside the purchase order.
Estimated Time
14 hours