web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Changing the Common Data Service-option mapping

(0) ShareShare
ReportReport
Posted on by 46

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:

cds-payment-terms.PNG

Many thanks in advance!

Kind regards

I have the same question (0)
  • CU17101358-0 Profile Picture
    46 on at

    We managed to do this via an extension, thanks!!

  • CU17101358-0 Profile Picture
    46 on at

    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 Profile Picture
    on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,513

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 706 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans