API or Import program to create Retainage Release type Invoice in Payable
Hi,
Is there any API or Import program to create Retainage Release type Invoice in Payable ? While trying to populate the interface as below and submit Payables Open Interface Import; the program rejects the record with error Invalid Invoice Type Lookup code. Type must be Standard, Credit, Debit, Payment Request, Prepayment, or Expense Report.
WE have to develop an interface to create retainage release invoices and I would appreciate any guidance here.
insert into apps.ap_invoices_interface
( invoice_id,
group_id,
invoice_num,
invoice_type_lookup_code,
invoice_date,
vendor_id,
vendor_site_id,
invoice_amount,
invoice_currency_code,