The fields on the Tab “Filter on Values”

Find Overstock Items to reduce Inventory Cost
Video 4/11
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Videos with the tag "Commonly Used" describes the functionality that is used by most companies. Commonly Used This video includes functionality from the app "Reverse Planning" which is available at Microsoft AppSource. Click to visit AppSource. Reverse Planning

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

When you’re looking for overstock item, you can filter on specific values, for instance, the highest inventory value being higher than 25,000, or your end inventory value being higher than 5,000, etc.

And then when you calculate, it looks after one of those criteria, or all of them if you set the criteria to be end.

So, here you can see the highest inventory value exceeding the 25,000, and the lowest inventory value, and some of them exceeding 9,000.

You could show the average inventory value being higher than whatever quantity, and the average inventory value is actually calculated per day, so, if we look at this item with a higher average inventory value, and we look at the graphical profile for that item, as you can see here, it calculates for each date in this period, calculating the quantities, multiply it by all those days, and then multiply it by the cost, and it takes the average of that, so, it’s an actual average calculation.

You can calculate for the inventory quantity being higher than whatever quantities, and end inventory being higher than whatever quantities.

This of course only makes sense if your item has the same understanding of quantities.

And finally, you can show if locked order line exists, meaning if you select this check mark, it will take into account all items where there’s lines with planning flexibility none, meaning items that you have locked from a planning perspective.

This is due to the reason that as a planner I would like to have a special focus on items where the planning flexibility is locked, because the MRP doesn’t take the locked lines into account for being possible to move.