Knowledge Management for AP Invoices conversion in 11.5.10

1. Responsibility / Navigation / Module
Payables manager

2. Conversion Approach / Reference Documents
Interface Tables / AP Invoices User Guide

3. Application Setup Requirements
N/A

4. Assumptions / Prerequisites / Validations
Vendors, GL code combinations, purchase Order should be created.
Required Columns validations
1. Organization id (org_id)
2. Vendor name (vendor_name)
3. Vendor site code (vendor_site_code)
4. Ap terms (terms_name)
5. AWT group name
6. Invoice number (invoice_num)
7. Invoice type lookup code
8. Accts pay code combination (accts_pay_code_combination_id)
9. Payment method lookup code
10. Code combination id
11. Item number
12. Invoice id
13. Line type lookup code
14. Tax code
15. PO Distributions

5. Base Tables Effected
AP_INVOICES_ALL
AP_INVOICES_DISTRIBUTIONS_ALL

6. Interface Tables / APIs
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE

7. Navigation of Import Program & Parameters
Others =>request=>run => ‘payable open interface import’
Parameter
1 => Source
2 => Batch source name

8. Import Errors
AP_INTERFACE_REJECTIONS