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
17
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!