Oracle Financials for the Americas User Guide

Prerequisites

1. Defining the Main Ledger

2. Defining the Adjusted Ledger

3. Entering Transactions in the Main Ledger

4. Posting Journal Entries in the Main Ledger

5. Running the Latin American General Ledger Journal Copy Process

6. Posting Journal Entries in the Adjusted Ledger

Setting Up Oracle General Ledger for Inflation Adjustment

1. Define Inflation Ratio Precision

2. Define Inflation Adjustment Accounting Models

3. Define Price Indexes

Adjusting Accounts for Inflation

Submitting the Inflation Adjustment Process

Using the Inflation Adjustment Date

Latin American General Ledger Inflation Adjustment Report

Oracle Receivables

Copy and Void Invoices Overview

Setting Up Copy and Void Invoices

1. Define the Void Transaction Type

2. Enable Automatic Transaction Numbering

3. Define Void Reasons

Regional Receivables Copy and Void Invoices Preview Report

Running the Regional Receivables Copy and Void Invoices Process

Regional Receivables Copy and Void Invoices Report

Reviewing an Invoice Copy Status

Latin Tax Engine Overview

Taxes, Tax Categories, and Tax Rates

Tax Conditions and Tax Condition Values

Tax Group

Tax Rules

Latin Tax Engine Tax Calculation

Determining Tax Categories

Determining Tax Codes

Determining Base Rates

Calculating the Tax

Setting Up the Latin Tax Engine

Setup Steps and Options

1. Define System Options

2. Define Tax Conditions

3. Define Tax Condition Values

4. Define Legal Message Exception Codes

5. Define Tax Categories

6. Define Tax Codes and Rates

7. Assign Default Tax Codes to Tax Categories

8. Define Latin Tax Category Details

9. Define Latin Tax Category Schedules

10. Associate Tax Categories with Tax Conditions and Values

11. Define Tax Condition Classes for Organizations

12. Assign Tax Condition Classes to Organizations

13. Define Tax Condition Classes for Contributors

14. Assign Tax Condition Classes to Contributors

15. Define Customers

16. Define Customer Site (Bill To, Ship To)

17. Define Customer Site Tax Profiles

18. Define Latin Locations

19. Define Tax Condition Classes for Transactions

20. Define Fiscal Classifications

21. Define Items

22. Assign Tax Condition Classes and Fiscal Classifications to Items

23. Define Memo Lines

24. Assign Tax Condition Classes and Fiscal Classifications to Memo Lines

25. Define Transaction Types

26. Define Latin Tax Groups

27. Assign Tax Group to Transaction Types

28. Define Tax Exceptions by Fiscal Classification

29. Define Tax Exceptions by Items

30. Define Tax Exceptions by Customer Site

31. Define Tax Exceptions by Transaction Condition Value

32. Define Latin Tax Rules

33. Define Legal Messages

34. Associate Legal Messages and Tax Rules

How the Latin Tax Engine Calculates Taxes

Using the Customer Interface Program

Mapping Globalization Flexfield Context Codes

Mapping Globalization Flexfield Segments

Customer Interface Transfer Report

Taxpayer ID Validations

Using the AutoInvoice Interface Program

Mapping Globalization Flexfield Context Codes

Mapping Globalization Flexfield Segments

Oracle Assets

Inflation Adjustment Overview

Maintaining Both Historical and Inflation-Adjusted Amounts

Maintaining Only Inflation-Adjusted Amounts

Setting Up Oracle Assets for Inflation Adjustment

Enable Automatic Revaluation Rate Calculation

Define Inflation Ratio Precision

Define Price Indexes

Define Price Index Rate Calculation Method

Set Up Depreciation Books

Set Up Asset Categories

Define Inflation Start Dates

Set Up Assets in a Depreciation Book

Adjusting Assets for Inflation

Running the Calculate Gains and Losses Program

Revaluing Assets

Performing Oracle Assets Procedures

Capitalizing CIP Assets

Retiring Assets

Running Depreciation

Running the Create Journal Entries Process

Running the Latin American Fixed Assets Inflation Adjustment of Retired Assets Program

Running the Journal Import Process

Regional Fixed Assets Inflation Adjusted Asset Summary Report

Statutory Reports

Statutory Asset Ledger Report

