Account Schedules Totalling

keedykeedy Member Posts: 20
edited 2015-01-21 in Navision Financials
I am trying to create a trial balance report with four columns. The columns should show the following:

1) Sum of all Debit Transactions
2) Sum of all credit Transactions
3) Balance on account Debit
4) Balance on account Credit
For 3 & 4 this shoudl show the account balance whether it be a debit or credit balance as in the following:

Account 1234 - 1) Total value of Debits 18,000 2) Total value of credits 21,0000 3) Debit Balance 0.00 4) Credit Balance 3,000

Does anyone know how this can be done??

Thanks

Comments

  • jijuoommenjijuoommen Member Posts: 3
    Your requirement is not clear..

    Can you explain in more detail?
    Thank You...
    Jiju Oommen
Sign In or Register to comment.