Invoice totals matching details (form) [AX 2012]

Updated: March 28, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click Accounts payable > Common > Vendor invoices > Pending vendor invoices. On the Action Pane, on the Vendor invoice tab, click Invoice. On the Action Pane, click the Review tab, and then click Matching details. Click the Invoice amount button.

–or–

Click Accounts payable > Periodic > Maintain vendor invoices. On the Action Pane, click the Review tab, and then click Matching details. Click the Invoice amount button.

–or–

Click Procurement and sourcing > Common > Purchase orders > All purchase orders. Double-click a purchase order. On the Action Pane, click the Invoice tab, and then click Pending invoices. Click Matching details. Click the Invoice amount button.

–or–

Click Accounts payable > Common > Vendors > All vendors. On the Action Pane, click the Invoice tab, and then click Pending vendor invoice. Click Matching details. Click the Invoice amount button.

–or–

Click Accounts payable > Inquiries > History > Invoice history and matching details. Click Matching details. Click the Invoice amount button.

Use this form to view expected invoice totals, actual invoice totals, and variances for invoice totals matching.

The Actual invoice totals column contains amounts from the invoice. The invoice might have been entered in one of the following ways:

  • In an invoice register and updated in an invoice approval journal

  • Based on a purchase order and modified in the Vendor invoice form and the Invoice matching details form

  • Entered in a vendor portal

  • Imported by a service

The Expected invoice totals column contains amounts that are based on currency amounts, charges transactions, and sales tax information from the purchase order, and quantities from the invoice.

The Variance percentage column contains the percentage value of the difference between the actual and expected amounts. If the variance exceeds the tolerance percentage for the vendor or for the legal entity, a warning icon is displayed between the Actual invoice totals and Expected invoice totals columns.

  • If the expected amount is a positive value, the variance percentage is calculated by using the following formula: (Actual amount - Expected amount) / Expected amount * 100.

  • If the expected amount is a negative value, the variance percentage is calculated by using the following formula: (Expected amount - Actual amount) / Expected amount * 100.

  • If the expected amount is zero and the actual amount is a negative value, -999,999,999.99% is displayed.

  • If the expected amount is zero and the actual amount is a positive value, 999,999,999.99% is displayed.

NoteNote

A positive percentage indicates that you will pay more than expected. A negative percentage indicates that you will pay less than expected.

The following table provides descriptions for the controls in this form.

Field

Description

Invoice totals tolerance percentage

The percentage variance that is acceptable. A variance that exceeds this tolerance is considered a matching discrepancy.

This is the invoice totals tolerance percentage that is specified for the vendor. If no tolerance percentage is specified for the vendor, the invoice totals tolerance percentage that is specified in the Accounts payable parameters form is used.

Balance

The transaction balance, in the currency that is associated with the selected invoice.

This is the sum of the net amounts from all lines, as shown in the Invoice matching details form.

Total discount

The total discount amount for the selected invoice.

You can change the total discount amount for the invoice by clicking Totals on the Action Pane in the Vendor invoice form.

The total discount amount for the purchase order includes information from the Price and discount tab in the Purchase order form and from trade agreements that are associated with the purchase order.

Charges

The total charges amount for the selected invoice, in the currency that is associated with the invoice.

The actual charges amount is the total of the calculated values of all charges for the invoice. You can change the charges amounts for the invoice by clicking the buttons in the Charges group on the Action Pane in the Vendor invoice form.

The expected charges amount is the total of the calculated values of the charges for the purchase order that are connected to invoice charges. If Pcs. is selected as the transaction category for line-specific charges, the calculation uses the invoice quantity multiplied by the charges value.

NoteNote

If the charges amounts on the purchase order are in a different currency, the amounts are converted to the accounting currency. For information about the calculation, see Charges totals details/Compare charges values (form).

Sales tax

The sales tax amount for the invoice.

You can change the actual sales tax amount for the invoice by clicking Sales tax on the Action Pane in the Vendor invoice form.

The expected sales tax amount is calculated based on the net amount of the purchase order lines, as calculated in the Invoice matching details form.

Round-off

The round-off amount for the invoice.

Invoice amount

The total invoice amount, in the currency that is associated with the invoice.


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

Community Additions

Show: