This chapter contains the following topics:
Section 9.2, "Setting Up Your System to Work With Sales EDI Invoice Number"
Section 9.4, "Forms Used to Enter Invoice Numbers (Release 9.1 Update)"
Section 9.5, "Setting Processing Options for the General Ledger Invoice Number Program (P700911)"
Section 9.7, "Manually Entering Invoice Numbers for Multiple Records"
Section 9.8, "Importing Invoice Number Information from a File"
The invoices that companies issue and receive to document their transactions are identified using a legal number. We can categorize the invoices in three groups:
Electronic Invoice: Companies in Mexico are required to issue a digital version of the invoices generated for their transactions. This electronic invoice is called Comprobante Fiscal Digital por Internet (CFDI or Internet Digital Fiscal Document). The CFDI electronic invoice is a tax receipt that documents and confirms that a business transaction is in accordance with the standards defined by the Mexican Tax legislation. It must be generated, transmitted and protected by electronic means and must comply with certain format and content specifications.
Companies can only submit electronic invoices through a Proveedor Autorizado de Certifiación (PAC or Authorized Certification Provider) which is an authorized third-party service provider appointed by the Mexican tax authorities (SAT) and performs the validation, folio and digital stamp of the electronic documents.
|
Note: JD Edwards EnterpriseOne does not support the electronic invoice generation process as a PAC. You must generate the legal invoice using third-party software. |
The legal number that identifies the electronic invoice is the CFDI universally unique identifier (UUID). The UUID is a 36 characters-long code: It consists of 32 hexadecimal digits in lowercase, as shown in 5 groups separated by hyphens (of 8, 4, 4, 4, and 12 digits).
Other National Invoices
Exceptionally, some companies in Mexico are authorized to issue other types of invoices such as a Comprobante con Código de Barra Bidimensional (CBB or Bi-dimensional Bar Code documents), or Comprobante Fiscal Digital (CFD or digital fiscal documents) instead of CFDI electronic invoices.
The legal number that identifies these documents is a serial number and the document number. For this document type, both the serial and document number are required.
Foreign Invoices
If your company makes transactions with foreign companies, the invoices that document these operations may have a legal invoice number issued by the foreign company.
You can use JD Edwards EnterpriseOne for Mexico Localizations to associate the invoice numbers to the accounting records of your transactions for reporting purposes.
The system provides different programs to associate invoice numbers to your transaction records:
Use the Sales Invoice Number program (P703B11) to associate the legal invoice numbers to the documents that your company generates for a transaction. This program creates the records in the AR Invoice Number table (F703B11).
Use the Purchases Invoice Number program (P704220) to associate the legal invoice numbers to the documents that your company receives from suppliers. This program creates the records in the AP Invoice Number table (F704220).
(Release 9.1 Update) Use the A/R Receipts Invoice Number (P703B102) program to store the invoice numbers for the AR payments. This program creates the records in the AR Payments Invoice Number table (F703B102).
(Release 9.1 Update) Use the A/P Payments Invoice Number (P70413M) program to store the invoice numbers for the AP payments. This program creates the records in the AP Payments Invoice Number table (F70413M).
Use the Sales EDI Invoice Number program (P703B1Z1) to associate the legal invoice numbers to the batch invoices that your company processes through the Batch Invoice Revisions program (P03B11Z1). You can choose to display all the batch invoices or only the batch invoices without a legal number.
This program creates the records in the Sales EDI Invoice Number table (F703B11Z1).
The program lists the records processed with the standard batch invoice programs. If you purge the records in the standard tables using the Batch Invoice Processor program (R03B11Z1A), or the Batch Invoice Purge program (R03B11Z1P), the corresponding records in the localized table are also purged.
Use the General Ledger Invoice Number program (P700911) to associate legal invoice numbers to your general ledger records. You can choose to display all the records in the Account Ledger table (F0911) or only the records without a legal invoice number.
This program creates the records in the GL invoice Number table (F700911).
The Sales, Sales EDI, GL, and Purchases Invoice Number programs (P703B11, P703B1Z1, P700911, and P704220) consist of a search and select form where the system lists the records in the Customer Ledger (F03B11), the Batch Invoices (F03B11Z1), Account Ledger (F0911), or the Accounts Payable Ledger (F0411) tables, respectively. You can list all invoices or filter only the records without an invoice number.
You can also choose to include the processed invoices or not.
JD Edwards EnterpriseOne for Mexico Localizations offers three different methods to enter data using the applications listed:
Manual entry of single records.
Manual entry of multiple records.
Importing data from a file.
To create these associations, the records for the transactions must be previously entered in the system using the usual process.
You must verify that the invoice number you enter is correct. The system does not perform this validation.
Use the Functionality by Country Setup program (P700000) to enable the electronic invoice number functionality for Mexico to work with Sales EDI invoice numbers. The system uses this functionality when you work with electronic invoice numbers for Mexico processed by batch programs.
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Functionalities By Country | W700000A | Enter P700000 in the Fast Path field. | Enable or disable the electronic invoice number functionality to work with Sales EDI invoice numbers in Mexico. |
Access the Functionalities by Country form.
Select the country code MX for Mexico from the Localization Country Code UDC table (00/LC).
The system triggers the country-specific functionality based on the country code using the country server methodology in the base EnterpriseOne product.
Select the value of the functionality that you want to enable from the Functionalities by Country UDC table (70/FC).
To enable the Electronic Invoice Number functionality to work with Sales EDI invoice numbers for Mexico, select the value ELEINVNBR.
Before you complete the tasks in this section:
Verify that the value in the Localization Country Code field in the User Profile Revisions program (P0092) is set to MX (Mexico).
Enter and post the vouchers, invoices, or batch invoices for your transactions.
|
See Also: |
To work with Sales EDI invoice numbers, enable the Electronic Invoice functionality in the Functionalities by Country program.
| Form Name | Form ID | Navigation | Usage |
|---|---|---|---|
| Sales Invoice Number - Work With AR Invoice | W703B11A | Invoice Information (G76M02), Sales Invoice Number. | Review and select the existing records in the Customer Ledger table (F03B11). |
| Sales Invoice Number - Update AR Invoice | W703B11B | On the Work With A/R Invoice Number form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| Sales Invoice Number - Multiple Add Invoice | W703B11C | On the Work With A/R Invoice Number form, select Import Data from the Form menu. | Manually add multiple invoice number records. |
| Invoice Number Inquiry | W703B11D | In the Sales Invoice Number - Work With AR Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
| Purchases Invoice Numbers - Work With AP Invoice | W704220A | Invoice Information (G76M02), Purchases Invoice Number. | Review and select the existing records in the Accounts Payable Ledger table (F0411). |
| Purchases Invoice Number - Update AP Invoice | W704220B | On the Work With AP Invoice form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| Purchases Invoice Numbers - Multiple Add Invoice | W704220C | On the Work With AP Invoice form, select Import Data from the Form menu. | Manually add multiple invoice number records. |
| Invoice Number Inquiry | W704220D | In the Purchases Invoice Numbers - Work With A/P Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
| Sales EDI Invoice Number - Work With AR Z1 Invoice | W703B1Z1A | Invoice Information (G76M02), Sales EDI Invoice Number. | Review and select the existing records in the Batch Invoices table (F03B1Z1). |
| Update AR Z1 Invoice Number | W703B1Z1B | In the Sales EDI Invoice Number - Work With AR Z1 Invoice form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| Invoice Number Inquiry | W703B1Z1C | Sales EDI Invoice Number - Work With AR Z1 Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
| Work With GL Invoice | W700911A | Invoice Information (G76M02), General Ledger Invoice Number. | Review and select the existing records in the Account Ledger table (F0911). |
| Update GL Invoice | W700911B | In the Work With GL Invoice form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| Multiple Add/Update Invoice | W700911C | In the Work With GL Invoice form, select Import Data from the Form menu. | Manually add multiple invoice number records. |
| Invoice Numbers Inquiry | W700911D | In the Work With GL Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
| Global Update | W700911E | Select multiple records in the Work With GL Invoice form, and then select Global Update from the Form menu. | Enter an Invoice Number and associate it to multiple records previously selected in the Work With GL Invoice form. |
| Import Assistant | NA | Select Import Grid Data from the A/R Multiple Add Invoice form, the A/P Multiple Add Invoice form, or the Multiple Add/Update Invoice form | Specify the file and the records to import. |
| A/R Receipts Invoice Number - Work With A/R Receipts Invoice | W703B102A | Invoice Information (G76M02), AR Payments Invoice | Review and select the existing records in the AR Receipts Invoice Number table (F703B102). |
| A/R Receipts Invoice Number - Update A/R Receipts Invoice | W703B102B | On the Work With A/R Receipts Invoice form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| A/R Receipts Invoice Number - Multiple Add/Update Invoice | W703B102C | On the Work With A/R Receipts Invoice form, select Import Data from the Form menu. | Manually add multiple invoice number records. |
| A/R Receipts Invoice Number - Invoice Numbers Inquiry | W703B102D | On the Work With A/R Receipts Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
| A/P Payments Invoice Number - Work With A/P Payments Invoice | W70413MA | Invoice Information (G76M02), A/P Payments Invoice | Review and select the existing records in the AP Payments Invoice Number table (F70413M). |
| A/P Payments Invoice Number - Update A/P Payments Invoice | W70413MB | On the Work With A/P Payments Invoice form, select a record and click OK. | Add and revise the invoice number for the selected record. |
| A/P Payments Invoice Number - Multiple Add/Update Invoice | W70413MC | On the Work With A/P Payments Invoice form, select Import Data from the Form menu. | Manually add multiple invoice number records. |
| A/P Payments Invoice Number - Invoice Numbers Inquiry | W70413MD | On the Work With A/P Payments Invoice form, select Invoice Number Inq from the Form menu. | Review detailed information about invoices. |
Processing options enable you to specify default processing values.
Select a value from the Ledger Types UDC table (09/LT) to specify the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units), for which the system displays records.
Select a value from the Batch Type UDC table (98/IT) to specify the type of batches of the records that the program lists.
|
Note: The program does not process the Batch Types IB (Invoices), # (Payroll Vouchers), / (tenant vouchers), 2B (Tenant AR Invoices), V (Voucher Entry), B (Revenue - Journal Entries), DB (Draft Receipts), RB (Receipts and Adjustments), K (A/P Checks - Automatic), M (Manual and Void Checks with Match), and W (Manual Checks without Match). Do not select any of these batch types.If you select the batch type G (General Accounting) the system does not process the records with Document Type P1 (A/P Drafts). |
This section discusses how to enter single invoice number records manually.
Access the Update AR Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Access the Update AP Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Access the A/R Receipts Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Access the A/P Payments Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Access the Update AR Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Access the Update GL Invoice form.
Select a value from the Invoice Type UDC table (70/IN) to specify the invoice type.
Enter or modify the serial number for the invoice (if applicable).
Enter or modify the invoice number for the selected transaction record.
Select the Address Book record number that identifies the customer for the transaction record, in case this field is not already populated. This field is required and cannot be left blank.
You can manually enter multiple records at a time or import data from a spreadsheet to enter invoice numbers in multiple records.
Access one of these forms:
Sales Invoice Number - Multiple Add/Update Invoice
Purchases Invoice Number - Multiple Add/Update Invoice
(Release 9.1 Update) A/R Receipts Invoice Number - Multiple Add/Update Invoice
(Release 9.1 Update) A/P Payments Invoice Number - Multiple Add/Update Invoice
GL Invoice Number - Multiple Add/Update Invoice
Enter the records manually or copy and paste grid data from a spreadsheet that mirrors the grid in the form.
Correct errors (if any) and click OK on the revision form to save the data to the table.
For General ledger Invoices, you can use the Global Update functionality to add or update multiple GL records with the same invoice number.
In the Work With GL Invoice form, you can select multiple records that must be associated to the same legal invoice number, and then access the Global Update form from the Form menu.
Enter the invoice information that applies to all the records and click Save. The system updates all the records selected and associates them to the legal invoice number data entered.
This section provides an overview of data import and discusses how to import data from a spreadsheet.
Instead of manually entering invoice number information, you can import data from a spreadsheet to populate the values for these programs:
Sales Invoice Number (P703B11)
Purchases Invoice Number (P704220)
(Release 9.1 Update) A/R Receipts Invoice Number (P703B102)
(Release 9.1 Update) A/P Payments Invoice Number (P70413M)
General Ledger Invoice Number (P700911)
When you import data, the system populates the tables in which the system stores values for the program. The system stores the values in these tables:
AR Invoice Number table (F703B11)
AP Invoice Number table (F704220)
(Release 9.1 Update) AR Receipts Invoice Number table (F703B102)
(Release 9.1 Update) AP Payments Invoice Number table (F70413M)
General Ledger Invoice Number table (F700911)
To import data, first prepare a spreadsheet with the following values:
Enter the number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher, or journal entry.
Enter the code from the Document Type UDC (00/DT) table that identifies the origin and purpose of the transaction.
Use this field to enter the number that identifies the original document for the transaction, such as a voucher, invoice, or journal entry.
Enter the code from the Invoice Type UDC table (70/IN) that specifies the invoice type.
Use this field to enter the serial number for the invoice (if applicable).
Use this field to enter the alphanumeric value of the invoice that documents the transaction.
(Release 9.1 Update) To import data for A/P Payments Invoice, first prepare a spreadsheet with the following values:
Enter a number that the system assigns from the Next Numbers to identify and track payment records.
Use this field to create the Variance Journal Entries for payments, receipts, and journal entries when running the Auto Bank Statement Process (R09616). If the Document Type on the Payment Clear tab is left blank, the default value is PN. If Document Type on the Receipt Clear tab is left blank, the default value is RC. If Document Type on the Journal Entry Reconcile tab is left blank, the default value is JE.
Use the Document Type to create Journal Entries on the Journal Entry Create tab, and the Draft Paid tab. For both of these, the default value is JE, if left blank.
Use this field to identify a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
Use a code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction. Valid values are set up in the Batch Type UDC table (98/IT). You cannot assign new values. All batch types are hard coded.
Enter the code from the Invoice Type UDC table (70/IN) that specifies the invoice type.
Use this field to enter the serial number for the invoice (if applicable).
Use this field to enter the alphanumeric value of the invoice that documents the transaction.
(Release 9.1 Update) To import data for A/R Receipts Invoice, first prepare a spreadsheet with the following values:
Enter a number that the system assigns from the Next Numbers to identify and track payment records.
Use this field to identify a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either assign a batch number or let the system assign it using the Next Numbers program.
Use a code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction. Valid values are set up in the Batch Type UDC table (98/IT). You cannot assign new values. All batch types are hard coded.
Use this field to identify a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions.
Enter the code from the Invoice Type UDC table (70/IN) that specifies the invoice type.
Use this field to enter the serial number for the invoice (if applicable).
Use this field to enter the alphanumeric value of the invoice that documents the transaction.
Then, access the import function, complete the range of cells to import, and then import the information. The data must be in the correct data type, such as numeric for fields that accept only numeric values.
Access one of these forms:
Sales Invoice Number - Multiple Add/Update Invoice.
Purchases Invoice Number - Multiple Add/Update Invoice.
(Release 9.1 Update) A/R Receipts Invoice Number - Multiple Add/Update Invoice
(Release 9.1 Update) A/P Payments Invoice Number - Multiple Add/Update Invoice
GL Invoice Number - Multiple Add/Update Invoice
Select Import Grid Data from the Tools menu.
In the Define Import File area of the Import Assistant form, use one of the following options:
Select Import From Comma Separated Values (CSV) file, and enter the path to the spreadsheet in the Excel file: field.
Import From Clipboard.
In the Define Cell Range area, complete the starting and ending cell fields, or select the option Import All.
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.