SAP Business One

Tags:

Updated:

3 minute read

Application configuration is an integral activity prior to the process of integration. If your chosen application is SAP Business One, credentials need to be provided for validating the agent. Here you will find the detailed description on how to configure the agents for the application of SAP Business One, attributes and action, and the Troubleshooting issues.

Note: This document is for the SAP Business One version >=8.8

Prerequisites for SAP Business One Configuration

  1. Select the application SAP Business One 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

Configure the SAP Business One Application in the Agent

  1. Open APPSeCONNECT Agent by providing correct credentials.

  2. In the connection page of APPSeCONNECT Agent, you will see the connection is created in APPSeCONNECT Cloud.

sapb1-agent1

  1. Click on the credentials icon to provide SAP B1 credentials to validate the connection.

sapb1-agent2

  1. Provide the credentials of SAP B1

sapb1-agent3

Under SAP Event XML file path & SAP Image file path, you need to create two folders respectively and link the path to it. This path later needs to be provided in SAP B1 as well.

Follow the steps mentioned below, to provide SAP Event XML file path & SAP Image file path in SAP B1

  1. Open SAP B1 after providing valid credentials.
  2. Navigate through Administrator > System Initialization > General Settings.
  3. A form will open. Select “Path” menu under it. Browse for SAP Event XML file path and Image path.

sapb1-agent4

  1. After providing all the credentials. Click “Save” button.

sapb1-agent5

A message “Connection Data Saved” will appear if all the credentials provided by you for SAP B1 is valid.

  1. Click on the “Validate” button, to validate the connection.

sapb1-agent6

A message “Test Connection Successful” will appear if all the credentials provided by you for SAP B1 is valid. In this way, you can configure the credentials of SAP B1.

Troubleshooting

Issue 1: Source Application Data Not Found

“Source Application Data Not Found” even if Data is present is the Source Application.

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, you need to publish the touchpoints again along with Update Configuration on the agent.

For E.g. If the “Source Application Data Not Found” in the log file appears, the probable cause is due to the presence of the Temp and Cache Files.

Issue 2: Syncing issues

While working with SAP B1 Integrations, SAP Business One DI Server ON/OFF is needed to be done for proper syncing else data will not sync to SAP.

Attributes and Actions

While defining a connect to an API endpoint in SAP Business One, 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 SAP Business One 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.

SAP Business One being a SOAP based application, it has objects that are used for pushing and pulling the data. Click here to know about the Object Code ID, its Primary Key and the related Table in SAP that would be required for the Integration.

Endpoint Action Action Type Schema UI Path API Path
ExecuteSQL ExecuteSQL GET oEmployeesInfo Fetch employee from SAP Business One to destination Application
ExecuteSQL ExecuteSQL GET oItems Fetch Products from SAP Business One to destination Application
AddObject AddObject POST oEmployeesInfo Post employees from Source Application to SAP Business One