Oracle Financials for the Americas User Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Regional Overview

Overview

Common Country Features

Oracle General Ledger
      Inflation Adjustment Overview
      Maintaining Both Historical and Inflation-Adjusted Balances
      Maintaining Only Inflation-Adjusted Balances
      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
      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
      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 Invoice Sub-Series
      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
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 Generate File 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
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

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

Index