Using the Remaining Shelf Life Percentage calculates Item batches that expires within a percentage of its life time

Find Overstock Items to reduce Inventory Cost
Video 9/11
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An advanced video is for the experts, and it requires detailed knowledge about the specific area of Business Central. Advanced Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details 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

With the overstock item functionality, it is possible to find items that are expiring.

I’ll show you the example here.

So, I can find all the items that has item ledger entry that expires.

So, this one, the first one has an end inventory of 10, meaning an expiring inventory of 10.

And if we look at this one, there will be one cross, meaning one entry that expires here.

Because we have other stuff here, sales orders, etc.

This is the cross represent the item ledger entry that expire.

But you can use this with remaining shelf-life percentage as well.

So, this, if it’s not filled in, it means that the remaining shelf life is just zero.

So, it’s looking at the actual expiration date.

But if you have customers requiring that when you sell the item to those, the remaining shelf-life percentage must be 75% of the item’s lifetime.

You could calculate with that as well.

So, we will just calculate the same way.

And now we can see the first line has an inventory of 50 instead, meaning an expiring inventory of 50.

But if I want to investigate it now, and I’m looking at the graphical profile, this is an other set of the graphical profiles.

So, I didn’t add the remaining shelf line percentage to that view.

So, I need to do that first.

Meaning I need to go into my item availability setup like this, and finding the graphical item availability setup.

This is a rarely used functionality.

And therefore, you have to go and put it up in the setup.

So, the remaining shelf-life percentage in here, you can set this for 75, which equaled the overstock item that we just entered or added.

So, this means now if I’m looking at the graphical profile, now that I’ve set the remaining shelf life percentage, I can see all the crosses here that we have several item ledger entries that are now expiring within 25% of their lifetime, because the customer will need a 75% remaining shelf life when we sell it.

And this way it’s possible to identify item that runs for or falls for remaining shelf-life percentage.