(BRA) Match a received NF-e XML document against a vendor invoice [AX 2012]

Updated: June 9, 2014

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.

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

Category

Prerequisite

Version

Microsoft Dynamics AX 2012 R3

Country/region

The primary address for the legal entity must be in the following countries/regions: Brazil

Related setup tasks

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.

    NoteNote

    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.

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.

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.

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.

NoteNote

The discount in the vendor invoice line is for a unit, whereas the discount in the NF-e XML line is the total for a line. The discount for a unit of the item is recalculated when you update the discount rate.

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.

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.

Category

Prerequisite

Security roles and duties

To perform this task, you must be a member of a security role that includes the following duties:

  • Match a vendor invoice to an NF-e XML document

  • View the discrepancies between vendor invoice values and received NF-e XML values

  • Maintain vendor invoices

Security roles and privileges

To perform this task, you must be a member of a security role that includes the following privileges:

  • View the discrepancies between vendor invoice values and the received XML values

  • View approved divergences

  • Request new approval

  • View the mapping between vendor invoice lines and NF-e XML lines


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

社区附加资源

添加
显示: