Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Localizations for Mexico

• JD Edwards EnterpriseOne Localizations for Mexico Overview
• JD Edwards EnterpriseOne Localizations for Mexico Implementation
• Understanding Translation Considerations for Multilingual Environments
• Understanding Translation Routines
• Setting Up User Display Preferences
  • Understanding User Display Preferences
  • Form Used to Set Up User Display Preferences
  • Setting Processing Options for User Profile Revisions (P0092)
    • A/B Validation
    • PIM Server Setup
  • Setting Up User Display Preferences

2 Understanding Localizations for Mexico

• How to Validate Tax IDs in Latin American Countries
• Using an Additional Ledger Type to Work with IETU
  • Cash Basis Accounting
  • Automatic Bank Statement Processing
  • Manual Bank Statement Processing
  • Reconciling Bank Tapes
  • Reconciling Bank Account Transactions
• Mexico-Specific Setup and Processes

3 Understanding Supplier Withholding in Mexico

• Understanding Supplier Withholding in Mexico
• Working with Supplier Withholding in Mexico

4 Setting Up Your System for Supplier Withholding in Mexico

• Understanding Setup for Supplier Withholding
• Prerequisite
• Setting Up UDCs for Supplier Withholding in Mexico
  • Document Type (00/DT)
  • Voucher Document (00/DV)
  • Withholding Applicable Type (76M/AT)
  • Person/Corporation Code (76M/NP)
  • Withholding Type (76M/WT)
• Setting Up Legal Concepts in Mexico
  • Understanding Legal Concepts for Mexico
  • Forms Used to Manually Add Legal Concepts in Mexico
  • Manually Adding Legal Concepts in Mexico
• Setting Up Withholding Concepts in Mexico
  • Understanding Withholding Concepts for Mexico
  • Forms Used to Manually Add Withholding Concepts in Mexico
  • Manually Adding Withholding Concepts in Mexico
• Setting Up Withholding Percentages in Mexico
  • Understanding Withholding Percentages for Mexico
  • Forms Used to Set Up Withholding Percentages in Mexico
  • Setting Up Withholding Percentages Manually in Mexico
• Importing Data from a Spreadsheet for Mexican Withholding
  • Understanding Data Import
  • Forms Used to Import Data from a Spreadsheet
  • Importing Data from a Spreadsheet for Mexican Withholding
• Setting Up Company Information for Supplier Withholding in Mexico
  • Understanding Company Information for Supplier Withholding in Mexico
  • Prerequisites
  • Forms Used to Set Up Company Information for Supplier Withholding in Mexico
  • Setting Up Company Constants for Supplier Withholding in Mexico
• Associating VAT and Income Withholding Concepts to Supplier Address Book Records in Mexico
  • Understanding Address Book Records for Supplier Withholding in Mexico
  • Prerequisite
  • Forms Used to Associate VAT and Income Withholding Concepts to Supplier Address Book Records in Mexico
  • Setting Processing Options for Address Book Withholding Information (P76M006)
    • Process

5 Entering Vouchers with Supplier Withholding in Mexico

• Understanding Vouchers with Supplier Withholding in Mexico
• Adding Withholding Information to Existing Unpaid Vouchers in Mexico
  • Understanding How to Add Withholding Information to Existing Unpaid Vouchers in Mexico
  • Running the Assign Withholding Concepts to Unpaid Vouchers Program
  • Setting Processing Options for Assign Withholding Concepts to Unpaid Vouchers (R76M411)
    • General
• Working with Vouchers in Mexico
  • Understanding the Withholding Additional Information Program in Mexico
    • Setting Up Versions for the Withholding Additional Information Program
    • Cancelling, Deleting, and Voiding Vouchers
  • Prerequisites
  • Forms Used to Review and Modify Withholding Concepts Associated with Vouchers
  • Setting the Processing Option for Withholding Additional Information (P76M411)
    • Process
  • Reviewing and Modifying Withholding Concepts Associated with Vouchers

6 Processing Payments with Supplier Withholding in Mexico

• Processing Automatic Payments with Supplier Withholding in Mexico
  • Understanding Automatic Payments with Supplier Withholding
    • Create Payment Group
    • Undo Payment Group Before Write Payment Group
    • Write Payment Group
    • Undo Payment Group Before Update Payment Group
    • Update Payment Group
    • Vouchers in a Foreign Currency
  • Prerequisites
  • Setting the Processing Option for Print Payment Order - MEX (R76M573)
    • General
• Processing Manual Payments with Supplier Withholding in Mexico
  • Understanding Manual Payment Processing with Supplier Withholding
    • Manual Payment Entry - Withholding Registration (P76M413)
    • Cancelled, Deleted, and Voided Payments
  • Forms Used to Add Withholding Information to Manual Payments
  • Adding Withholding Information to Manual Payments in Mexico

7 Generating the Supplier Withholding Certificate in Mexico

• Understanding the Mexican Supplier Withholding Certificate
• Setting Processing Options for Print Withholding Certificate - MEX (R76M422)
  • Selection
• Running the Print Withholding Certificate - MEX Program

8 Working With VAT in Mexico

