Dynamics Community Forum Thread Details

Integrated Manager: Payroll Master

For some reason, integration manager cannot update address id, address 1, Gender, Marital Status, Ethnic, Origin and Deduction:

I have a text source file with all the fields above defined.

I have the destination: Payroll Master

I have a destination mapping that maps the field in the source file with the destination.

I have tried setting the integration to update only and insert and update but nothing works.

The integration runs successfully with no errors and no warning but only the address id updates. The other fields remain blank. I have set the "Employee ID" as IsKey under Source setting.

What is going on here?

To start with I would say that the Address ID and all address fields need to be in a separate source file (although this could be the same physical file). Integration Manager is weird about the way it handles one to many relationships. If there's a one to many in the database (e.g. multiple address for one employee), you generally need to have different source files.

For the gender, marital status, and ethinic orgin, you probably don't have have valid values in the source file for the import. Since these are drop down lists in GP, the values are numeric from 0 to ... To make sure you have to correct values, you should always translate these fields by using the Translation option. Let me know if you need more info about doing this. Hopefully this is enough to get you started.

Mike

Quick Links