AAR - Report ID 120

veeravi

Hi,
In AAR report, you can generate with three options i.e., by posting date,by due date & document date.By posting date & document date reports are fine.

When I generate by due date the balance figures are dynamic in nature.

The scenarios are explained here:
Invoice No. Posting Date Amount Due Date
INV1001 15/Apr/2012 1000/- 15/05/2012
INV1002 10/May/2012 1000/- 10/06/2012

Balance as on 31st May 2012 is 2000-00 and the report is OK. Then, I received a payment of 500 against INV1001 on 10 Jun and posted against the same invoice. Now, I have generated two AAR reports as on 31 May and 15 Jun and balance shown 2000-00 and 1500-00 respectively. This report is fine.

Then, I have posted an Invoice for 5000-00 on 25 Jun. Again, I generated a AAR as on 31 May, the balance is showing 6500-00 instead of 2000-00.

Is there any way out get it fixed this report by due date?

Any solution for this?

Thanks,
RAVI

vijay_g

The balance will always remain same what's outstanding on card if you are running aging by due date either your date filter is not fix. You have to work around if you want to get it.