NAV-CRM Connector - Error generated for Country/Region code when activating Enumerated values to Picklist map

Hi Hemant,

Error point on issue with NAV part mapping, could you show what you have in your PickList Map for "dynamics_erpcountrycode" field?

My map has "dynamics_erpcountrycode" = "Countries Regions\Country Regions\Code" and it works fine

cheers,

Konstantin

Hi,

Thanks for your reply.

Below is the screenshot of the Enum-Picklist map.

It appears that the mapping is same as you have however i don't know from where the event log is picking up the mapping to Countries Regions\Item\Code.

Here is the screenshot of the event log.

Hope the above information is usefull.

Regards,

Hemant

Looks like you have modified Country Page (PAG10) in NAV.

Please make sure that your page has field "Code". if not, then you have to add it and refresh Connector Setting for NAV.

Another strange thing, on screenshot you have "Countries/Regions\Country/Regions\Code", on my map I have  "Countries Regions\Country Regions\Code". Spaces instead slashes.

You can also try to delete this line in mapping and add it again, probably it will help.

Cheers,

Konstantin

The Page10 do have the Code field.

I then deleted the map and added it as Countries_Regions\Country_Region\Code. Note the underscore '_' instead of forward slash '/'.

After making the above change and running the map again, i see that the map is running successfully. I even verified the picklist values populated from NAV to CRM.

The reason for using underscrore instead of forward slash is due to the setup done on Alter Database dialog, Integration tab > Remove Characters. Here it is set as ."\/'. which effectively removes the forward slash found in Country/Region and replaces it with underscore i.e. Country_Region (as seen in SQL database table name)

Please check your Remove Character setting in Alter Database dialog for having spaces in your object name i.e. Country Region .

One hintch i have is that inspite of the map running successfully, the Last Run Time is not getting updated.

Any idea?

Thanks,

Hemant

Hey, after exiting the connector and running it again i can see the Last run time getting updated.

I suspect it was not changing since i was running a RDP to the connector machine for a long time.

Seems like the problem is solved.

Thanks once again.

Hemant

Hi again,

After running the Customer-Account map, it seems that the issue is not resolved. The log shows an error displaying "...The supplied country "UK" is not in the integrated Microsoft Dynamics ERP Country options". This means that the Enum-Picklist mapping for Dynamics ERP Country Code has some problem.

Although i have set the Dynamics ERP Country Code mapped to Countries_Regions\Country_Region\Code in Enum-Picklist mapping, when i click the icon next to this mapping field, the Map Destination Field dialog does now show any selection for Countries_Regions. Since i have entered the mapping manually, it maps the field to a constant value. Sounds strange to me.

Is there any selection available in Map Destination Field dialog for Countires_Regions?

Any idea?

Thanks,

Hemant

Has anyone solved this Topic so far? We have exactly the same problem here.