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!

Accounts Payables

Discussion in 'Oracle Financials' started by jyothibasu24, Jan 3, 2014.

  1. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    I want to know. Is there any check id without invoice id in accounts payable.
    can any one clarify my doubt please.

    Thanks in advance
    Jyothibasu P
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi check below query.

    SELECT * FROM ap_checks_all
    where check_id not in (select check_id from ap_invoice_payments_all)