Increased Lot and Serial Number fields input to 30 characters

This enhancement is made to align the Infor Lawson Item Detail Tracking to the Industry Standards (GS1, HIBCC, and ICCBBA). Item detail tracking particularly lot and serial numbers are increased to 30 characters to support the current industry standards.

These are the list of tables which the lot and serial fields are present and are affected by the increased field size:

Inventory Control (IC) systems:
  • SOHDETAIL
  • ICLOT
  • ICTRANSDTL
  • ICUDIDTL
  • ICITEMUDI
  • ITSERIAL
  • ICFREEZE
  • ICCTRNDTL
  • ICCPHYINV
Purchase Order (PO) systems:
  • POUDIDTL
  • RETURNDTL
  • RALDTLOUT
  • POTRANSDTL
  • MACRECPOT
Order Entry (OE) systems:
  • OEINVCDTL
Requisitions (RQ) systems:
  • RQLINEDTL
  • RQAUDIT
Warehouse (WH) systems:
  • WHSHLDTL
  • WHDEMAND
  • WHDEMNDDTL
  • WHDVAUDIT
  • WHSHLDTLIN
Work Order (WO) systems:
  • WODETAIL

The changes in this list of programs involves extending the display of lot and serial fields for online forms and reports, to reflect the increased character length of 30.

Inventory Control (IC) systems:
  • IC23 - Intransit Receiving
  • IC26 - Detail Transfers
  • IC27 - Lot Hold Control
  • IC29 - Lots / IC29.2 - Serials
  • IC41 - Items Within a Bin
  • IC42 - Stock by Detail
  • IC43 - Bin Type Inquiry
  • IC44 - Inventory Stock Status
  • IC52 - Serial or Lot History
  • IC54 - Inventory Control Adjustment
  • IC57 - Physical Inventory Table Fix
  • IC73 - Count Detail
  • IC74 - Random Counts
  • IC75 - Item UDI Details
  • IC76 - Variance Reasons
  • IC110 - Intransit Shipping
  • IC170 - Freeze Selected Items
  • IC175 - Update Variances
  • IC220 - Transaction History Report
  • IC270 - Count Sheets
  • IC375 - Item UDI Print and Archive
  • IC500 - Transaction Interface
  • IC574 - Physical Inventory Interface
  • IC598 - Bin Label Export
  • IC820 - Beginning Balance Load
Purchase Order (PO) systems:
  • PO32 - GL distribution for returns
  • PO39 - Additional Receiving Entry
  • PO131 – Receiving Log
  • PO133 – Receiving Adjustment Log
  • PO300 – PO and Receipt Purge
  • PO515 – Purchase Orders CSV Create
Matching (MA) systems:
  • MA53 – Receiving Interface Edit
  • MA531 – Receipt Interface
Warehouse (WH) systems:
  • WH20 – Allocation
  • WH30 – Picking Feedback
  • WH31 – Packing Feedback
  • WH32 – Shipping Feedback
  • WH33 – Detail Feedback
  • WH34 – Component Feedback
  • WH52 – Shipment Interface Maintenance
  • WH110 – Batch Allocation
  • WH126 – POD Print
  • WH130 – Pick List Print
  • WH131 – Bulk Pick List
  • WH132 – Batch Feedback
  • WH222 – Shipments in Process
  • WH224 – Packing List Print
  • WH520 – Batch Feedback Interface
  • WH830 – Shipment Load Program
Order Entry (OE) systems:
  • OE30 – Returns
  • OE86 – Return Line Inquiry
  • OE114 – Ship Immediate
  • OE330 – Returns Purge
Work Order (WO) systems:
  • WO32 – Picking Feedback
  • WO40 – Production Feedback
  • WO41 – Component Production Feedback
  • WO42 – By-product Production Feedback
  • WO81 – Traceback Inquiry
  • WO132 – Picking Feedback Update
  • WO133 – Production Print
  • WO140 – Production Feedback
  • WO256 – Lot and Serial Nbr Traceback
Billing (BL) systems:
  • BL80 – Invoice Inquiry
  • BL120 – Invoice Batch Release
  • BL121 – Invoice Verification Report
  • BL122 – Invoice Register Print
  • BL125 – EP Invoice Batch Release
  • BL290 – Sales Journal
Requisitions (RQ) systems:
  • RQ39 – Serial Feedback
  • RQ190 – Requisition Audit Report

Web/Self-Service Applications: RQC – Receiving Self-Service screen

Dependencies
  • If you are a RQC user, then you are required to install RQC 10.0.9.15 together with this enhancement.
  • If you are a MSCM user, then you are required to install MSCM 2022.03 together with this enhancement. In MSCM V10, these are the supported field sizes:
    • Lot Number - 10
    • Serial Number - 16
    Note:  If your vendors are generating Lot and Serial Numbers that exceeds the field length, then you must upgrade to MSCM 2022.03.
  • If you are a LMPROC user, then you are required to install LMPROC 10.1.0.41 together with this enhancement.
Related Documentation JT-1613482: File Layout Update for the IC, BL, OE, WH, and MA programs
Related JT JT-1596096: Lot and Serial Number fields are increased up to 30 characters