Statutory Asset Cost Detail Report

Statutory Asset Reserve Detail Report

Fixed Assets Register Report

Argentina

Oracle General Ledger

Inflation Adjustment Overview

Using Inflation Adjustment Based on a Price Index

Using the Inflation Adjustment Date

Oracle Payables

Withholding Tax in Argentina

Income Tax Withholding

VAT Withholding

Turnover Tax Withholding

Employer Contribution Withholding (SUSS)

Argentine Simplified Regime Contributors (Monotributistas)

Setting Up Oracle Payables for Withholding Tax

1. Enable Extended Automatic Withholding Tax Calculation

2. Define Payables Options

3. Define Province Jurisdiction

4. Define Zones

5. Define Tax Authority Categories

6. Define Locations

7. Define Suppliers

8. Define Tax Authority ID Types

9. Define Supplier Provincial Inscription Numbers

10. Define Withholding Tax Types

11. Define Withholding Tax Codes and Rates

12. Define Company Withholding Applicability

13. Define Supplier Withholding Applicability

14. Define Legal Transaction Categories

15. Define Transaction Letters

16. Define Tax Authority Transaction Types

17. Define DGI Transaction Types

Tax Treatment in Argentina

Tax Treatment Features

Entering Tax Regime Reporting Code for VAT Perceptions Tax

Invoices

Entering Withholding Information

Maintaining Withholding Tax Codes

Payments

Defining DGI Currency Codes

Argentine Payables Withholding Certificate

Argentine Payables Withholding Flat File

Argentine Payables Supplier Statement Report

Argentine Payables VAT Buying Report

Argentine Payables Purchasing Flat File

Argentine Payables CITI Flat File

Argentine Payables Perceptions Taken Flat File

Oracle Receivables

Latin Tax Engine

Tax Treatment in Argentina

Tax Treatment Features

VAT

Additional VAT

VAT Not Categorized

VAT Non Taxable

VAT Perception

Provincial Turnover Perceptions

Excise

Municipal Perceptions

Argentine Tax Handling

Setting Up for VAT, Provincial Turnover Perceptions, Municipal Perceptions, and Excise

1. Define System Options

2. Define Tax Conditions

3. Define Tax Condition Values

4. Define Legal Message Exception Codes

5. Define Tax Categories

6. Associate Tax Categories with Tax Conditions and Values

7. Define Tax Codes and Rates

8. Define Tax Condition Classes for Organizations

9. Assign Tax Condition Classes to Organizations

10. Define Tax Condition Classes for Customers

11. Assign Tax Condition Classes to Customers

12. Define Tax Exceptions by Customer Site

13. Define Tax Condition Classes for Transactions

14. Define Fiscal Classifications

15. Assign Tax Condition Classes and Fiscal Classifications to Items

16. Assign Tax Condition Classes and Fiscal Classifications to Memo Lines

17. Define Latin Tax Group

18. Assign Tax Group to Transaction Types

19. Define Exceptions by Transaction Condition Value

20. Define Latin Tax Rules

21. Define Legal Messages

22. Associate Legal Messages and Tax Rules

23. Associate DGI UOM Codes with UOM Codes

Latin Tax Reports

Argentine Receivables Income Tax Self-Withholding Report

Argentine Receivables CITI Flat File

Argentine Receivables VAT Sales Report

Argentine Receivables Perceptions Flat File

Argentine Receivables Other Perceptions Flat File

Argentine Receivables Sales Flat File

Argentine Receivables Sales Documents Duplicates Flat File

Argentine Receivables Withholding Taken Flat File

Argentina RG 6835

Entering Withholding Tax Information for Receipts

Defining Fixed Asset Exceptions

Collection Processing Overview

Transaction Numbering Overview

Setting Up Transaction Numbering

1. Define the Branch Numbering Method

2. Define VAT Document Letters

3. Define Branch Numbers

4. Assign Branch Numbers

5. Define Transaction Sources

6. Define Order Management Transaction Types

7. Define Source and Type Relationships

Defining DGI Currency Codes

Argentine Receivables AutoInvoice Batch Source Update Program

Argentine Receivables AutoInvoice Batch Source Update Report

Argentine Receivables AutoInvoice Programs

Oracle Assets

Inflation Adjustment Overview

Inflation Adjustment Setup

Set Up Depreciation Books

Define Asset Groups

Set Up Asset Categories

Set Up Assets in a Depreciation Book

Argentine Exhibit of Fixed Assets Report

Oracle Order Management

Entering Order Management Information

Entering Sales Order Information

Marking Tax Categories

Brazil

General Setup

Defining Lookup Codes

Defining a Business Day Calendar

Creating a Workday Exception Template

Creating the Business Day Calendar

Defining Local Holidays

Oracle Payables

Entering and Associating Collection Documents

Manually Entering Collection Documents

Manually Associating Collection Documents

Correcting Collection Documents

Electronic Collection Document

Consolidate Billing

Major Features

Interest

Major Features

Brazilian Payables Consolidated Invoice Register Report

Brazilian Payables Cancelled Consolidated Invoices Register Report

Brazilian Payables Associated Trade Notes and Bank Collection Documents Report

Brazilian Payables Non-Associated Trade Notes and Bank Collection Documents Report

Brazilian Payables Import Bank Collection Documents Report

Oracle Receivables

Tax

Major Features

Bank Transfer

Major Features

Billing

Major Features

Interest

Major Features

Setting up Brazilian Receivables

Defining System Options

Defining Customer Profile Classes

Entering Customers

Defining Receipt Classes

Defining Remittance Banks

Defining Remit-To Addresses

Defining Transaction Types

Defining Associated Import Batch Source

Defining Locations for an Organization

Entering Information for Locations

Defining Memo Lines

Defining Freight Carriers

Defining Tax Codes and Rates

Defining Global Receipt Method Accounts

Defining Master Items

Defining Bank Occurrences

Defining Bank Instructions

Defining Latin Tax Categories

Defining Latin Legal Messages

Defining Latin Tax Groups

Defining Latin Tax Locations

Defining Latin Fiscal Classifications

Defining Latin Tax Exceptions by Fiscal Classification

Defining Latin Tax Exceptions by Item

Defining Latin Tax Rules

Managing Invoices

Entering Invoice Information

Entering Interest for Invoices

Entering Tax for Invoices

Entering Billing Information for Invoices

Entering Bank Transfer Information for Invoices

Correcting Invoices

Canceling Invoices

Entering Bank Collection Information

Creating Bank Transfer Remittance Batches

Automatically Creating Bank Transfer Remittance Batches

Status Field Table

Manually Creating Bank Transfer Remittance Batches

Modifying Bank Transfer Remittance Batches

Formatting Remittance Batches

Entering Bank Occurrences

Creating Occurrence Remittance Batches

Entering Bank Return Occurrences

Correcting Bank Return Occurrences

Importing Bank Return Occurrences

Posting Bank Returns

Running the GL Interface Program

Managing Receipts

Entering Receipts

Entering QuickCash Receipts

Merging Customers

Reports

Brazilian Receivables Invoice Print

Brazilian Receivables Complementary Invoices

Brazilian Receivables Customer Interface Error Report

Brazilian Receivables Customer Account Detail Report

Brazilian Receivables Collection Remittance Batch Report

Brazilian Receivables Occurrences Remittance Batch Report

Brazilian Receivables Factoring Remittance Batch Report

Brazilian Receivables Bank Return Import Report

Brazilian Receivables Post Bank Return Report

Brazilian Receivables Bank Collection GL Interface Report

Brazilian Resolution 13 - Import Content Attributes

Brazilian CFOP - Derivation and Defaulting

Brazilian SISCOSERV

Brazilian NF-e

Oracle General Ledger

Brazil Accounting SPED

Oracle Order Management

Entering Order Management Information

Entering Sales Order Information

Entering Delivery Information

Marking Tax Categories

Chile

Oracle General Ledger

Inflation Adjustment Overview

Adjusting Balances Based on a Price Index

Using Inflation Adjustment Based on a Price Index

Using the Inflation Adjustment Date

Revaluing Balances Based on a Foreign Exchange Rate

Revaluing Balances Based on a Direct Foreign Exchange Rate

Revaluing Balances Based on a Foreign Exchange Rate Using a Stable Currency

Setup (Legal Journal Categories)

Enable Sequential Numbering

Define Document Sequences

