Back

The Criteria function (OR/AND) determines if all criterias or only one criteria should be fullfilled

Find Overstock Items to reduce Inventory Cost
Video 5/11
Play
Close
  • 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 items with Reverse Planning, it’s possible to set up criteria as all or end criteria.

Let’s see how it works.

So, if we, in this template, looking for overstock items, and I have quite a few down here, and the criteria was highest inventory value, 25,000, end inventory value higher than 5,000, and I have no multiple of quantities up here.

Now if I select and as a criteria instead, both those criteria need to be fulfilled, and when I calculate now, of course, I would expect less items because they need to fulfill both criteria.

Likewise, I could have set an inventory value, it needs to be higher than 10,000 for instance, and I could have added order multiples up here.

So, for instance, my regular point times 1.2 should be fulfilled as well as a criteria.

And again, when I calculate with the end criteria, all of those criteria need to be fulfilled.

And now we have down to two items.

I could also use the lock functionality just to show you that it will, because I know one of those items has a planning flexibility none item, order line somewhere.

And this way I could filter on my criteria as being fulfilled, all of them to be a critical item or an overstock item I want to view.

467675974-DBsROc9ymss-ENG20031707