Discussion in 'Oracle Apps Technical' started by sambhaji, Feb 6, 2014.
Can anybody tell me query to get all receipts which are not posted to gl??
You are talking about Ar Receipts?
AR_CASH_RECEIPT_HISTORY_ALL stores all the status change of AR Receipts. Below query will give the receipts that are not posted to GL.
WHERE posting_control_id = -3;
posting_control_id = -3 indicates those receipts which are not posted to GL.
http://docs.oracle.com/cd/A85683_01/acrobat/artrm.pdf explains the same(page 189).