AnsweredAssumed Answered

financial trial balance report

Question asked by eibcga on Mar 22, 2014
Latest reply on Mar 27, 2014 by philmodjunk

Title

financial trial balance report

Post

     I am trying to get a trial balance report to work as intended.  The opening and closing balances are not showing the balances properly based on the specified date ranges.  The total debits and total credits are not showing the proper balances within the specified date ranges.  I list below the settings made with the corresponding Column heading / Field name / One-row filtered portal setup.  Also are the screenshots which show the relationships and layout.

Open

     Ledger_TB::summaryruntotal_amount

     Journal::date  ≥ Ledger_TB::g_dateopen

Debit

     Ledger_TB::summarytotal_dr

     Ledger_TB::g_dateopen ≤ Journal::date and Ledger_TB::g_dateclose ≥ Journal::date

Credit

     Ledger_TB::summarytotal_cr

     Ledger_TB::g_dateopen ≤ Journal::date and Ledger_TB::g_dateclose ≥ Journal::date

Close

     Ledger_TB::summaryruntotal_amount

     Journal::date  ≤ Ledger_TB::g_dateclose

     It's almost there but I'm missing something.  Any guidance please?

      

      

test.jpg

Outcomes