Proposal summary

This proposal covers the new customization in the Sales Order record to show the alert and restriction when the user tries to add a SKU/Item more than once.

Requirement

Display an alert message to notify the user if they enter a SKU/item more than once in a sales order record. Also, restrict the user from adding the same SKU/item twice. The kit item need not to be considered.

Deliverables

• Display an alert message box when the user re-enter the same item. We will create a script to validate the entry of the new SKU/item in each line. When the user adds a line item to the sales order, if it already exists, the script will not allow the user to add it again. An alert message will notify the user: “This SKU/item has already been added once. Please try adding a different item.f”.
• This alert message will applicable during the creation of a new sales order record and, in edit mode it will be applicable to sales orders that are in pending approval status.

Assumptions

• If the user adds the kit items multiple times, the script will allow it, and no alert will be displayed.
• When a sales order is created using the ‘make copy’ functionality from an existing sales order that already has SKUs/items used multiple times, this alert will not work. This alert message will only work when manually adding a new line.
• This is only applicable for Sales orders created through UI. Any sales orders created via scripts, integration or webstore will not be considered for the proposed method of restriction.
• The functionalities like Add multiple, Upsell Items, Intelligent Recommendations cannot be considered due to the limitations of the customization in NetSuite.

Risk

• The user may experience performance issues as the page might go unresponsive during validations of a new line SKU/Item of a Sales Oder that has a large number of items.
• This delay can also occur when opening the sales order record in edit mode under the same conditions.