Acronis needs a report showing GL Accounts with postings to SubAccount Cost Centers 0000 and 0600. We cannot filter on the Cost Center section of the SubAccount number on the Trial Balance Details Report (see previously reported bug). So I thought we would create a report for them showing what they need to see. They need to see all GL Account/SubAccount combinations that have a balance in Cost Centers 0000 and 0600 for GL Accounts greater than 49999.
I set up a Row Set with Expand Sub and Row Description Code-Description. The Report shows the SubAccount number but you have no idea what GL Account the balance is affiliated with.
I set up a Row Set with Expand Account Account with Row Description Code-Description. The Report shows the Account number and Description but you have no idea what GL SubAccount the balance is affiliated with.
There needs to be a way to display both Account and SubAccount on a Report.