Oracle NetSuite Sync Error: Value for location/department/class was either blank or invalid

Why the Sync Error occurs

This error occurs when a payment or fund transfer cannot sync to Oracle NetSuite because Make Locations (or Departments or Classes) Mandatory is enabled in Oracle NetSuite. Cashflow360 doesn't allow for these classifications on payments or funds transfers.

How to Fix the Sync Error

There are two options to resolve this sync error.

  1. Set the default classifications in Netsuite:

    1. In NetSuite, go to Customization > List, Records, & Fields > Record Types
    2. Select__ List__ to the right of Bill.com Preferences
    3. Select Edit against the subsidiary name
    4. Select the Transactions subtab
    5. Enter a value in the applicable classification field
  2. Alternatively, you can disable the Make Locations (or Departments or Classes) Mandatory setting in Oracle NetSuite. There are 2 options to disable:

Disable the setting for the specific transaction type:

  1. Customization > Forms > Transaction Forms
  2. Locate the form for the transaction type with the error.
  3. Make sure location, department, and class aren't mandatory fields.

Disable the setting for all records and transactions

  1. Set up > Accounting > Accounting Preferences
  2. Uncheck Make Locations (or Departments or Classes) Mandatory.

If you can't disable this setting, manually enter the transaction in Oracle NetSuite. Then in Cashflow360:

  1. Select Fix or Resolve on the sync error.
  2. Select I've updated this sentpay in NetSuite; remove this error and sync future updates.
  3. Select Confirm/Next to clear the error.

Disable the Multi-Location Inventory setting in Oracle Netsuite:

  1. Setup > Company > Enable Features > Items & Inventory
  2. Uncheck the box for Multi-Location Inventory

If you can't disable this setting, manually enter the bill in Oracle NetSuite then sync to bring the bill into Cashflow360.