(BRA) Match a received NF-e XML document against a vendor invoice

Applies To: Microsoft Dynamics AX 2012 R3

Follow the steps in this topic to automatically match a vendor’s Cadastro Nacional da Pessoa Jurídica (CNPJ) and Inscrição Estadual (IE) and the total amounts in the received Nota Fiscal electronica (NF-e) XML document against a vendor invoice. If you select the Block NF-e posting if XML does not match check box on the NF-e federal FastTab in the Fiscal establishments form, you can post only the electronic fiscal documents for which the XML document information matches the vendor invoice information.

If there are divergences between the received XML document information and the vendor invoice information for the following values, you can approve the divergences to post the vendor invoice:

• Total fiscal document amount

• Total product amount

• Total freight amount

• Total other charges

• Total Imposto Sobre Circulação de Mercadorias e Serviços (ICMS) base amount

• Total ICMS-ST (ICMS tributary substitution) base amount

• Total ICMS-ST amount

• Total Imposto Sobre Produtos Industrializados (IPI) amount

If you have approved the divergences once and the divergences change, you can cancel the earlier approval and request a new approval.

If there are divergences in the vendor’s CNPJ and IE, these divergences cannot be approved, and the vendor invoice cannot be posted.

Prerequisites

The following table shows the prerequisites that must be in place before you start.

Verify the vendor invoice information and the received NF-e XML information, and then approve divergences

Use this procedure to verify the vendor invoice information and the received NF-e XML information. If there are divergences for the total amounts in the fiscal documents, you can verify the divergences, and then approve or request approval for the divergences.

To perform this task, follow these steps:

1. Click Accounts payable > Common > Purchase orders > All purchase orders.

   –or–

   Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

2. Select an approved purchase order for which the NF-e XML document is received. For more information, see 从采购订单创建供应商发票 and (BRA) Enter vendor invoice lines to a vendor invoice for a purchase order.

3. On the Action Pane, click Invoice > Invoice.

4. In the Document model field, select the fiscal document model.

5. In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.

6. On the Action Pane, click NF-e XML matching details to open the View the NF-e XML and vendor invoice matching details form, and then verify the details of the vendor invoice and the received NF-e XML document.

   备注

   The NF-e XML matching details button is available only if you enter an access key in the Access key field.

   Field	Description
   Approval status	The approval status of the divergences, if any.
   Invoice	The number of the vendor invoice.
   Access key	The access key of the NF-e.
   CNPJ	The CNPJ of the vendor in the vendor invoice and the NF-e XML document.
   IE	The IE of the vendor in the vendor invoice and the NF-e XML document.
   Amount	The amount of the vendor invoice and the NF-e XML document.
   Total products amount	The total amount of the vendor invoice items and the NF-e XML document.
   Freight	The vendor invoice freight charges and the NF-e XML document.
   Insurance	The vendor invoice insurance charges and the NF-e XML document.
   Other charges	The other vendor invoice charges and the NF-e XML document.
   IPI	The vendor invoice IPI tax amount and the NF-e XML document.
   ICMS base amount	The base amount on which the ICMS tax is calculated for the vendor invoice and the NF-e XML document.
   ICMS	The vendor invoice ICMS tax amount and the NF-e XML document.
   ICMS-ST base amount	The base amount on which the ICMS-ST tax is calculated for the vendor invoice and the NF-e XML document.
   ICMS-ST	The vendor invoice ICMS-ST tax amount and the NF-e XML document.

7. To approve divergences, click Approve divergences, and then in the Reason field, enter the reason to approve the divergences. Click OK.

   –or–

   If you have approved the divergences once and the divergences change, click Request new approval to cancel the previous approval and request a new approval. You can then click Approve divergences again to approve the divergences.

You can view the approved divergences in the Approved divergences form.

View the XML document for the received NF-e

Use this procedure to view the XML document for the received NF-e.

You can view the totals for product amounts, discounts, freight amounts, insurance amounts, other charges, ICMS base amounts, ICMS amounts, ICMS-ST base amounts, ICMS-ST, IPI, fiscal document amounts, and the issue date of the NF-e in both the header and line view of the received XML document.

In the line view of the received XML document, you can view information that is related to the NF-e lines, such as the item code, description, quantity, unit, unit price, CFOP code, fiscal classification code, discount, FCI number, ICMS value, IPI value, IPI base amount, IPI amount, ICMS ST, freight charges, insurance changes, other charges, and addition information about the XML.

To perform this task, follow these steps:

1. Click Accounts payable > Common > Purchase orders > All purchase orders.

   –or–

   Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

2. Select an approved purchase order for which the NF-e XML document is received.

3. On the Action Pane, click Invoice > Invoice.

4. In the Document model field, select the fiscal document model.

5. In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.

6. On the Action Pane, click XML document to view the XML document for the received NF-e.

Verify the mapping between the received NF-e XML document and the vendor invoice

Use this procedure to verify the mapping between the received NF-e XML document and the vendor invoice. The mapping is done based on external item descriptions.

To perform this task, follow these steps:

1. Click Accounts payable > Common > Purchase orders > All purchase orders.

   –or–

   Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

2. Select an approved purchase order for which the NF-e XML document is received.

3. On the Action Pane, click Invoice > Invoice.

4. In the Document model field, select the fiscal document model.

5. In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.

6. On the Action Pane, click NF-e XML mapping details to open the View mapping form, and then verify the quantity and price information for the received NF-e XML document and the vendor invoice.

   Field	Description
   Access key	The access key of the NF-e document.
   Purchase order	The purchase order number.
   Name	The name of the vendor.
   Vendor invoice item code	The item number on the vendor invoice line.
   Vendor invoice item code	The number of the vendor invoice line.
   Vendor invoice unit price	The unit price of the item on the vendor invoice line.
   Vendor invoice quantity	The quantity of the item of the vendor invoice line.
   Mapping status	The status of the mapping.
   NF-e XML item code	The item number on the NF-e XML document line.
   NF-e XML line number	The number of the NF-e XML document line.
   NF-e XML unit price	The unit price of the item on the NF-e XML document line.
   NF-e XML quantity	The quantity of the item on the NF-e XML document line.
   Vendor invoice taxation origin	The taxation origin of the vendor invoice line.
   Vendor invoice fiscal classification code	The fiscal classification code of the vendor invoice.
   NF-e XML taxation origin	The taxation origin of the NF-e XML document.
   NF-e XML fiscal classification code	The fiscal classification code of the NF-e XML document.

Update the quantity and unit price from the received NF-e XML document on the vendor invoice

Use this procedure to update the quantity, unit price, and discount in the vendor invoice lines using the information from the received NF-e XML document lines that are mapped.

To perform this task, follow these steps:

1. Click Procurement and sourcing > Common > Purchase orders > All purchase orders.

   –or–

   Click Accounts payable > Common > Purchase orders > All purchase orders.

2. Select an approved purchase order for which the NF-e XML document is received.

3. On the Action Pane, click Invoice > Invoice.

4. In the Document model field, select the fiscal document model.

5. Click Update from NF-e XML, and then click Yes to update the quantities, unit prices, and discounts of the vendor invoice lines using the values from the received NF-e XML lines.

Related tasks

(BRA) About the NF-e process

Technical information for system administrators

If you don't have access to the pages that are used to complete this task, contact your system administrator and provide the information that is shown in the following table.