Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

    -

    :

    Info
     Accounts (100:199) means that it is interval of the accounts
    100 through 199
     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:

...