Beginning/Ending Balance

[LMRollins]

Hopefully I can explain this. I want to be able to create a report that has a beginning and ending balance by vendor where it would show the beginning balance - checks + invoices = ending balance. The problem I have is that there are two date ranges: The beginning would be 10/1/06 to 10/28/06 and the other would be 10/29/06 to 12/2/06. I've done a parameter for the whole range but don't know how to get it to group. I do have an accounting period table that shows the period dates for all periods but haven't quite figured out how to work it in. Any help would be appreciated. I'm running CR IX.

 

[LMRollins]

I should have also said that I don't want any of the data from the beginning period to show in the period from 10/29/06 to 12/2/06.

 

[MrBillSC]

Showing sample data and desired output would be helpful. How are your accounting periods determined? Could you create a formula to give you the accounting period the invoice date is in and then group on the formula?

MrBill

 

[Madawc]

For the example you give, grouping would be something like

if {your.date} >= cdate(2006, 10, 28) then "Group A" else "Group B"

You should be able to adapt this to whatever it is you're needing. Use DateDiff, DateAdd etc.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[LMRollins]

There is an acct period table but it shows every accting period since we went on the system. I could use the year field to narrow it down to the correct year and it has a field for the period of 1 to 12 with the beginning and ending dates for each period.

Here is sort of how I want it to look:

Beginning Amount (sum of data from 10/1/2006 - 10/28/06)

$4500.00

- 500.00 (Checks from 10/29/06 to 12/2/06)
+ 300.00 (Invoices from 10/29/06 to 12/2/06)

$4300.00 (Ending Balance - data from 10/29/06 to 12/2/06) this should equal the sum of the data from this date range also.

And this has to be done for each vendor.

Lori