SQL query to extract all the open AR invoices for a particular BU in oracle cloud ERP
This query helps in extracting all the open AR invoices for a particular BU in oracle cloud ERP. This is extremely helpful in sending the extract to dunning softwares. SELECT apsa.TRX_NUMBER TRANSACTION_NUMBER , hou.NAME BU_NAME, CST.ACCOUNT_NUMBER CUSTOMER_NUMBER , hp.PARTY_NAME CUSTOMER_NAME , apsa.CLASS TRANSACTION_CLASS , rctta.NAME TRANSACTION_TYPE , rctta.DESCRIPTION TRANSACTION_TYPE_DESC, apsa.INVOICE_CURRENCY_CODE TRX_CURRENCY , apsa.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, apsa.AMOUNT_DUE_ORIGINAL […]
Read MoreSql query to Extract all Open AR invoices for a particular Customer in Oracle cloud
This query helps in extracting all the Open AR invoices which are still open for a particular customer in oracle cloud ERP. This is particularly helpful in dunning operations when sending data to third parties which expect to send the dunning letters to customer for unpaid invoices from their end.
Read More