https://purchasingpo.blogspot.com/2022/05/how-to-create-invoice-in-ap-if-pay-on.html
INVOICE_STATUS_CODE in the RCV_TRANSACTIONS table is kept null if Autopay setup is not present on the supplier. To Rectify the same, first do Autopay setup on supplier and then amend the INVOICE_STATUS_CODE field from null to ‘PENDING’ as below,
select l.invoice_status_code from rcv_transactions l where l.shipment_header_id = ?
INVOICE_STATUS_CODE
PENDING
Now, amend the PAY_ON_CODE field from null to 'RECEIPT' in po_headers_all table
select q.pay_on_code from po_headers_all q where q.segment1= '?'
PAY_ON_CODE
RECEIPT
Run “Pay On Receipt AutoInvoice”
Program afterwards
