suppressed amount still included in crystal report total

[ejastia]

Hi!

I am creating a crystal report based on AR aged trial balance data entries such as dates and aging periods. My data fields are ARAGED, ARCUS, AROBL & AROBP. I cannot EXCLUDE in running total or summary the amount i have suppress in one of my formula field.

For example:

batch date: 12/13/2011
transaction type: unapplied cash
date entry: 01/31/2012(date of check)
year period: 2011-12 (date collected)
date applied to document:12/13/2011
amount: 24,000.00


If I run the report i did with 2011-12 year period cut-off, the 24,000 still appears. This should not happen because only transactions without outstanding balances shall appear. So, I suppress this amount with the condition that AROBL.amount = -AROBP.amount. Although it doesnt appear in the report, its still included in total. Any suggestions on what to do? Thank you guys for your help. Ive been working on it for days now so any help would be highly appreciated. I am not a programmer so please dont be too technical. Thank you so very much.


dej

 

[DjangMan]

I would recommend printing the aging report and then study the table records. Then change the aging and cut-off ahead one fiscal year/period and examine the records again. Then do it again and you should get a better sense of how the report handles the different columns. It isn't completely straight forward but it isn't impossible to figure out, either.

 

[ejastia]

Thanks Dyangman. I cannot change the cut-off ahead one period because some transactions will appear that shouldnt be there. Is there any formula to be used in running total? Thanks a lot.

 

[DjangMan]

How does your report differ from the aged trial balance report?

 

[ejastia]

Actually, its just the same. Whatever output it produce is the same as mine, but I want to change something. I have attached an actual sub-ledger for your reference.

1 Notice that highlighted collections for customer 001 are added not subtracted

in total AR. I have changed this already and totals are okay.

2 Customer 002- This is my concern. Since my cut-off is year 2011, this transaction shoudn't be here because its already applied in 2011.

My cut-off is by year period and the aged trial balance is by date(12/31/2011). If I am going to change the aged TB's cut-off by year period, it will not include those post dated transactions.


Thanks.