AbaConnect Web service receivables interface

This extension is no longer being developed. Instead, the cloud-ready Abacus Web Receivable Interface 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 AbaConnect Webservice extension offers all possible FAR related activities in Vertec, except the selection of a FAR client. The AbaConnect Webservice extension does not offer the possibility to import or export files (XML or ASCII). The extension uses the Abacus extension definitions of version 2007.10. For operation an Abacus 2012 or newer is required.

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 web services, the AbaConnect web services must be accessible over the network. Vertec connects to the AbaSioux web server; 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, check the ports on which the AbaSioux service receives data in the ABACUS ServiceManager under Ports.

The AbaConnect user in Abacus must be licensed per application used through AbaConnect. The Vertec AbaConnect web service debtor interface uses FIBU (as the accounts are used), DEBI and ATK (Abacus ToolKit for VAT types, payment connections, cost centers and addresses).

Posting without a “Customer” license

As of Vertec version 6.2.0.4 it is possible to post receivable invoices without the Abacus license for the “Customer” interface. This means that customers who have only “Document” license can also use the interface.

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

Further system settings for the AbaConnect Webservice receivables interface are:

Abacus Project Number Expression: See Abacus Credit Cost Center2 Expression. For customers who had previously installed an Abacus extension, this system setting is still called Abacus Project Number Expression. However, it does exactly the same as before, namely the Credit Cost Center2. The designation has been changed for new installations.

Abacus Credit Cost Center2 Expression (formerly Abacus Project Number Expression): Here you can specify an OCL expression. This refers to the project of the posted invoice, the result is then passed as Credit KST2 for each posting line. Since Credit KST2 is an account, the result must be an integer.

The expression is interpreted directly as OCL and therefore does not have to be enclosed in % symbols.

PropertyName: AbacusProjektnummerExpression. StringProperty.

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

PropertyName: CreateAddressesForAllDb. BooleanProperty.

Receivable postings Cancellation method: Sets whether Vertec should use the cancellation or internal credit option when cancelling receivables. This setting can be changed during operation.

PropertyName: Stornierungsmethode. SelectProperty.

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.

Use invoice number as Abacus document number: If this property is set to Ja, the invoice number is used as the posting number. The number ranges in Abacus for invoice numbers and posting numbers must be identical in this case.

If ESR from Vertec is used, this setting must be set to Yes. The invoice number is passed in the ESR coding line. In order for Abacus to assign invoices when reading in payments from Post/Bank, the document number in Abacus must be the invoice number in Vertec.

PropertyName: AbacusUseRechnungBelegnummer. BooleanProperty.

Blocked date Accounting: Specifies the date from which postings are allowed. Postings with an older date are rejected with an error message. If nothing is specified, all postings are allowed.

PropertyName: SperrdatumBuchhaltung. 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 receivables and the VAT codes must be imported from Abacus into Vertec.

In addition, the settings in Abacus regarding invoice numbers and document numbers must match the settings in Vertec.

Furthermore, the types (account or cost item) of the revenue accounts used must correspond to the data stored in Vertec. For example, cost units must be stored 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

Once you have installed the AbaConnect web service receivables extension, you can call up the payment reconciliation via menu settings > Payment reconciliation.

The individual payments are then read into an invoice from AbaConnect and the invoice is adjusted accordingly in Vertec.