I am trying to build an account schedule that lists all accounts (balance sheet and income statement posting accounts) in the rows with 2 columns - 1 to display debit account balances and the 2 to display credit account balances.
By using the Amount Type to be Debit Amounts for Column 1 and Credit Amounts for Column 2 - this just produces a results balances for both columns if the account has both debit and credit transactions.
By using the Amount Type - Net Amount and then for Column 1 (Debit) show When Positive and for Column 2 (Credit) show when Negative - this produces the required result for each account row.
The problem then is the final row I want to display a total for the column - it displays zero balance as its the full Trial Balance - display the total as zero.
Snapshot of the output trying to be achieved
| Account Code |
Account |
Account Type |
Debit |
Credit |
| 200 |
Fixed Revenue |
Revenue |
|
870,092.57 |
| 201 |
Deliverables |
Sales |
|
325,845.66 |
| 202 |
Workforce Planning |
Sales |
|
2,120,150.01 |
| 203 |
Communications |
Sales |
|
2,246,378.90 |
| 204 |
Skilling |
Sales |
|
1,555,038.16 |
| 205 |
Admin |
Sales |
|
1,089,784.00 |
| 207 |
Reimburseable Income |
Sales |
|
417,236.29 |
| 208 |
Talent Acquisition |
Sales |
|
532,201.08 |
| Total |
|
|
13,814,195.65 |
13,814,195.65 |
