1. Using Analytics and Reports for Financials
  2. How You Capture Electronic Invoice Information for Mexico

How You Capture Electronic Invoice Information for Mexico

The Journals for Mexico report collects information on all transactions that are accounted and posted in different subledgers. The report also captures information related to electronic invoices generated for sales, received from suppliers for purchases, or from manually entered journals.

However you must update the global descriptive flexfields when entering and posting transactions in Oracle Payables, Oracle Receivables, and Oracle General Ledger.

Global descriptive flexfields store the unique identifier and invoice number issued either by the Tax Administration Services (SAT) or by an authorized service provider (PAC).

This table summarizes the flexfields you must update for electronic invoices when you create an invoice or transaction in Payables, Receivables, Expense Reports or manual General Ledger entries.

Global Descriptive Flexfields

Used in

Description

Digital Tax Receipt using Internet Unique ID

  • AP Invoices

  • AP Payments

  • AR Invoices

  • AR Receipts

  • Manual GL Entries

Enter the unique identifier of the Comprobante Fiscal Digital por Internet. CFDI is an electronic billing schema that simplifies the process of issuing and receiving invoices and involves engaging an authorized certification provider.

Digital Tax Receipt Serial Number

  • AP Invoices

  • AR Invoices

Enter the serial number on the Digital Fiscal Document or Fiscal Document with Bidirectional Bar Code (CFD/CBB). CFD/CBB is a paper-based fiscal document that contains an authorized bidirectional bar code. This type of fiscal document is issued to taxpayers whose annual income is less than four million Mexican Pesos.

Digital Tax Receipt Invoice Number

  • AP Invoices

  • AR Invoices

Enter the invoice number on the CFD/CBB.

Foreign Invoice Number

  • AP Invoices

Enter the foreign invoice number, if it exists.

Payment Method

  • AP Payments

Select the payment type from the given list of values

Receipt Number

  • Expense Reports

Enter the unique identifier of CFDI. CFDI is an electronic billing schema that simplifies the process of issuing and receiving invoices and involves engaging an authorized certification provider.

Tax Payer ID

  • Manual GL Entries

Enter the tax payer ID of the transaction corresponding the manually entered journal in GL.

To capture all the Mexican transactions correctly:

  • In Payables, you can:

    • Select Invoices for Mexico from the Regional Information list on the Additional Information tab on the Show More page of the invoice header. Ignore the Routing Attributes 1-5 for now.

    • Select invoice lines for Mexico from the Regional Information list on the Update Additional Information dialog box, which appears after clicking the Details icon on the Payables invoice line.

  • For Payables Payments, select Payments for Mexico from the Regional Information list on the Additional Information tab of the payment header.

  • In Receivables, select Transactions for Mexico from the Regional Information list on the Miscellaneous tab of the transaction header.

  • In Receivables Receipts, select Receipt for Mexico from the Regional Information list on the Additional Information section of the AR Receipt header.

    Note: You must already define a payment method for the receipt method used in the Receivables Receipts. You can define this method using Receipt Classes for Mexico from the Regional Information list on the Receipt Classes and Methods page.

  • For Expense Reports, define the Receipt Number field to identify the UUID code on the Detail page of the expense item definition. The page can be accessed directly by clicking the Create New Expense Item button or from the detail section of an expense report by adding (and defining) a new expense item. Apart from the UUID entered at the Receipt Number field, Merchant Name and Taxpayer ID fields are also mandatory for extracting the information.

    Note: If you provide a valid UUID in the Receipt Number field, the transaction is considered as an expense report with a UUID. Otherwise, it's treated as a foreign invoice reported under NumFactExt. The Valid UUID format is: ad662d33-6934-459c-a188-bdf03930f444.

  • For manual General Ledger transactions, select Journals for Mexico from the Regional Information list on the Journal tab of the Show More page of the journals header.

If an invoice is paid in multiple installments, capture each payment separately. Update the GDFs with the details of your payments.You can access the GDFs from the:

  • Payment Installments dialog box in Payables

  • Review Installments dialog box in Receivables