Go to main content
1/14
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to JD Edwards EnterpriseOne Localizations for Colombia
1.1
JD Edwards EnterpriseOne Localizations for Colombia Overview
1.2
JD Edwards EnterpriseOne Localizations for Colombia Implementation
1.3
Understanding Translation Considerations for Multilingual Environments
1.4
Understanding Translation Routines
1.5
Setting Up User Display Preferences
1.5.1
Understanding User Display Preferences
1.5.2
Form Used to Set Up User Display Preferences
1.5.3
Setting Processing Options for User Profile Revisions (P0092)
1.5.3.1
A/B Validation
1.5.3.2
PIM Server Setup
1.5.4
Setting Up User Display Preferences
2
Understanding Localizations for Colombia
2.1
How to Validate Tax IDs in Latin American Countries
2.2
(COL and ECU) Tax Explanation Codes for Columbia and Ecuador
2.3
Colombia-Specific Setup and Processes
3
Setting Up Functionality for Colombia
3.1
Setting Up UDCs for Colombia
3.1.1
Setting Up UDCs to Use Magnetic Media for Tax Reporting
3.1.1.1
Address Book Category Codes (01/xx)
3.1.1.2
General Ledger Category Codes (09/xx)
3.1.1.3
DIAN Concepts for Format 1001 (76C/01)
3.1.1.4
DIAN Concepts for Format 1002 (76C/02)
3.1.1.5
DIAN Concepts for Format 1003 (76C/03)
3.1.1.6
DIAN Concepts for Format 1004 (76C/04)
3.1.1.7
Concepts for Format 1007 (76C/07)
3.1.1.8
DIAN Concepts for Format 1008 (76C/08)
3.1.1.9
DIAN Concepts for Format 1009 (76C/09)
3.1.1.10
DIAN Concepts for Format 1011 (76C/11)
3.1.1.11
DIAN Concepts for Format 1012 (76C/12)
3.1.1.12
DIAN Concepts for Format 1034 (76C/34)
3.1.1.13
DIAN Document Types (76C/DT)
3.1.1.14
Returns Document Type (76C/DV)
3.1.1.15
DIAN Magnetic Media Formats (76C/FM)
3.1.1.16
Person/Corporation Code (76C/PC)
3.1.1.17
DIAN VAT Prefixes (76C/VT)
3.1.1.18
DIAN VAT Withholding Prefixes (76C/VW)
3.1.1.19
DIAN Writeoff Codes (76C/WO)
3.1.2
Setting Up UDCs for Accounts Payable Transactions for Colombia
3.1.2.1
Recycle Voucher (76C/RC)
3.1.2.2
Tax Payer Type (76C/TC)
3.2
Setting Up Address Book Information for Colombia
3.2.1
Understanding Address Book Information for Colombia
3.2.2
Setting Processing Options for Address Book Colombian Additional Information (P76C0101)
3.2.2.1
General
3.2.2.2
Display
3.2.3
Form Used to Enter Additional Address Book Information for Colombia
3.2.4
Entering Additional Address Book Information for Colombia
3.3
Setting Up Cost Accounts for Depreciation and Inflation Adjustments for Colombia
3.3.1
Understanding Cost Inflation Adjustments
3.3.2
Understanding Depreciation Inflation Adjustment Accounts
3.3.3
Forms Used to Set Up Cost Accounts for Depreciation and Inflation Adjustments
3.3.4
Setting Up Cost Accounts for Cost Inflation Adjustments
3.3.5
Setting up Cost Accounts for Depreciation Adjustments
3.4
Setting Up Payment Formats for Colombia
3.4.1
Understanding Payment Formats for Colombia
3.4.2
Setting Processing Options for Print Automatic Payments - COL (R76C572)
3.4.2.1
Translation
3.4.2.2
Payment
3.4.2.3
Conversion
3.4.2.4
Print
4
Understanding Tax Reporting Using Magnetic Media in Colombia
4.1
Process for Reporting Taxes Electronically
4.1.1
Overview of Process
4.1.1.1
Accounts Payable Records
4.1.1.2
Accounts Receivable Records
4.1.1.3
General Ledger Records
4.1.1.4
Records with Minimal Amounts
4.1.2
Report Setup Programs
4.1.3
Filter Programs
4.1.4
XML Generation Programs
5
Setting Up the System for Colombian Taxes
5.1
Understanding Tax Rate Areas and Tax Rules for Colombia
5.1.1
Tax Rules
5.2
Setting Up UDCs for Colombian Taxes
5.2.1
Address Book Category Codes (01/xx)
5.2.2
General Ledger Category Codes (09/xx)
5.2.3
Concepts (76C/00)
5.2.4
DIAN Concepts for Format 1008 (76C/08)
5.2.5
DIAN Concepts for Format 1009 (76C/09)
5.2.6
DIAN Concepts for Format 1011 (76C/11)
5.2.7
DIAN Concepts for Format 1012 (76C/12)
5.2.8
DIAN Concepts for Format 1034 (76C/34)
5.2.9
Colombia Tax Explanation Mapping Additional Tax (76C/AT) (Release 9.1 Update)
5.2.10
DIAN Country Code (76C/CC)
5.2.11
DIAN Document Types (76C/DT)
5.2.12
Returns Document Type (76C/DV) (Release 9.1 Update)
5.2.13
DIAN Magnetic Media Formats (76C/FM)
5.2.14
Person/Corporation Code (76C/PC)
5.2.15
Type Account (76C/TA) (Release 9.1 Update)
5.2.16
DIAN VAT Prefixes (76C/VT)
5.2.17
DIAN VAT Withholding Prefixes (76C/VW)
5.2.18
DIAN Writeoff Codes (76C/WO)
5.3
Entering Additional Address Book Information in Colombia
5.3.1
Understanding Address Book Information for Colombia
5.3.2
Form Used to Enter Additional Address Book Information for Colombia
5.3.3
Setting Processing Options for Address Book Colombian Additional Information (P76C0101)
5.3.3.1
General
5.3.3.2
Display
5.3.4
Entering Additional Address Book Information for Colombia
5.4
Setting Up Economic Activity Code Information
5.4.1
Understanding Economic Activity Codes
5.4.2
Prerequisites
5.4.3
Forms Used to Set Up Economic Activity Codes
5.4.4
Setting Processing Options for I.C.A. (P76CI00)
5.4.4.1
Currency
5.4.5
Associating an Economic Activity Code to a Tax Rate Area
5.4.6
Setting Up Effective Dates, Rates, and Minimum Amounts
5.5
Setting Up Tax Parameters
5.5.1
Forms Used to Set Up Tax Parameters
5.5.2
Setting Up Tax Parameters
5.6
Setting Up Tax Areas Relationship (Release 9.1 Update)
5.6.1
Form Used to Set Up Tax Area Relationship
5.6.2
Setting Up Tax Area Relationship
5.7
Setting Up General Parameters for Tributary Codes
5.7.1
Form Used to Set Up General Parameters
5.7.2
Setting Up General Parameters
5.8
Setting Up General System Information for Tax Reporting
5.8.1
Understanding Next Numbers for DIAN Reporting
5.8.2
Understanding Legal Companies
5.8.3
Understanding General System Setup for Tax Reporting
5.8.3.1
Legal and Natural Person Information
5.8.3.2
General Ledger Information
5.8.3.3
XML Generation Information
5.8.3.4
Minor Amounts Setup
5.8.4
Prerequisites
5.8.5
Forms Used to Set Up the System for Tax Reporting
5.8.6
Associating Codes for Natural and Legal Entities to DIAN Document Types
5.8.7
Setting Up General Format Information
5.8.7.1
General Setup
5.8.7.2
Address Book
5.8.7.3
General Ledger
5.8.8
Associating Minimum Amounts and Next Numbers with DIAN Format Numbers
5.9
Setting Up GL Accounts by Concept Codes and Format Number
5.9.1
Understanding GL Account and Concept Code Setup
5.9.1.1
Copying GL Accounts
5.9.1.2
Importing Data
5.9.2
Prerequisites
5.9.3
Forms Used to Associate GL Accounts to DIAN Concept Codes and Format Numbers
5.9.4
Associating Formats Numbers to Accounts
5.9.5
Copying Account Data
5.9.6
Importing Data from a Spreadsheet
5.10
Identifying Missing GL Account/Format/Concept Code Associations
5.10.1
Understanding the DIAN Concept Account Setup Control Report Program
5.10.2
Running the DIAN Concept Account Setup Control Report
5.10.3
Setting Data Selection for DIAN Concept Account Setup Control Report
5.10.4
Setting Processing Options for DIAN Concept Account Setup Control Report (R76C9F00)
5.10.4.1
General
5.11
Setting Up Account Types for Formats 1001 and 1007 (Release 9.1 Update)
6
Generating and Modifying Records for Electronic Tax Reporting in Colombia
6.1
Understanding How to Generate and Modify DIAN Records
6.1.1
Overview of Process
6.2
Generating Records for DIAN Formats 1001, 1002, 1003, 1004, and 1007
6.2.1
Understanding How to Extract Data for DIAN Formats 1001, 1002, 1003, 1004, and 1007
6.2.1.1
Format 1001
6.2.1.2
Format 1002
6.2.1.3
Format 1003
6.2.1.4
Format 1004
6.2.1.5
Format 1007
6.2.2
Understanding the DIAN Output XML Generation Program
6.2.2.1
File Status
6.2.3
Prerequisite
6.2.4
Running the DIAN Generate concept by Account ID Program
6.2.5
Setting Processing Options for DIAN Generate concept by Account ID (R76C9F01)
6.2.5.1
General
6.2.6
Running the DIAN Output XML Generation — Format 1001, 1002, 1003, 1004, 1007 Program
6.2.7
Setting Processing Options for DIAN Output XML Generation (R76C9F02)
6.2.7.1
Process
6.3
Generating Records for DIAN Format 1005
6.3.1
Understanding DIAN Format 1005
6.3.1.1
DIAN Sales VAT to Pay Originated by Purchases
6.3.2
Running the DIAN Sales VAT to Pay originated by Purchases Program
6.3.3
Setting Processing Options for DIAN Sales VAT to Pay originated by Purchases (R76C4F60)
6.3.3.1
Process
6.3.4
Running the DIAN Output XML Generation (1005) Program
6.3.5
Setting Processing Options for DIAN Output XML Generation (1005) (R76C4F62)
6.3.5.1
Process
6.4
Generating Records for DIAN Format 1006
6.4.1
Understanding DIAN Format 1006
6.4.1.1
DIAN Sales VAT Discountable Origination by Sales
6.4.2
Running the DIAN Sales VAT Discountable originated by Sales Program
6.4.3
Setting Processing Options for DIAN Sales VAT Discountable originated by Sales (R76C3F50)
6.4.3.1
Process
6.4.4
Running the DIAN Output XML Generation (1006) Program
6.4.5
Setting Processing Options for DIAN Output XML Generation (1006) (R76C3F52)
6.4.5.1
Process
6.5
Generating Records for DIAN Format 1008
6.5.1
Understanding DIAN Format 1008
6.5.1.1
DIAN Accounts Receivable Pending (R76C3F80)
6.5.2
Setting Processing Options for DIAN Configurable Setup Concepts for Format 1008 (R76C3F81)
6.5.2.1
Process
6.5.3
Running the DIAN Accounts Receivable Pending Program
6.5.4
Setting Processing Options for DIAN Accounts Receivable Pending (R76C3F80)
6.5.4.1
Process
6.5.4.2
Version
6.5.5
Running the DIAN Output XML Generation (1008) Program
6.5.6
Setting Processing Options for DIAN Output XML Generation (1008) (R76C3F82)
6.5.6.1
Process
6.6
Generating Records for DIAN Format 1009
6.6.1
Understanding DIAN Format 1009
6.6.1.1
DIAN Accounts Payable Pending (R76C4F90)
6.6.2
Setting Processing Options for DIAN Configurable Setup Concepts for Format 1009 (R76C4F91)
6.6.2.1
Process
6.6.3
Running the DIAN Accounts Payable Pending Program
6.6.4
Setting Processing Options for DIAN Accounts Payable Pending (R76C4F90)
6.6.4.1
Process
6.6.4.2
Version
6.6.5
Running the DIAN Output XML Generation (1009) Program
6.6.6
Setting Processing Options for DIAN Output XML Generation (1009) (R76C4F92)
6.6.6.1
Process
6.7
Generating Records for DIAN Format 1011
6.7.1
Understanding DIAN Format 1011
6.7.1.1
DIAN Tributary Information (R76C9F11)
6.7.2
Prerequisites
6.7.3
Running the DIAN Tributary Information Program
6.7.4
Setting Processing Options for DIAN Tributary Information (R76C9F11)
6.7.4.1
Process
6.7.5
Running the DIAN Output XML Generation (1011) Program
6.7.6
Setting Processing Options for DIAN Output XML Generation (1011) (R76C9F13)
6.7.6.1
Process
6.8
Generating Records for DIAN Format 1012
6.8.1
Understanding the DIAN 1012 Format
6.8.1.1
DIAN Tributary Information (Certificates, Titles) (R76C9F14)
6.8.2
Prerequisites
6.8.3
Running the DIAN Tributary Information (Certificates, Titles) Program
6.8.4
Setting Processing Options for DIAN Tributary Information (Certificates, Titles) (R76C9F14)
6.8.4.1
Defaults
6.8.5
Running the DIAN Generate Output XML Generation (1012) Program
6.8.6
Setting Processing Options for DIAN Output XML Generation (1012) (R76C9F16)
6.8.6.1
Process
6.9
Generating Records for DIAN Format 1034
6.9.1
Understanding DIAN Format 1034
6.9.1.1
DIAN Consolidate Balance Sheet (R76C9F34)
6.9.2
Prerequisites
6.9.3
Running the DIAN Consolidate Balance Sheet Program
6.9.4
Setting Processing Options for DIAN Consolidate Balance Sheet (R76C9F34)
6.9.4.1
Defaults
6.9.5
Running the DIAN Output XML Generation (1034) Program
6.9.6
Setting Processing Options for DIAN Output XML Generation (1034) (R76C9F36)
6.9.6.1
Process
6.10
Reviewing and Modifying DIAN Records
6.10.1
Understanding How to Review and Modify Concept Codes for DIAN Records
6.10.2
Forms Used to Review and Modify DIAN Records
6.11
Generating the XML File Interactively
6.11.1
Forms Used to Generate the XML File Interactively
7
Working with Fixed Assets for Colombia
7.1
Calculating Depreciation Adjustments for Inflation for Colombia
7.1.1
Understanding Depreciation Adjustments for Inflation
7.1.1.1
Adjustment by Inflation Depreciation/Amortization (R76C1202)
7.1.1.2
Data Selection for Adjustment by Inflation Depreciation/Amortization
7.1.2
Prerequisites
7.1.3
Calculating the Depreciation Inflation Adjustments
7.1.4
Setting Processing Options for Adjustment by Inflation Depreciation/Amortization (R76C1202)
7.1.4.1
Process
7.1.4.2
Subledger
7.1.4.3
No Batch Trans.
7.2
Calculating the End of the Useful Life for Colombian Assets
7.2.1
Understanding the Life End Date Program
7.2.2
Prerequisites
7.2.3
Calculating the End of Useful Life
7.2.3.1
Data Selection for Life End Date
7.2.4
Setting Processing Options for Life End Date (R76C1208)
7.2.4.1
Process
7.2.4.2
No Batch Trans
7.2.4.3
Ledger
7.3
Working With Cost Inflation Adjustments in Colombia
7.3.1
Understanding Cost Inflation Adjustments
7.3.1.1
Calculating Cost Inflation Adjustments
7.3.1.2
Data Selection for the Adjustment by Cost / Deferred Charge Report
7.3.2
Prerequisites
7.3.3
Forms Used to Review and Revise Cost Accounts
7.3.4
Calculating the Cost Inflation Adjustments
7.3.5
Setting Processing Options for Adjustment by Inflation to Cost / Deferred Charge (R76C1201)
7.3.5.1
Process
7.3.5.2
Subledger
7.3.5.3
No Batch Trans.
8
Understanding Reports for Colombia
8.1
Reports for Colombia
8.1.1
Processing Options for R76C0001 and R76C0003
8.1.1.1
Date
8.1.1.2
Print
8.1.1.3
Level and Company
8.1.1.4
Responsible
8.1.1.5
Display
8.1.1.6
Third Party
8.1.1.7
Reprocess
8.1.1.8
Title
8.1.1.9
Certificate
8.1.1.10
IVA Withheld
8.1.2
Processing Options for R76C0002
8.1.2.1
Date (Release 9.1 Update)
8.1.2.2
Display
8.1.2.3
Display and Company
8.1.2.4
Total
8.1.2.5
Print
8.1.2.6
Reprocess
8.1.2.7
Title
8.1.3
Processing Options for R76C0003
8.1.4
Processing Options for Timbre Withholding (R76C0004)
8.1.4.1
Print
8.1.4.2
Level
8.1.4.3
Responsible
8.1.4.4
Display
8.1.4.5
Third Party
8.1.4.6
Reprocess
8.1.4.7
Title
8.1.4.8
Certificate
8.1.4.9
VAT Withheld
8.1.5
Processing Option for Auto-Withholding Calculation (R76C0005) (Release 9.1 Update)
8.1.6
Processing Option for Additional Tax Calculation (R76C0006) (Release 9.1 Update)
8.1.7
Processing Options for General Journal by Category Code (R76C0911)
8.1.7.1
Dates
8.1.7.2
Cat. Code
8.1.8
Processing Options for General Ledger with Total by Object Account (R76C0911A)
8.1.8.1
Dates
8.1.9
R76C094 - Inventory and Balance Sheet by Category Code
8.1.10
Processing Options for Inventory and Balance Sheet by Category Code (R76C094)
8.1.10.1
Period
8.1.10.2
Print Options
8.1.10.3
Level
8.1.10.4
Ledger
8.1.10.5
Cat Code
8.1.11
Processing Options for Inventory and Balance Sheet by Object Account (R76C094B)
8.1.12
Processing Options for Trial Balance by Category Code (R76C0941)
8.1.12.1
Period
8.1.12.2
1. Level
8.1.12.3
Ledger
8.1.12.4
Cat Code
8.1.13
Processing Options for Debits and Credits T/B by Object Account (R76C9411)
8.1.13.1
Process
8.1.13.2
Group
8.1.13.3
Title
8.1.13.4
Version
8.1.14
Processing Options for G/L with Subledger Totals (R76C094211)
8.1.14.1
Ledger Type
8.1.14.2
Subledger
8.1.15
R76C9415B - Daily Books by Complete Document Report
8.1.16
Processing Options for G/L by Object Account with Subledger Total (R76C9422)
8.1.16.1
Content
8.1.16.2
Dates
8.1.16.3
Print
8.1.16.4
Document
8.1.16.5
Currency
8.1.16.6
Ledger Type
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.