REQUIREMENT:
An automated system in NetSuite that selects the Lot number in the Item Fulfillment record based on the expiry date. The system should automatically choose the Lot with the nearest expiry date for item fulfillment. The Lot that is closest to its expiration date should be automatically selected in the Item Fulfillment process.
DELIVERABLES
- A button ‘Assign & Fulfill’ will be created in Sales order
- On button Click, An IF record will be created with status ‘Picked’.
- The Lot for lot numbered item in IF record will be chosen that is closest to the expiration date.
- A single IF record is created on the button click with committed items.
- The standard ‘Fulfill’ button will be made hidden to avoid any confusions.
- If all items are not committed, the ‘Assign & Fulfill’ button can be clicked once the items are committed. An IF will be created with remaining committed items in the sales order that are not picked.
- On failure, error message will be displayed.
- The IF will be created
ASSUMPTIONS
- We assume that the Lot numbers and expiry date for the item will be available in the item record.
- Partial fulfilments are not considered.
- We assume that the expiry date and lot number details will be available in the item search.
RISKS
- The NetSuite will enforce concurrency limits on Suitelet.
- Item fulfillment is created with all the committed items. Hence quantity cannot be adjusted.
- If more item lines are in the SO record, lagging issue may arise.