Home » Applications » Oracle Fusion Apps & E-Business Suite » Report for Credit Memos in AR
Report for Credit Memos in AR [message #389987] Wed, 04 March 2009 07:55 Go to next message
abbas9001
Messages: 20
Registered: April 2008
Location: Hyderabad
Junior Member
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.
Re: Report for Credit Memos in AR [message #396084 is a reply to message #389987] Fri, 03 April 2009 14:04 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
You can use between to restrict the dates.
sum and last value for the values, you require.

But not sure what is your expected output, if I give 10-feb-2009 to 20-feb-2009.

By
Vamsi
Previous Topic: error while install EPS
Next Topic: After Retirement Asset Gain/Loss should be zero
Goto Forum:
  


Current Time: Mon Aug 21 09:10:29 CDT 2017

Total time taken to generate the page: 0.13774 seconds