This chapter discusses how to set up:
(CHL and PER) User-defined codes (UDCs).
(CHL and PER) Automatic accounting instructions (AAIs).
(CHL and PER) Next numbers.
(CHL and PER) Corresponding versions of country-specific and standard software programs.
(CHL and PER) Lines of business.
(CHL and PER) Legal companies.
(CHL and PER) The system for actual costs.
(CHL) Processing options for Address Book Regional Information - CHI - 01 (P76H101).
(PER) Processing options for Address Book Regional Information - PER - 01 (P76P101).
(CHL) Processing options for Address Book Batch Upload (R76H101Z1).
(PER) Processing options for Address Book Batch Upload (R76P101Z1).
(CHL) Processing options for Chilean Add Vouchers Set Up (P76H0411)
(PER) Revaluation accounts and limits.
(CHL and PER) The fixed asset ledger.
Setting up Chile-specific and Peru-specific UDCs enables you to use country-specific functionality. You also set up some base software UDCs with country-specific values.
In addition to the standard UDC setup, set up these UDCs for Chile and Peru to process:
(CHL and PER) Legal documents
(CHL and PER) Legal companies
(CHL and PER) Fixed assets
(CHL and PER) Address book validations
(CHL and PER) Inventory management
(PER) Supplier withholding
(CHL) Statutory reporting
(CHL and PER) You also set up UDCs to work with accounts receivable draft processing.
See Understanding UDCs for Accounts Receivable Drafts.
Set up legal documents to enable tax processing on various types of documents, such as vouchers and invoices.
Cancellation Codes (76H/CC)
Set up this UDC with values that describe why a legal document is cancelled. For example, you might set up codes for damaged goods, errors, and so on.
Legal Document Types Groups (76H/DG)
The system uses UDC table 76H/DG to identify the processing for each legal document type. This table shows the hard-coded values for legal document types groups:
Code |
Description 01 |
01: |
Invoice |
02: |
Boleta (ticket) |
03: |
Credit Note |
04: |
Debit Note |
05: |
Exportation Invoice |
06: |
Exportation Credit Note |
07: |
Exportation Debit Note |
08: |
Shipment Guide |
09: |
Proforma Invoice |
10: |
Receipt |
99: |
Others |
Set up legal companies to associate transactional companies to legal companies and to set tax parameters.
Address Book Category Code (01/xx)
Set up an address book category code UDC to specify the activities of customers, suppliers, or companies. You then specify the category code used to identify the activities when you set up legal company constants. The system uses the values in the UDC table when you generate reports.
See (CHL and PER) Setting Up Lines of Business for Chile and Peru.
In addition to the standard UDCs for fixed asset processing, set up these country-specific UDCs.
Asset Ledger Column Name (76P/CN)
Use the values in this UDC for the Fixed Asset Ledger Setup program (P76P502) to link the amounts to retrieve by document type to the column, according to the column name that you assign. The system uses this information when you run the Fixed Asset Ledger (R76P5020).
The values in this table are hard-coded and should not be changed:
Code |
Description |
AJI |
Inflation Adjustment |
CTO |
Cost |
DCB |
Exchange Rate Difference |
DPR |
Depreciation |
IRE |
Revaluation |
MEJ |
Improvements |
RET |
Deductions |
Asset Ledger Setup Code (76P/CO)
Enter the code that you want to use to link the columns and document types to include on the Fixed Asset Ledger. The Fixed Asset Ledger retrieves the columns and corresponding document types to use to retrieve amounts based on the value of the Set up Code field that you assign in the Fixed Asset Ledger Set up program and in the processing option of the Fixed Asset Ledger (R76P5020).
Ledger Types to Process (76H/LL)
Set up the ledgers that you want the system to include on the Fixed Assets Ledger report (R76P5020).
The system validates tax ID numbers when you set up these UDCs.
AB Legal Document Types (76H/DA)
R.U.T number validation values specify whether the system performs validation on the tax identification number. Values are:
1: Validate the R.U.T number. You must also enter 1 in the special handling code for this UDC value for the system to perform validation.
2: Do not validate the R.U.T number.
V.A.T Registration Status (76H/02)
V.A.T registration status values specify whether a customer or supplier has registered for VAT. Values are:
N: Not registered.
Y: Registered.
(CHL) Address Book Search Types (76H/ST)
Address book search types indicate for which search types the system should perform R.U.T number validation. Examples include:
C: Customer
S: Supplier
Set up these UDCs before working with the inventory management system.
76A/CA (Adjustment Codes)
Adjustment codes identify adjustment indexes.
76A/ED (Excluded Documents)
Excluded documents are used to identify purchase orders to be excluded from the inventory adjustment calculation.
41/xx (Item Currency)
The item currency code must be defined in the category codes by branch/plant, and is used only for imported items.
Set up these UDCs before calculating supplier withholding.
IGV Withholding Concept (76P/01)
These values specify the type of IGV withholding. Examples are:
IG1: Prueba
IG2: Prueba
IG3: Prueba 3
IGV: Generic IGV Concept
SPOT Concept (76P/02)
These values specify the type of SPOT withholding.
Type Code (01/W0)
The Type Code (01/W0) UDC table includes values that the system uses in the Who's Who (P0111) program. You must set up codes for suppliers who are classified as individuals to specify the names of the supplier's mother and father. This information is required when reporting withholding for these suppliers.
Withholding Document Type (76H/HO)
Set up UDC 76H/HO to include the internal document types that you use to enter fees for withholding.
Amount Type to Use (76P/AT)
The software provides hard-coded values to identity the basis on which the system calculates taxes. For example, when you use a value in this UDC, you can specify that the system calculates taxes based on the gross amount of the voucher.
TAXC (H00/TA)
Set up this UDC to include codes that the system uses to identify the names of the supplier's mother and father. The system uses this information when you run reports for suppliers who are individuals.
Set up this UDC before you generate general ledger reports.
Account Category Codes (09/01–43)
You can combine object accounts into groups for financial reporting purposes. For each group, you set up an account category code in UDC table 09/01–43. These codes describe your organizational structure for higher level or selective reporting.
Account category codes are commonly used to provide a second chart of accounts. For example, you might need a chart of regulatory accounts for government reporting as well as your internal chart of accounts. The system provides 43 category codes; 23 of them can accommodate secondary account numbers.
Depending on the number of characters needed for accounts:
Use types 01–20 for 3-character codes.
Use types 21–43 for 10-character codes.
Chile and Peru use category codes 21–23 for statutory reporting.
Account category codes are stored in the Account Master table (F0901).
Set up AAIs to work with accounts receivable drafts, assets, asset revaluation, inflation adjustments, and the localized cardex.
See Setting Up AAIs for Draft Processing for Argentina.
See Understanding the Calculations for the Revaluation Journal.
See Understanding the Fixed Asset Ledger.
See Understanding Inventory Adjustments for Raw Materials and Resale Goods.
See Understanding the Localized Cardex.
(PER) Set up the Payables Trade (PC) AAI with the document type for SPOT vouchers as defined in the Legal Company Constants (P76P002) program. For example, if you set up IG as the document type, set up this AAI as PCIG.
See Understanding Accounts Payable AAIs.
You set up next numbers for legal documents and to number pages in the fixed asset ledger.
See Setting Up Next Numbers for Legal Documents for Chile and Peru.
See Understanding the Fixed Asset Ledger.
See Also
Voiding Legal Numbers for Chile and Peru
Some country-specific functionality requires that you create versions of the same name for a country-specific program and a base software program. For example, to have the system access the processing options for a country-specific voucher program, you might need to set up a version named XYZ for the country-specific voucher program, and a version named XYZ of the Standard Voucher Entry (P0411) program.
Set up corresponding versions for these programs:
Chile or Peru Program |
Standard Software Program |
See (CHL and PER) Processing Credit Notes and Debit Notes Related to Documents for Chile and Peru. |
|
(CHL) Address Book Regional Information - CHI - 01 (P76H101) |
|
(PER) Address Book Regional Information - PER - 01 (P76P101) |
|
This section provides an overview of setting up lines of business and discusses how to specify the address book category code the represents a company's line of business.
You must set up the system to ensure that the customer’s activity or line of business appears on the legal vouchers. To specify the line of business, or activity, for a company, you:
Set up an address book category code UDC with values that represent lines of business or activities for companies.
For example, you might set up UDC table 01/25 with codes for the lines of business.
Specify the value from the address book category code when you enter information about the company on one of the Cat Code tabs of the Address Book Revisions form.
Specify in the Legal Company Constants (P76H002) or (P76P002) program the address book category code that is set up for the lines of business/activity codes.
Form Name |
FormID |
Navigation |
Usage |
Work With Legal Company Constants |
W76P002A |
|
Add and revise company constants. |
Enter Legal Company Constants |
W76P002B |
Select a legal company on the Work With Legal Company Constants form and click Add. |
Add a line of business to a company. |
Access the Enter Legal Company Constants form.
Activity Category Code Nr. |
Enter the code that specifies the address book category code that is used to store the company's activity code, or line of business. The category code value is included in legal reports. Activity must be defined as an address book category code value. This field is used to indicate the category code number where the company's activity has been defined. After you have specified which category code an organization uses to store line of business information, you can then enter the appropriate line of business code in the appropriate Cat Code tab on the Address Book Revisions form for the company. |
This section provides overviews of legal companies and legal company constants, list prerequisites, and discusses how to:
Associate transactional companies with a legal company.
Set up company constants.
Legal company and transactional company relationships enable many companies to be unified in one legal company and to produce combined accounts payable reports. You can associate the companies that you use for transaction processing (transactional companies) with companies that you use for legal reporting (legal companies) so that legal reports can contain data for more than one transactional company. At a minimum, a legal company and a transactional company relationship must exist for the default company.
When you activate a legal company, the same company is automatically activated in the corresponding localized table. If the legal company is different from the transactional company, you must modify it manually.
You use the Legal Company Constants program (P76H002) to specify whether value-added tax (VAT) reimbursement validation is defined in days or months. This program complies with the VAT law provisions. An invoice does not charge a tax area with a fiscal credit if the number of days or months between the dates defined in the constants exceeds the number allowed by law.
If the VAT reimbursable validation is defined in months, only the fiscal credit can be taken within the two tax periods for an invoice. If it is defined in days, the fiscal credit applies to days.
This table provides an example of the relationships between the From and Thru dates that you define in the legal company constants:
From Date |
Thru Date |
Relationship |
Y |
Y |
G/L Date - Service Date |
Y |
N |
G/L Date - Invoice Date |
N |
Y |
Today's Date - Service Date |
N |
N |
Today's Date - Invoice Date |
See Also
(CHL and PER) Nonreimbursable VAT Processing for Chile and Peru
(CHL and PER) Setting Up the System for Chile and Peru Legal Requirements
Before you complete the tasks in this section:
Ensure that companies have been set up in the Company Names & Number program (P0010).
Set up one or more default business units.
Set up the chart of accounts.
Set up a default company in the JD Edwards EnterpriseOne Address Book system.
Form Name |
FormID |
Navigation |
Usage |
Work With Legal Company |
W76H010A |
(CHL) General Configuration (G76H00), Legal Company (PER) General Configuration (G76P00), Legal Company |
Review a list of legal companies. |
Legal Company Revision |
W76H010B |
Click Add on the Work With Legal Company form. |
Set up a legal company. |
Work With Legal Company Constants (CHL) |
W76H002A |
(CHL) General Configuration (G76H00), Legal Company Constants |
(CHL) Review the constants for legal companies. |
Enter Legal Company Constants (CHL) |
W76H002B |
Click Add on the Work With Legal Company Constants form. |
(CHL) Enter information about legal assignees, dates used to determine reimbursable VAT, professional fee withholding, and the tax explanation code for sales order processing. |
Work With Legal Company Constants (PER) |
W76P002A |
(PER) General Configuration (G76P00), Legal Company Constants |
(PER) Review the constants for legal companies. |
Enter Legal Company Constants (PER) |
W76P002B |
Click Add on the Work With Legal Company Constants form. |
(PER) Enter information about legal assignees, dates used to determine reimbursable VAT, and professional fee and solidarity withholding. |
Access the Legal Company Revision form.
Company |
Enter the transactional company with which to associate a legal company. |
Legal Company |
Enter the legal company with which to associate a transactional company. |
Access the Enter Legal Company Constants form.
General
Activity Category Code Number |
Enter the address book category code that you set up to contain the lines of business or activity codes that apply to companies, customers, or suppliers. If you leave this field blank, the system does not print this information in the accounts payable report heading. |
Legal Assignee 01 and Legal Assignee 02 |
Enter the address book number of the representative. If you leave this field blank, the system does not print this information in the accounts payable report heading. |
Reembosabilidad del IVA (VAT Reimbusability)
Use Service Date as Date From Date |
Select this check box to use the service date as the from date. If you do not select this check box, the system uses the invoice date. |
Use G/L Date as Date Thru |
Select this check box to use the GL date as the through date. If you do not select this check box, the system uses today's date. The system calculates the number of days and months between the selected dates to determine whether the VAT is reimbursable or nonreimbursable. |
Number of Days / Months to check reimbursability |
Enter the number of days or months that the VAT should be considered as reimbursable or nonreimbursable. |
Dias (days) andMeses (months) |
Select an option to specify whether to check reimbusibility by days or by months. |
Non Reimbursable Tax Explanation Code |
Enter a value that exists in the Tax Explanation Code (00/EX) UDC table that the system uses if a tax is not reimbursable. Use this code during invoice entry to specify whether the VAT of the invoice is reimbursable. |
Withholding
Withhold Professional Fee |
Select this check box if the company is a fees withholding agent. |
Professional Fee Minimum Amount |
Enter the minimum amount that the system applies to the fees withholding . |
SOP (Sales order processing)
Cantidad de Días / Meses para Reembolsabilidad (Number of Days / Months to check reimbursability) |
Enter the number of days or months that the VAT should be considered as reimbursable or non-reimbursable. Select the corresponding Dias (days) or Meses (months) option. |
Código de Explicación Fiscal Reembosabilidad (Non Reimbursable Tax Explanation Code) |
Enter a value that exists in the Tax Explanation Code (00/EX) UDC table that the system uses if a tax is not reimbursable. Use this code during invoice entry to specify whether the VAT of the invoice is reimbursable. |
Access the Enter Legal Company Constants form .
General
Activity Category Code Number |
Enter the address book category code that you set up to contain the lines of business or activity codes that apply to companies, customers, or suppliers. If this field is left blank, the system does not print this information in the AP report heading. |
Legal Assignee 01 and Legal Assignee 02 |
Enter the address book number of the representative. If this field is left blank, the system does not print this information in the AP report heading. |
Document Type Payment Order |
Enter a values that exists in the Document Type (00/DT) UDC table to specify the document types used for payment orders. |
VAT Reimbusability
Use Service Date as Date From Date |
Select this check box to use the service date as the from date. If this option is not selected, the system uses the invoice date. |
Use G/L Date as Date Thru |
Select this check box to use the GL date as the through date. If this option is not selected, the system uses today's date. The system calculates the number of days and months between the selected dates to determine whether the VAT is reimbursable or non-reimbursable. |
Number of Days / Months to check reimbursability |
Enter the number of days or months that the VAT should be considered as reimbursable or non-reimbursable. Select the Months option to indicate that the value that you enter is for months. If you do not select the Months option, the system uses the value entered to calculate the number of days. |
Non Reimbursable Tax Explanation Code |
Enter a value that exists in the Tax Explanation Code (00/EX) UDC table that the system uses if a tax is not reimbursable. Use this code during invoice entry to specify whether the VAT of the invoice is reimbursable. |
Withholding
Withhold Professional Fee |
Select this check box if the company is a fees withholding agent. |
Professional Fee Minimum Amount |
Enter the minimum amount that the system applies to the fees withholding. |
Withhold Solidarity |
Select this check box if the company is a solidarity withholding agent. |
Solidarity Withholding Minimum Amount |
Enter the minimum amount that the system applies to the solidarity withholding. |
Document Type IGV Withholding |
Enter a value that exists in the Document Type (00/DT) UDC table to specify the document type used for IGV withholding. |
This section provides an overview of the setup for actual costs and discusses how to: account and cost type relationship and discusses how to .
Set up the account/cost type relationship.
Set up the order/work order relationship.
You must set up a relationship between an account and a cost type to establish the relationship between the account where the cost was charged and the cost object tracking in the JD Edwards Enterprise One Advanced Cost Accounting system. You use the Account ID / Cost Type Relationship program (P76H6005) to set up the relationship.
To generate the actual bill of materials, you must specify the types of documents to be taken into account for the actual cost process. You set up associations between order types and work order types in the Allowed Order Type/WO Type (P76H6006) program.
Form Name |
FormID |
Navigation |
Usage |
Work with Account ID / Cost Type Relationship |
W76H6005A |
(CHL) Actual Cost (G76H31), Account ID / Cost Type Relationship. (PER) Actual Cost (G76P31), Account ID / Cost Type Relationship. |
View and select existing records. |
Account ID/Cost Type Relationship |
W76H6005B |
Select Add on the Work with Account ID / Cost Type Relationship form. |
Set up the account/cost type relationship. |
Work with Order Type / Type W.O. Allowed for Actual Cost |
W76H6006A |
(CHL) Actual Cost (G76H31), Order Type / Type WO Allowed (PER) Actual Cost (G76P31), Order Type / Type WO Allowed |
View and select existing records. |
Order Type / Type W.O. Allowed for Actual Cost |
W76H6006C |
Select Add on the Work with Order Type / Type W.O. Allowed for Actual Cost form. |
Set up the allowed order type/work order type relationship. |
Access the Account ID / Cost Type Relationship form.
Ledger Type |
Enter a value that exists in the Ledger Type (09/LT) UDC table to specify the ledger type to which you associate a cost type. |
Account ID |
Specify the general ledger account. |
Subledger |
Specify the subledger for the account. |
Subledger Type |
Enter a value that exists in the Subledger Type (00/ST) UDC table to identify the subledger type. |
Cost Type |
Enter a value that exists in the Cost Component Add-Ons (30/CA) UDC table to specify the cost type to which you associate a ledger type. |
Access the Order Type / Type W.O. Allowed for Actual Cost form.
Order Type |
Enter a value that exists in the Document Type (00/DT) UDC table to specify the order type to which you associate a work order type. |
Type |
Enter a value that exists in the Work Order/ECO Type (00/TY) UDC table to specify the work order type that you associate with the order type. |
Set these processing options before you enter address book records for Chile. Access the processing option for this program using the Interactive Versions program.
1. Enter “1” to allow duplicate tax identification. |
Specify whether to allow users to enter duplicate tax identification numbers. Values are: Blank: Do not allow duplicate tax identification numbers. 1: Allow duplicate tax identification numbers. |
Set these processing options before entering address book records for Peru. Access the processing option for this program using the Interactive Versions program.
1. Enter '1' to allow duplicate tax identification. |
Specify whether the system allows the entry of duplicate tax identification numbers. Values are: Blank: Do not allow duplicate tax identification numbers. 1: Do not allow duplicate tax identification numbers. |
Select Address Book (G76H01), Address Book Batch Upload.
Set these processing options before using the standard batch upload programs for address book records.
General
Allow Tax ID Duplicate |
Enter 1 to allow duplicate tax identification numbers. |
Select Address Book – Peru (G76P01), Address Book Batch Upload.
Set these processing options before using the standard batch upload programs for address book records.
General
Allow Tax ID Duplicate |
Enter 1 to allow duplicate tax identification numbers. |
Set these processing options before you process vouchers for Chile. You must set up a corresponding version of the Chilean Add Vouchers Set Up program and the Standard Voucher Entry program (P0411).
General
Legal Number Validation |
Enter N to suppress validation of the legal number when you enter vouchers. Leave this processing option blank to have the system perform the validation. |
This section provides an overview of the setup requirements for revaluating assets for Peru and discusses how to:
Set up default revaluation accounts.
Set up revaluation limits.
When you revaluate assets in Peru, you must set up revaluation accounts that are different from those accounts used to record the initial value and accumulated depreciation. You set up the revaluation accounts for each cost code using the Default Revaluation Accounts program (P76P501). This program enables you to link the cost account, by company, to a revaluation asset cost account and revaluation accumulated depreciation account. When you run the Revaluation Journal (R12845), the system uses the accounts that are set up in the Default Revaluation Accounts program for the journal entries that the system generates. The system stores default revaluation account information in the Default Asset Revaluation Account table (F76P501).
In addition to setting up revaluation accounts to use, you must also set up revaluation limits. The Peruvian legislation states that assets cannot be revaluated at an amount that is greater than the current market value (replacement value) of the asset. To accommodate this requirement, you must set up the revaluation limit for each asset before you run the Revaluation Journal program. You use the Revaluation Limit program (P76P503) to set up the market value for each asset with an ending date. When you run the revaluation process, the system uses the limit that you establish if the calculation results in an amount that is greater than the limit. The system stores the revaluation limit records in the Regional Constants by Asset Number table (F76P503).
See Also
Revaluing Assets for Chile and Peru
Setting Up Revaluation Indexes
Form Name |
FormID |
Navigation |
Usage |
Work With Default Assets Revaluation Accounts |
W76P501A |
Fixed Asset (G76P12), Default Revaluation Accounts |
|
Default Assets Revaluation Accounts Revisions |
W76P501B |
Click Add on the Work With Default Assets Revaluation Accounts form. |
|
Work With Regional Constants by Asset Number |
W76P503A |
Fixed Asset (G76P12), Revaluation Limit |
|
Regional Constants Revision by Asset Number |
W76P503C |
Click Add on the Work With Regional Constants by Asset Number form. |
Access the Default Assets Revaluation Accounts Revisions form.
Asset Cost Object |
Enter the object and subsidiary of the account associated with the asset that you want to revalue. |
Reval. Asset Cost (revaluation asset cost) |
Enter the account to update with the revaluated cost when you run the Revaluation Journal (R12845) program. Enter the account using the standard format BU.OBJ.SUB. |
Reval. Accum. Depreciation (revaluation accumulation depreciation) |
Enter the account to update with the revaluated accumulated depreciation amount when you run the Revaluation Journal program. Enter the account using the standard format BU.OBJ.SUB. |
Access the Regional Constants Revision by Asset Number form.
Revaluation Limit |
Enter the current market value of the asset. The system uses this amount if the asset is revalued at a higher amount when you run the Revaluation Journal program. The adjusted value of the asset cannot be greater than the replacement value. |
Ending Date |
Enter the date on which the revaluation limit expires. |
This section provides an overview of the setup requirements for the Fixed Asset Ledger report and discusses how to set up the fixed asset ledger.
Before you can run the Fixed Asset Ledger program (R76P5020), you must set up the information that the system uses to retrieve the fixed asset information using the Fixed Asset Ledger Set up program (P76P502). You use the Fixed Asset Ledger Set up program to specify which amounts to print, according to document type, in the corresponding column, which you identify by assigning a value from the Asset Ledger Column Name (76P/CN) UDC table as the column name. The UDC values are hard-coded to work with the Fixed Asset Ledger program and should not be changed.
You set up the document type and column association information in the Asset Ledger Setup Code (76P/CO) UDC table. You enter the values you set up in the processing options of the Fixed Asset Ledger (R76P5020). The system uses the setup code to retrieve the document types for the corresponding columns by legal company. For example, if you set up the value GENERAL in UDC 76P/CO and use it as the setup code for the Fixed Asset Ledger Setup program, when you run the Fixed Asset Ledger, the system retrieves all the set up information that corresponds to the setup code GENERAL for the legal company specified. You can establish as many setup codes as necessary for the fixed asset document types that you use for each legal company.
Form Name |
FormID |
Navigation |
Usage |
Work With Asset Ledger Set up |
W76P502A |
|
|
Default Assets Revaluation Accounts Revisions |
W76P502B |
Click Add on the Work With Asset Ledger Set up form. |
Access the Default Assets Revaluation Accounts Revisions form.
Legal Company |
Enter the legal company number that represents the transaction companies for which you generate the fixed asset ledger transactions. |
Set up Code |
Enter the UDC code (76P/CO) to identify the document types to use to retrieve the asset amounts to print on the Fixed Asset Ledger report in the corresponding columns. |
Do Ty (document type) |
Enter the document type to use to retrieve the asset amounts to print on the Fixed Asset Ledger report in the corresponding column that is set up in the Column Name field. |
Column Name |
Enter the UDC (76P/CN) that indicates the column for which the system prints the fixed asset amounts for the document type entered in the Do Ty field. |