Hi Crystal people,
I am trying to create a Trial Balance Report, I am having a problem about my balance sections.
I am displaying an beginning balance,displaying net change which calculates debits and credits, summing the detail and displaying the sum of the net change and an ending balance for 12 accounting periods for one year . My problem is I would like to use the ending balance as the opening balance in a new period . What would be the way to solve tis problem, should I use variables, I tried using Previous function but because I had to use this function with formula field It did not work.
I am trying to create a Trial Balance Report, I am having a problem about my balance sections.
I am displaying an beginning balance,displaying net change which calculates debits and credits, summing the detail and displaying the sum of the net change and an ending balance for 12 accounting periods for one year . My problem is I would like to use the ending balance as the opening balance in a new period . What would be the way to solve tis problem, should I use variables, I tried using Previous function but because I had to use this function with formula field It did not work.