NetSuite Error: [Code=USER_ERROR] You Must Enter at Least One Line Item for This Transaction

Applies to both platforms of Riva (Cloud and On-Premise).

Issue

In Outlook, a user drags and drops an email into a SmartConvert folder, specifically the - Create New Order or - Create New Quote folder, and the following sync error occurs:

Cause

The configuration for creating an order or quote in NetSuite is incomplete.

Solution

1. In NetSuite, create an item and take note of its internal ID.

2. Do one of the following:

   • For Riva Cloud, contact the Riva Success Team.
   • For Riva On-Premise, apply the appropriate advanced option to the NetSuite connection.

Step 1: In NetSuite, create an item's Internal ID

1. Sign into NetSuite as an Administrator.

2. Select Lists >> Accounting >> Items.

3. In the Items tab, on the New drop down, select Inventory Item.

4. In the Inventory Item window, select Create a New Item, and select Save.

5. Take note of the item's automatically generated internal ID.

   Note: The ID is required when updating Riva's sync policy. To create orders and quotes, you need two items: one for orders and the other for quotes. To create a second item, repeat steps 3 and 4. Take note of both internal IDs.

Step 2: In Riva On-Premise, apply the appropriate advanced option to the NetSuite connection

Note: For Riva Cloud, contact the Riva Success Team.

For Riva On-Premise, do the following:

• In the Riva Manager application, apply the appropriate advanced option to the NetSuite connection.

  • For an order, apply NetSuite.SalesOrder.DefaultLineItemId = n

  • For a quote, apply NetSuite.Quote.DefaultLineItemId = n

    where n is the item's internal ID from the NetSuite Inventory.