Tuesday, June 30, 2009

E-Business Tax Setup: Setup Tax Users

Platform: R12

Seeded E-Business Tax Responsibilities

Oracle E-Business Tax provides 3 seeded responsibilities which you can assign to your tax-users:

-          Tax Manager: Highest level of access. Assign to users responsible to setup and maintaining tax configuration data

-          Tax Administrator: Assign this responsibility to users who will provide E-Business Tax technical setup and support services.

-          Oracle Tax Simulator: Assign to users responsible to test tax setups.

You can of course define your own custom responsibilities.

See document ‘Designing Custom Responsibility’ (Document to follow).

Shameem Bauccha

30 June 2009

High Level Setup for Oracle E-Business Tax

Platform: R12

Copyright Info: Document from Oracle Help



Oracle E-Business Tax Setup Prerequisites

Complete the setup tasks in the E-Business Suite applications that E-Business Tax uses for tax-related processes. These setup tasks include:

  • Legal Entities and Establishments - Set up legal entities and establishments to represent the first parties and tax authorities involved in your tax transactions.

  • Lookup Codes - Set up lookup codes for E-Business Tax lookup types.

  • Inventory Item Category Sets and Categories - Set up Inventory item categories for the items involved in your tax transactions. You associate Inventory item categories with product fiscal classifications to use in tax determination.

  • TCA Party Class Categories and Codes - Set up TCA classifications to create tax-related categories to classify third parties for tax purposes.

  • Tax Zones - Set up tax zones to group together geographical regions that share the same tax requirement.




Tax Configuration

Complete the E-Business Tax setup tasks to create a basic tax configuration for each of your tax regimes. A basic tax configuration contains the data applicable to the taxes belonging to a tax regime.

The tax configuration setup tasks are:

  • Tax Authority Party Tax Profiles - Set up a party tax profile for each tax authority involved in your transaction taxes.

  • Tax Regimes - Set up tax regimes in each country and geographical region where you do business and where a separate tax applies.

  • First Party Legal Entity Party Tax Profiles - Set up a party tax profile for each first party legal entity involved in your transaction taxes. When you first set up the party tax profile, set up configuration options for the tax regimes associated with the party.

    • Configuration Options - Set up configuration options to associate tax regimes with first parties.

    • Service Subscriptions and Exclusions - Where applicable, set up service subscriptions and service exclusions to use the tax services of external service providers for tax calculation.



  • Taxes - Set up a record for each of the taxes belonging to a tax regime.

  • Tax Reporting Codes - Set up tax reporting types and tax reporting codes to capture additional tax information on transactions for your tax reports, and apply them to the entities that you want to report on for each tax.


Where applicable, add tax reporting codes for the tax.

  • Tax Status - Set up the tax statuses for each tax.

  • Tax Jurisdictions - Set up tax jurisdictions for each tax to identify the geographical locations where the tax authority levies the tax.

  • Tax Recovery Rates - Set up tax recovery rates for each tax for full or partial recovery of taxes on transactions.

    • Tax Accounts - Where applicable, enter or update tax accounts for each tax recovery rate.



  • Tax Rates - Set up tax rates for each tax.

    • Tax Accounts - Where applicable, enter or update tax accounts for each tax rate.

    • Tax Reporting Codes - Where applicable, add tax reporting codes for each tax rate.






Fiscal Classification System

Complete the E-Business Tax setup tasks for fiscal classifications, if you intend to use fiscal classifications in the creation of tax rules for tax determination. Complete each setup task that applies.

  • Oracle Inventory - Set up Inventory-based product fiscal classification types using Oracle Inventory category sets. The product fiscal classification is defaulted on the transaction line for any item that belongs to the inventory category set.

    • Product Classification - Set up product fiscal classifications against an Inventory category set.

    • Product Intended use - Set up product intended use fiscal classifications against an Inventory category set when the intended use of the Inventory item is a factor either in tax determination or the tax recovery rate.



  • Non-Inventory - Set up non-Inventory-based product fiscal classification types using the E-Business Tax product category. You use the E-Business Tax product category if you do not use Oracle Inventory and for other special product classification needs.

    • Product Classification - Set up product fiscal classifications using the E-Business Tax product category. You can enter these product fiscal classification codes on a transaction line irrespective of the item.

    • Product Intended Use - Set up product intended use fiscal classifications using the E-Business Tax product category when the intended use of the product fiscal classification is a factor either in tax determination or the tax recovery rate.



  • Party Classification - Set up party fiscal classifications for your customers and customer sites and suppliers and supplier sites. You can also use the legal classification tax usage of legal activity codes according to your tax determination and tax reporting requirements.

  • Transaction Classification - Set up transaction fiscal classifications to classify transactions for tax determination and tax reporting purposes.

  • Transaction Business Categories - Set up a hierarchy of transaction fiscal classification codes under transaction business categories to identify specific transaction events.

  • Document Classification - Set up document fiscal classifications to classify transactions that require special documentation to accompany the transaction.

  • User Defined Transaction Classification - Set up user defined transaction fiscal classification codes to classify any tax requirement that you cannot define using the existing fiscal classification types.


