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:
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.
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.
There are several potential solutions to fix this sync error, depending on the root cause:
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.
After entering the ID, perform a sync operation between BILL and Sage Intacct. This should allow the records to map and sync properly.
If auto-numbering is not enabled for vendors or customers in Sage Intacct, you can turn it on by:
For Vendors:
For Customers:
Enabling auto-numbering ensures new vendor and customer records have a unique ID assigned automatically.
If the above solutions do not resolve the “warehouseid” sync error, consider these extra steps:
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.
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.
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.
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.
Go to Accounts Payable > Configure Accounts Payable, and input a value for the Vendors field in the Document Numbering section.
Go to Accounts Receivable > Configure Accounts Receivable, and in the Document Numbering section, input a value for the Customers field.
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.
Having the proper location/entity ID set for cash management checking accounts in Sage Intacct ensures transactions sync properly from BILL.
Yes, multi-currency mismatches can potentially trigger the “warehouseid” sync error. You may need to create a new single-currency contact to resolve it.
If the sync connection itself seems to have failed, disconnecting and reconnecting with new credentials can potentially clear up sync errors.