Integration Fixes That Stick

There’s are an infinite number of ways an integration can break. ERP PROS helps you anticipate infinity plus one. Here are fixes for four common failures.

"Dimension Mismatch" on Order Entry

• The Error: Salesforce opportunities fail to sync to Intacct with a message like: "The project dimension selected is not related to your header-level Customer ID."

• The Cause: In Salesforce, an Opportunity is linked to a Project that is actually assigned to a different Customer in Intacct (often due to parent/child account confusion).

• The Intacct Fix:

  • Enable Dimension Relationships in the General Ledger.

  • By setting up a rule that "Project X" must belong to "Customer Y," you force the integration to validate the relationship before it tries to post. This keeps your reporting clean and prevents orphan projects.

Restricted Picklist Value Errors

• The Error: Salesforce says: "Restricted picklist value: [Value] does not exist."

• The Cause: You added a new Department or Location in Sage Intacct, but didn’t manually update the corresponding picklist in Salesforce. The systems are no longer speaking the same language.

• The Intacct Fix: * Use the Advanced CRM Integration (SmartSync) settings.

  • Configure the integration to automatically push picklist updates. When a new Dimension (like a Department) is created in Intacct, it should trigger a metadata update in Salesforce, ensuring the "Sales" side always has the latest "Finance" options.

"Result Status: Failure for Control ID" (Permission Gaps)

• The Error: Most transactions sync, but certain ones (like Credit Memos or Journal Entries) fail with a vague "Control ID" failure.

• The Cause: The Web Services User lacks "Write" or "Post" permissions for specific modules in the Role Subscriptions.

• The Intacct Fix:

  • Go to Company > Admin > Roles and find the role assigned to your sync user.

  • Click Subscriptions and check the Permissions for the specific module failing.

  • Pro Tip: Often, users forget to check the "Integration" or "XML" permission box within the individual module level.

Multi-Currency Synchronization Failures

• The Error: Salesforce records fail to sync to Intacct with the message: "Enable foreign-currency transactions and try again."

• The Cause: The Opportunity in Salesforce is in a currency (e.g., CAD) that hasn't been enabled or defined in your Sage Intacct Multi-Currency console.

• The Intacct Fix:

  • Navigate to Company > Setup > Multi-Currency.

  • Ensure all currencies used in Salesforce are "turned on" and, more importantly, that the Exchange Rate Provider (like Oanda) is correctly linked. If Intacct can't find a daily rate for the date of the Salesforce transaction, the sync will reject the record.