Skip to main content

Notifications

Announcements

No record found.

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

MS Bookings Sync Setup

(0) ShareShare
ReportReport
Posted on by 323

Hi,

Has anyone configured MS Bookings before ? Please share some steps. Thanks.

  • DK-17100705-0 Profile Picture
    DK-17100705-0 7 on at
    MS Bookings Sync Setup
    Hi all,
     
    I presume there has been no update to this. I am still getting the same error ( Cannot open the Bookings Sync. Setup page. Make sure that your company is set up in the Bookings application in Office 365. ) - but the bookings sync option is still there. 
    Do I need to do the manual sync using Power Automate? Anyone else had any joy here? 
  • Verified answer
    KC Lai Profile Picture
    KC Lai 323 on at
    RE: MS Bookings Sync Setup

    Hi Marco,

    We have a prospect who is looking for Bookings that integrates with BC for billing.  I have to ask them to wait then.

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: MS Bookings Sync Setup

    Hello,

    That is correct. Due to deprecation of Basic Authentication in Exchange Online, MS Booking does no longer work in any OnPrem / Cloud release of Dynamics 365 Business Central and you will get the error reported.

    Based on this community posting, I created an internal bug for this issue. At the moment, I cannot tell when the team will get to this due to all the other priorities they have.

    The document you already found is what we have, It should be sufficient but you cannot get past the authentication issue.

    Thank you.

  • KC Lai Profile Picture
    KC Lai 323 on at
    RE: MS Bookings Sync Setup

    Hi Marco,

    My setup is Business Central Cloud. Do you mean I need to wait for future release?

    Is there any documentation to share on mapping the fields from Bookings to Business Central - Customers, Sales Invoice etc. ?

    Regards

    KC

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: MS Bookings Sync Setup

    Hello,

    The error is misleading which is a bit unfortunate. The root cause is that the connection string still tries to connect via Exchange Web Services which has been deprecated by Exchange Online team. At least the following code applies to OnPrem:

           BookingsSetupErr: Label 'Cannot open the Bookings Sync. Setup page. Make sure that your company is set up in the Bookings application in Office 365.';

       procedure BuildExchangeConnectionString(var ExchangeSync: Record "Exchange Sync") ConnectionString: Text

       var

           User: Record User;

           Token: Text;

           Password: Text;

       begin

           // Example connection string

           // {UserName}="user@user.onmicrosoft.com";{Password}="1234";{FolderID}="Dynamics NAV";{Uri}=outlook.office365.com/.../Exchange.asmx

           if (not GetUser(User, ExchangeSync."User ID")) or

              (User."Authentication Email" = '') or

              (ExchangeSync."Folder ID" = '') or (not GetPasswordOrToken(ExchangeSync, Password, Token))

           then

               Error(O365RecordMissingErr);

       procedure RegisterBookingsConnection(BookingSync: Record "Booking Sync")

       var

           ExchangeSync: Record "Exchange Sync";

       begin

           if ExchangeConnectionID <> '' then

               UnregisterConnection(ExchangeConnectionID);

           if BookingsConnectionReady(BookingSync) then

               exit;

           if BookingsConnectionID <> '' then

               UnregisterConnection(BookingsConnectionID);

           ExchangeSync.Get(BookingSync."User ID");

           BookingsConnectionID := CreateGuid();

           if RegisterConnection(ExchangeSync, BookingsConnectionID, BookingsConnectionString) then

               SetConnection(ExchangeSync, BookingsConnectionID);

       end;

    I expect that this code for MS Booking also applies to the Cloud release (requiring connection via Exchange web services). Fortunately, we added support for Exchange contact synch allowing OAUTH2 connecting strings but we did not yet do this for the OnPrem world. This will therefore never work until we add support to Exchange Synch to allow OAUTH2 connections for the Exchange contact synch in both OnPrem and Cloud.

    I will add this information to the work item we currently have open.

    Thank you for raising this to us.

  • KC Lai Profile Picture
    KC Lai 323 on at
    RE: MS Bookings Sync Setup

    Hi,

    The links did not say much how to setup company in MS Bookings. 

    Look forward for materials to configure the connector within Business Central.

    Regards

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
  • KC Lai Profile Picture
    KC Lai 323 on at
    RE: MS Bookings Sync Setup

    Hi,

    I created a Booking Page named as "Cronus AU" in O365.

    In Business Central Cloud  >Exchange Sync Setup > Validate Exchange connection. This was successful.

    I proceed to Navigate>Bookings Sync Setup>

    I received the following message .

    Cannot open the Bookings Sync. Setup page. Make sure that your company is set up in the Bookings application in Office 365.

    I search through Business Central Help, but no much information.

  • Suggested answer
    Manish Prasad Profile Picture
    Manish Prasad 315 on at
    RE: MS Bookings Sync Setup

    Hello KC Lai,

    Go through this video link. Hope it will help you.

    www.youtube.com/watch

    If my answer helped you, maybe it can help others, please verify it, so other users know it worked or helped you.

    Thank you.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans