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
- The planner sets the period and dates for the history window.
- The planner adds filters for posting group, category, location, usage range, or reordering policy.
- The planner chooses Generate to list the matching items.
- 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.
Related Item Planning Review features
All Item Planning Review features →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.
