Skip to content
Item Planning Review app iconItem Planning ReviewReview

Filter Settings for Usage Review for Microsoft Dynamics 365 Business Central

Reviewing planning parameters for every item at once is not practical. Planners need to find the items worth looking at: the ones moving faster than their settings assume, or not moving at all.

Item Planning Review has filter settings at the top of the page that narrow the review by period, item production posting group, item category, location, average usage range, and reordering policy.

How Filter settings for usage review works in Item Planning Review

  1. The planner sets the period and dates for the history window.
  2. The planner adds filters for posting group, category, location, usage range, or reordering policy.
  3. The planner chooses Generate to list the matching items.
  4. The planner reviews and adjusts the results, then changes the filters for the next group.

Key capabilities

History window

Period, Start Date, and End Date set the range that average usage is calculated over, and Period Summary shows its length.

Item groups

Item Prod. Posting Group and Item Category narrow the review to a product family, such as one category of stocked goods.

Location

Item Location limits the review to one location. When stockkeeping units (SKUs) exist there, Item Planning Review shows SKU-level values.

Usage range

Minimum Average Usage and Maximum Average Usage isolate items that are moving when they should not be, or not moving at all.

Reordering policy

Filter by reordering policy to review, for example, only items planned by maximum quantity.

See Filter settings for usage review on screen

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

Details that matter on the floor

The usage filters do the work

The minimum and maximum average usage filters are the practical ones. They separate slow movers and fast movers so a planner can act on each group.

Small batches

Working one category or location at a time keeps each review short enough to finish.

Who uses Filter settings for usage review

Inventory managers

Find items whose usage no longer matches their settings.

Production planners

Review one production posting group at a time.

Warehouse managers

Review items for one location.

Questions about Filter settings for usage review

Can I filter items by average usage in Business Central?

Yes, with Item Planning Review. Minimum and maximum average usage filters, along with period, posting group, item category, location, and reordering policy, narrow the list before you review planning parameters.

Which filters does Item Planning Review have?

Period, start date, end date, item production posting group, item category, item location, minimum average usage, maximum average usage, and reordering policy.

How do I find slow-moving items?

Set a maximum average usage filter for the period you care about and generate the list. Items below that usage appear for review.

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 Filter settings for usage review?

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