Nov 11

Financial Report improvement featuring Multi report sources

When doing implementation we often struggle to produce Financial Report with complex multi-dimensional accounting layouts. One of the case is when we would like to breakdown an account by Cost Centers or by Sales Regions. In traditional accounting, we used to find a structure of Chart of Account which composed of many duplicated accounts, for example one set of travel expense accounts for General activity and another set of the same travel expense accounts for Sales activity. With multi-dimensional feature that Adempiere has, we often suggest our clients to get rid of those duplicated accounts and tell them that later on they can break them down by any other dimensions they want.

Sample report breakdown by Dept dimension

Sample report breakdown by Dept dimension

Well, not that easy. When it comes to Financial Report, we get hit by the wall that it is so difficult to prepare such a layout using the existing functionality. There is Combination feature in Report Source tab introduced sometimes ago but it is also not offering an easy way we thought. You can use that feature if the dimension only contains small data but what if you have hundreds of records, such as “tell me how much is the Revenue breakdown by products”.

Team Goodwill have tried to improve the current Report Source tab to allow combining multiple report sources in one Report Line using the And/Or condition. Future development would include support for condition in parentheses. For example you can combine two report sources, Account “AND” Business Partner, to produce a Receivables detail report showing the balance for each customer.

Just take a look at the sample report above. The sample #1 is a Report Line using single report source, which is only Account type. By choosing a summary account, it can then expand all its child accounts.

The sample #2 is a Report Line using two report source, one is Account type, and the other is Activity. The Activity is purposely left empty because we want to show all. The system would always expand the details of the report source with the highest Sequence Number, in this case the Activity.

Travel Expense - ALL DEPT (breakdown by Dept)

Travel Expense – ALL DEPT (breakdown by Dept)

Here, we used Activity dimension as “Departments”.

The Tree of Activity as Departments

The Tree of Activity as Departments

Ok, let’s take a look another examples. In sample #5, we show Travel Expense and filtered by General departments only.

Sample Report Filtered and Breakdown

Sample Report Filtered and Breakdown

This is how we do it. We add two report sources like above. But this time we enter “General” activity. In this sample, when the Sequence number is the same, the system would expand the details of the last report source we entered. And since “General” is a summary level activity, system will show all its children.

Travel Expense - General only (breakdown by Dept)

Travel Expense – General only (breakdown by Dept)

In sample #6, thing is getting serious. We want to show Travel Expense, filtered by Sales dept and breakdown by Sales Region. Here how we do it.

Travel Expense - Sales Dept (breakdown by Sales Region)

Travel Expense – Sales Dept (breakdown by Sales Region)

That’s it folks. We would like hearing your feedback on how to improve this functionality. Let’s make Adempiere great again 🙂

Oct 29

Implementation options for holding company

Implementation options for holding company.

Many times we are facing this scenario. Our client has more than one business (legal) entities. How do you deal with that ?

Option 1: Implement in single Adempiere client (A as the holding company). The subsidiaries will go as Organization A1, Organization A2, and so on.

– All subsidaries must be 100% own, as Adempiere don’t take care of % role up.
e.g. Company A own 51% of company A1, hence only will take in 51% of profit, assets, liability…etc…
– All data is in one Client instance. So,
+ Online realtime information access & reports
+ One mass up, all mass up (possible)
+ One Financial Calendar (not all company share the same Financial Calendar.
Some are Industry driven.)   – You can make each Organization have their own calendar but at the end you lose the ability to consolidate)
+ So everyone open and close period the same time.
+ One accounting schema (Segment value is also very much Industry specific)
+ One accounting elements (COA) – Don’t think it goes well with CFO of each subsidary. Normally they like to be in FULL control of their accounts set up/make up.
+ No need manual export, format, load data
+ Security access control is much more challenging
+ All must have real time connection to one server

Option 2: Implement into separate Adempiere clients.

– Will be the opposite of above
– Need a consolidation module to produce consolidated Financial Report for holding company.

– If you install in different instances (can be physical or virtual server), you can back up separately. One goes down, the rest is still intact. – But you need to do updates and upgrades to each instances.


If all of your subsidiaries are the same industry, you can take your bet on first option. Just make sure you have a strong backup and recovery strategy. If not, it is still better to choose second option.

Goodwill Consulting adalah bagian dari komunitas pengembang dan pendukung Adempiere. Jika Anda membutuhkan bantuan profesional untuk implementasi Adempiere, silahkan menghubungi kami.