11.5.10 Can Payables Open Interface Invoice Import Program Imports Prepayment ?
As far as I know is not possible to upload prepayments through open interface in R11i.
Can Payables Open Interface Invoice Import Program Imports Prepayment Type of Invoices? [ID 1335837.1]
However I need to upload many prepayments, hence I was wondering in three options.
1.-Insert directly the records in the tables ap_invoice_all and ap_invoice_distributions_all, po_vendors, po_vendor_sites etc through SQL Loader Program
2.-Customize the import program I mean get rid of the prepayments validations
3.-Upload the information either through Dataloader or create an Excel Integrator to upload the prepayments through WEB ADI.