Bulk Invoicing for Microsoft Bookings in Business Central
If your company uses the Bookings app in Microsoft 365, you can do bulk invoicing for appointments. The Bookings Not Invoiced page in Business Central provides a list of the company's completed bookings. In this page you can quickly select the appointments that you want to invoice and create draft invoices for the services provided.
Connect to Bookings
To connect your Business Central with Bookings, you must specify your Bookings company, what to synchronise with Bookings, how often to synchronise, and which templates to use. You set up this information on the Booking Sync. Setup page, which you can launch from the Exchange Sync. Setup page, which you can find through Search.
For example, if you want to synchronise customers between Bookings and Business Central, you must specify the default template to use to add new customers in Business Central based on the customers in your Bookings company.
Note
The Bookings app is designed to book appointments for individual customers rather than companies. The synchronisation with Business Central will, therefore, only synchronise customer contacts with a Type of Person. An email address is also required for the contact to synchronise.
Similarly, if you want to synchronise service items between Bookings and Business Central, you must specify the default template to use to add new service items in Business Central based on the services in our Bookings company.
Note
Only items of type Service will synchronise between Bookings and Business Central. The template that you set up in the Configuration Templates page so it can be used for the item synchronisation must define the type as Service.
Invoice Appointments
When it is time to send invoices for the completed bookings, you go to the Bookings Not Invoiced page. Depending on how often the information is synchronised, the list is long or short. You can create invoices for all bookings in the list or one booking at a time. You can select one or more entries in the list and invoice those only.
The support for invoicing appointments from Bookings is simpler than the fuller workflow of working with sales quotes, sales orders, and sales invoices. For more information, see Invoice Sales. You can choose to sell your services using Business Central or choose to use Bookings, depending on your business needs.
Note
In May 2022, we discovered an issue in the integration with Bookings. Currently, the sync from Bookings to Business Central requires you to manually associate the invoices with customers in Business Central.