AR SQL Query to get Open Invoices for a Customer or for all Customers where payment status is Open

Hi All, The below provides the main columns from the table – RA_CUSTOMER_TRX_ALL and AR_PAYMENT_SCHEDULES_ALL to get the details for the Open Invoices for a particular Customer ( enter TRX_NUMBER) or for all Customers.   SELECT RA_CUST_TRX.STATUS_TRX, RA_CUST_TRX.TRX_NUMBER, RA_CUST_TRX.TRX_DATE, RA_CUST_TRX.BILLING_DATE, RA_CUST_TRX.BATCH_ID, RA_CUST_TRX.BATCH_SOURCE_ID, RA_TERMS.NAME || ‘-‘ || RA_TERMS.DESCRIPTION   TERM_NAME, RA_CUST_TRX.INVOICE_CURRENCY_CODE TRX_CURR, APS.ORG_ID, APS.CUSTOMER_ID, APS.CUSTOMER_TRX_ID, –APS.TRX_NUMBER, –APS.TRX_DATE, […]

Read More

Oracle Receivables – AR Setup Checklist that requires for transaction processing

Hi All, Please find below the common AR setup to be done in Oracle Apps –  Oracle Receivables for the transaction processing.   Setup Description Required? Define Sets Of Books Yes Use The Account Generator Yes Define System Item Flexfields Structure Yes Define Organizations Yes Define Territorry Flexfield No Define Sales Tax Location Flexfields structure […]

Read More

oracle apps R12 Oracle Receivables (AR) Receipt creation

In Oracle Receivables, Receipts can be created of 2 types: Standard Receipts: Standard Receipts includes Cash or Check received from the Customer in the exchange of goods or services provided. These are termed as ‘Cash Receipts’ also. Miscellaneous Receipts: Miscellaneous Receipts includes the revenue earned from the interest, refunds, investments or any other nonstandard item. […]

Read More