- This topic has 3 replies, 2 voices, and was last updated 1 year, 3 months ago by Terri V..
-
AuthorPosts
-
27 March 2025 at 2:35 pm #8684TMTodd M.
Does anyone have recommendations for the Reorder Quantity Expression in the Item Planning Review Setup? We just started to use the Item Planning Review and the currently configuration is avg_daily_usage for the expression and that doesn’t make sense to us.
31 March 2025 at 7:03 am #10312TVTerri V.Insight WorksHello Todd,
Following are two Knowledge Base articles with additional information:
- https://kb.dmsiworks.com/knowledge-base/enhanced-forecasting-worksheet-customize-the-predicted-value-and-change-item-planning-expressions/
- https://kb.dmsiworks.com/knowledge-base/expression-evaluator/?seq_no=2
Thank you,
14 August 2025 at 7:37 am #10477TMTodd M.When using the suggested default setup, we get the following error.
Error message:
The variable ‘AVG_DAILY_FORECAST’ is not defined in the expression ‘avg_daily_forecast * lead_time_days’ at position ’19’. Available are: AVG_DAILY_USAGE,USAGE_QTY,DAYS,LEAD_TIME_DAYS,[UNIT PRICE],[UNIT COST],[STANDARD COST],[LAST DIRECT COST],[INDIRECT COST %],[REORDER POINT],[MAXIMUM INVENTORY],[REORDER QUANTITY],[CALC. REORDER QUANTITY],[INVENTORY],[SALES (QTY.)],[DISCRETE ORDER QUANTITY],[MINIMUM ORDER QUANTITY],[MAXIMUM ORDER QUANTITY],[SAFETY STOCK QUANTITY],[ORDER MULTIPLE],[RESERVED QTY. ON PROD. ORDER],[RES. QTY. ON PROD. ORDER COMP.],[RES. QTY. ON REQ. LINE],[DAMPENER QUANTITY],[OVERFLOW LEVEL],[PLANNING TRANSFER SHIP. (QTY).],[PLANNING WORKSHEET (QTY.)],[QTY. ON PURCH. RETURN],[QTY. ON SALES RETURN],[CALC. DAYS],[LEAD TIME DAYS],[AVG. DAILY USAGE],[AVERAGE USAGE],[IWXEPP AVERAGE USAGE],[PERIODS],[TOTAL QUANTITY],[CALC. AVERAGE DAILY USAGE],[CALC. SAFETY STOCK QUANTITY],[CALC. REORDER POINT],[CALC. MAXIMUM INVENTORY],CALC. SAFETY STOCK QUANTITY14 August 2025 at 8:23 am #10478TVTerri V.Insight WorksHello Todd,
‘AVG_DAILY_FORECAST’ is not a variable that is available on the Item Planning Review Setup, as it is only available on the Enhanced Forecast Setup.
You can further review which variables are available per page by following our Knowledge Base article: Expression Evaluator – Insight Works Knowledge Base
Please submit a support request to su*****@*******ks.com for further assistance.
Thank you,
-
AuthorPosts
- Sign in below to reply.