Sage Intacct Sync Error “Required field ‘warehouseid’ is missing”

This sync error between BILL and Sage Intacct is triggered when specific vendor or customer records requirements are not met in one or both systems.

Error message: "Sage Intacct sync error: Bill XXX cannot be created in Intacct - Required field ‘warehouseid’ is missing"
There are two main causes:

1. Auto-Numbering Not Enabled for Vendors/Customers

In Sage Intacct, if the “auto-numbering” option is not enabled for vendors or customers, it can lead to this sync issue. Auto-numbering automatically assigns a unique ID to each new vendor/customer record.

2. Missing Vendor/Customer ID in BILL

If the vendor or customer record in BILL does not have an ID entered, it cannot properly map to the corresponding record in Sage Intacct during syncing. This missing ID triggers the “warehouseid” error.

How to Resolve Sage Intacct Sync Error “Required field ‘warehouseid’ is missing”

There are several potential solutions to fix this sync error, depending on the root cause:

If Vendor/Customer ID is Available

• Enter the ID in BILL

Log into your BILL account and navigate to the Vendor or Customer Details page. Use the edit icon to manually enter the vendor/customer ID that matches the record in Sage Intacct.

• Initiate Sync

After entering the ID, perform a sync operation between BILL and Sage Intacct. This should allow the records to map and sync properly.

If Vendor/Customer ID Field is Missing in BILL

1. Log into BILL and Access Settings
   Access your BILL account and navigate to the Settings section.
2. Go to Accounting Preferences
   Under the Accounting tab, select Preferences.
3. Edit Preferences
   Click the edit icon to modify the preference settings.
4. Enable Manual ID Entry
   Choose the option to “Enter ID Manually” in the Vendor/Customer Sequence ID field.
5. Save Changes
   Confirm and save the new preference setting.
6. Perform Sync
   Attempt to sync BILL and Sage Intacct again to apply the manual ID entry option.

Enabling Auto-Numbering in Sage Intacct

If auto-numbering is not enabled for vendors or customers in Sage Intacct, you can turn it on by:

For Vendors:

1. Navigate to Accounts Payable > Configure Accounts Payable
2. In the Document Numbering section, input a value in the “Vendors” field

For Customers:

1. Navigate to Accounts Receivable > Configure Accounts Receivable
2. In the Document Numbering section, input a value in the “Customers” field

Enabling auto-numbering ensures new vendor and customer records have a unique ID assigned automatically.

Additional Steps

If the above solutions do not resolve the “warehouseid” sync error, consider these extra steps:

• Check for and resolve any duplicate vendor/customer contacts
• Set up a location ID for cash management checking accounts
• Update invoice summary frequency settings
• Disconnect and reconnect the BILL-Sage Intacct sync connection
• Remove any extra/duplicate line items causing conflicts
• Address multi-currency issues for contacts/invoices

Here are some FAQs for "Required field ‘warehouseid’ is missing"

Q. What causes the “Required field ‘warehouseid’ is missing” error?

This error occurs when vendor or customer records in BILL do not have IDs that match the corresponding records in Sage Intacct, or if auto-numbering is not enabled for vendors/customers in Sage Intacct.

Q. Why is it important to have matching vendor/customer IDs?

Matching IDs allow BILL and Sage Intacct to properly map and sync vendor/customer records between the two systems. Mismatched or missing IDs will prevent records from syncing correctly.

Q. How can I add a vendor/customer ID in BILL?

Log into BILL, go to the Vendor or Customer Details page, and use the edit icon to manually enter the ID that matches the record in Sage Intacct.

Q. What if the vendor/customer ID field is missing in BILL?

In BILL settings > Accounting Preferences, enable the “Enter ID Manually” option for the vendor/customer sequence ID field. This will allow you to enter IDs going forward manually.

Q. How do I enable auto-numbering for vendors in Sage Intacct?

Go to Accounts Payable > Configure Accounts Payable, and input a value for the Vendors field in the Document Numbering section.

Q. How do I enable auto-numbering for customers in Sage Intacct?

Go to Accounts Receivable > Configure Accounts Receivable, and in the Document Numbering section, input a value for the Customers field.

Q. What if I have duplicate vendor/customer contacts causing conflicts?

Identify any duplicate contacts, rename them to be distinct, and then resync BILL and Sage Intacct. You may also need to deactivate one of the duplicate contacts.

Q. Why is setting up a location ID for cash management accounts helpful?

Having the proper location/entity ID set for cash management checking accounts in Sage Intacct ensures transactions sync properly from BILL.

Q. Can multi-currency issues between a contact/invoice and BILL cause sync errors?

Yes, multi-currency mismatches can potentially trigger the “warehouseid” sync error. You may need to create a new single-currency contact to resolve it.

Q. When should I disconnect and reconnect the BILL-Sage Intacct sync connection?

If the sync connection itself seems to have failed, disconnecting and reconnecting with new credentials can potentially clear up sync errors.