Tag: AR_PAYMENT_SCHEDULES_ALL

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,

Continue reading
Copy Protected by Chetan's WP-Copyprotect.