Forum Stats

  • 3,853,528 Users
  • 2,264,231 Discussions
  • 7,905,381 Comments

Discussions

Discoverer Plus: Trial Balance Report (Opening, Period & Closing Balances)

3203660
3203660 Member Posts: 2
edited May 15, 2016 2:27AM in Discoverer

Dear All

 

We design Trial Balance accounting periodic report. The report is done as follow:

 

 

  1. Opening Balance – Not able to create (value should be for inception of the compnay to Dec 2014 – which mean December of last year)

  2. Period Debit (ok) – CASE function to display the debit value only (value for Jan to Dec 2015)
  3. Period Credit (ok) – CASE function to dispay the credit value only (value for Jan to Dec 2015)
  4. Period Balance (ok) – “Period Debit” less “Period Credit” (value for Jan to Dec 2015)
  5. Closing Balance (ok) – “Opening Balance” plus “Period Balance” (value should be for inception of the compnay to Dec 2015)

  

  Report conditions:

  •   Month between “Jan” & “Dec”
  • Year “2015

How to get the opening balance values?

 

I would be thankful if you could provide me the most suitable option.

Answers

This discussion has been closed.