AbaConnect Webservice Accounts Payable extension

This extension is no longer being developed. Instead, the cloud-ready Abacus Web Accounts Payable Extension can be used.

Note: As of Vertec 6.5.0.16 , extensions and modules on the filesystem are no longer considered, but are imported as Vertec script modules. Accessing the module wshelper is therefore no longer available in newer versions.

If you want to continue using the module in the new extension, you can register the module as a script (only line Expert):

• Open the file wshelper.py from the extension folder of your Vertec installation directory.
• Create a script in Vertec and paste the contents of the file as script text. Make sure that the first symbol in the script text # is.
• Save the script as wshelper (case sensitive!)

General

The AbaConnect Webservice extension addresses the AbaConnect Webservices directly over the network. The connection is made using the protocol http or https, depending on how the URL is entered. If https is to be used, it must be ensured that the Abacus server is reachable using this protocol.

The extension uses the Abacus interface definitions of version 2007.10. An Abacus 2012 or newer is required for operation. In order to be able to create new addresses in accounts payable, the address module must be licensed in Abacus.

In order to activate the AbaConnect web service extension, a number of settings have to be made on both sides (Vertec and Abacus). These are explained below.

The Abacus application must support AbaConnect web services. If you are unsure about this, please consult the Abacus application support.

If your Abacus application supports AbaConnect Webservices, the AbaConnect Webservices must be accessible over the network. Vertec connects to the AbaSioux Webserver; the corresponding port must be accessible and open in the network (the firewall must be configured accordingly). By default this is port 40000, for security, please check the ABACUS ServiceManager under Ports on which port the AbaSioux service receives data.

Some system settings are installed for all accounts payable interfaces. These are listed in System settings > Accounting.

Further system settings for the AbaConnect web service accounts payable interface are:

Use Abacus supplier number as address number: This setting must correspond to the address number unique setting in Abacus (program 6311 Client Information). If you have not licensed the address module in Abacus and the address number unique option is enabled, it is not possible to create accounts payable addresses from within Vertec due to limitations in Abacus.

PropertyName: AbacusUseSupplierAddress Number. BooleanProperty.

Open addresses in all tenants: This setting is currently ineffective.

PropertyName: CreateAddressesForAllDb. BooleanProperty.

FAR client: The code of the FAR client must be entered manually. Abacus does not offer the possibility to select the client via a web service.

Starting with Vertec 6.2.0.3, the interface supports business areas. Business areas in Abacus only concern transaction data (postings), not root data (personal account). In Vertec, business areas are implemented in such a way that they are a property of the personal account. This means that a personal account knows which business area it should post to and always posts to the same business area. Cross-department posting is not currently supported. The business area must be entered following the client’s code with a hyphen. Therefore, if a personal account is to be posted in business area 10 of the client 7777, the entry must read 7777-10.

PropertyName: FARConnection. StringProperty.

FAR Login: User name for logging in to Abacus. Since a certain login can only log in to Abacus once at the same time, the same user should not be used as the one logging in to the Abacus client program.

PropertyName: LoginFibu. StringProperty.

FARU Password: The password of the user specified under FARU Login.

PropertyName: PasswordFibu. StringProperty.

URL for Abacus web services: The URL to the AbaSioux server, e.g. http://myhost:40000/abaconnect/services.

PropertyName: AbacusBaseUrl. StringProperty.

Before the extension can be used, the payment terms for accounts payable and the VAT codes must be imported from Abacus into Vertec.

Furthermore, the types (account or cost item) of the expense accounts used must correspond to the data stored in Vertec. For example, cost units must be defined in Vertec if accounts of type cost item are posted.

The Abacus interfaces have a built-in mapping table to determine the country code to be used for posting. This table allows plain text country names in Vertec address entries to be converted to the country abbreviations used by Abacus (e.g. Switzerland = CH). Currently, the mapping table contains entries for Switzerland, Germany, Italy and France.

If a country is not in this table, the extension from Vertec 6.1.0.12 uses the country on the address directly as the country code for the extension. It is therefore necessary to ensure that the country is a valid Abacus country code. If the country is empty, CH is used.

Example default country code:

• empty: CH is passed (default value)
• DE or DEU: DE is passed (in mapping table)
• AT: not in Vertec mapping table, but in Abacus
• OE: gives Abacus error because not known in Abacus