Currently within MAS500, the supposed Lot receipt date is stored at the bin level in the last Fill Date. This is the wrong place to store the date for the lot. It should be stored with the lot and follow the lot along with the quantities. When I choose Oldest Receipt Date when picking inventory, it would get the true born on date for that lot.

There are cases where you may order say 1000 pallets of a particular lot. You receive say 100 a month. During a particular month you consule all the inventory. You then do another receipt. However, since it may already be in the system for the receipt bin, the date is never replaced. Even though your rewceipt date is correct, the date in the system when it uses Oldest Receipt Date does not work. It grabs this newer inventory.

At a customer I built this logic to store the born on date.

by: Steve L. | over a year ago | 3 - Sales & Distribution