Changing the Common Data Service-option mapping

(0) Share

Report

Posted on by JR61

Hello everyone,

At our company we're currently integrating Business Central with Dynamics 365 Sales. One of the problems we're facing is changing the standard CDS-option mapping for payment terms.

The standard CDS mapping contains 4 options: NET30, 2%10NET30, NET45 & NET60. However we would like to use different options for our payment terms. The payment term should be set in a field in the CRM order, and should automatically also give the same value when sending the order to Business Central.

The problem is that when changing the labels in the CDS field for 'payment terms' does not have an effect on the CDS-option mapping (also not after synchronising), the standard options will remain when changing the label in the CDS. My question therefore is; is there a way to change the CDS-option labels and if yes, how can I do it?

I am referring to the following CDS-options table:

Many thanks in advance!

Kind regards

All responses (3)

Answers (1)

JR61 20 on at

Like (0)

Report

RE: Changing the Common Data Service-option mapping

We managed to do this via an extension, thanks!!
JR61 20 on at

Like (0)

Report

RE: Changing the Common Data Service-option mapping

Thanks for your reply!

Is there a maybe a video or youtube tutorial that explains how this can be done? Unfortunately, it is still not completely clear to me.
Verified answer

Chris Bulson on at

Like (1)

Report

RE: Changing the Common Data Service-option mapping

Hello,

This is a customization that can be done through a fairly simple extension. Here is a document with example code.

docs.microsoft.com/.../admin-cds-missing-option-values