To re-create your profit & loss report in flex.bi you must follow these instructions.
1. Finding out what your HansaWorld Profit & Loss report contains
To first thing you need to do is find out what your Profit & Loss report is made out of. To do that you have to look at the Report Settings in HansaWorld. To do that:
...
In this window you can see Account groups or Lines that defined. they can be following :
- Id - Account Group identification
- "Comment" name that will be displayed in report
- " Accounts" - Accounts or Account Groups that those groups consist of (Accounts).
This column use specialized way of displaying the amount of accounts a group contains by using the symbols ":" or "+".
The symbol
Interval of Accounts
":" between two account numbers
represents and interval.Interval of Accounts or Account Groups
-
The example shown in the image above:
100 through 199Info Accounts (100:199) means that it is interval of the accounts
from 100 to 199 (100, 101, 102, 103, ... , 198, 199) are included in this group
- but the example Accounts (10 + 20) means the Sum of Account Groups displayed (That is accounts (10 + 20 + 30) means that only the accounts 10,20,30 are included in this group).the " + " defines Sum of Accounts or Account Groups , but it can be also " - "
Info |
---|
Account group (10 + 20) means the Sum of Account Groups created before, means that lines 10 + 20 are included in this group). |
- As well as these can be Interval of Account groups and Sum of Accounts
In Hansaworld reports lines cannot be defined by Object limitations - In Flex.bi can .
2. Re-creating the account groups in flex.bi
To recreate your account groups in flex.bi you will need to create calculated members that aggregate the accounts you need into groups. First you have to pick a group you want to re-create, always try to work with one group at a time to make this task easier. By default you will have the groups Asset, Liability, Equity, Income and Expense created for you already. This example will contain several methods of aggregating accounts into groups:
...