Overview
The iSupply snapshot logic question involves whether open order quantities are included when calculating new replenishment orders. The default configuration does not include open orders in the Suggested Delivery calculation, which is defined as "Max − (Current Inventory + In‑Transit/ASNs)." However, custom or Dynamic Min/Max (DMM) formulas can include open orders if explicitly referenced. This behavior is not clearly documented, leading to potential configuration issues or misunderstandings.
Information
Issue
Understanding iSupply snapshot logic for open orders.
Default Behavior
The default Suggested Delivery calculation does not include open orders:
Suggested Delivery = Max − (Current Inventory + In‑Transit/ASNs)Custom/Dynamic Min/Max (DMM) Formulas
- Open orders can be included if the formula explicitly references them.
- Example: Custom formulas may use variables like open order quantity or user-defined fields (UDFs).
Potential Causes for New Orders Exceeding Max
- Container Rounding: Rounding to full container size can exceed max.
- Order Methods: Some methods add forecasts or prior open orders, affecting totals.
- Timing/Status Filters: Only certain statuses/time windows are counted.
Configuration Recommendations
- Verify DMM agent configuration to ensure open orders are included if needed.
- Review and adjust formulas to properly account for open orders.
Verification Steps
-
Check DMM Agent Configuration:
- Navigate to i-Manager → Tools or Dynamic Min/Max menu.
- Review the FORMULAS tab for active agents.
- Ensure open order variables are included.
-
Review Formula Syntax:
- Confirm formulas subtract open orders correctly.
- Example:
Suggested = Max - (CurrentInventory + OpenOrders)
-
Verify Snapshot Data:
- Query snapshot table to confirm open_order_quantity is populated.
-
Check Order Statuses:
- Ensure open orders have correct status values for inclusion.
Note: If further clarification is needed, consider escalating to engineering for a detailed review.
Frequently Asked Questions
- How do I know if open orders are included in my replenishment calculations?
- Check your Dynamic Min/Max agent configuration to see if open order variables are included in the formulas. The default behavior does not include them unless specified.
- What should I do if new orders are created even when inventory + open orders exceed max?
- Review your DMM formulas to ensure they properly account for open orders. Consider container rounding and order method impacts as well.
- Can I configure iSupply to include open orders in the default calculation?
- Yes, by using custom or DMM formulas that explicitly reference open order quantities, you can include them in the calculation.
- What if the documentation is unclear about this behavior?
- If the documentation does not provide clarity, consider escalating the issue to engineering for a more detailed analysis and confirmation.
Priyanka Bhotika
Comments