Account not found during Integration - But its there?

Occasionally I get errors in SCRIBE transfers where the account can't be found. Even though the account is in both Dynamic GP and Dynamics CRM. Why? Unbeknownst to me the mapping for accounts is actually kept on the KEYCROSSREFERENCETWOWAY table in the Scribe Internal DB. Generally when this error occurs, the account has been merged in CRM and the GUID for the inactive account is referenced in the APP_B_KEY field in the KEYCROSSREFERENCETWOWAY table. We need to change this.

Check to see if the accounts have been merged. If they have been merged look at the GUIDs for both the Active and Inactive account. Copy The GUID for the active account including the "{}". The GUID is located in the address bar as seen here.



When accounts can't be found but they are in CRM and GP. Verify the GUID Scribe is using in APP_B_KEY in the KEYCROSSREFERENCETWOWAY table in \\NTINTEGRATOR\SCRIBE SQL Server.

Select *
From KEYCROSSREFERENCETWOWAY
Where APP_A_KEY = '%ACCOUNTNUMBER%'

The results should look like:

If the APP_B_KEY field doesn't equal the GUID of the active Account make it so.

This will fix any of those errors.