Assign Document Sequences to Internal Journal Categories

Entering Journals

Defining a Cash Accounting Model

Chilean General Ledger Cash Ledger Report

Oracle Receivables

Chilean Receivables Sales Ledger Overview

Document Classification Overview

Setup

Define Transaction Types

Define Transaction Batch Sources

Enable Sequential Numbering

Define Document Sequences

Define Document Categories

Define Sequence Assignments

Tax Reporting Codes Overview

Assigning Tax Reporting Codes

Chilean Receivables Sales Ledger Report

Oracle Payables

Document Type Overview

Assigning Document Types

Chilean Payables Purchase Ledger Report

Chilean Payables Withholding of Fees Ledger Report

Defining Sequences for Withholding Tax Certificate Numbering

Enabling Sequential Numbering

Defining Document Sequences

Defining Sequence Assignments

Chilean Payables Withholding Certificate Overview

Chilean Payables Professional Fees Certificate

Chilean Payables Professional Fees and Participation Certificate

Chilean Payables Withholding Certificate Summary Report

Chilean Payables Supplier Statement Report

Oracle Assets

Inflation Adjustment Overview

Inflation Adjustment Setup

Set Up Depreciation Books

Set Up Asset Categories

Set Up Assets in a Depreciation Book

Revaluing Assets

Colombia

Third Party Management

Third Party Information

Use of the Third Party ID

Setting Up Oracle Financials for Third Party Management

Setting Up General Ledger

Setting Up Oracle Payables

Setting Up Oracle Receivables

Setting Up Oracle Purchasing

Entering Third Party Information

Entering Journal Line Third Party Information

Entering Supplier Third Party Information

Entering Multiple Third Party Information for Invoices

Entering Customer Third Party Information

Maintaining Third Party Information

Loading Non-Oracle Application Transactions

Generating Third Party Balances

Correcting Third Party Balances

Colombian Account/Third Party Report

Colombian Third Party/Account Report

Oracle General Ledger

Magnetic Media Reporting

Literal and Subliteral Definition

Reported Values

Report Groupings

Threshold Values

Setting Up Magnetic Media Information

Defining Literals and Subliterals

Assigning Ranges of Accounting Flexfield Segments

Colombian Magnetic Media Literal Configuration Verification Report

Generating the Magnetic Media File

Colombian Magnetic Media Get Movements Program

Colombian Magnetic Media Apply Thresholds Program

Colombian Magnetic Media Literals, Accounts and Third Party Movement Report

Colombian Magnetic Media Literals and Third Party Movement Report

Setting Up the Unique Chart of Accounts

Oracle Payables

Withholding Tax Overview

Withholding Tax and Calculation

Income Tax Withholding

VAT Withholding

Industry and Trade Tax Withholding

Remittance Tax Withholding

Stamp Tax Withholding

Setting Up Withholding Tax

Enable Extended Automatic Withholding Tax Calculation

Define Payables Options

Define Suppliers and Supplier Sites

Define Lookup Codes

Define Locations

Define Tax Withholding Types

Define Tax Codes and Rates

Define Your Withholding Applicability

Define Your Supplier's Withholding Applicability

Entering Documents

Colombian Payables Withholding Certificate Report

Colombian Payables Withholding Report

Colombian Foreign Taxpayer ID

Oracle Inventory

Inflation Adjustment for Inventory

Inventory Inflation Adjustment Setup Steps

Define a Price Index

Assign the Inflation Index

Define Item Category Set and Categories

Assign the Item Category Set and Categories

Assign the Name of the Category Set and Categories

Define Inflation Adjustment GL Accounts

Assign Inventory Inflation Adjustment Accounts to Items

Load the Historical Data

Inventory Inflation Adjustment Processing

Enter the Inflation Adjustment Index Value for the Current Period

Close the Accounting Period

Run the Inflation Adjustment Processor

Print the Kardex Reports

Review Calculations in the Kardex Reports

Transfer the Adjustment Transactions to General Ledger

Calculating the Inventory Inflation Adjustment

Fiscal Kardex Reports

Oracle Receivables

Income Tax Self Withholding and VAT

Withholding Responsibility

Value Added Tax (VAT)

Latin Tax Engine

Calculating Income Tax Self Withholding and VAT

