I’m trying to modify the existing Journal Transaction report to ignore subaccounts. We have subaccount enabled in our set up but it is only meaningful in certain situations. When I want to look at the activity in an ACCOUNT, I don’t want it broken up by subaccount.
I know the GLHistory tables are used to pull the opening balances and they are organized by account & subaccount.
When I try to collapse the grouping around subaccount I get garbage for opening balances.
I’ve also tried abandoning the GLHistory table and have built up the opening balance by pulling in all records from GLTRAN and totaling all of the DR/(CR)’s prior to the period I want. But, I can’t get that calculated variable to pass from the detail section of the report to the header section for the account.
Can anyone suggest an approach to either pull the combined records from GLHISTORY or how to pass a variable from a detail section BACK to a header section.
Thanks in advance.
