Proposal for handling automatic selection of lot number on Item fulfillment record

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 … Continue reading Proposal for handling automatic selection of lot number on Item fulfillment record

Search to get inventory details of Lot Numbered Inventory Items

/** * function to search inventory details of lot numbered inventory items */ function invtDetailSearch(itemArray) { //An array of lot numbered item is passed as argument to this function. try { var searchResultArray = []; var JJ_invtDetailSearch = search.create({ type: “inventorydetail”, filters: [ [“item.internalid”, “anyof”, itemArray], “AND”, [“expirationdate”, “after”, “today”], “AND”, [“itemcount”, “greaterthan”, “0”], “AND”,… Continue reading Search to get inventory details of Lot Numbered Inventory Items