Income Tax Self Withholding

VAT

Setting Up for Income Tax Self Withholding and VAT

Define System Options

Define Tax Conditions

Define Tax Condition Values

Define Tax Categories

Associate Tax Categories with Tax Conditions

Define Tax Codes and Rates

Define Tax Condition Classes for Organizations

Assign Tax Condition Classes to Organization Locations

Define Tax Condition Classes for Customers

Assign Tax Condition Classes to Customers

Define Tax Condition Classes for Transactions

Define Fiscal Classifications

Assign Tax Condition Classes and Fiscal Classifications to Items

Assign Tax Condition Classes and Fiscal Classifications to Memo Lines

Define Tax Group

Assign Tax Group to Transaction Types

Define Tax Rules

Entering Transactions

Self Withholding Income Tax Example

Colombian Receivables Income Tax Self Withholding Report

Defining the VAT Tax Category

Colombian Receivables Sales Fiscal Book Report

Colombian Receivables Cash Receipt Report

Oracle Assets

Inflation Adjustment Overview

Inflation Adjustment Setup

Define Journal Categories

Set Up Depreciation Books

Set Up Asset Categories

Set Up Assets in a Depreciation Book

Accounting for Deferred Depreciation Balances

Accounting for Deferred Monetary Correction Credit Balances

Accounting for Deferred Monetary Correction Charge Balances

Adjusting Assets for Inflation

Revaluing Assets

Generating Inflation Adjustment Journal Entries

Transferring Inflation Adjustment Journal Entries to General Ledger

Running the Journal Import Process

Reporting Inflation Adjustment Information

Colombian Fixed Assets Inflation Adjusted Drill Down Report

Colombian Fixed Assets Inflation Adjusted Account Drill Down Report

Colombian Inflation Adjusted Fixed Assets Report

Archiving, Purging, and Restoring Inflation Adjustment Data

Performing the Archive, Purge, and Restore Procedure

Technical Appraisal Overview

Setting Up Technical Appraisal

Define a Technical Appraisal Journal Category

Assign the Technical Appraisal Journal Category

Define Technical Appraisal Accounts

Enter Initial Values for Technical Appraisals

Using Colombian Fixed Assets Technical Appraisal Mass Load

Entering or Modifying Technical Appraisals

Validating Appraisal Information

Reviewing Appraisal Statuses

Accounting for Technical Appraisals

Accounting Logic

Transferring Technical Appraisal Account Balances

Transferring Technical Appraisal Journal Entries to General Ledger

Archiving, Purging, and Restoring Technical Appraisals

Performing the Archive, Purge, and Restore Procedure

Colombian Fixed Assets Technical Appraisal Additions Report

Colombian Fixed Assets Technical Appraisal Revaluation Report

Mexico

Oracle Assets

Inflation Adjustment Overview

Inflation Adjustment Setup

Define Inflation Ratio Precision

Set Up Depreciation Books

Set Up Asset Categories

Set Up Assets in a Depreciation Book

Revaluing Assets

Tax Reporting Overview

Tax Reporting Setup

Define Inflation Ratio Precision

Enable Middle Month Function for a Depreciation Book

Mexican Fixed Assets ISR Report

Mexican Fixed Assets IMPAC Report

Mexican Fixed Assets Fiscal Gain and Loss on Assets Retirements Report

General Ledger

Mexican Electronic Accounting

Withholding Tax Setup Examples for Argentina

Setting Up Argentine Withholding Tax

1. Define Payables Options

2. Define Special Calendar

3. Define Zones

4. Define Legal Transaction Categories

5. Define DGI Transaction Types

6. Define Provinces

7. Define Locations

8. Define Tax Authority Categories

9. Define Tax Authority Types

10. Define Tax Authorities

11. Define Provincial Inscription Numbers

12. Define Withholding Tax Types

13. Define Withholding Tax Codes

14. Define Company Withholding Applicability

15. Define Supplier Withholding Applicability

Example

Profile Options for the Americas

Overview

Brazil

Brazilian Import

Mexico Electronic Accounting: Chart of Accounts

Acronyms and Defintions

Mexican Chart of Accounts - XML File Layout

Chart of Accounts Mapping Scenarios and Guidelines

Index

Oracle Financials for the Americas User Guide

Contents