When converting AR Invoices using AutoInvoice, the interface table needs to be populated is: RA_INTERFACE_LINES_ALL. Since legacy system transactions (invoices and credit memos) have already included taxes and in new system we want only one line (summary line) for each transaction and of course tax lines should be avoided.

I have been trying so hard to find the right fields and right values in interface table for this purpose and functional people are trying doing certain setups in E-Business tax…and finally I found it and seems we don’t need to do anything within E-Business Tax.

Here is the trick: assign ‘Y’ to AMOUNT_INCLUDES_TAX_FLAG and ‘N’ to TAXABLE_FLAG. With the combination of these two, issues with taxes are gone and tax lines are not generated.

The same logic applies to AP Invoices conversion with AP.AP_INVOICES_LINES_INTERFACE table. 

I’m excited about the finding and told my lead that I’m proud of myself!