Apply Hold on invoice via API.
I am in a process of writing interface for vendor invoices to AP invoices.
Data comes in text file. (tsv)
VENDOR | Invoice Date | Invoice # | Vendor Part Number | Description | Qty Invoiced | Purchase Order | Unit Price | Order Line Amount | Unit | invoice amount |
MINT | 11/1/16 | 1234 | Junior_Mint098 | Creamy mints in Pure Chocolate | 10 | PO1234 | 0.50 | 5 | EA | 7.5 |
MINT | 11/1/16 | 1234 | Double_Mint765 | double mint | 10 | PO1234 | 0.25 | 2.5 | EA | 7.5 |
I have successfully created pl/sql program to map and parse the file and load it into - ap_invoices_interface and ap_invoice_lines_interface tables.
But I have a requirement to check if the item is setup in Oracle Inventory. For this I have setup Vendor Item XREF for each vendor part number so that I can get to the PO LINE.