AR Report To be Developed

[abbas9001]

Hello All,

I have requirement to develop a report in AR.
Requirement is one credit memo is created and 3 invoices are applied.
example:
Credit memo amount 1000
applied amount invoiceno amount remaining dateapplied
200 123 800 01-feb-2009
300 124 500 10-feb-2009
200 120 300 20-feb-2009

Parameters from date and to date
If I run this report using from date 01-feb-2009 and 15-feb-2009
then it should show me the result as
applied amount amount remaining
500 500
that means it should calculate the data based on the dates provided if from date is 01-feb and to dat is 05 of feb
then output should be
applied amount amount remaining
200 800.

Normally when i build a query and run it, it will show the final result like
applied amount amount remaining
700 300

Advise please.

Regards,
Abbas.

[wenjie]

can u give me the table schema