TABLE OF CONTENTS

 

 

A. Expiration Date Control and Vendor Lot Traceability (E*)

  1. Introduction

  2. P/O Receipt of Goods and Item Maintenance

  3. Custom Office and UDF's

  4. Manufacturing Picking Sheets

  5. Bill of Materials Production Entry

  6. Physical Counts

  7. Vendor Lot Traceability Report

 

 

 

A. Expiration Date Control and Vendor Lot Traceability

Scanco MULTI-BIN WMS FOR EXPIRATION DATE CONTROL AND VENDOR LOT

Instead of having a dedicated module, Expiration Date Control and Vendor Lot Traceability works throughout all of your Multi-Bin enabled modules to ensure efficient distribution of goods, accurate tracking of expiring or expired inventory, appropriate use of date sensitive manufacturing components, and the ability to track vendor lots through the manufacturing and distribution channels to the customers who purchased finished goods that contain them.

 

Expiration Date Control by Module

  • Purchase Order > Receipt of Goods prompts for Manufacturer Lot Number and Expiration Date. Can choose to require expiration dates.
  • Inventory Management > Inventory Maintenance, Item Maintenance and many Bin Location Lookups provide expiration information.
  • Inventory Management > Physical Count provides expiration information for reference and allows entry of information for new lines.
  • Sales Order > Auto Allocation Options can take use expiration date sensitivity when allocating goods for Sales Orders.
  • Sales Order > Set Customer Shipability Rules use pre-setup Customizer UDFs.
  • Sales Order > Picking Sheets display expiration information for goods in bins.
  • Manufacturing > Bill of Materials Productions and Work Order Completions allow the entry of Lot Numbers and Expiration dates. 
  • Reports > Track Expiration Dates of Inventory Items.

 

 

Vendor Lot Traceability through all modules

Raw material Lot and Serial numbers are tracked internally and automatically as they are issued to subassemblies and finished goods. The system traces lot and serial numbers issued from raw materials to subassemblies and to finished goods. It provides what lot serial numbers have been issued to finished goods. Use Inventory—Lot Serial Inquiry to search and print report cards on lot serial numbers.

 

Trace/Issued: Trace from raw materials to subassemblies and finished goods. Issued for Finished Goods what lot and serial numbers were issued.

 

  1. RECEIPT OF GOODS ENTRY

PURCHASE ORDER > MAIN MENU

 

When completing a Receipt of Goods with Expiration Date Control and Vendor Lot Traceability, the item’s Manufacturer Lot Number and its expiration date can be input. These fields can be entered at any time from Inventory Maintenance - Lot button.

 

 Inventory Maintenance/Inquiry Expire Date, Vendor Lot No:

Select the Lot button to enter or override the Lot Serial additional fields. Changes to the Expiration date and Vendor Lot No fields will retain an audit trail of the change.

 

 

 

2. CUSTOM OFFICE - USER DEFINABLE FIELDS

UDF data will be retained along with the Expiration Dates and Vendor lot data. That file is the IM404_VendorLotSerial and retains data by the Item + Lot Number and no concern about the warehouse code. You can display and enter to your UDF fields in a maintenance screen in Inventory Maintenance/Inquiry and/or our Multi-bin Grid Distribution screens.

UDF entries in IM404_VendorLotSerial will supersede UDF fields for Multi-bin Lot Serial items.

 

 Create UDF Fields in Files

Create your UDF fields in the IM Multi-bin Vendor Lot Serial, IM Multi-Bin Location History File and all distribution files where you need the data in our grids.

 UDF fields to these files to auto store and display. Purchase Order: PO404_ReceiptTierDistribution, PO404_MaterialReqTierDist, PO404_ReturnTierDist

Sales Order: SO404_OrderTierDist, SO404_InvoiceTierDist

Inventory: IM404_VendorLotSerial, IM404_BinLocationHistory, IM404_ItemLocationUDF, IM404_TransactionTierDist, IM404_Physical, IM_ItemCost

Bill of Materials: BM404_ProductionTierDist, BM404_DisassemblyTierDist

 

 


 Add UDF Fields to selected Lot Serial Expiration Vendor Maintenance Panel 
The IM404_ExpVendorLot.M4L is the dialog in Inventory maintenance and inquiry.

 Add UDF Fields to selected Distribution screens

Select the CI404_MBin_Entry.M4L and add your fields to each selectable business object you want them on.

 Add UDF Fields to Multi-bin Inventory in Inventory Maintenance/Inquiry

Select the PMultiBin Panel in the IM_Item.M4L. UDF fields are automatically shown in the list-box named UDF1, UDF2 to 6.

Numerics and date fields appear the best right justified. Column headings and numeric mask settings are obtained from the field set up in custom office.

 

  3. MANUFACTURING PICK SHEETS

BILL OF MATERIALS > MAIN MENU WORK ORDER > MAIN MENU

 

To aid in accurate picking, the Multi-Bin version of the Bill of Materials and Work Order Picking Sheets will list the Vendor/Lot Serial Numbers and Expiration dates assigned to components and raw materials.


  

 

4. PRODUCTION ENTRY

 

BILL OF MATERIALS > MAIN MENU

 

When creating finished products, users will be prompted to assign expiration dates if necessary.

  

When using the special customizer screens provided, users can set the days to expiration in Bill of Materials maintenance and bin location so that they default into this screen. See the appendix for more information about importing the customizer changes.

 

 

5. PHYSICAL COUNT

INVENTORY MANAGEMENT > PHYSICAL MENU

 

When conducting a Physical Count, the system will reference the expiration date and vendor/ lot of items being entered. This information is locked in (based on the receipt or the production) and cannot be altered.

 

 

 

6. MULTI-BIN VENDOR LOT TRACEABILITY REPORT

INVENTORY MANAGEMENT > REPORTS MENU

 

The Multi-Bin Vendor Lot Traceability report will track a specific vendor lot throughout the inventory system.

 

 

 

(*E) Feature for Add-on for Expiration Date and Vendor Lot Traceability

(*P) Feature for Add-on for License Plating - Case Packs, Pallets, and Containers

(*W) Feature for Add-on for Wave Batch Picking