Dynamics NAV Business Central

Tags:

Updated:

3 minute read

Application configuration is an integral activity prior to the process of integration. If your chosen application is Microsoft Dynamics Business Central, providing the credentials is essential for configuring the agent. Here you will find the detailed description on how to configure the agents for the application of Microsoft Dynamics Business Central, the Integration Techniques and the Troubleshooting issues.

Note: For Integrating with Microsoft Dynamics Business Central, the application Microsoft Dynamics NAV (≥ 2009R2 Generic) is needed to be selected in AEC Portal

Prerequisites for NAV Business Central Configuration

  1. Select the application Microsoft Dynamics NAV (≥ 2009R2 Generic) in the APPS section of the APPSeCONNECT Portal.
  2. Create and publish a connection in the cloud portal.
  3. Update the Configuration in your On-Premise AEC Agent. You will find your Connection present in the agent. To Know about Agent Configuration, Click here

Note: if you are working with custom connector (per business need), custom touchpoints are needed to be created

ProTip: Before Implementing Integration with MS Dynamics NAV, the NAV Extension is needed to be installed. Click Here to know about the Installation Process.

Populating Historical Data in AEC Tables

After Installing the NAV Extension, the old data are needed to be synced and should be reflected in the AEC Tables. Therefore, these specific CodeUnit functions are needed to be called in the OnRun ().

CODE UNITS:

  1. AEC Customer Codeunit = CopyExistingCustomerInAEC(); Call this in OnRun() and save and then Run the CodeUnit

  2. AEC Item Codeunit = CopyExistingItems(); Call this in OnRun() and save and then Run the CodeUnit

  3. AEC Contact = CopyExistingContactInAEC;

Call this in OnRun() and save and then Run the CodeUnit.

Note: This should be done for all the Dynamics NAV Version.

Configure the NAV Business Central Application in the Agent

  1. Login to your AEC Agent with your registered account credentials.
  2. Click on the settings button to view the Credentials page.
    nav-businesscentral1
  3. Fill in the required details in the Credential Page
    nav-businesscentral2
  4. Click Save and Validate button.
  5. The validation success message confirms that the application is configured in the agent.
    nav-businesscentral3

The above steps completes the process of configuring Agent with NAV credentials

Troubleshooting

ISSUE 1: If the Source Application Not Found Some of the basic troubleshooting issue happens due to improper validations or even if it is accurately validated, and if touchpoints do not sync, this basic issue resolves after removing the Temp and Cache files from the portal and from your system. Therefore, after clearing all this publish the touchpoints again along with Update Configuration on the agent. For E.g. If the Source Application Not Found in the log file appears, the probable cause is due to the presence of the Temp and Cache Files.

Attributes and Actions

While defining a connect to an API endpoint in Microsoft Dynamic Business Central, you require clear understanding about the data requirements and endpoint configurations. You can refer to this document to find all the endpoint details of your Microsoft Dynamic Business Central installation. To define the endpoint in APPSeCONNECT, you need Actions and Entities. Actions are specifically targeted for an endpoint while schema is the data needed to execute the API. Here, is the list of some of the pre-packaged API actions defined for you which you can easily plug and play while doing your integrations.

Endpoint Action Action Type Schema UI Path API Path
ReadMultiple ReadMultiple GET Page/webapplicationcontactdata Fetch Accounts/customers from Business Central and post it to the destination application ReadMultiple
ReadMultiple ReadMultiple GET Page/webapplicationproductdata Fetch products from Business Central and post it to the destination application ReadMultiple
AECCustomerImport AECCustomerImport POST AECCustomerXMLPort Post customer from source application to Business Central AECCustomerImport
AECSimpleProductImport AECSimpleProductImport POST AECSimpleItemXmlPort Post product from source application to Business Central AECSimpleProductImport