How to create invoice in AP if Pay On Receipt AutoInvoice setup is missed on supplier

 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