Transaction conversion table

../_images/transfer-transactionconversation.png

Add the required conversions to the table for the transaction transfer. The conversion table is company-specific, and common for all companies that use the interface.

  1. Add a new row by right-clicking the row text. Choose Add below. Define the code and name.

  2. “Company code” -column. Define the company. If left empty, then all companies using interface are included.

  3. “From” ja “Until” -sarakkeissa voit määrittää säännölle voimassaoloajan, muodossa vvvvkkpp. Esimerkiksi From 20190101 Until 20191231 tarkoittaa sääntöä vuodelle 2019. Säännön voi määrittää päivätarkkuudella.

  4. “Dimensions” + Old -transactionbase’s dimensions - the basis of which the conversion is made. Filled dimension in the row means, that the condition must be met.

Special rules

  • Empty values are activated with the codeword is_space

  • Activation for accounts: only balance accounts, with the code is_balance, or only profit and loss accounts, with the code is_pl

  • For the old column value a mask and lenght delimiter can be utilized. For example, 12? or 12??|.

  • Data can also be transferred from one column to another using the codeword copy_col. This codeword must be placed in the Old column from which you want to transfer the data, and in the New column to which the data will be transferred.

  1. “Dimensiot” + New - konvertoitavat tiedot, eli kun rivin “Old” -kohtaan täytetyt arvot täsmäävät, “New” kohdan arvot täytetään. Mikäli dimension arvo halutaan nollata, suositellaan käytettäväksi arvoa “0”. Mikäli halutaan tyhjentää, se tapahtuu koodisanalla “is_space” (alkaen versiosta v2019.117)

General instructions

  • The rule works always on the AND/OR principle. All Old -conditions entered to the row must be met, in order the codes for the New -column can be used. If left empty, it means that “value can be anything”.

  • It is possible to re-reprocess previously processed row, in the next new row.

Examples

  • Old - Account 1234, New - Account 1234B

=> all transactions, where the account is ‘1234’ -the account number is changed to ‘1234B’

  • Old - Account 1234 AND Center 80, New - Account 1234G

=> all transactions with account 1234 AND cost center ‘80’ - the account number is changed to ‘1234G’

  • Old -Account 1234 AND Center is_space, New -Account - 1234C

=> all transactions, with account ‘1234’ AND Center is empty - the account number is changed to ‘1234C

  • Account’s special rules: 123? = all accounts starting with 123. 123??| = all 5-characters long accounts starting with 123. 1? 2? = all accounts starting with 1 and 2.

Add column

To add new column, or remove column follow next steps:

  1. Right-click the row text. Choose “Add column”

  2. Use the menu, either to add or to remove column.

  3. Confirm changes. Hit “OK” button.

Note

  • Dimensions can not be removed.

  • Columns with values can not be removed.