In the VRFQ (Vendor Request for Quote) creation process, since the amount field is mandatory it throws an error when no item is selected or when the quantity or price of the selected item is 0.
The error occurs because the standard ‘Amount’ field has a built-in validation that allows only values greater than zero to be set.
To resolve this issue, a placeholder logic was implemented in the script.
When the amount is zero, the script sets a small placeholder value, 0.001, to the ‘Amount’ field. Since the ‘Amount’ field is of the currency type, NetSuite automatically trims and formats this value according to the currency precision settings, which typically display two decimal places. As a result, the field value becomes 0.00.
By using 0.001 as a placeholder, this approach satisfies the built-in validation, allowing the VRFQ record creation to proceed without errors. This method effectively handles scenarios where line items are not added while maintaining the integrity of the VRFQ record.