(BRA) Match a received NF-e XML document against a vendor invoice
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
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.
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 |
|
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:
Click Accounts payable > Common > Purchase orders > All purchase orders.
–or–
Click Procurement and sourcing > Common > Purchase orders > All purchase orders.
Select an approved purchase order for which the NF-e XML document is received. For more information, see Create vendor invoices from purchase orders and (BRA) Enter vendor invoice lines to a vendor invoice for a purchase order.
On the Action Pane, click Invoice > Invoice.
In the Document model field, select the fiscal document model.
In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.
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.
Note
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.
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 Requires 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:
Click Accounts payable > Common > Purchase orders > All purchase orders.
–or–
Click Procurement and sourcing > Common > Purchase orders > All purchase orders.
Select an approved purchase order for which the NF-e XML document is received.
On the Action Pane, click Invoice > Invoice.
In the Document model field, select the fiscal document model.
In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.
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:
Click Accounts payable > Common > Purchase orders > All purchase orders.
–or–
Click Procurement and sourcing > Common > Purchase orders > All purchase orders.
Select an approved purchase order for which the NF-e XML document is received.
On the Action Pane, click Invoice > Invoice.
In the Document model field, select the fiscal document model.
In the Vendor invoice form, in the Access key field, enter the identification code of the access key for the vendor invoice.
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.
Note
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:
Click Procurement and sourcing > Common > Purchase orders > All purchase orders.
–or–
Click Accounts payable > Common > Purchase orders > All purchase orders.
Select an approved purchase order for which the NF-e XML document is received.
On the Action Pane, click Invoice > Invoice.
In the Document model field, select the fiscal document model.
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
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.
Category |
Prerequisite |
---|---|
Security roles and duties |
To perform this task, you must be a member of a security role that includes the following duties:
|
Security roles and privileges |
To perform this task, you must be a member of a security role that includes the following privileges:
|