For prerequisites(click here)--> Setup For Invoice import with Tax details
Sample Data for Invoice import(with Tax)Invoice interface (AP_INVOICES_INTERFACE) header data:
Column Name Value
INVOICE_ID 99999
INVOICE_NUM Tax001
CALC_TAX_DURING_IMPORT_FLAG Y
ADD_TAX_TO_INV_AMT_FLAG Y
Invoice interface lines (AP_INVOICE_LINES_INTERFACE) lines data:
Column Name Value
LINE_NUMBER 1
LINE_TYPE_LOOKUP_CODE ITEM
AMOUNT 100
LAX_CLASSIFICATION_CODE US PMP TAX RATE 2(This was setup done at EB Tax-refEBTax setup
DIST_CODE_COMBINATION_ID 12345
Submit the Payables Open Interface Import Concurrent Program and observe that the invoice is
successfully imported along with the tax line generated during the Import.