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.