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!

How can i get a partially paid invoice in AP

Discussion in 'SQL PL/SQL' started by jyothibasu24, Dec 23, 2013.

  1. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi All,

    How can i get a partially paid invoice in Accounts Payable .
    Is that any Status Flag is there .
    Please Help me .

    Thanks in Advance

    Jyothibasu P
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    payment_status_flag is available at header level , statuses will be 'Y' -- Fully Paid, 'P' -- Partially Paid , 'N'-- Not Paid


    Code (SQL):
      SELECT *  
     FROM  ap_invoices_all
     WHERE payment_status_flag  = 'P'

    Regards
    Sambasiva Reddy.K
     
    jyothibasu24 likes this.
  3. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi Sir,

    Thank you so much sir .

    Regards.
    Jyothibasu P
     
  4. Anant Danve

    Anant Danve Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Mumbai
    Hi

    You can also check partial Paid Invoice details in Invoice Window using tourch option

    In tourch option you can find partial paid invoices by filtering data in payment field.

    Regards

    Anant Danve