There are two interface tables that hold the data to be
imported:
1. AP_INVOICES_INTERFACE
2. AP_INVOICE_LINES_INTERFACE
Additionally, the following table holds the rejection reasons if an invoice is not successfully imported.
1. AP_INTERFACE_REJECTIONS
1. AP_INVOICES_INTERFACE
2. AP_INVOICE_LINES_INTERFACE
Additionally, the following table holds the rejection reasons if an invoice is not successfully imported.
1. AP_INTERFACE_REJECTIONS
PREREQUISITE:
Prerequisites while Importing Invoices with Tax Lines:
1. The setup of 'Configuration Owner Tax Option' under the Defaults and Controls section of EB-Tax, controls the creation of tax lines for the invoices imported using open interface.
2. The Place of Supply option under 'Tax Rules' needs to be selected carefully during implementation
---- Tax Rules - 'Place of Supply' Options:
- Operating Unit is for "Bill-To" location
- Supplier & Supplier Site are for "Bill-From" and "Ship-From"
- Location is for "Ship-To"
Note: This setup is valid only for system calculated tax lines and not relevant for manually imported tax lines
3. In R12 you cannot have multiple tax lines with the same regime to rate information being allocated to a single item line. Single regime to rate can be allocated to multiple item lines for an invoice.
Note: multiple tax lines with the same regime to rate information are not supported.
4. If CALC_TAX_DURING_IMPORT_FLAG is set to 'Y' during import, EB Tax will calculate taxes automatically as per the tax setup. Following columns in AP_INVOICE_LINES_INTERFACE are tax driver columns, which may be used to determine the tax applicability during import:
-- PRIMARY_INTENDED_USE
-- PRODUCT_CATEGORY
-- PRODUCT_FISC_CLASSIFICATION
-- USER_DEFINED_FISC_CLASS
-- SHIP_TO_LOCATION_ID
-- PRODUCT_TYPE
-- TRX_BUSINESS_CATEGORY
Important Columns in the Interface Tables to drive the Tax Calculation:
TAX_CODE
This field is no longer used in R12, the customer must use the new fields in R12 in the interface and also setup EB Tax appropriately to meet their tax calculation needs.
The new fields in R12 are as follows:
Prerequisites while Importing Invoices with Tax Lines:
1. The setup of 'Configuration Owner Tax Option' under the Defaults and Controls section of EB-Tax, controls the creation of tax lines for the invoices imported using open interface.
2. The Place of Supply option under 'Tax Rules' needs to be selected carefully during implementation
---- Tax Rules - 'Place of Supply' Options:
- Operating Unit is for "Bill-To" location
- Supplier & Supplier Site are for "Bill-From" and "Ship-From"
- Location is for "Ship-To"
Note: This setup is valid only for system calculated tax lines and not relevant for manually imported tax lines
3. In R12 you cannot have multiple tax lines with the same regime to rate information being allocated to a single item line. Single regime to rate can be allocated to multiple item lines for an invoice.
Note: multiple tax lines with the same regime to rate information are not supported.
4. If CALC_TAX_DURING_IMPORT_FLAG is set to 'Y' during import, EB Tax will calculate taxes automatically as per the tax setup. Following columns in AP_INVOICE_LINES_INTERFACE are tax driver columns, which may be used to determine the tax applicability during import:
-- PRIMARY_INTENDED_USE
-- PRODUCT_CATEGORY
-- PRODUCT_FISC_CLASSIFICATION
-- USER_DEFINED_FISC_CLASS
-- SHIP_TO_LOCATION_ID
-- PRODUCT_TYPE
-- TRX_BUSINESS_CATEGORY
Important Columns in the Interface Tables to drive the Tax Calculation:
TAX_CODE
This field is no longer used in R12, the customer must use the new fields in R12 in the interface and also setup EB Tax appropriately to meet their tax calculation needs.
The new fields in R12 are as follows:
- TAX_REGIME_CODE
- TAX.
- TAX_JURISDICTION_CODE
- TAX_STATUS_CODE
- TAX_RATE_ID
- TAX_RATE_CODE
- TAX_RATE_ID
- TAX_RATE NUMBER.
- CALC_TAX_DURING_IMPORT_FLAG and ADD_TAX_TO_INV_AMT_FLAG
- PRORATE_ACROSS_FLAG
- LINE_GROUP_NUMBER
