The blog provides the SQL Query to get On-Account Receipt Amount Total in Oracle Receivables.
What is On-account receipt in Receivables ?
Oracle Receivables R12 allows to apply on-account receipts to customer’s open debit items. Consider and example Customer receives the goods worth $1000 but was not happy with the received goods and thus company agrees to credit $200 to customer account. When customer makes the payment of $800, then $200 is credited as customer on-account
Oracle Receivables On-Account Receipt Amount