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

Community site session details

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

Integration BC (on-premise) and sales (on-premise) custom entities

(0) ShareShare
ReportReport
Posted on by 5

Hello,

My company uses Dynamics Sales on premise and would maybe like to deploy Business Central on premise. The company sells insurance policies.

Custom entities have been created in Dynamics Sales to manage the policies. 

How can BC get the data in these custom entities to create invoices?

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    131 on at
    RE: Integration BC (on-premise) and sales (on-premise) custom entities

    This walk through is helpful for the general pathway: docs.microsoft.com/.../administration-custom-cds-integration

  • wapiti Profile Picture
    5 on at
    RE: Integration BC (on-premise) and sales (on-premise) custom entities

    Thanks for the answer.

    But the Dataverse is only in the cloud, right?

    The company would like to keep their data on premise, and doesn't want to use a cloud solution.

  • AliHH Profile Picture
    40 on at
    RE: Integration BC (on-premise) and sales (on-premise) custom entities

    Hello,

    You will need to create tables of type "CRM" in Business Central using VS Code and AL language of course, and this can be done using tools provided by Microsoft that automatically generate the tables' definition in AL Code (regardless if the deployment is Online or On-Premise). Once that is done, in business central you need to connect to the CRM Organization, now fro Dynamics 365 Slas Online (CRM) it is easy, but for On-Premise it seems that Business Central On-Premise won't connect to CRM On-Premise, as I'm too trying to connect BC (On-Prem) to CRM(On-Prem) and haven't yet found a solution

  • Suggested answer
    Marco Mels Profile Picture
    on at
    RE: Integration BC (on-premise) and sales (on-premise) custom entities

    Hello,

    This is a difficult scenario to establish and probably also difficult to maintain. You must first connect to Dataverse in later releases of BC before you can connect to CRM OnPrem.

    I did setup the scenario myself and we (developers from Product Group and CSS (me)) got very far in making this work. Our developers directly worked on the virtual machines I created for them. But in the end the customer decided to move to CRM Online as it took us a very long time as it was very complicated.

    Best probably is to consider moving from CRM OnPrem to CRM Online to get scenario to work.

    Thanks.

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

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 3,421

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,878 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,645 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans