Tax Handling
Tax Configuration
Tax code editing is currently only available for Oracle E-Business Suite version 11i.
The Tax engine configuration parameters determine the how the system handles tax calculation. You can choose whether PROCESSIT should apply taxes before invoices are imported to Accounts Payable. If you enable the tax engine, you must also specify the accounts and rules used to apply tax to invoices. This is done via the D4 configuration parameters:
- Tax engine - Always enabled for 11i. Optional for R12.
- Tax engine inventory account - Only used in Oracle E-Business Suite R12
- Tax engine withholding offset account - Only used in Oracle E-Business Suite R12
Tax Support
Tax Recovery and Offset Tax are supported. Invoice lines are adjusted if required by a partly recovered tax amount in case tax amount is included on the line, otherwise an extra unrecoverable tax line is inserted prior to the import.
Tax Engine
The Tax engine parameter determines when tax is calculated. If the configuration parameter Tax Engine is set to Yes the PROCESSIT tax engine is enabled.
If the Tax engine parameter is enabled, tax amounts are calculated and distributed as item lines according to the default tax codes for the invoice supplier during import.
If the Tax engine parameter is not enabled, in Oracle E-Business Suite R12 tax is handled by Accounts Payable configuration, in Oracle E-Business Suite 11i the account coder supplied the tax codes for the invoice lines.
Tax Configuration
Tax handling is determined by the tax engine configuration parameters. These are specified in the Configuration Manager.
Tax for Oracle E-Business Suite R12
Tax in Oracle E-Business Suite R12 is handled by the tax engine in Oracle. In PROCESSIT, users are not prompted for any tax information except the invoice tax amount. The balance checks for an invoice subtracts the tax amount from the amount eligible for coding.
No tax setup in Oracle
If the tax engine in Oracle E-Business Suite is not configured, you can enable a tax engine in PROCESSIT. The PROCESSIT tax engine assumes that:
- No automatic tax calculation is setup in Accounts Payable.
- No automatic tax calculation is setup for any suppliers.
Prior to invoice import, the tax engine distributes the invoice tax amount according to the supplied accounting coding information on the invoice lines. The tax engine includes GL account combinations, project accounting and distribution set. If invoice lines are matched to purchase order lines accounting is found on the purchase order distribution, with the exception that Account ID is taken from a parameter if purchase order lines contains inventory items. The generated tax lines have the type Item, since it is assumed that tax has not been setup.
Tax for Oracle E-Business Suite 11i
Default behavior states that tax codes must be supplied on the invoice lines. The invoice tax amount is calculated based on the supplied tax codes and is utilized to check if the invoice amount balanced.
Prior to invoice import, the system checks how the supplier is setup. If no automatic tax calculation has been defined for the supplier, the system inserts tax lines according to the supplied tax codes. All tax features in Oracle E-Business Suite is supported, including Tax Recovery and Offset Tax.
This method is suited for an Oracle E-Business Suite configuration where automatic tax calculation is setup on Accounts Payable level with a mixed supplier setup, where suppliers have either automatic tax calculation on line, on header or no tax calculation applied.
No tax setup in Oracle
If automatic tax calculation is not setup in Oracle E-Business Suite, you can enable a tax engine in PROCESSIT. If the tax engine is enabled users are not be prompted to supply tax codes. The balance checks for an invoice subtracts the tax amount from the amount eligible for coding.
Prior to invoice import, the tax engine distributes the invoice tax amount according to the supplied accounting coding information on the invoice lines. The tax engine includes GL account combinations, project accounting and distribution set. If invoice lines are matched to purchase order lines accounting is found on the purchase order distribution, with the exception that Account ID is taken from a parameter if purchase order lines contains inventory items. The generated tax lines have the type Item, since it is assumed that tax has not been setup.
You can configure the automatic match procedure to send invoices with tax difference for manual match.
Tax Related invoice for Oracle R12
You can identify related invoices regardless of the type of invoice. Related invoices are not related to matching, but pertain to tax handling in Oracle E-Business Suite R12.
The reference field where the value is stored is called TAX_RELATED_INVOICE_ID, and can contain a single tax related invoice for each invoice.
This field enables passing a related invoice value via PROCESSIT to store and pass the value into the OOI onto EBS R12.