Query to fetch sum of debit memos and credit memos for an original invoice
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.
1