Scenario
User is getting an error: "Existing lots for this item do not have an expiry date. Add expiry date to the lots and try again." when trying to edit an item.
Cause
The error occurs because some lot numbers linked to the item lack expiry dates, even if inactive, due to historical transactions in NetSuite.
Solution
To identify the lot number causing the error, we performed the following steps:
- Navigate to Lists > Search > Saved Searches > New
- Select Item
- Under Criteria:
– Expiration Date is empty (or null) to filter lots without expiry dates. Optionally, filter by Item if you know the specific item causing the error for targeted searches. - Under Results, include relevant fields for easy identification and action::
– Name
– Display Name
– Description
– Type
– Inventory Number: Internal ID
– Serial Lot Number
– Inventory Number : Expiration Date - Save the search with a descriptive name, such as "Lots Without Expiry Dates for Item Editing."
- Run the search to generate a list of all lot numbers needing updates.
To remove the error, update the Lot Number Record with an Expiration Date. Kindly refer to the steps below:
- For each lot number identified in the search, access its record using the URL format:
ACCOUNTNUMBER.app.netsuite.com/app/accounting/transactions/inventory/inventorynumberrecord.nl?id=LOTNUMBERID- Replace ACCOUNTNUMBER with your NetSuite account number (e.g., 123456).
- The Lot Number Record will display. Click Edit.
- Add an appropriate Expiry Date based on the item's shelf life or business rules (e.g., 12 months from receipt for perishables).
- Save the changes to update the record.
Additional Notes
- When setting up lot-numbered items, train staff to always enter expiry dates during processes like Item Receipt or Inventory Adjustment. While NetSuite does not have a built-in feature to make this field mandatory without customization, user awareness can mitigate issues.
- Use saved searches or reports to audit inventory for missing expiry dates, especially before period closes or major updates, to ensure compliance and avoid errors.
Conclusion
By implementing the improved solution, users can resolve the error "Existing lots for this item do not have an expiry date" efficiently and prevent future occurrences through proactive measures like recurring saved searches and staff training. While manual updates are necessary for current systems, exploring customization options can further streamline processes for businesses with frequent lot-numbered inventory needs. This approach ensures compliance with NetSuite's inventory management requirements and enhances operational efficiency.
-----
If you find this information useful, let us know by reacting or commenting on this post!