• Understanding VAT and the General Ledger for Mexico
• Understanding the Mexico VAT Recognition Process
• Working with Reports to Reclassify VAT for AP Transactions
  • Understanding Reports to Reclassify VAT for AP Transactions
  • Running the AP Vat for Gain Loss Report
  • Setting Processing Options for the AP Vat for Gain Loss Report (R76M940)
    • A/B Validation
    • Journal Entry
  • Running the Closed AP Draft Vat on Gain Loss Report
  • Setting Processing Options for the Closed AP Draft Vat on Gain Loss Report (R76M990)
    • Process
    • Journal Entry
• Working with Reports to Reclassify VAT for AR Transactions
  • Understanding Reports to Reclassify VAT for AR Transactions
  • Running the AR Vat on Gain Loss Report
  • Setting Processing Options for the AR VAT on Gain Loss Report (R76M930)
    • Process
    • Journal Entry
• Understanding the Setup for Processing VAT on Payments and Receipts for Mexico
  • Discounts and Write-Offs
  • GL Date for Vouchers and Invoices
  • Automatic Accounting Instructions
  • Set Processing Options to Redistribute AP and AR VAT for Mexico
  • Reviewing Mexican VAT Transactions
    • Error Handling
• Setting Processing Options for POs Redistribute AP VAT - Mexico (R76M1630)
  • Default
  • Versions
• Setting Processing Options for POs to Redistribute AR VAT Accounts - Mexico (R76M1010)
  • Default
  • Versions

9 Working With Invoice Information

• Understanding Invoice Numbers
• Setting Up Your System to Work With Sales EDI Invoice Number
  • Form Used to Set Up Sales EDI Invoice Number Functionality for Mexico
  • Setting Up the Electronic Invoice Number Functionality for Mexico
• Prerequisites
• Forms Used to Enter Invoice Numbers
• Setting Processing Options for the General Ledger Invoice Number Program (P700911)
  • Default
• Manually Entering Single Invoice Information
  • Sales Invoice Number
  • Purchases Invoice Number
  • Sales EDI Invoice Number
  • General Ledger Invoice Number
  • A/R Receipts Invoice (Release 9.2 Update)
  • A/P Payments Invoice (Release 9.2 Update)
• Manually Entering Invoice Numbers for Multiple Records
  • Global Update for GL Invoices
• Importing Invoice Number Information from a File
  • Understanding Data Import
  • Importing Data from a File

10 Working With Electronic Accounting for Mexico

• Understanding Mexico Electronic Accounting
  • Understanding XML Files Generation
  • Mexico Electronic Accounting Process
• Working With the Chart of Accounts (Catálogo)
  • Understanding the Setup to Work with the Chart of Accounts
    • Level of Detail
  • Forms Used to Work with the Chart Of Accounts (Catálogo)
  • Setting Up UDCs to Work With the Chart of Accounts
    • Account Ledger Category Codes (09/xx)
    • Replaced Character - W3C Std (70/RC)
  • Setting Up Single Accounts for Mexico Electronic Accounting
  • Setting Up Account Translation
  • Setting Processing Options for the Chart of Accounts by Level Program (R7009001)
    • Default (Release 9.2 Update)
    • Process
  • Running the Chart of Accounts by Level Program (R7009001)
    • Naming Conventions for the Chart of Accounts XML File
• Working With the Trial Balance (Balanza)
  • Understanding the Trial Balance XML File Generation
    • Level of Detail
  • Prerequisites
  • Setting Processing Options for the Trial Balance Program (R7009002)
    • Default (Release 9.2 Update)
    • Process
  • Running the Trial Balance Program (R7009002)
    • Data Selection
    • Naming Conventions for the Trial Balance XML File
• Working With the General Ledger Report (Pólizas)
  • Understanding the General Ledger Report
    • Bank Information
    • Checks and Bank Transfers Information
    • Currency Information
  • Prerequisites
  • Setting Up UDCs to Work With the General Ledger Report
    • Address Book Category Codes (01/xx)
    • Payment Instrument (70/PY)
    • Currency Code Reference (70/CC)
    • Document Type with UUID (70/DV)
  • Forms Used to Set Up the General Ledger Report
  • Setting Up Bank Account Information
    • Prerequisite
    • Associating Legal Bank Codes to Address Book Records for Banks
    • Completing G/L Bank Accounts Information
    • Completing Bank Account by Address Information
  • Setting Processing Options for the General Ledger Report Program (R7009003)
    • Default (Release 9.2 Update)
    • Process
    • Bank Information
  • Running the General Ledger Report Program (R7009003)
    • Data Selection
    • Naming Conventions for the Polizas XML File
    • Example: Polizas XML File Output (Release 9.2 Update)
• Working With the Auxiliary Ledger by Account Program (Auxiliar de Cuentas)
  • Understanding the Auxiliary Ledger by Account Program
  • Prerequisites
  • Setting Processing Options for the Auxiliary Ledger By Account Program (R7009004)
    • Default (Release 9.2 Update)
    • Process
  • Running the Auxiliary Ledger by Account Program
    • Data Selection
    • Naming Conventions for the Auxiliar de Cuentas XML File

11 Glossary

• 2nd Item Number, 3rd Item Number, and Item Number
• Fixed Asset Number
• G/L Date (general ledger date)
• Main Fixed Asset Number
• Object Account
• Subledger
• Subledger Type
• Subsidiary