Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Query to fetch sum of debit memos and credit memos for an original invoice — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to fetch sum of debit memos and credit memos for an original invoice

Received Response
18
Views
2
Comments
edited May 11, 2021 7:31AM in Reporting and Analytics for ERP 2 comments

Summary

Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.

Content

I want to query to get sum of credit memos linked to original invoice ie
Original invoice -HCS1
Credit memo-HCS2

So now sum of credit memos here -1000 as only 1 credit memo is there

The credit memo is linked to original invoice through transaction number ie original invoice reference number in screenshot for credit memo is HCS1

similarly I want a query to get sum of debit memo amounts.

 

Functional Navigation:

oracle fusion-receivables-billing-search with Transaction number--go to actions in the top-click on view transaction details.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!