Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Localizations for Colombia

• JD Edwards EnterpriseOne Localizations for Colombia Overview
• JD Edwards EnterpriseOne Localizations for Colombia 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 Colombia

• How to Validate Tax IDs in Latin American Countries
• (COL and ECU) Tax Explanation Codes for Columbia and Ecuador
• Colombia-Specific Setup and Processes

3 Setting Up Functionality for Colombia

• Setting Up UDCs for Colombia
  • Setting Up UDCs to Use Magnetic Media for Tax Reporting
    • Address Book Category Codes (01/xx)
    • General Ledger Category Codes (09/xx)
    • DIAN Concepts for Format 1001 (76C/01)
    • DIAN Concepts for Format 1002 (76C/02)
    • DIAN Concepts for Format 1003 (76C/03)
    • DIAN Concepts for Format 1004 (76C/04)
    • Concepts for Format 1007 (76C/07)
    • DIAN Concepts for Format 1008 (76C/08)
    • DIAN Concepts for Format 1009 (76C/09)
    • DIAN Concepts for Format 1011 (76C/11)
    • DIAN Concepts for Format 1012 (76C/12)
    • DIAN Concepts for Format 1034 (76C/34)
    • DIAN Document Types (76C/DT)
    • Returns Document Type (76C/DV)
    • DIAN Magnetic Media Formats (76C/FM)
    • Person/Corporation Code (76C/PC)
    • DIAN VAT Prefixes (76C/VT)
    • DIAN VAT Withholding Prefixes (76C/VW)
    • DIAN Writeoff Codes (76C/WO)
  • Setting Up UDCs for Accounts Payable Transactions for Colombia
    • Recycle Voucher (76C/RC)
    • Tax Payer Type (76C/TC)
• Setting Up Address Book Information for Colombia
  • Understanding Address Book Information for Colombia
  • Setting Processing Options for Address Book Colombian Additional Information (P76C0101)
    • General
    • Display
  • Form Used to Enter Additional Address Book Information for Colombia
  • Entering Additional Address Book Information for Colombia
• Setting Up Cost Accounts for Depreciation and Inflation Adjustments for Colombia
  • Understanding Cost Inflation Adjustments
  • Understanding Depreciation Inflation Adjustment Accounts
  • Forms Used to Set Up Cost Accounts for Depreciation and Inflation Adjustments
  • Setting Up Cost Accounts for Cost Inflation Adjustments
  • Setting up Cost Accounts for Depreciation Adjustments
• Setting Up Payment Formats for Colombia
  • Understanding Payment Formats for Colombia
  • Setting Processing Options for Print Automatic Payments - COL (R76C572)
    • Translation
    • Payment
    • Conversion
    • Print

4 Understanding Tax Reporting Using Magnetic Media in Colombia

• Understanding Tax Reporting Using Magnetic Media in Colombia
  • Process for Reporting Taxes Electronically
    • Overview of Process
      • Accounts Payable Records
      • Accounts Receivable Records
      • General Ledger Records
      • Records with Minimal Amounts
    • Report Setup Programs
    • Filter Programs
    • XML Generation Programs

5 Setting Up the System for Colombian Taxes

• Understanding Tax Rate Areas and Tax Rules for Colombia
  • Tax Rules
• Setting Up UDCs for Colombian Taxes
  • Address Book Category Codes (01/xx)
  • General Ledger Category Codes (09/xx)
  • Concepts (76C/00)
  • DIAN Concepts for Format 1008 (76C/08)
  • DIAN Concepts for Format 1009 (76C/09)
  • DIAN Concepts for Format 1011 (76C/11)
  • DIAN Concepts for Format 1012 (76C/12)
  • DIAN Concepts for Format 1034 (76C/34)
  • Colombia Tax Explanation Mapping Additional Tax (76C/AT) (Release 9.2 Update)
  • DIAN Country Code (76C/CC)
  • DIAN Document Types (76C/DT)
  • Returns Document Type (76C/DV)
  • DIAN Magnetic Media Formats (76C/FM)
  • Person/Corporation Code (76C/PC)
  • Type Account (76C/TA)
  • DIAN VAT Prefixes (76C/VT)
  • DIAN VAT Withholding Prefixes (76C/VW)
  • DIAN Writeoff Codes (76C/WO)
• Entering Additional Address Book Information in Colombia
  • Understanding Address Book Information for Colombia
  • Form Used to Enter Additional Address Book Information for Colombia
  • Setting Processing Options for Address Book Colombian Additional Information (P76C0101)
    • General
    • Display
  • Entering Additional Address Book Information for Colombia
• Setting Up Economic Activity Code Information
  • Understanding Economic Activity Codes
  • Prerequisites
  • Forms Used to Set Up Economic Activity Codes
  • Setting Processing Options for I.C.A. (P76CI00)
    • Currency
  • Associating an Economic Activity Code to a Tax Rate Area
  • Setting Up Effective Dates, Rates, and Minimum Amounts
