The CUSTOMFIELDID limit reached when installing xml package

Sage Intacct allows 25 custom fields per object. The Bill.com xml package for Sage Intacct sync installs 6 custom fields within Sage Intacct, 3 for Accounts Payable Bills and 3 for Accounts Receivable Invoices:

For Accounts Payable Bills:

  • BDC_BILLID
  • BDC_ORGID
  • BDCURLPREFIX

For Accounts Receivable Invoices:

  • BDC_INVOICEID
  • BDC_ORGID
  • BDCURLPREFIX

Note: These fields are coded into the xml package and cannot be removed.


Why the error occurs

If a user has created custom fields or integrates their Sage Intacct account with another system (ie: SalesForce) that installs custom fields for Bills and Invoices they may encounter a custom field id limit error.

Below is an example of one for AR: Intacct CustomfieldID error


How to fix the error

Custom fields will need to be removed within Sage Intacct for the object the error is referring to, to allow for the 3 that we install.

There's no other workaround at this time.