Topal Solutions accounts receivable extension

Setting up and operating the Topal Solutions receivable interface

Product line

Standard

|

Expert

Operating mode

CLOUD ABO

|

ON-PREMISES

Modules

Services & CRM

Budget & Phases

Purchases

Resource Planning

Business Intelligence

Created: 05.03.2007
Machine translated
Updated: 15.03.2024 | Cloud-ready from Vertec 6.7.0.7

Prerequisites

For the operation of the Vertec Topal interface a 32bit Topal client is required.

As of version 6.4, Vertec is shipped as a 64-bit application. In order for the Topal extension to work with it, Topal has to be switched to 64-bit. For this purpose, Topal has a menu item Tools > Switch to x64:

Cloud Capability

The Vertec Topal extension is cloud-ready from Vertec version 6.7.0.7 onwards. In order to be able to use it in the cloud app, a Vertec version from 6.7.0.7 onwards is required.

Installing the extension

In Vertec, open the extensions in the settings folder. Select the Topal Solutions receivables interface and press the Install button.

System Settings Vertec

Some system settings are installed for all receivables. These are listed in System settings > Accounting.

The special system settings for the Topal Solutions receivable interface are:

Topal Server: the server name of the Topal server. For Topal single-user installations this value can be left blank, the extension then uses localhost as the server name.
Attention: For Topal network versions localhost does not work, even if the extension is used locally on the server, the host name of the server must always be entered.

PropertyName: TopalServer. StringProperty.

Topal Login via SSL: As of Vertec 6.1 you can set whether the connection to Topal should be made via SSL.

For this system setting to appear, the Topal extension must be installed once after updating to Vertec 6.1

uninstalled and reinstalled . Existing system settings are not lost. If the system setting is not visible or set to No, everything remains as before and the extension continues to work.

Further information on Topal SSL connection can be found at http://info.topal.ch/content/info/Topal_Media_Server/de/topal_ssl_anbindung.htm.

PropertyName: TopalUseSSL. BooleanProperty.

FAR Login: The login name for the login to the Topal server.

PropertyName: LoginFibu. StringProperty.

FAR password: The password for logging in to the Topal server.
Attention: A certain login can only be logged in to the Topal server once at the same time. If the Topal client program is to be used at the same time as the Vertec extension, it is recommended to use a separate login for the extension.

PropertyName: PasswordFibu. StringProperty.

FAR client: The client number (code) of the Topal client.

PropertyName: FARConnection. StringProperty.

Posting period: The posting year of the Topal client to be used for new postings.

PropertyName: PeriodFibu. StringProperty.

Number range receivable postings: Select the receivable number range directly from Topal by clicking on the “...” button. The code of the number range is stored with this code. For each posting, a number range with this code is searched and used if found. If no number range with the stored code is found in a client, no number range is simply passed on.

Since number ranges in Topal are client-specific, it is possible that a number range can be found in one client with the stored code, but not in the other client. If you want to post several clients in Topal, all clients in which you want to use a number range must have a number range with the same code.

PropertyName: DebiNumber Range. StringProperty.

Cancellation method: Versions before 5.8 implement cancellation in Topal as deleting the invoice. From version 5.8 onward, the cancellation method can be set. The following options are available:

  • Delete invoice: Default setting. The invoice is deleted in Topal when canceling in Vertec.
  • reconcile with credit note: Topal performs the cancellation as follows:

    1. A credit note will be created for the invoice amount.
    2. In addition, a so-called zero-sum posting is created, which posts the corresponding invoice amount from account 1100 (debt collection account) to account 1100 each in debit and credit. The period selection for cancellation is based on the posting year.

PropertyName: Cancellation method. SelectionProperty.

Client Password

If you have entered client passwords in Topal (password protection activated), the check mark for Require password when logging in by another application must be removed in the client properties under security in order for the extension between Vertec and Topal to work properly.

Handling of numbers

The topal interface uses the numbers as described below. This description applies to topal interfaces from version 149.

Post

Vertec writes the invoice number in the Topal in the FreeInvoice Number field. The Invoice Number field in Topal is not described. Topal assigns the invoice number independently.

For this purpose, the Free Invoice Number Unique and Ascending option should be deactivated. Otherwise, an error message Duplicate Free Invoice Number may appear and the invoice will not be posted.

Reporting

If the Free Invoice Number is to be output on the Topal Reports instead of the invoice numbers, this can be set per client in the properties.

The user interface may vary depending on the version of Topal. However, all settings can always be found in the client properties.

Posting completed

In Vertec, the Topal invoice number is saved as a document number on the just posted invoice. It serves as a clear reference to the Topal invoice for the payment reconciliation.

Restrictions

Support for balance taxation

Topal 6 always supports posting with gross amount. This means that posting also works for clients with balance taxation. The posts from Vertec have been changed accordingly, with the FibuTopal.py extension from version 131 onwards, only gross amounts are transferred to Topal.

Vat billing according to net tax rates

If you want to settle according to net tax rates, you must also make the following adjustments:

Necessary adjustments in topal for net tax:

  • In the client’s settings, balance tax must be selected under the VAT settings.
  • VAT rates must be adjusted to the rates indicated by the VAT authority.

Necessary adjustment in Vertec for net tax:

  • In the settings > Projects > VAT types, the VAT codes must be applied from Topal. After that, however, the tax rate must be overwritten manually, since the customer must receive an invoice with the standard rate.

Example of posting after net tax

An invoice in Vertec looks like this:

  • Invoice in Vertec over CHF 1000.00
  • VAT 8% CHF 80.00
  • VAT Code: UStn

The following shall be handed over to Topal:

  • CHF 1080.00
  • VAT code: UStn (this is mandatory so that the VAT billing in Topal works correctly)

Payment Import

Once you have installed the Topal Solutions receivables interface, you can import the payment reconciliation via menu settings > Payment reconciliation.

The payment reconciliation looks in the topal for the invoice number, which is posted in Vertec as a document number, and thus finds the corresponding payments.

The individual payments for an invoice are then imported from Topal and the invoices are adjusted accordingly in Vertec. The payments created by the payment reconciliation receive the payment document number from Topal as the document number.

Handling of invoices with deduction amount

If an invoice is paid in Topal with a discount or discount, Topal will create a payment as if the customer had paid the full amount and a second payment with the discount amount.

When importing a payment with Vertec, the payment with the deduction amount is ignored. Thus, the amounts are correct even for partial payments (with / without deduction amount), and the invoice appears normally paid in Vertec, the outstanding amount is 0. The deduction cannot be traced in Vertec.

In case of overpayments, Vertec imports the complete payment amount and sets the paid check mark; the invoice then has a negative open amount.

Prerequisite

The prerequisite for the operation of the payment reconciliation as described here is a Topal version from 5.0 and a Vertec Topal Solutions receivable interface from version 149. The interface version can be found in the Extension Manager.