1 Reply Latest reply on Jan 15, 2019 5:05 PM by Mat Tyndall-Oracle

    Open PO Line - Supplier cannot add Invoices - Status is Invoiced and Not Available to Invoice

    3849355

      We have an Open PO that should have available funds for the supplier to invoice. However, the Billing status is showing that the amounts are either Invoiced or Not available to invoice. Why is this occurring? We are using a 3-way match.

        • 1. Re: Open PO Line - Supplier cannot add Invoices - Status is Invoiced and Not Available to Invoice
          Mat Tyndall-Oracle

          Run this sql-enter the PO # when prompted

           

          select h.segment1 PO_NUMBER,l.line_num Line_Number, ll.shipment_num,ll.quantity, ll.QUANTITY_BILLED,ll.QUANTITY_RECEIVED,

                ll.amount_billed, ll.amount_received, ll.receipt_required_flag, ll.match_option, ll.CLOSED_CODE

          from

          po.po_headers_all h,

          po.po_lines_all l,

          po.po_line_locations_all ll

          where h.po_header_id = l.po_header_id

          and ll.po_line_id = l.po_Line_id 

          and h.segment1 = '&ponumber'

          /

           

           

          Check the amount billed or quantity billed columns. If they are equal to the shipment quantity then maybe this has been invoiced already?

           

          Also check closed_code on the shipment-is it closed for invoice?