Total Pageviews

December 14, 2018

12/14/2018 09:18:00 AM

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.
 
Related Posts Plugin for WordPress, Blogger...