1. Five Basic Column Names
Identification Number for Each Transaction Group
Each voucher shall have at least one transaction. If Imported Transactions do not have this column, the system will assign number (based on time-stamp) automatically.
Voucher Date for Each Transaction Group
Primary Classification of Transactions within Each Transaction Group
2a. Optional Column Name – Analysing Amount
e.g. Analysis Contact: Tech
e.g. Analysis BU: Audio
e.g. Analysis Location: Germany
e.g. Analysis Project: FDK1675
There are no limit of the number of analysis categories. Together with the column “Ledger” and “Account”, this form an important structure to support recording your transactions with building multi-dimensional balances for the column “Amount” . These important dimensional columns can be configured its code list and supplementary information by setting relevant Master Files.
2b. Optional Column Name – Descriptive Information
e.g. Gold Coins
2c. Optional Column Name – Calculation for Each Transaction
e.g. Pcs, OZ
The system support multi-currency handling by a currency master file. This support recording your foreign currency transactions with building multi-dimensional balances for both the column “Original Amount” and “Amount” . To avoid confusion, the default settings of the system recognise the alias name of “Amount” e.g. “Base Amount”.
3. User-defined Column Name
User-defined Column Name
There are no limit of the number of user-defined columns.