Viewing Items that falls for Remaining Shelf Life

Function and Features of Graphical Inventory Profile
Video 11/13
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
This video includes functionality from the app "Graphical Inventory Profile" which is available at Microsoft AppSource. Click to visit AppSource.
Graphical Inventory Profile

Playlists  Manage

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

Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

With Graphical Inventory Profile, it is possible to view item ledger entries that expires, meaning if we view the graphical profile for an item like this, we can see that it has an item ledger entry in the middle that expires.

The quantity 5,500 will expire on this date, on the specific lot number, which means that one sales order will not handle. But it’s also possible to handle what we call remaining shelf life. So in real life, this item ledger entry here that expires on July 28, 2020, if we go in the item ledger entry, this will be the expiration date for that item ledger entry. But a customer wouldn’t like an item on the day it expires, so they might have demands for what we call remaining shelf life. This is if we go into the setup for this graphical profile, and the way in here will be explained in another video, so don’t be nervous for this.

There’s a field down here on the dates tab, both where we have selected we want to show item that expires. This field is the field that actually take this into account. And then we can add here a remaining shelf life percentage, meaning if we enter 60 here, we would like our items to have at least 60% of their shelf life remaining when we sell it to the customer. So after entering this, if I use the same item, view the graphical profile for this item, I can now see that the item ledger entry we saw before will actually expire a lot before, it only lasts 40% of the period. And this also causes another item ledger entry to expire within the period. So I can still ship my first sales order, but taking from another batch number on a stock and then I can ship my second sales order, that’s an even worse impact on my inventory. So with this way, you can actually overview remaining shelf life.

If you use the app, Reverse Planning, it’s possible to calculate and display all your items that falls for remaining shelf life and find out a way to get rid of them or sell them before they expire.