Header Ads Widget

Top Picks


Bringing ChatGPT into Business Central

 Hi readers,

The purpose of the blog is to provide a step-by-step guide on how to integrate ChatGPT, a conversational AI tool, in Business Central, an all-in-one business management solution. The blog aims to educate readers on what ChatGPT and Business Central are, and how to sign up for ChatGPT, obtain the ChatGPT API, and create a Codeunit, Table, and Page in Business Central. The blog post also aims to show readers how to integrate ChatGPT into Business Central, and how it can be used to streamline business operations and enhance customer support.


What is ChatGPT?

  1. Definition and overview of ChatGPT
  2. Explanation of how it works and its key features

2.      What is Business Central?

    1. Definition and overview of Business Central
    2. Explanation of its features and benefits for businesses

3.      How to Signup in ChatGPT

    • Step-by-step guide on how to create an account in ChatGPT
    • Explanation of the requirements and necessary information
    • ChatGPT Play Ground

4.      Creating a Codeunit in Business Central

6.      Creating a Table in Business Central

7.      Creating a Page in Business Central

       Video Explanation

8.     Conclusion

What is ChatGPT?

a. ChatGPT is an advanced conversational AI language model developed by OpenAI. It is a state-of-the-art deep learning model trained on a massive corpus of text data, allowing it to generate human-like responses to a wide range of natural language queries and conversations.

b. ChatGPT works by analyzing the context of a conversation and generating responses based on the patterns it identifies in the data. Its key features include the ability to generate coherent and contextually appropriate responses, adapt to the tone and style of the conversation, and learn from user interactions to improve its performance over time. ChatGPT can be used for a variety of applications, including customer support, chatbots, virtual assistants, and more.

What is Business Central?

a) Business Central is an all-in-one cloud-based business management solution developed by Microsoft. It provides a comprehensive suite of tools and functionalities for small and medium-sized businesses, including financial management, sales and service management, project management, supply chain management, and more.

b) Business Central is designed to help businesses streamline their operations and improve their productivity by automating routine tasks, providing real-time visibility into their operations, and enabling collaboration and communication across teams. It offers a user-friendly interface and can be easily customized to meet the specific needs of each business.

Some of the key features and benefits of Business Central include:

  • Financial management: Allows businesses to manage their financial operations, including accounting, budgeting, cash flow management, and more.
  • Sales and service management: Enables businesses to manage their sales and service processes, including customer relationship management, order management, and invoicing.
  • Project management Provides tools for project planning, resource management, and time tracking.
  • Supply chain management: Helps businesses manage their supply chain operations, including inventory management, purchasing, and vendor management.
  • Reporting and analytics Offer real-time visibility into business operations through customizable dashboards, reports, and analytics.

 How to Signup in ChatGPT

  1. Step-by-step guide on how to create an account in ChatGPT

  • The top right corner of the page has the "Get Started" button.
  • Include your name, email address, and preferred password in the registration form.
  • The "Create Account" button must be clicked in order to submit your registration.
  • Check your email for a verification link from ChatGPT and click on the link to verify your email address.
  • You can access your ChatGPT account when your email address has been validated.

Requirements and necessary information for signing up for ChatGPT include a valid email address and a strong password. It's also important to read and agree to the ChatGPT terms and conditions before creating an account. Additionally, some of the advanced features of ChatGPT may require additional setup and configuration, such as obtaining an API key.

Steps: b. Explanation of the requirements and necessary information, Step-by-step guide on how to obtain the ChatGPT API

The steps to develop an API are listed below. 

ChatGPT playground to check if it works

Creating Codeunit in Business Central

The code uses an HttpClient to send a POST request to the ChatGPT API with the user's message prompt and the necessary parameters for the AI to generate a response.

The code also includes a local procedure to create the JSON object required for the access and refresh tokens and another local procedure to read the response from the ChatGPT API and insert it into the Chat GPT table in Business Central.

The "SendMessage" procedure takes in the user's API key and message prompt as parameters sends the request to the API and returns the generated response. The response is then parsed and inserted into the Chat GPT table using the "InsertResponse" procedure.

You can find the codeunit code on the Github Page  (Save the repository for easy access)

Creating a Table in business central

The table has two fields: "Entry No." which is an auto-incremented integer field and "Message" which is a text field that stores the chat interaction. The table has one primary key "Entry No." which is clustered. The data classification for both fields is set to "CustomerContent" indicating that it contains data that is considered confidential and should be protected.

You can find the Table code on the Github Page (Save the repository for easy access)

Creating Page in Business Central

The page is based on the "Chat GPT" table and displays a list of interactions between the user and the ChatGPT model. The layout of the page consists of a content area with a field to input a message to send to the ChatGPT model and a repeater with a read-only field that displays the messages exchanged. The page also includes an action to send a message to ChatGPT.

The page uses the codeunit "ChatGPT Integration with BC" to interact with the ChatGPT model. When the user inputs a message in the "MessageToSend" field and clicks the "Send message to ChatGPT" action, the codeunit sends the message to the ChatGPT model using an API key and displays the response in a message box.

You can find the Page code on the Github Page (Save the repository for easy access)

Step-by-step video


In this blog post, we have explored the concept of Chatbots and their integration with Business Central using Chat GPT. We have discussed the benefits of using Chatbots in businesses, such as improved customer engagement, cost savings, and increased productivity.

The blog post has provided a step-by-step guide on how to integrate Chat GPT with Business Central, including creating a Chat GPT account, setting up the API key, and creating a codeunit to handle the integration.

Readers are encouraged to consider the benefits of Chatbots for their businesses and explore the integration with Business Central using Chat GPT. With the availability of tools like Chat GPT, businesses can easily enhance their customer engagement and streamline their operations, leading to increased efficiency and profitability.

Leave you doubts and thoughts in the comment. 

Will meet you soon in the next blog. 

Post a Comment


  1. Replies
    1. how can we flow data of custom field on transfe line to item ledger entry

  2. These electronic tool cases csgo skins could be purchased through various suggests, such as for instance in-game falls, trading with different players, or buying them from the Steam Community Market. While cases don't provide any gameplay benefits, they offer players a method to customize their gaming knowledge and highlight their fashion to others.

  3. I am thankful to this blog giving unique and helpful knowledge about this topic.ai check

  4. It is really a helpful blog to find some different source to add my knowledge. person does not exist com


Youtube Channel Image
goms tech talks Subscribe To watch more Tech Tutorials