NetSuite Sync Error | NetSuiteResourceException('You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist.')

This error may occur if a bill in NetSuite is not in OPEN status and is currently marked as Pending Approval. Ramp does not control the NetSuite approval workflow, so syncing requires the bill to be in an approved state.

How to resolve:

• Check if the bill in NetSuite is in OPEN status.
• If the bill is in Pending Approval:
  • Verify if there is a vendor bill approval workflow in place.
  • If you want to continue using the NetSuite approval workflow, make sure all necessary fields are filled out to allow routing for approval.
  • If you do not want to use the existing workflow, create a new one that marks bills as APPROVED or OPEN.
• To check your NetSuite settings:
  • Navigate to Setup > Accounting > Accounting Preferences.
  • Click the Order Management tab.
  • Scroll down to the Vendor Bills section and review the Default Vendor Bill Status:
    • If set to Pending Approval, a vendor bill approval workflow is required.
    • If set to Approved, bills can sync without additional workflow steps.
• To create a new approval workflow:
  • Go to Customization > Workflow > Workflow > New.
  • Set the following values:
    • Name: Ramp - Vendor Bill Approved
    • Record Type: Transaction
    • Subtype: Vendor Bill
    • Execute as Admin: Check
    • Release Status: Released
    • On View: Check
    • On Create or Update: Check
    • Context: RESTlet (only)
  • Save the workflow.
  • Double click in State 1 and create a new action.
  • Select: Set Field Value.
  • Field: Approval Status.
  • Select: Static > Approved.
• Return to Ramp and retry the sync.