Is there a way to get a list of products that will expire before they are used or sold based on the current forecasted demand?
We produce fresh food products and juices, both the ingredients and finished goods have relatively short shelf life. We would like to be able to see what items we are long on so that we can take actions to either sell or donate them instead of purging the products.
We are on Apps 10 update 5
Best answer by CedKanchM
View originalPlease check if below is applicable ,
this is mainly to consume stocks before it gets expired, (This works with MRP /MS...)
----------Extracting from Online help-------------------------------
MRP will be considering future expiration stocks of an inventory parts if the Mandatory Expiration Date flag is checked for the part and it plans MRP receipts accordingly.
During MRP execution, MRP calculates beginning on hand reducing all the expired qty up to system date. This will further be affected if Minimum Remaining Days for Planning defined for the part in Acquisition tab in Inventory Part,
Before inventory stock get expired it will be consumed by demands fall before the expiration date, This is also affected by the Minimum Remaining Days for Planning, if such stock is remaining even after consumed by demands, the remaining qty will be expired and will be visible in IFS application as a demand with an MRP source type MRP Inventory Lot Expiration. These demands are only visible and reduce the projected on hand qty by remaining qty to be expired on that particular date
Beginning on hand = 250-10-15
MRP Inventory Lot Expiration demand exists on 2017/04/02 for a qty of 5
MRP Inventory Lot Expiration demand exists on 2017/05/03 for a qty of 5 (qty of 20 will be consumed by the demand which exists before the expiration)
Inventory stock going to be expired on 2017/06/26 for a qty of 5 (full qty will be consumed by the demand which exists before the expiration). Hence no MRP Inventory Lot Expiration Demand displayed on this date.
---------------------------------------------------------------
+4
Sounds like you need to calculate the number of days remaining inventory and compare that with how many days remaining shelf life you have.
We don’t have a standard report for this. All information is available in the system though, so hopefully you have a reporting tool you can use to create a report.
If you are using IFS Demand Planning you will find the forecast in a view called forecast_day. The stock levels and expiry dates are in inventory_part_in_stock.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
