NetSuite Workflow: Pop-Up Alert for Sales Order Shipping Cost Discrepancy

Initial attempts to use workflow fields and the 'Show Message' action did not execute as expected when conditions were tested. Using the Visual Builder for conditions also did not trigger the action. The 'Return User Error' action, when set with a 'Before Record Submit' trigger, executed but displayed the message on a new page rather than as a desired pop-up. The 'Show Message' action is specifically designed for client-side events and triggers, which occur on the browser. Workflow fields in this context were initially considered server-side fields. The 'Before User Submit' trigger is a client-side trigger. When comparing currency fields, it is necessary to convert them to an integer using parseInt().

To implement this solution, follow these steps:nn

1. Create Two Custom Transaction Body Fields.

   Navigate to Customization > List/Records/Fields > Transaction Body Fields > New.

   Field #1 - Captures SO Shipping Costn* Label: SO Shipping Cost (Workflow)n* Type: Currencyn* Applies to: Salen* Display Type: Inline Text

   Field #2 - Captures Invoice Shipping Costn* Label: Invoice Shipping Cost (Workflow)n* Type: Currencyn* Applies to: Salen* Display Type: Inline Textnn

2. Create Workflow.

   Navigate to: Customization > Workflow > New.

   Workflow Definitionn* Name: Invoice Shipping Cost Alertn* Record Type: Transactionn* Sub Types: Invoicen* Event Definition On Create

   Define State 1 - Invoice Alert

   Action #1 - Set Field Valuen* Trigger On: Entryn* Field: SO Shipping Cost (Workflow)n* Formula:n

n{createdfrom.shippingcost}n

Action #2 - Set Field Valuen* Trigger On: Before User Submitn* Field: Invoice Shipping Cost (Workflow)n* From Field = Tn* Record (Join Field) Current Recordn* Field: Shipping Cost

Action #3 - Show Messagen* Conditionn* Custom Formula:n

nparseInt({custbody_gs_so_ship_workflow})>parseInt({custbody_gs_inv_ship_cost_workflow})n

n* Text: SO Shipping Cost > Invoice Shipping Cost

Important Note: The hierarchy of actions dictates that the 'Display Message' action should be the last in the sequence.