Tuesday, May 18, 2010
Below insert script will insert the minimal information required for creating a invoice through Payables open interface import program.
Change the values used in the script as per the comments given. We have tested this script in R12.1.1 instance.
<< Inserting into AP_INVOICES_INTERFACE>>
,SYSDATE --<invoice date>
,3003 --<vendor_id validated against po_vendors.vendor_id>,
,106 --<vendor_site_id validated against po_vendor_sites.vendor_site_id>,
,'TEST' -- It can be retrived by following query
<< Inserting into AP_INVOICE_LINES_INTERFACE>>
,1 --<some unique_number>,
,100 --<line_amount> sum of line_amount should always be equal to invoice_amount,
,'612860' --'<account code>'
After inserting, run the “PAYABLES OPEN INTERFACE IMPORT” program to load the invoice.
Do you think this Article is useful?
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.