Hi,
I am stuck building the trail balance for a client.
I want to build a trail balance with;
Opening balance (always locked on the 20xx-01-01 for the year of the report date)
Debet (from 20xx-01-01 to report date)
Credit (from 20xx-01-01 to report date)
Accumulated debet and credit
Closing balance (sum of opening balance + accumulated of debet/credit) (on report date)
With my setup, se below, i have the following problems:
1. My numbers always change to the month of report date.
If I choose YTD in debet and credit I get wrong numbers, I also get my year end closing transactions.
2. If report date is January, my sum of opening balance disappears which gets me the wrong number when I sum closing balance.