Skip to main content

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

Copy Protected by Chetan's WP-Copyprotect.