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. Bill.com℠ 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.
Set the default classifications in Netsuite:
- In NetSuite, go to Customization > List, Records, & Fields > Record Types
- Select__ List__ to the right of Bill.com Preferences
- Select Edit against the subsidiary name
- Select the Transactions subtab
- Enter a value in the applicable classification field
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:
- Customization > Forms > Transaction Forms
- Locate the form for the transaction type with the error.
- Make sure location, department, and class aren't mandatory fields.
Disable the setting for all records and transactions
- Set up > Accounting > Accounting Preferences
- Uncheck Make Locations (or Departments or Classes) Mandatory.
If you can't disable this setting, manually enter the transaction in Oracle NetSuite. Then in Bill.com:
- Select Fix or Resolve on the sync error.
- Select I've updated this sentpay in NetSuite; remove this error and sync future updates.
- Select Confirm/Next to clear the error.
Disable the Multi-Location Inventory setting in Oracle Netsuite:
- Setup > Company > Enable Features > Items & Inventory
- 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 Bill.com.
Account Setup View all
Making Payments to your Vendor View all
Getting Paid by your Customer View all