Small and medium business | Business Central, N...

BC Integration with Dataverse -Item -Product

(0) Share

Report

Posted on by Vlora

How to do field mapping that are option from BC to CRM with Dataverse.

I need to to sync Type field in Item BC with Field Service Product Type in CRM Product table,Direction::ToIntegrationTable

Both are option and they have deferent values.

I did synchronization but doesn't work.

Can anyone has experience with this. Please write to me.

Thanks in Advance

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Vaishnavi J 3,062 on at

Like (0)

Report

Hi,

In Table filter add the below condition

Uncheck this if you want to create record

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

please check by going to the Integration Table mapping > field and there you can set the direction of each field. see the image.

Was this reply helpful? Yes No
Vlora 12 on at

Like (0)

Report

Hello Vaishnavi

Thanks for your answer

I need to send all Items that I have created or Insert new in BC to CE, also I have to sent Type value field as I have in bc to field service Product type to CRM Product Table CE.

I did Integration field mapping. "Type" Field in Item is Enum whether "Field Service Product Type" is Option and they have different value;

When I create new Item it doesn't send the properly value to CE. Also It doesn't work when i do synchronization.

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,062 on at

Like (0)

Report

Hi,

Could you please tell me which user performs the synchronization?

Is the D365 Sales admin account being used as the integration account? If so, this could be one of the reasons why items are not syncing properly.

You must create a valid user in D365 Sales with no admin rights and a separate Integration user account under whose credentials the integration is run.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much

Was this reply helpful? Yes No
Vlora 12 on at

Like (0)

Report

Hi

The synchronization is right.

All fields that are synchronized from Item BC are going well to CE ,except field Type.

In BC Field "Type" in Item Table is enum with values

value(0; "Inventory") { Caption = 'Inventory'; }

value(1; "Service") { Caption = 'Service'; }

value(2; "Non-Inventory") { Caption = 'Non-Inventory'; }

whereas field "Field Service Product Type" is Option in"CRM Product" table with this values

OptionMembers = " ",Inventory,"Non-Inventory",Labour;

OptionOrdinalValues = -1, 690970000, 690970001, 690970002;

I have done field mapping with this two fields and Id doesn't work properly. It doesn't sent the properly value to CE.

I need to do Direction::ToIntegrationTable .

for example if I select type Inventory in my Item and than create than Synchronize that Item with Item in CE it doesn't inherit this value to "Field Service Product Type" field.

I want to now If anyone has the same issue like me

Thanks

Vlora

Was this reply helpful? Yes No