Infoniqa ONE 200 Accounts Payable Extension

Formerly Infoniqa ONE 200 extension.

In order for the vendor interface to be able to create new creditors in Infoniqa ONE 200, some default data must be configured. A vendor suggestion is created for this purpose. This is done as follows:

1. Open Infoniqa ONE 200 Financial.
2. Go to Root data > Account payable > Account payable master files on the Advanced information tab and click on the Suggest button.
3. In the window that opens, the currency must first be selected. Then the individual default details can be defined.
4. Important are:
   • collective account
   • Pre-registration
   • Condition number
   • Market affiliation
5. Then click save and close the window.
6. Repeat the process for all currencies you use in Vertec.

In addition, a enter link must be entered on the vendor address before posting.

The information you enter here is then stored as default values for new creditors. You only have to enter this information once.

The create of the ODBC data source is described in the article about the Infoniqa one 200 accounts receivable extension.

In Vertec, open the Extensions extensions in Settings. Select the Infoniqa ONE 200 creditor extension and press the Installieren button.

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

The special system settings for the Infoniqa ONE 200 accounts payable extension are:

• Expenditure account outlays, Example 4000
• Expenditure account expenses, example 4060
• FAR Login: Enter the login for Infoniqa ONE 200 here.
  Propertyname: LoginFibu. StringProperty.
• 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).
  • Database name: Name of the database on the SQL server (e.g. Infoniqa). 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 Password: Enter the password for the above login to Infoniqa ONE 200.
  Propertyname: PasswordFibu. StringProperty.
• Automatically select posting period: From extension version 145.
  • Yes: If this option is set to Yes, the matching posting period (based on the date on the creditor) 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 to No, then the behavior is the same as before, i.e. the appropriate accounting period must be set in the system settings.

PropertyName: AutoPeriodeFibu. BooleanProperty.

• Perform definitive postings in Infoniqa ONE 200: If the setting is Yes, the document is not deleted when an invoice posting is cancelled, but a cancellation posting is created. Default is No.
  Propertyname: SbsBuchenDefinitiv. BooleanProperty.
• Accounting period: Here you can select which period is current used in the tenant.
  Propertyname: PeriodeFibu. StringProperty.
• The checkbox Use employee cost center for creditor posting only needs to be set if Infoniqa ONE 200 is set to post with cost units. A cost unit must be set to the employee.
  Note: Outlays use the same value as expenses.
• Currencies: To update or create the creditor PersonalAcc entry in the accounting program, the entry is passed in all the currencies specified here (for all these currencies a Payable Suggestion must exist, see above).
  Enter the currencies manually, separated by a comma. The values must correspond to the currencies in Infoniqa ONE 200 (Infoniqa ONE 200 Finance > Root data > Currencies). If nothing is specified, CHF is used.
  Propertyname: WaehrungenFibu. StringProperty.

If multiple currencies are used, the addresses must also be opened in all necessary currencies. However, when creating the accounts payable personal account based on the Vertec address, no specific currency is available.

Therefore, the system settings > Accounting > Currencies must be set accordingly. If nothing is specified there, the creditor will be opened in CHF. If Euro is to be used, it must say 'CHF,EUR’.

Attention: The necessary suggestions in Infoniqa ONE 200 must be defined in advance for all currencies used in Infoniqa.

If the reference number field is set on the address (page More Info > Reference number), it will be interpreted as an addressid of an existing address in Infoniqa ONE 200 and used when creating the new account payable. If no reference number is set, a new address will be created and the reference number will be entered accordingly.