Hello Members

Can someone help. I tried writing a query for R12 reversed receipts that fail to account indicating Online Accounting should be submitted.

This is a query I wrote that fetch all reversed receipts either accounted or fail accounting.

DISTINCT

.cash_receipt_id,

.receipt_number,

. name "RECEIPT_METHOD",

(ac.TYPE, 'cash', 'cash receipt receipt','misc', 'miscellaneous', ac.TYPE) receipt_type,

.amount,ar.amount_applied,

.receipt_date,

.apply_date,

.gl_date,

---bb.bank_name, bb.bank_branch_name,ac.comments description,

.status,ai.status,ar.status,

.org_id

ar_cash_receipts_all ac,

,

,

  ac.cash_receipt_id = ai.cash_receipt_id

ac