Country Defaults

Set up country default controls to default tax registration information for the applicable tax regimes and taxes to legal establishment party tax profiles.

Tax Exceptions

Set up tax exceptions to apply special tax rates to products.

Tax Rules

Set up tax rules to manage the setup and execution of the E-Business Tax tax determination process for your tax regimes and taxes.



Complete First Party Legal Entity Party Tax Profile

Complete the party tax profile of the first party legal entity.

  • Party Classifications - If applicable, associate party fiscal classification codes with this party to use as determining factors in tax rules.

  • Tax Reporting Codes - If you associated tax reporting types with party tax profile, enter any applicable tax reporting codes.


First Party Legal Establishment Party Tax Profile

Complete the party tax profile for each legal establishment belonging to the first party legal entity.

  • Tax Registration - Set up tax registrations records for the first party legal establishment.

    • Tax Accounts - Where applicable, enter or update tax accounts for each tax registration.

    • Tax Reporting Codes - If you associated tax reporting types with tax registration, enter any applicable tax reporting codes.



  • Party Fiscal Classifications - If applicable, associate party fiscal classification codes with this party to use as determining factors in tax rules.

  • Tax Reporting Codes - If you associated tax reporting types with party tax profile, enter any applicable tax reporting codes.


Party Tax Profiles for Third Parties

Set up third party tax profiles for your customers and customer sites and suppliers and supplier sites.

Customers

  • Party Tax Profile Details - Set up a party tax profile for each customer.

    • Tax Registration - Set up tax registrations records for the customer.

    • Tax Exemption - Set up tax exemptions for the customer and customer sites.

    • Tax Reporting Codes - If you associated tax reporting types with tax registration, enter any applicable tax reporting codes.



  • Party Fiscal Classifications - If applicable, associate party fiscal classification codes with this party to use as determining factors in tax rules.

  • Tax Reporting Codes - If you associated tax reporting types with party tax profile, enter any applicable tax reporting codes.


Suppliers

  • Party Tax Profile Details - Set up a party tax profile for each supplier.

  • Party Fiscal Classifications - If applicable, associate party fiscal classification codes with this party to use as determining factors in tax rules.

  • Tax Reporting Codes - If you associated tax reporting types with party tax profile, enter any applicable tax reporting codes.


Configuration Owner Tax Options

Where applicable, set up configuration owner tax options for a combination of configuration owner and application event class.

Application Tax Options

Set up application tax options to update migrated tax setup or to create new tax setup based on the Release 11i defaulting hierarchy model. The defaulting hierarchy model defaults tax classification codes to transactions.

Note: You must complete additional setup tasks to use migrated tax data on transactions with E-Business Tax.

Make Tax Available on Transactions

After you complete your tax setup and verify that the tax setup behaves according to your requirements, you can enable each tax in the tax regime. Enabling a tax makes it available for use on transactions.

Simulate Transactions

After you complete your setup tasks, use the Tax Simulator to test the details of your tax configuration.

Using the Tax Configuration Region

After you complete tax setups, you can use the Tax Configuration region to display tax configuration data by country or by tax regime.



Oracle Help

30 June 2009

Oracle E-Business Tax Overview

Platform: R12

Copyright Info: Entire Document sourced from Oracle Help


Oracle E-Business Tax

[caption id="" align="alignnone" width="829" caption="E-Business Tax Homepage"]E-Business Tax Homepage[/caption]

E-Business Tax allows transaction tax requirements in all geographic locations where the company has business. Configure your taxes to include rules, default values etc. for each tax requirement. At transaction time E-Business Tax uses tax configuration to determine which tax applies. Based on this the tax amounts are calculated.

Tasks involved in setting up tax requirement fall in the following categories:

  1. Setting up transaction taxes. Evaluate your tax configuration first.

  2. Completing all of the setups and settings related to the processing of taxes on transactions.

  3. Setting up tax rules and defaults to manage tax processing.


E-Business Tax and Transaction Taxes

E-Business Tax provides tax services for Order to Cash and Procure to Pay business flows in these applications:

  • Advanced Global Intercompany System

  • Consigned Inventory

  • Oracle General Ledger

  • Oracle Internet Expenses

  • Oracle iProcurement

  • Oracle iStore

  • Oracle Order Capture

  • Oracle Order Management

  • Oracle Payables

  • Oracle Projects

  • Oracle Purchasing

  • Oracle Receivables

  • Oracle Services Contracts

  • Oracle Trade Management


