I have 2 machine running Open Bravo POS each machine runs independent databases and is synchronised with my existing web store database hosted remotely. The synchronisation is done via a pentaho transformation.
I would like a close cash report that is split by department category similar to the image attached ([url removed, login to view])
An additional field would be needed in Openbravo from web store database in the transformation.
The report would show the totals for each department.
The departments shown would be the root category of the item.