Skip to content
Item Planning Review app iconItem Planning ReviewConfigure

Calculation Expressions for Microsoft Dynamics 365 Business Central

Every planner has a rule of thumb for safety stock or a reorder point, but applying it by hand across hundreds of items is not realistic, and different planners apply it differently.

Item Planning Review lets you write calculation expressions, formulas on its setup page, for suggested safety stock, reorder point, reorder quantity, and maximum inventory, with rounding rules.

How Calculation expressions works in Item Planning Review

  1. An administrator or planner opens the Item Planning Review Setup page.
  2. They write an expression for each value, using variables and item fields listed in Expression Help.
  3. They set the rounding direction and precision.
  4. Planners generate the review, and the calculated columns show the results beside current values.

Key capabilities

Four expressions

The Item Planning Review Setup page has a Safety Stock Expression, Reorder Point Expression, Reorder Quantity Expression, and Maximum Inventory Expression. Their results appear in the calculated columns on the review page.

Built-in variables

Expressions can use avg_daily_usage, lead_time_days, days (the number of days in the period), and usage_qty.

Item fields

Numeric fields from the item planning data, such as [Unit Cost], [Inventory], [Sales (Qty.)], or [Reorder Point], can be used in square brackets. Expression Help lists them.

Functions and rounding

Expressions can use functions such as round, for example round(avg_daily_usage * lead_time_days;1). Round Direction and Round Precision set how results are rounded.

Empty means zero

Deleting an expression's contents returns zero for that value, so an unused calculation stays out of the way.

Shared approach

Item Planning Review uses the same expression evaluator as other Insight Works planning apps, including Enhanced Forecasting Worksheet.

See Calculation expressions on screen

Real screens from Item Planning Review, shown with demo data.

Details that matter on the floor

Your rule, applied the same way

One expression applies the team's rule to every item, so two planners reviewing the same item see the same suggestion.

A suggestion to accept or not

Calculated values appear next to current values. The planner decides whether to apply them.

Who uses Calculation expressions

Inventory managers

Turn the team's safety stock rule into a formula.

Supply chain analysts

Test different formulas against real usage.

Business Central consultants

Set up expressions that match the customer's planning policy.

Questions about Calculation expressions

Can Business Central calculate safety stock from usage?

With Item Planning Review, yes. Write a safety stock expression on the setup page, for example based on average daily usage, and the calculated value appears beside the current safety stock for each item.

What variables can I use?

avg_daily_usage, lead_time_days, days, and usage_qty, plus numeric item fields in square brackets such as [Unit Cost], [Inventory], and [Reorder Point]. Expression Help on the setup page lists them.

Can I round the results?

Yes. Round Direction and Round Precision on the setup page control rounding, and expressions can use the round function.

Are calculated values applied automatically?

No. They appear in calculated columns for review. You apply them on the page or with Update Item Planning.

Item Planning Review app icon

Part of Item Planning Review

Optimize inventory management by streamlining reorder planning, minimizing costs, and enhancing accuracy.

Have a question about Calculation expressions?

Send us a note and the Item Planning Review team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions