Infoniqa ONE 200 receivable interface

Formerly Sage 200 (Infoniqa) 200 extension.

In order for the receivable interface to create new receivables in Infoniqa ONE 200, some default data must be configured. For this purpose, a receivable suggestion is created. This is done as follows:

1. Open Infoniqa ONE 200 Finance.
2. Under Master data > Accounts receivable > Receivable master files, go to the Advanced information tab and click on the Suggestion button.
3. In the window that opens, the currency must first be selected. Then the individual default information can be entered.
4. Important are:
   • Cost unit (unless completely disabled when installing Infoniqa ONE 200)
   • collective account
   • Revenue account
   • (Payment) conditions
   • Reminder group
5. Then click Save and close the window.
6. Repeat the process for all the currencies you use in Vertec.

The information you enter here will then be stored as default values for new receivables. You only need to enter this information once.

To access Infoniqa ONE 200, an ODBC data source must be created on the client side.

• For Vertec versions 6.4 and above, create a 64-bit data source using the Windows native 64-bit ODBC Administrator.
• For earlier Vertec versions, use the Infoniqa ODBC Data Source Administrator tool to create a 32-bit data source.

1. Add data source:

   

2. Labeling and assignment of the correct SQL server. You need this information in the Vertec system settings at FARU Mandant (see below).

   

3. Enter the login details of the system administrator of the corresponding database:

   

This creates the data source. If you have any questions, please contact your Infoniqa administrator.

In Vertec, in the Settings > Interfaces folder, open the extensions. Select the Sage 200 (Infoniqa) 200 receivables interface and press the Installieren button.

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

The special system settings for the Infoniqa ONE 200 receivable interface are:

FAR client: The FAR client consists of the following information:

• Data source: Name of the ODBC data source for Infoniqa ONE 200 (e.g. MSSQLInfoniqa200). This is freely defined when installing the ODBC data source (see above).
• Database name: Name of the database on the SQL server (e.g. Infoniqa200). This information can be found on the SQL server.
• Client: Abbreviation of the client to work with can be found in Infoniqa ONE 200, table Client, field Mandid.
• The data must be entered manually and separated by commas, according to the scheme <Datenquelle>,<DB-Name>,<Mandant>:

PropertyName: DatenbankFibu. StringProperty.

FAR Login: Enter the login for Infoniqa ONE 200 here.

PropertyName: LoginFibu. StringProperty.

FAR password: Enter the password for the above login to Infoniqa ONE 200.

PropertyName: PasswordFibu. StringProperty.

Open address in all tenants: It is possible to open accounts receivable (PK) in all tenants (multi-tenant capability). This system setting must be activated for this purpose. For more information, see Creating / linking personal accounts in the article Post receivables with Vertec.

PropertyName: CreateAddressesForAllDb. BooleanProperty.

Open Address

If an address is newly created via the menu Actions > Accounting > Create new address in accounts receivable, it is created anew in all clients and receives a personal account number (PK-number) that is the same in all clients. It is therefore essential that the different clients have congruent address databases so that the same PK-numbers are available everywhere.

Update address

If an address is updated via the menu item Update address in accounts receivable, it is changed in all clients. The customer is identified by the personal identification number. It is therefore essential that the different clients have congruent address databases so that another address is not changed incorrectly.

Automatic selection of posting period: From extension version 145.

• Yes: If this option is set to Yes, the matching posting period (based on the value date) is automatically searched for when posting and cancelling. If no matching period is defined, the usual error that the posting date is outside the allowed range appears.
• No (default): If the setting is set to No, the behavior is such that the appropriate accounting period must be set in the system settings before posting.

PropertyName: AutoPeriodeFibu. BooleanProperty.

Use country code in Sage 200 extension: Default to no. If yes, the country code of Infoniqa ONE 200 must be observed when mapping the address. If the default country is specified for the address, it will be used, otherwise CH.

PropertyName: SBSUseLaendercode. BooleanProperty.

Post main processing assistant as debtor information: If yes, the main processing assistant will be included as debtor information when posting to accounting. This is especially useful if the main processing assistant is, for example, the invoice issuer. It should be noted that the abbreviation of this person in Vertec and Infoniqa ONE 200 is exactly the same for the connection to work.

PropertyName: HBStvBuchen. BooleanProperty.

Post Bebu project information: When posting, the project code (invoice.project.code) is passed as BebuProjekt.

If the debtor is rewritten (call on the project), the BebuProject is rewritten in Infoniqa ONE 200 and the following values are passed (code, description + related).

PropertyName: BebuProjBuchen. BooleanProperty.

Perform definitive posting in Sage 200: If the setting is set to Yes, canceling an invoice does not delete the document, but instead creates a cancel posting. Default is No.

PropertyName: SbsBuchenDefinitiv. BooleanProperty.

Accounting period: Here you can select which period is used up to date in the client.

PropertyName: PeriodeFibu. StringProperty.

Currencies: To update or create the debtor PK entry in the accounting program, the entry is passed in all currencies specified here (for all these currencies a creditor suggestion must exist, see above).

Enter the currencies manually, separated by commas. The values must correspond to the currencies in the Infoniqa ONE 200 (Infoniqa ONE 200 finance > root data > currencies).

If nothing is specified, CHF applies.

PropertyName: WaehrungenFibu. StringProperty.

Consider customer number as personalacc number: Default to yes. If a customer number is specified on the address in the Vertec, this number is entered as personalacc number. If no number is entered there or this property is set to no, the personalacc number is newly created according to the scheme adressid + 100,000.

PropertyName: SBSKundennrPk. BooleanProperty.

The payment reconciliation, which is started via the settings menu, searches Vertec for all invoices that have been posted but have not yet been fully paid (checked paid). For each of these invoices, Infoniqa ONE 200 checks whether a payment is available based on the invoice number.

For each of these payments, Vertec enters a payment on the invoice and reads the following values from Infoniqa ONE 200:

• Date: Date of payment
• Account: Receiving account
• Bankid: Bankid of receipt of payment
• Amount: paid amount
• Document number: Document number of the payment in the accounting system
• Text: Text for payment

Only payments, instalments and advance payments are taken into account. For advance payments, the corresponding Vertec invoice number must be entered as an external document number in Infoniqa ONE 200.

The payment reconciliation can also be imported on a single invoice or on a list of invoices via the Actions menu. In this case, the single invoice or all invoices in the list are considered for the payment reconciliation, regardless of the paid check mark.

To prevent creating duplicate payments, no payment will be created if there is already a payment on the invoice with the same date and amount.