Integration with SAP Business One

Download the latest version of the web service at the bottom of this article.

Extract the files into a directory (for example: C:\Zenvoices\SAP Business One web service).

Create a new website in IIS named “Zenvoices SAP Business One web service” and link it to the directory.

Install a valid SSL certificate and create an HTTPS binding with this certificate. If the customer does not have an SSL certificate, a certificate from Zenvoices can be used. Contact support to request this certificate. See the guide for installing an SSL certificate.

Open appsettings.json with a text editor and change the following settings if necessary:

a. Archive directory (Zenvoices.ArchiveDirectory): the directory where archive documents must be temporarily stored. For example: C:\Zenvoices\Archive temp. Ensure the IIS process has access to this folder. This can be done, for example, by giving the local group IIS_IUSRS write access to this folder.

b. Secret token (Zenvoices.SecretToken): generate this for example via https://lastpass.com/generatepassword.php and use a length of 32 characters. Generate a token that only contains letters and numbers to prevent XML encoding errors.

Afterwards verify that the IIS website is no longer accessible by opening it in a browser. A 401 error should be displayed when calling http://localhost:8900/api/masterdata/authenticate. This confirms that the additional security works.

Ensure that the IIS process has access to the digital archive directory configured in SAP Business One (see chapter “Digital archive explanation”). This can be done, for example, by giving the local group IIS_IUSRS write access to this folder.

Go to Manage / Environment / Accounting integrations in Zenvoices, create a New accounting integration and choose SAP Business One.

Fill in the requested details:

a. API URL: the URL where the Zenvoices SAP Business One web service is accessible via the internet. For example: https://ipadresklant:8900/

b. Secret token: the secret token configured in appsettings.json.

c. Database server name: hostname/IP address and port (optional) of the SAP Business One database server. This can be found by starting the SAP Business One client and clicking “Change Company” during login. The server name can be found in the second field on the right behind Current Server.

d. Administration database name: database name of the administration to be connected.

e. Username: username of the integration user.

f. Password: password of the integration user.

g. Database server type: server type of the database.

Click Next to test the integration. If the integration works, a list of administrations will be displayed. This list always contains one administration.

Set the default administration details in Zenvoices: currency and country (optional).

Test the integration by performing the following actions:

a. Read a test invoice.

b. Create a relation from the booking screen in Zenvoices.

c. Save the booking so that it is exported to SAP Business One.

d. Check the result in SAP Business One: verify that the booking and the archive document can be consulted. Delete the data afterwards.

Stop the IIS website of the Zenvoices SAP Business One web service

Overwrite all files except appsettings.json

Start the IIS website

Test from Zenvoices whether the integration works