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
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.
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.

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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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.

Previous Topic: FNDCPASS changing schema password
Next Topic: FND: Developer Mode
Goto Forum:

Current Time: Tue Apr 25 03:51:18 CDT 2017

Total time taken to generate the page: 0.14914 seconds