• Setting Up Tax Parameters
  • Forms Used to Set Up Tax Parameters
  • Setting Up Tax Parameters
• Setting Up Tax Areas Relationship
  • Form Used to Set Up Tax Area Relationship
  • Setting Up Tax Area Relationship
• Setting Up General Parameters for Tributary Codes
  • Form Used to Set Up General Parameters
  • Setting Up General Parameters
• Setting Up General System Information for Tax Reporting
  • Understanding Next Numbers for DIAN Reporting
  • Understanding Legal Companies
  • Understanding General System Setup for Tax Reporting
    • Legal and Natural Person Information
    • General Ledger Information
    • XML Generation Information
    • Minor Amounts Setup
  • Prerequisites
  • Forms Used to Set Up the System for Tax Reporting
  • Associating Codes for Natural and Legal Entities to DIAN Document Types
  • Setting Up General Format Information
    • General Setup
    • Address Book
    • General Ledger
  • Associating Minimum Amounts and Next Numbers with DIAN Format Numbers
• Setting Up GL Accounts by Concept Codes and Format Number
  • Understanding GL Account and Concept Code Setup
    • Copying GL Accounts
    • Importing Data
  • Prerequisites
  • Forms Used to Associate GL Accounts to DIAN Concept Codes and Format Numbers
  • Associating Formats Numbers to Accounts
  • Copying Account Data
  • Importing Data from a Spreadsheet
• Identifying Missing GL Account/Format/Concept Code Associations
  • Understanding the DIAN Concept Account Setup Control Report Program
  • Running the DIAN Concept Account Setup Control Report
  • Setting Data Selection for DIAN Concept Account Setup Control Report
  • Setting Processing Options for DIAN Concept Account Setup Control Report (R76C9F00)
    • General
• Setting Up Account Types for Formats 1001 and 1007

6 Generating and Modifying Records for Electronic Tax Reporting in Colombia

• Understanding How to Generate and Modify DIAN Records
  • Overview of Process
• Generating Records for DIAN Formats 1001, 1002, 1003, 1004, and 1007
  • Understanding How to Extract Data for DIAN Formats 1001, 1002, 1003, 1004, and 1007
    • Format 1001
    • Format 1002
    • Format 1003
    • Format 1004
    • Format 1007
  • Understanding the DIAN Output XML Generation Program
    • File Status
  • Prerequisite
  • Running the DIAN Generate concept by Account ID Program
  • Setting Processing Options for DIAN Generate concept by Account ID (R76C9F01)
    • General
  • Running the DIAN Output XML Generation — Format 1001, 1002, 1003, 1004, 1007 Program
  • Setting Processing Options for DIAN Output XML Generation (R76C9F02)
    • Process
• Generating Records for DIAN Format 1005
  • Understanding DIAN Format 1005
    • DIAN Sales VAT to Pay Originated by Purchases
  • Running the DIAN Sales VAT to Pay originated by Purchases Program
  • Setting Processing Options for DIAN Sales VAT to Pay originated by Purchases (R76C4F60)
    • Process
  • Running the DIAN Output XML Generation (1005) Program
  • Setting Processing Options for DIAN Output XML Generation (1005) (R76C4F62)
    • Process
• Generating Records for DIAN Format 1006
  • Understanding DIAN Format 1006
    • DIAN Sales VAT Discountable Origination by Sales
  • Running the DIAN Sales VAT Discountable originated by Sales Program
  • Setting Processing Options for DIAN Sales VAT Discountable originated by Sales (R76C3F50)
    • Process
  • Running the DIAN Output XML Generation (1006) Program
  • Setting Processing Options for DIAN Output XML Generation (1006) (R76C3F52)
    • Process
• Generating Records for DIAN Format 1008
  • Understanding DIAN Format 1008
    • DIAN Accounts Receivable Pending (R76C3F80)
  • Setting Processing Options for DIAN Configurable Setup Concepts for Format 1008 (R76C3F81)
    • Process
  • Running the DIAN Accounts Receivable Pending Program
  • Setting Processing Options for DIAN Accounts Receivable Pending (R76C3F80)
    • Process
    • Version
  • Running the DIAN Output XML Generation (1008) Program
  • Setting Processing Options for DIAN Output XML Generation (1008) (R76C3F82)
    • Process
• Generating Records for DIAN Format 1009
  • Understanding DIAN Format 1009
    • DIAN Accounts Payable Pending (R76C4F90)
  • Setting Processing Options for DIAN Configurable Setup Concepts for Format 1009 (R76C4F91)
    • Process
  • Running the DIAN Accounts Payable Pending Program
  • Setting Processing Options for DIAN Accounts Payable Pending (R76C4F90)
    • Process
    • Version
  • Running the DIAN Output XML Generation (1009) Program
  • Setting Processing Options for DIAN Output XML Generation (1009) (R76C4F92)
    • Process
