Estimating Expired Inventory

richchipper

Well Known Member
We currently have thousands of active SKU's in dozens of locations. We are trying to find a clean way to highlight the products that will expire before being used up.

We can pull the Lot Status Report (R41082) to see what is expiring - but it doesn't indicate if the amount will be used before then.

MRP messages show what may expire in the planning fence, but doesn't showcase how many units will expire before being used up.

In contrast, on the Supply/Demand screen (P4021), you are able to see which items will expire before being used, but we don't want to have to check every item in Supply/Demand.

I'm wondering if there is a way to create a report that would pull out the same information as Supply/Deman. Some information on our system:

- We are using 8.12
- We use DRP without MPS planning
- We forecast for a rolling twelve months

Any help you can give would be great.
 
Back
Top