1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

receips which are not posted to gl

Discussion in 'Oracle Apps Technical' started by sambhaji, Feb 6, 2014.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,

    Can anybody tell me query to get all receipts which are not posted to gl??


    Regards,
    Sambhaji
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Sambhaji,

    You are talking about Ar Receipts?
     
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi Jagadekara,

    Yes.

    Regards,
    Sambhaji
     
  4. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Hi Sambhaji,

    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.

    Code (SQL):


    SELECT  *
    FROM    AR_CASH_RECEIPT_HISTORY_ALL
    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).

    Regards,
    Yowan Cristo