This chapter contains the following topics:
Section 4.3, "Setting Up UDCs for Supplier Withholding in Mexico"
Section 4.7, "Importing Data from a Spreadsheet for Mexican Withholding"
Section 4.8, "Setting Up Company Information for Supplier Withholding in Mexico"
Before you work with supplier withholding in Mexico, you must set up base software with the information that the system uses as it processes vouchers and payments.
Set up this information in the JD Edwards EnterpriseOne standard software:
All standard setup to process accounts payable transactions, such as companies, accounts, and address book records.
Automatic accounting instructions (AAIs).
Set up the specific AAIs that you need to process the withholding lines on the vouchers for suppliers of services. You must include the withholding concept as part of the AAI item, as a suffix. For example, $ISER represents withholding VAT (type: I) for services (concept: SER). The system limits AAIs to six characters.You also associate the base AAIs and document types to withholding types (VAT and Income) in the Generic Constants program (P76M005). The system automatically completes the base AAIs with the corresponding withholding concepts assigned to each pay item during voucher registration.
In addition to the document types that you set up to process your vouchers, set up document types for the withholding lines that are generated when you process vouchers for the suppliers of services. You associate base AAIs and document types to withholding types in the Generic Constants program (P76M005).
Set up a next numbering scheme for system 76M on line two of the Next Numbers program (P0002), and another numbering scheme for system 76M on line three of the Next Numbers program.
The system uses the next numbering scheme on line two to number payment orders when you run the Write process of the automatic payment process, and uses the numbering scheme on line three to number withholding certificates.
Before you perform the tasks in this chapter, verify that the Localization Country Code field in the User Profile Revisions program (P0092) is set to MX (Mexico).
Before you process supplier withholding in Mexico, set up these UDC tables:
Set up codes in this UDC table for the document types that you want to use for the withholding lines that the system writes when you process payments. You assign a code from this UDC table when you associate document types and AAIs to withholding concepts in the Generic Constants program (P76M005).
Set up codes in this UDC table for the voucher document that you want to use for the withholding lines that the system writes when you process payments.
The JD Edwards EnterpriseOne system provides hard-coded values for this UDC table.
The values of G and T must exist in this UDC table. You specify a value from this UDC table when you set up withholding percentages in the Work With Withholding Percentages program (P76M003). The system uses the values when you run the Create Payment Groups Control program (R04570) to calculate withholding amounts.
Examples of values are:
| Codes | Description |
|---|---|
| G | Gross amount |
| T | Taxable amount |
Set up codes in this UDC table to identity the person/corporation codes that you use for individuals. The system compares the values in this UDC table to the person/corporation code that exists in the supplier's address book record. If the code assigned to a supplier exists in this UDC table, the system prints on the supplier withholding certificate information that applies to individuals. If the code assigned in the supplier address book record does not exist in this UDC table, the system prints the withholding certificate without information that applies to only individuals.
The JD Edwards EnterpriseOne software includes hard-coded values for this UDC table. You select a value from this UDC table to specify whether to work with VAT or income withholding when you set up legal concepts in the Work with Legal Concepts program (P76M001). Values are:
| Codes | Description |
|---|---|
| I | Income |
| V | VAT |
This section provides an overview of legal concepts for Mexico and discusses how to manually add legal concepts in Mexico.
You must set up your system with the legally required reporting codes (concepts) for VAT and income withholding. The system uses the legal codes on the supplier withholding certificate that you generate for VAT and income withholding. You obtain the legal codes from the government.
Because you might need to set up multiple withholding rates for a legal concept, you can set up the legally required codes and then associate them with the withholding codes (concepts). You can associate multiple withholding codes to a legal concept.
You use the Work with Legal Concepts program (P76M001) to set up legal constants. You can manually set up legal concepts, or you can import the codes from a MicroSoft Excel© spreadsheet. The system saves the legal concepts to the Withholding Legal Concepts table (F76M001). You cannot delete a legal concept after you associate a withholding concept to it.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work With Legal Concepts | W76M001A | Withholding Setup (G76M0401), Work with Legal Concepts | Review and select existing records. |
| Legal Concepts Revision | W76M001B | Click Add on the Work With Legal Concepts form. | Manually add the legal concept. |
This section provides an overview of withholding concepts for Mexico and discusses how to manually add withholding concepts in Mexico.
Withholding concepts are internally used codes for different types of VAT or income withholding. You use the Work with Withholding Concepts program (P76M002) to associate the codes that you use internally with the legally required codes for withholding that you set up in the Work with Legal Concepts program (P76M001). The legally required codes are also known as legal concepts. You can associate multiple withholding codes to a legal concept.
You can manually set up a withholding concept and associate it with a legal concept, or you can import the codes and associations from a MicroSoft Excel© spreadsheet.
The system saves the withholding concepts and their associations to legal concepts in the Withholding Concepts table (F76M002). You cannot delete a withholding concept record if you have set up withholding percentages for the concept in the Work With Withholding Percentages program.
After you set up withholding concepts, you use the Work With Withholding Percentages program (P76M003) to associate the withholding percentages and effective dates to the withholding concept. You also associate the withholding concepts, and thus the percentages, to the address book record of the suppler. When you process vouchers, the system uses the withholding concepts that you associate with the supplier address book record to retrieve the withholding percentage to apply to the voucher.
|
Note: The system retrieves withholding information for a voucher only when you set a processing option in the Withholding Additional Information program (P76M411) to specify that withholding applies. |
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work with Withholding Concepts | W76M002A | Withholding Setup (G76M0401), Work With Withholding Concepts | Review and select existing records. |
| Withholding Concepts Revision | W76M002B | Click Add on the Work with Withholding Concepts form. | Associate a withholding concept with a legal concept. |
Access the Withholding Concept Revision form.
Enter a value from the Withholding Type (76M/WT) UDC table to specify whether to set up a withholding concept for VAT or for income withholding. Values are:
V: VAT
I: Income
Enter a code for the withholding concept. You must complete this field.
Enter a definition for the withholding concept.
Enter a code from the Withholding Legal Concepts table (F76M001) to associate the legal concept to the withholding concept.
This section provides an overview of withholding percentages for Mexico and discusses how to manually add withholding percentages in Mexico.
You use the Work With Withholding Percentages program (P76M003) to specify the withholding percentages that the system applies for VAT and income withholding. You can set up as many records for each withholding type (VAT or income) as you need to account for all of the withholding percentages that you might need.
You specify whether the percentage applies to the gross or the taxable amount of the service. The system uses values from the Accounts Payable Ledger table (F0411) to determine the gross and taxable amounts.
The system saves the withholding percentage information to the Withholding Percentage table (F76M003). You can manually enter the data or import it from a spreadsheet.
When you create payment groups using the Create Payment Control Groups program (R04570) in the automatic payment process, the system uses the VAT and income percentages that you set up to calculate the withholding amount.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work With Withholding Percentages | W76M003A | Withholding Setup (G76M0401), Work with Withholding Percentages | Review and select existing records. |
| Withholding Percentage Revisions | W76M003B | Click Add on the Work With Withholding Percentages form. | For each withholding concept, specify the percentage to withhold, the effective and expiration dates, and whether to apply the percentage to the gross or taxable amount of a voucher. |
Access the Withholding Percentage Revisions form.
Enter the company for which the withholding percentage applies. You must complete this field.
Enter a value from the Withholding Type (76M/WT) UDC table to specify whether to set up a withholding percentage for VAT or for income withholding. You must complete this field.
Enter a value from the Withholding Concepts table (F76M002) to specify the withholding concept for which you set up the withholding percentage. You can enter only a concept that is associated with the withholding type that you specified in the Withholding Type field. You must complete this field.
Enter the beginning of the date range for which the withholding percentage is in effect. You must complete this field.
Enter the end of the date range for the withholding percentage. You must complete this field.
Enter the withholding percentage. If you do not complete this field, the system assigns a value of zero (0) percent.
Enter a value from the Withholding Applicable Type (76M/AT) UDC table to specify whether to apply the percentage to the gross amount or taxable amount. Values are:
G: Gross amount. The system ignores the Tax Explanation code and calculates the VAT or income withholding based on the gross amount of the voucher line.
T: Taxable amount. The system uses the taxable amount when you process income or VAT withholding.
This section provides an overview of data import and discusses how to import data from a spreadsheet.
Instead of manually entering data, you can import data from a spreadsheet to populate the values for these programs:
Work with Legal Concepts (P76M001)
Work with Withholding Concepts (P76M002)
Work With Withholding Percentages (P76M003)
When you import data, the system populates the tables in which the values are stored for the program. The system stores the values in these tables:
Withholding Legal Concepts (F76M001) for data imported using the Work with Legal Concepts program.
Withholding Concepts (F76M002) for data imported using the Work with Withholding Concepts program.
Withholding Percentage (F76M003) for data imported using the Work With Withholding Percentages program.
To import data, first prepare a spreadsheet with the values that you want to import. Then, after completing the header fields on the revision form for the program, you access the import function, complete the range of cells to import, and then import the data.
When you prepare the spreadsheet, consider these factors:
You must populate the F76M001 table with withholding legal concept codes before you can import the associations between the withholding legal concept codes and the withholding concept codes.
When you use the Work with Withholding Concepts program to import the spreadsheet for the F76M002 table, the system validates that the withholding legal concepts that you associate with the withholding concepts exist in the F76M001 table, so you must populate the F76M001 table before importing values for the F76M002 table.
You must populate the F76M002 table with withholding concept codes before you can import the percentages to associate with the codes.
When you use the Work With Withholding Percentages program to import the spreadsheet for the F76M003 table, the system validates that the withholding concept codes for which you import the percentages exist in the F76M002 table, so you must populate the F76M002 table before importing values for the F76M003 table.
Each entry must be unique for the key fields.
Key fields include the Withholding Concept and Legal Concept fields. If the value in your spreadsheet is the same as a value that already exists in a table that you populate when you import the data, the system generates an error message. The system also generates an error message if you attempt to import a value multiple times on the spreadsheet.
The data must be in the correct data type, such as numeric for fields that accept only numeric values.
The date must be in the correct format, such as a date format that is valid in the JD Edwards EnterpriseOne system.
Data that are validated against a UDC or other table must be a value that exists in the UDC table.
For example, the values for the Gross or Taxable field in the Work With Withholding Percentages program are validated against the 76M/AT UDC table. The value that you enter in the spreadsheet must exist in the 76M/AT UDC table.
A value must exist in the spreadsheet cells for required fields.
For example, the Effective Date and Expiration Date fields in the Work With Withholding Percentages program are required fields. You must import cells from the spreadsheet that include valid values for those fields to prevent the system from issuing an error message.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Import Assistant | NA | Withholding Setup (G76M0401), Work With Legal Concepts
Click Add on the Work With Legal Concepts form. On the Legal Concepts Revision form, select Import Grid Data from the Tools menu. Withholding Setup (G76M0401), Work With Withholding Concepts Click Add on the Work With Withholding Concepts form. On the Withholding Concepts Revision form, select Import Grid Data from the Tools menu. Withholding Setup (G76M0401), Work With Withholding Percentages Click Add on the Work with Withholding Percentage form. On the Withholding Percentage Revision form, select Import Grid Data from the Tools menu. |
Specify the cells of the spreadsheet to import. |
Access one of these forms:
Legal Concepts Revision
Withholding Concepts Revision
Withholding Percentage Revision
Complete the header fields:
Withholding Type
Company
You complete the Company field on the Withholding Percentage Revision form only.
Select Import Grid Data from the Tools menu.
In the Define Import File area of the Import Assistant form, select Import From Excel and enter the path to the spreadsheet in the Excel file: field.
In the Define Cell Range area, complete the starting and ending cell fields.
In the Define Import Location in Grid area, select Insert to import data at the beginning of the table, or select Paste to replace the data that exists in the cells that you specified in the Define Import File area.
Click Apply.
The system displays the values that you imported in a grid on the Import Assistant form.
Click Continue.
The system displays the data that you imported on the revision form of the program, and displays error messages for fields for which validations failed.
Correct errors, if any.
Click OK on the revision form to save the data to the table.
This section provides an overview of company information for supplier withholding in Mexico and discusses how to set up constants for supplier withholding.
You use the Generic Constants program (P76M005) to associate document types and AAIs to the withholding types that you use for each company. The system assigns the document type to the withholding lines it generates when it calculates withholding amounts, and uses the base AAI that you specify along with the withholding concept assigned to the pay item to write the amount to the F0411 table. The system determines the GL bank account information of the withholding lines from the GL account of the AAI. The GL offset account of the withholding lines is the same as the document type. You can set up separate trade accounts for the withholding lines.
You can create associations between document types, AAIs, and withholding concepts for as many document types and withholding concepts that you need to use. You can set up one document type and AAI for VAT and one for income withholding. The system considers the following AAI rules for withholding:
If you select a pay item for which no specific AAI exists for the withholding concept, the system uses the specific AAI (base AAI + withholding concept. For example, if the base AAI is $G and the withholding concept is SER, then the specific AAI is $GSER.) that you set up for company 0000.
If there is no specific AAI set up for company 0000, the system uses the base AAI that you set up for the company.
If you do not set up the base AAI for the company, the system uses the information that you set up for company 0000.
|
Important: At a minimum, you must set up the associations between one VAT withholding type and one income withholding concept for company 0000. Failure to set up company 0000 might cause the system to incorrectly calculate VAT and income withholding. |
You access the Generic Constants program from the Regional Info option in the Company Names & Numbers program (P0010). The system saves the values that you enter to the Generic Constants table (F76M005).
After you enter the document type and AAI for a withholding type, the system launches the Company Additional Information program (P76M010). You specify the legal representative to print on the withholding certificate in the Company Additional Information program.
Before you perform the task in this section:
Set up a version of the P76M005 program that matches the version of the Company Names & Numbers program.
For example, if you use a version named MEXICO to set up companies for Mexico, you must set up a version of the P76M005 program named MEXICO.
Set up the document types in UDC 00/DT to use for the withholding lines that the system writes to the F0411 table.
Set up the AAIs to use for the withholding lines that the system writes to the F0411 table.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work with Companies | W0010C | Organization & Account Setup (G09411), Company Names & Numbers | Review and select existing companies. |
| Company Setup | W0010B | Click Add on the Work with Companies form. | Enter standard information for the company. |
| Generic Constants | W76M005A | Click OK on the Company Setup form.
Select a record on the Work with Companies form, and then select Regional Info from the Row menu. Select Regional Info from the Form menu on the Company Setup form. |
Specify the document type and AAI that the system uses to write records for withholding for each withholding type. You must enter values for both income and VAT concepts. |
| Company Additional Information | W76M010A | Click OK on the Generic Constants form. | Enter the address book number of the person who is the legal representative. |
Access the Generic Constants form.
Enter a value from the Withholding Type (76M/WT) UDC table to specify the withholding type. Values are:
I: Income
V: VAT
Enter a value from UDC 00/DT table to specify the document type that the system assigns to the withholding lines that it writes for the withholding type you specified in the Withholding Type field.
Enter the base AAI that the system uses along with the withholding concept to write the withholding lines for the withholding type.
This section provides an overview of address book records for supplier withholding in Mexico, lists the forms used to associate withholding concepts to address book records, and discusses how to set processing options for Address Book Withholding Information (P76M006).
After you enter address book information in the standard program Address Book Revisions (P01012) for a supplier, you can access the Address Book Withholding Information form, which you use to associate the VAT and income withholding concepts to the address book record. The system assigns to the vouchers that you generate for the supplier the VAT and income withholding concepts that you set up. You can modify the withholding concepts that the system assigns to vouchers when you review voucher information before calculating withholding amounts and processing payments. The system uses the percentages associated with the withholding concept in the withholding calculations for the voucher lines.
You can associate only one VAT and one income withholding concept to a supplier record. The system saves the association to the Address Book Withholding Information table (F76M006).
|
Note: The system retrieves withholding information for a voucher only when you set a processing option in the Withholding Additional Information program (P76M411) to specify that withholding applies. |
If you set the processing option in the Address Book Withholding Information program (P76M006) to do so, the system launches the Address Book Withholding Information form when you click OK after entering the standard address book information. You can also use the Regional Info menu options in the Address Book Revisions program to access the Address Book Withholding Information form.
Before you perform the task in this section, set up a version of the Address Book Withholding information program that matches the version of the Address Book Revisions program that you use to set up address book records for Mexico. For example, if you use a version named MEXICO in the Address Book Revisions program, you must set up a version of the Address Book Withholding Information program named MEXICO. If you do not set up a corresponding version, the system calls version ZJDE0001 of the Address Book Withholding information program.
| Form Name | FormID | Navigation | Usage |
|---|---|---|---|
| Work With Addresses | W01012B | Daily Processing (G0110), Address Book Revisions | Review and select existing address book records. |
| Address Book Revision | W01012A | Click Add on the Work With Addresses form. | Enter standard address book information.
You must complete the Tax ID field for all suppliers, and the Add'l Ind Tax ID (additional individual tax ID) field for suppliers who are individuals. The system uses these values when it prints the supplier withholding certificate. |
| Address Book Withholding Information | W76M006A | Click OK on the Address Book Revision form.
Select a record on the Work With Addresses form and then select Regional Info from the Row menu. Select Regional Info from the Form menu on the Address Book Revision form. |
Associate VAT and income withholding concepts to the address book record. |
Processing options enable you to set default processing values for programs and reports.
Enter 1 to cause the system to display the Address Book Withholding Information form after you enter or modify an address book record.