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!

I want to know how to find that particular purchase order the amount paid or not .

Discussion in 'Oracle SCM & Manufacturing' started by jyothibasu24, Dec 30, 2013.

  1. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi all

    i want to know for that particular purchase order,
    the amount paid or not .

    I want to know how to find that through back end

    thanks in advance

    jyothibasu
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: I want to know how to find that particular purchase order the amount paid or not

    Hi in R12,

    Try below Query. It may help you....

    select pha.segment1
    ,aid.invoice_id
    ,aia.invoice_num
    ,aia.invoice_amount
    from po_headers_all pha
    ,po_lines_all pla
    ,po_distributions_all pda
    ,ap_invoice_distributions_all aid
    ,ap_invoices_all aia
    where 1=1
    AND pha.segment1=:p_PO_NUM
    AND pha.po_header_id=pla.po_header_id
    AND pha.po_header_id=pda.po_header_id
    AND pla.po_line_id=pda.po_line_id
    AND pda.po_distribution_id= aid.po_distribution_id
    AND pha.org_id=aid.org_id
    AND aia.invoice_id=aid.invoice_id
    GROUP BY pha.segment1
    ,aid.invoice_id
    ,aia.invoice_num
    ,aia.invoice_amount
     
  3. jyothibasu24

    jyothibasu24 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Re: I want to know how to find that particular purchase order the amount paid or not

    hi sir ,

    i that any status flag is there in backend. to know the PO is paid or not

    Regards
    Jyothibasu
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Re: I want to know how to find that particular purchase order the amount paid or not

    Moved to the correct forum.
     
  5. Emdadul Huq

    Emdadul Huq Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Dhaka
    Its easy to know from Purchase Order summary then Inquire