• Generating Records for DIAN Format 1011
  • Understanding DIAN Format 1011
    • DIAN Tributary Information (R76C9F11)
  • Prerequisites
  • Running the DIAN Tributary Information Program
  • Setting Processing Options for DIAN Tributary Information (R76C9F11)
    • Process
  • Running the DIAN Output XML Generation (1011) Program
  • Setting Processing Options for DIAN Output XML Generation (1011) (R76C9F13)
    • Process
• Generating Records for DIAN Format 1012
  • Understanding the DIAN 1012 Format
    • DIAN Tributary Information (Certificates, Titles) (R76C9F14)
  • Prerequisites
  • Running the DIAN Tributary Information (Certificates, Titles) Program
  • Setting Processing Options for DIAN Tributary Information (Certificates, Titles) (R76C9F14)
    • Defaults
  • Running the DIAN Generate Output XML Generation (1012) Program
  • Setting Processing Options for DIAN Output XML Generation (1012) (R76C9F16)
    • Process
• Generating Records for DIAN Format 1034
  • Understanding DIAN Format 1034
    • DIAN Consolidate Balance Sheet (R76C9F34)
  • Prerequisites
  • Running the DIAN Consolidate Balance Sheet Program
  • Setting Processing Options for DIAN Consolidate Balance Sheet (R76C9F34)
    • Defaults
  • Running the DIAN Output XML Generation (1034) Program
  • Setting Processing Options for DIAN Output XML Generation (1034) (R76C9F36)
    • Process
• Reviewing and Modifying DIAN Records
  • Understanding How to Review and Modify Concept Codes for DIAN Records
  • Forms Used to Review and Modify DIAN Records
• Generating the XML File Interactively
  • Forms Used to Generate the XML File Interactively

7 Working with Fixed Assets for Colombia

• Working with Fixed Assets for Colombia
  • Calculating Depreciation Adjustments for Inflation for Colombia
    • Understanding Depreciation Adjustments for Inflation
      • Adjustment by Inflation Depreciation/Amortization (R76C1202)
      • Data Selection for Adjustment by Inflation Depreciation/Amortization
    • Prerequisites
    • Calculating the Depreciation Inflation Adjustments
    • Setting Processing Options for Adjustment by Inflation Depreciation/Amortization (R76C1202)
      • Process
      • Subledger
      • No Batch Trans.
  • Calculating the End of the Useful Life for Colombian Assets
    • Understanding the Life End Date Program
    • Prerequisites
    • Calculating the End of Useful Life
      • Data Selection for Life End Date
    • Setting Processing Options for Life End Date (R76C1208)
      • Process
      • No Batch Trans
      • Ledger
  • Working With Cost Inflation Adjustments in Colombia
    • Understanding Cost Inflation Adjustments
      • Calculating Cost Inflation Adjustments
      • Data Selection for the Adjustment by Cost / Deferred Charge Report
    • Prerequisites
    • Forms Used to Review and Revise Cost Accounts
    • Calculating the Cost Inflation Adjustments
    • Setting Processing Options for Adjustment by Inflation to Cost / Deferred Charge (R76C1201)
      • Process
      • Subledger
      • No Batch Trans.

8 Understanding Reports for Colombia

• Reports for Colombia
  • Processing Options for R76C0001 and R76C0003
    • Date
    • Print
    • Level and Company
    • Responsible
    • Display
    • Third Party
    • Reprocess
    • Title
    • Certificate
    • IVA Withheld
  • Processing Options for R76C0002
    • Date
    • Display
    • Display and Company
    • Total
    • Print
    • Reprocess
    • Title
  • Processing Options for R76C0003
  • Processing Options for Timbre Withholding (R76C0004)
    • Print
    • Level
    • Responsible
    • Display
    • Third Party
    • Reprocess
    • Title
    • Certificate
    • VAT Withheld
  • Processing Option for Auto-Withholding Calculation (R76C0005)
  • Processing Option for Additional Tax Calculation (R76C0006) (Release 9.2 Update)
  • Processing Options for General Journal by Category Code (R76C0911)
    • Dates
    • Cat. Code
  • Processing Options for General Ledger with Total by Object Account (R76C0911A)
    • Dates
  • R76C094 - Inventory and Balance Sheet by Category Code
  • Processing Options for Inventory and Balance Sheet by Category Code (R76C094)
    • Period
    • Print Options
    • Level
    • Ledger
    • Cat Code
  • Processing Options for Inventory and Balance Sheet by Object Account (R76C094B)
  • Processing Options for Trial Balance by Category Code (R76C0941)
    • Period
    • 1. Level
    • Ledger
    • Cat Code
  • Processing Options for Debits and Credits T/B by Object Account (R76C9411)
    • Process
    • Group
    • Title
    • Version
  • Processing Options for G/L with Subledger Totals (R76C094211)
    • Ledger Type
    • Subledger
  • R76C9415B - Daily Books by Complete Document Report
  • Processing Options for G/L by Object Account with Subledger Total (R76C9422)
    • Content
    • Dates
    • Print
    • Document
    • Currency
    • Ledger Type

9 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 Type
• Subledger
• Subsidiary