- Expiry dates are supported by the system, from receiving straight through to sales and retail, and are controlled by Lot numbers.
- The expiry date and lot number are stored on each Item Ledger Entry, and are easily filtered and sorted from this page.
- Any additional alerts or reporting would be custom
- Lot numbers can be enabled for specific items. If you are using item templates, a template for example "Snacks" can be setup to enable lot numbers so that all items in future created using this template will have lot numbers automatically enabled
- Existing stock would need to be adjusted out, lot tracking enabled, then stock put back in with a lot number and expiration date for each item you wish to enable lot tracking for.
- Enabling lot numbers will have a significant impact on all processes directly related to inventory for those items. The system will require/prompt for the user to enter a lot number for Receiving (Put away), Shipping (Picking), Transfers, Returns, Backoffice Sales, Retail Sales
- If an item does not already have a barcode for the lot number, the item would have to be labeled, OR the user would have to manually enter the lot number, OR we would have the system default to the oldest lot for sales only. All other transactions would require a specific lot number
- When receiving the stock, or entering positive stock adjustments, the lot number would have to be entered, and the related expiration date would have to be filled in. This means that the expiration dates would be heavily reliant on physical processes being in place to check the actual expiry dates on the items upon receiving them.
- The expiration date itself could be used as the lot number, but then you would need to label the item accordingly to allow the lot number to be scanned if the existing lot number is not the expiration date
- Complications
- When receiving goods, if there are multiple lots or expiries mixed together, users will tend to miss this and assume the entire shipment is the same lot and expiry. The stock would need to be separated, scrutinized, then received and stored as separate lots with separate expiration dates.
- When picking goods, the exact lot numbers would need to be entered. If a physical mistake is made, it can be very time consuming to reverse and correct the lot number. Physical storage and visibility of lot numbers, as well as picker/packer/delivery discipline becomes very important.
- When doing stock counts, lots and expiration dates would need to be checked, and entered accordingly.
ALTERNATIVES
- Item Age Composition Report - Value or Quantity
- This report will give you an idea of how old inventory is based on the date its was received
- This does not track exact expiration dates, however, it has no impact on the system or processes, and can be used immediately
- Expiring Goods Physical Warehouse Policies
- Implement a sticker system with a red label to clearly identify any goods in the warehouse expiring in the next X months
- Immediately label any goods that come in with a short expiry date
- Define warehouse and store policies to always pull/push those cases first
No comments:
Post a Comment