This chapter contains the following topics:
Section 3.4, "Entering Additional Address Information for Peru,"
Section 3.5, "Setting Up Corresponding Versions of Programs for Peru"
Section 3.8, "Setting Up the System for Actual Costs for Peru"
Section 3.9, "Setting Processing Options for PO - Address Book Batch Upload (R76P101Z1),"
Section 3.10, "Setting Up Revaluation Accounts and Limits for Peru,"
Setting up country-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 to process:
Legal documents
Legal companies
Fixed assets
Address book validations
Inventory management
Supplier withholding
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.
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.
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.
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.
In addition to the standard UDCs for fixed asset processing, set up these country-specific UDCs.
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 |
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).
The system validates tax ID numbers when you set up these UDCs.
R.U.T number validation values specify whether the system performs RUT validation. The system performs R.U.T validations based on the special handling codes set for the AB Legal Document Types UDC (76H/DA). The Special Handling Code values for the UDC are:
1: Validate the R.U.T number.
2: Do not validate the R.U.T number.
Blank or another value other than 1 or 2: Do not validate the R.U.T number. The system only verifies the Tax identification number if it contains only numbers (Release 9.1 Update).
Set up these UDCs before working with the inventory management system.
The item currency code must be defined in the category codes by branch/plant, and is used only for imported items.
Excluded documents are used to identify purchase orders to be excluded from the inventory adjustment calculation.
This table stores the relationships between document types and legal documents. The system uses this information to retrieve the legal code from legal document type transactions. The value configured in the Description 02 field is reflected in the inventory ledger report.
This table stores the relationships between document types and operation types. The system uses this information to retrieve the legal operation type from legal document type transactions. The value configured in the Description 02 field is reflected in the inventory ledger report.
Set up these UDCs before working with the inventory management system.
The item currency code must be defined in the category codes by branch/plant, and is used only for imported items.
Excluded documents are used to identify purchase orders to be excluded from the inventory adjustment calculation.
This table stores the relationships between document types and legal documents. The system uses this information to retrieve the legal code from legal document type transactions. The value configured in the Description 02 field is reflected in the inventory ledger report.
This table stores the relationships between document types and operation types. The system uses this information to retrieve the legal operation type from legal document type transactions. The value configured in the Description 02 field is reflected in the inventory ledger report.
Set up AAIs to work with accounts receivable drafts, assets, asset revaluation, inflation adjustments, and the localized cardex.
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.
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.
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 Peru.
See Understanding the Fixed Asset Ledger.
This section provides an overview of additional address book information for Peru, and discusses how to:
Set processing options for Address Book Regional Information - PER - 01 (P76P101)
Add address book information for Peru
Address book records for Peru require additional tax information. The system stores the additional information in the Address Book Tag File - PER - 01 table (F76P101T). The additional information required for Peru includes these elements:
N.I.T Validation
The N.I.T number (Número de Identificación Tributaria [NIT]) is the tax identification number. In addition to entering the tax identification number, you specify a legal document type that specifies whether the system must validate the N.I.T. number. The system performs the following validations:
The number cannot have more than 11 digits, and the last number must correspond to the verifier digit.
The verifier digit must be correct.
The number cannot already exist within the system.
Duplicate N.I.T. numbers are not allowed.
Withholding
For suppliers, you must specify whether a tax exemption certificate was entered and, if so, you must enter the due date. If a supplier has a tax exemption certificate, the system does not require you to enter withholding amounts during voucher entry.
You must also specify whether the supplier has a Solid arid ad withholding exemption and, if so, you must enter the due date.
VAT Status
Specify whether the supplier or customer is registered for taxes using the Registered for Taxes field. Enter N to indicate that the supplier or customer is not registered, and Y to indicate that they are registered.
Set these processing options before entering address book records for Peru. Access the processing option for this program using the Interactive Versions program.
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.
Form Name | Form ID | Navigation | Usage |
---|---|---|---|
A/B Regional Information Revision | W76P101B | Daily Processing (G0110), Address Book Revisions.
Select an address book record on the Work With Addresses form, and select Regional Info from the Row menu. When adding a new address book record, click OK on the Address Book Revisions form. |
Enter required address book information for Peru. |
Access the A/B Regional Information Revision form.
Select a value from UDC 76H/DA to specify whether the system validates the N.I.T number.
Enter the tax identification number.
Enter the name that you want to appear on payments that are made to the supplier.
Select this option to indicate that a professional services supplier presented the nonwithholding certificate. This certificate is issued by the fiscal authority and applies only to the professional fees withholding.
Enter the due date for the nonwithholding certificate that a supplier presented. This applies only for professional fees withholding. If you leave this field blank, the exemption will remain in effect.
Select to indicate that a supplier has presented a Solidaridad withholding exemption.
Enter the due date for the Solidaridad withholding exemption.
Select a value from UDC 76P/01. This is the General Sales Tax (IGV) withholding concept. This concept is associated with a withholding percentage. When you pay a voucher for this supplier, the system computes the withholding amount according to this withholding concept and its corresponding percentage.
Select a value from UDC 76P/02. This value determines the SPOT concept.
Specify whether the customer or supplier is registered for taxes. Select a value from UDC 76H/02.
Enter additional information for the address book record. These fields are optional and are used for reports.
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:
Peru Program | Standard Software Program |
---|---|
Address Book Regional Information - PER - 01 (P76P101) | Address Book Revisions (P01012) |
PO - Address Book Batch Upload (R76P101Z1) | Address Book Batch Upload (R01010Z)
See "Processing Batch Address Book Records" in the JD Edwards EnterpriseOne Applications Address Book Implementation Guide. |
Peruvian Add Vouchers Set Up (P76P411T) | Standard Voucher Entry (P0411) |
PO - PCG process - PER (P76P470) | Work With Payment Groups (P04571) |
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 | Form ID | Navigation | Usage |
---|---|---|---|
Work With Legal Company Constants | W76P002A | General Configuration (G76P00), Legal Company Constants | 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.
Figure 3-1 Enter Legal Company Constants
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 |
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 | Form ID | Navigation | Usage |
---|---|---|---|
Work With Legal Company | W76H010A | 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 | W76P002A | General Configuration (G76P00), Legal Company Constants | Review the constants for legal companies. |
Enter Legal Company Constants | W76P002B | Click Add on the Work With Legal Company Constants form. | Enter information about legal assignees, dates used to determine reimbursable VAT, and professional fee and solidarity withholding. |
Access the Legal Company Revision form.
Enter the transactional company with which to associate a legal company.
Enter the legal company with which to associate a transactional company.
Access the Enter Legal Company Constants form.
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.
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.
Enter a values that exists in the Document Type (00/DT) UDC table to specify the document types used for payment orders.
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.
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.
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.
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.
Select this check box if the company is a fees withholding agent.
Enter the minimum amount that the system applies to the fees withholding.
Select this check box if the company is a solidarity withholding agent.
Enter the minimum amount that the system applies to the solidarity 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 | Form ID | Navigation | Usage |
---|---|---|---|
Work with Account ID / Cost Type Relationship | W76H6005A | 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 | 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.
Figure 3-2 Account ID / Cost Type Relationship form
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.
Specify the general ledger account.
Specify the subledger for the account.
Enter a value that exists in the Subledger Type (00/ST) UDC table to identify the subledger 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.
Figure 3-3 Order Type / Type W.O. Allowed for Actual Cost form
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.
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.
Select Address Book – Peru (G76P01), Address Book Batch Upload.
Set these processing options before using the standard batch upload programs for address book records.
Enter 1 to allow duplicate tax identification numbers.
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).
Access the Default Assets Revaluation Accounts Revisions form.
Enter the object and subsidiary of the account associated with the asset that you want to revalue.
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.
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.
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.
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.
(Release 9.1 Update) You must also set up supplemental data for the fixed asset ledger. You use supplemental data to further define the assets in the system. For the fixed asset ledger, you must add the authorization document number on the Supplemental Data (P00091) program with code AM. The system uses this information to retrieve a value for the authorization number column.
Access the Default Assets Revaluation Accounts Revisions form.
Figure 3-4 Default Assets Revaluation Accounts Revision form
Enter the legal company number that represents the transaction companies for which you generate the fixed asset ledger transactions.
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.
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.
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.