Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Populating Parent Customer ID with KingswaySoft

Post Author: Joe D365 |

When using Microsoft Dynamics CRM, you will come across cases where you might need to populate the Parent Customer ID field using KingswaySoft.

A common mistake that occurs is when people try to use this to populate the parent customer ID field only. If so, they will receive this error message:

"Error: 0xC0047062 at Data Flow Task, Dynamics CRM Destination [2]: System.Exception: An input for 'parentcustomeridtype' field is required in order to process lookup field 'parentcustomerid' correctly. The input value should be one of the following entity names, or its corresponding entity type code in integer format: 'account', 'contact'. (Integer type code is the only option when SOAP 2007 or 2006 is used).

   at KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmDestinationComponent.PreExecute()

   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)"

 

When you use SSIS the error will be under the insert/update data section as shown below:

 

In order to solve it, we will need to make sure that the Parent Customer ID type is also being populated. If the parent customer is a contact, the value in the field will be a Contact record; if the parent customer is an account, the value in the field will be an Account record.

We hope this blog was helpful! If you interested in learning more, please check out our other related Dynamics CRM blog topics such as:

Happy CRM'ing!

 

 

 

 


Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

PowerObjects Recommends