Sage 100 Error: "The lot serial number is invalid"
“The lot serial number is invalid” when selecting a serial item in Sales Order Shipping Data Entry.
Invalid GroupSort field value in the IM_ItemCost field
- Open Library Master, Utilities, Data File Display, and Maintenance
- Browse to MAS_xxx and look in the file IM_ItemCost.m4t file (where xxx is the Company).
- In the Key field enter the part number in question.
- Click the lookup button and select the item with the correct serial number and warehouse.
- Look at field 04 GroupSort$
- Compare to field 07 LotSerialNo$
- Click Edit.
- Edit field 04 GroupSort$ to match field 07 LotSerialNo$
- Click Yes to “Remove Old Key”