During a Dynamics GP Sales Invoice to Dynamics CRM Invoice sync using the Connector for Microsoft Dynamics, it failed on a number of records with the error “A record level exception has occurred for record 00011111. Error text: Business object not found”. The error details mention checking the TaxScheduleKey, the order/line price list or the customer’s billing address.
While trying to re-sync the addresses, they failed stating it was unable to retrieve the customer address with a certain id. I cleared the More Addresses from the CRM Account and tried clearing out the Address 1 and Address 2 information in order to have a fresh sync. But when trying to clear out the Address Integration key fields, CRM failed saving the record.
In order to get around this problem, you can create a new Account and merge it with the problem Account. Select the newly created account as the master and then select all the fields from the old record except the address information.
With the new Account, you can first run a Connector integration to add the Address Integration keys and then a full Customer to Account sync.
With the addresses correct, the invoices successfully sync to CRM.
Written by Derek Finlinson, Dynamics CRM Technical Consultant for Tridea Partners. Tridea Partners is a Southern California based Dynamics CRM partner.