 |
Several considerations for AP invoice conversion.
1) Interface tables: AP _INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE
2) Oracle import concurrent program: Payables Open Interface Import Program.
3) To avoid the tax lines (the amount brought from legacy has included the tax amount. When converting to Oracle system, tax line(s) should be avoided in case double taxes are charged.)
In interface table: AP_INVOICE_LINES_INTERFACE_TABLE, assign AMOUNT_INCLUDES_TAX_FLAG to ‘Y’ and TAXABLE_FLAG to ‘N’.
4) To bring due_date from legacy system directly.Oracle will base on invoice_date or terms_date (if terms_date is not null) combining with terms_name to calculate payment due date. In the case that we need to bring due date from legacy directly.
The work around is: assign terms_date with legacy due_date, meantime assign ‘N00’ (due in 0 day) to terms_name. |
|
|
