Seamless Integration with SAP Business One though Service Layer
Table of Contents:
Table of Contents
Requirements:
The seamless integration with SAP Business One HANA and Clarity requires Service Layer to be setup and running on Business One machine.
Version Compatibility
There are several interfaces within Clarity:
...
SAP Business One v10.*, 9.*
Interface functionality
The interface between SAP Business One and Clarity includes the following:
- Retrieval of all General Ledger account codes and descriptions from SAP Business One into Clarity
- Import of Employees from SAP Business One to add to Clarity Employee database
- Employees from SAP Business One imported to update employee records in Clarity
- Employees from Clarity exported to update employee records in SAP Business One
- Export of General Ledger Accounting Transactions into SAP Business One as an un-posted Journal Voucher.
Using the SAP Business One Cloud Interface
In order to interface to SAP Business One there are a few steps that you need to adhere to in order for the interface to function appropriately. After you have confirmed that the requirements are completed (above) then you need to go Setupà Preferences and go to the Interfaces tab. Here you must set the Default general ledger interface to use the export interface of SAP Business One v.10, v.9 - Service Layer Summary (seamless) or SAP Business One v.10, v.9 - Service Layer Detail (seamless).
...
Service Root URL specifies where your SAP Service Layer is setup.
Company DB is the name of the Database in SAP that you are attempting to connect too.
User name and Password are your user name and password used to log into SAP Business One client.
Retrieving General Ledger Account Codes
As you can see in the Image to the left, SAP Business One can have numerous General Ledger account codes, and depending on your needs, these codes may be quite long and complex.
...
Now you are ready to obtain the General Ledger account codes and descriptions from SAP Business One. To start the process you need to go to the menu SetupàGeneral LedgeràRefresh Code Finder where you will enter the connection information (described in the Using the SAP Business One Interface section above) and select the option next which will then provide you with a single option to “Refresh”. After the refresh is complete you will get a message saying “Import complete!” If you do not receive this message but instead receive an error message refer to the error message listings at the end of the document.
Exporting your General Ledger to SAP Business One
After you have processed your payroll you can export the information to SAP Business One, here we will cover the export details relative to the interface only, general details about exporting GL can be reviewed in the Exporting your General Ledger article.
...
Once you select the “Export” option the transactions will be sent to SAP Business One without further interference from yourself. With the successful export the records will appear as an Un-posted Journal Voucher in SAP Business One. These Vouchers can be accessed in SAP business One by going to FinancialsàJournal Vouchers. In the event of unsuccessful export you will be displayed an error message. Referee to the error messages at the end of this document for details on possible errors.
SAP Business One Employee Exchange
Accessed under UtilitiesàSAP Business One employee exchange this option allows you to export or import information between SAP Business One and Clarity.
The interface provides three (3) options:
Import into Clarity new employees existing in SAP Business One
Import into Clarity updates for employees existing in both systems
Export from Clarity updates for employees existing in both systems.
Import new employees into Clarity
It’s important to note that when using this interface option the point of employee creation should always be in SAP Business One. The reason behind this is that the Employee number assigned to Employees in SAP Business One is an auto-incremented, non-customizable field and used as the linking field between Clarity and SAP Business One.
...
The fields above that are listed with a * in front of them are considered mandatory fields and the employee record will NOT import if the fields has not been defined properly in SAP Business One.
Error Codes
-10061: REST request failed: Socket Error # 10061. Connection refused.
Service Root URL is incorrect.
...