We often need to be able to filter transactions according to financial dimensions (eg. accounts receivable by cost centre) as we have several revenue lines at our organisation which get posted to the same account but different financial dimensions. I understand that the tables are not related to one another by default, but think it would be a good enhancement to join them in the back-end so that users can benefit from this additional functionality.