E-Business Tax does not provide tax services for these transactions:

  • Payables withholding taxes.

  • Latin American Receivables transactions.

  • India transaction taxes.


You can continue to set up and maintain these taxes in the Oracle E-Business Suite using the functionality available from Release 11i.

Oracle Help

30 June 2009

Monday, June 29, 2009

Accounts Payable Setup: Define Payment Terms

Define Payment Terms

Platform: R12

Payables Manager --> Setup --> Invoice --> Payment Terms







Payments Terms are assigned to an Invoice to automatically create scheduled payment when Payables Invoice Validation is submitted for the Invoice

You can define payment terms to create multiple scheduled payment lines and multiple levels of discounts. You can create an unlimited number of payment terms.

Payment terms have one or more payment terms lines, each of which creates one scheduled payment. Each payment terms line and each corresponding scheduled payment has a due date or a discount date based on one of the following:

  • a specific day of a month, such as the 15th of the month

  • a specific date, for example, March 15, 2002

  • a number of days added to your terms date, such as 14 days after the terms date

  • a special calendar that specifies a due date for the period that includes the invoice terms date. Only due dates can be based on a special calendar. Discount dates cannot be based on a special calendar.


[caption id="" align="alignnone" width="764" caption="Payment Terms"]Payment Terms[/caption]

Define Payment Terms



  1. Enter Unique payment term name and description.

  2. If you enter Day of Month terms, enter a Cut-off Day.

  3. If you enable Automatic Interest Calculation using the Interest Payables Options, enter a unique value in the Rank field.

  4. Enter each payment terms line.


Enter % due or Amount to determine the portion of an invoice due on the scheduled payment.

In the Due tab, choose between Calendar, Fixed Date, Days and Day of Month and Months Ahead to determine the due date.

  1. If you use discount terms, define payment terms lines in the First Discount , Second Discount, and Third Discount tabs. Define your discounts so that the first discount has an earlier discount date than the second and so on. You can realize only one discount on a payment terms line.


Note: You cannot use a special calendar to define discount terms.

(Document based on Oracle Window Help)

Bauccha Shameem

29 June 2009

Accounts Payable Setup: Set Multi-Org Preferences

Set Multi-Org Preferences (optionally required)

Platform: R12

Payables Manager --> Setup --> Options --> User Operating Unit Preferences





[caption id="" align="alignnone" width="801" caption="Multi-Org Preferences"]Multi-Org Preferences[/caption]

If you are using a Multi-Org structure, and you want to restrict Org Access, then set the Multi-Org Preferences.

Set the User Level Default Operating Unit.

Set the Preferred Operating Units.

Bauccha Shameem

29 June 2009

Thursday, June 25, 2009

Accounts Payable Setup - Define Payables Options

Platform: R12

You cannot define the Payables Options unless the Financials Options have been defined.

Payables Manager --> Setup --> Options --> Payables Options

Based on your profile options, your ‘Operating Unit’ is automatically picked up.

1. Accounting Option




[caption id="" align="alignnone" width="755" caption="Payables Options: Accounting Option"]Payables Options: Accounting Option[/caption]


2. Currency




[caption id="" align="alignnone" width="754" caption="Payables Options: Currency"]Payables Options: Currency[/caption]


3. Tax Reporting






[caption id="" align="alignnone" width="754" caption="Payables Options: Tax Reporting"]Payables Options: Tax Reporting[/caption]


4. Invoice




[caption id="" align="alignnone" width="754" caption="Payables Options: Invoice"]Payables Options: Invoice[/caption]

5. Approval




[caption id="" align="alignnone" width="754" caption="Payables Options: Approval"]Payables Options: Approval[/caption]



6. Matching



[caption id="" align="alignnone" width="755" caption="Payable Options: Matching"]Payable Options: Matching[/caption]



7. Interest




[caption id="" align="alignnone" width="754" caption="Payables Options: Interest"]Payables Options: Interest[/caption]



8. Expense Report





[caption id="" align="alignnone" width="755" caption="Payable Options: Expense Report"]Payable Options: Expense Report[/caption]



9. Payment


[caption id="" align="alignnone" width="754" caption="Payable Options: Payment"]Payable Options: Payment[/caption]



10. Withholding Tax


[caption id="" align="alignnone" width="754" caption="Payable Options: Withholding Tax"]Payable Options: Withholding Tax[/caption]


11. Report

[caption id="" align="alignnone" width="754" caption="Payable Options: Reports"]Payable Options: Reports[/caption]






Accounts Payable Setup - Payables System Setup

Platform: R12

Payables Manager --> Setup --> Options --> Payables System Setup

Define the Payables System Setup Options

[caption id="" align="alignnone" width="813" caption="Payables System Setup"]Payables System Setup[/caption]

Specify the Supplier Number generation options, Payment Terms and Invoice Match Option Control.

Shameem Bauccha

24 June 2009