Charges totals details/Compare charges values (form)

Article
10/09/2018

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

Use the Charges totals details - Invoice: %1 form to view charges for the invoice header, consolidated invoice header, and invoice lines. You can view a summary of the charges values by charges code or view individual charge amounts.

Use the Compare charges values - Invoice: %1 form to compare the charges values for an invoice with its corresponding purchase order lines.

Open the form from the vendor invoice Totals form

When the Charges totals details - Invoice: %1 form is opened from the Totals form, only charges values for charges codes that have a debit or credit type of Customer/Vendor are shown.

Click Accounts payable > Common > Vendor invoices > Pending vendor invoices.
Double-click a vendor invoice.
On the Action Pane, click Totals.
Click the Charges … button.

Open the form from the Invoice matching details form

When the Compare charges values - Invoice: %1 form is opened from the Invoice matching details form, not all charges transactions are displayed. For invoices, the form includes only charges codes for which the Compare purchase order and invoice values check box is selected in the Charges code form, and that have a debit or credit type of Customer/Vendor. For purchase orders, the form includes only charges transactions that are connected to charges on the invoice.

Click Accounts payable > Common > Vendor invoices > Pending vendor invoices.
Select a vendor invoice.
On the Review tab, click Matching details.
Click the Compared charges … button.

Task that uses this form

Account for vendor invoice variance due to charges

Navigating the form

The following tables provide descriptions for the controls in this form.

Tabs

Tab	Description
Invoice totals	View the totals of the calculated values for charges codes on the invoice. This control is available only if the form was opened from the Totals form for a vendor invoice.
Invoice details	View the calculated values for charges codes for each header, consolidated header, and line on the selected invoice. This control is available only if the form was opened from the Totals form for a vendor invoice.
Totals	View the totals and variances of the expected and actual values for charges codes on the invoice and purchase order. This control is available only if the form was opened from the Invoice matching details form.
Details	View the calculated values and variances for charges codes for each header, summary header, and line on the selected invoice. This control is available only if the form was opened from the Invoice matching details form.

Buttons

Button	Description
Allocation	Open the Allocate charges form, where you can distribute charges from the header or consolidated header to the lines on the invoice.
Charges	Open the Charges transactions form, where you can view or change charges amounts for the selected invoice.

Fields

Field	Description
Charges match	Displays a warning icon if there is a matching variance for the charges code. Displays a check mark if the variance percentage is within the acceptable tolerance percentage for the charges code. This control is available only if the form was opened from the Invoice matching details form.
Invoice charges code	The charges code that is associated with the charges transactions. Note The Charges totals details - Invoice: %1 form includes only charges codes that have a debit or credit type of Customer/Vendor. The Compare charges values - Invoice: %1 form includes only invoice-related charges codes for which the Compare purchase order and invoice values check box is selected in the Charges code form, and that have a debit or credit type of Customer/Vendor. For purchase order-related charges codes, the form includes only charges codes that are connected to charges on the invoice.
Description	The description of the charges code.
Actual total calculated value	The total of the calculated values for the charges code on the invoice. This field includes the total charges transactions only if the charges code has a debit or credit type of Customer/Vendor.
Expected total calculated value	The total of the calculated values for the charges code on the purchase order, in the currency of the invoice. The charges code on the purchase order must be connected to a charges code on the invoice. This control is available only if the form was opened from the Invoice matching details form.
Variance amount	The difference between the calculated charges code amounts for the invoice and the purchase order, in the currency of the invoice. This control is available only if the form was opened from the Invoice matching details form.
Variance percentage	The variance between the calculated charges code amounts for the invoice and the purchase order, expressed as a percentage. If the variance exceeds the tolerance percentage for the charges code or for the legal entity, a warning icon is displayed in the Charges match field. If the expected amount is a positive value, the variance percentage is calculated as follows: (Actual amount - Expected amount) / Expected amount * 100. If the expected amount is a negative value, the variance percentage is calculated as follows: (Expected amount - Actual amount) / Expected amount * 100. If the expected amount is zero and the actual amount is a positive value, 999,999,999.99% is displayed. If the expected amount is zero and the actual amount is a negative value, -999,999,999.99% is displayed. A positive percentage indicates that you will pay more than expected. A negative percentage indicates that you will pay less than expected. This control is available only if the form was opened from the Invoice matching details form.
Tolerance percentage	The variance percentage that is allowed for the charges code. If a tolerance percentage is not set up for the charges code, this is the tolerance percentage that is set up for the legal entity. This control is available only if the form was opened from the Invoice matching details form.
Invoice charge level	Indicates what the charge is attached to: Header – Attached to the invoice. Summary – Attached to a consolidated invoice header. (One or more invoices have been consolidated and this is the resulting header.) Line – Attached to an invoice line.
Purchase order	The purchase order for the charges code that the invoice charges transaction is associated with.
Purchase order charges code	The charges code on the purchase order that the invoice is associated with. If the charges code is incorrect or blank, you can click Charges > Connect to associate the invoice with a different charges code on the purchase order. This control is available only if the form was opened from the Invoice matching details form.
Item number	The identifier of the item that is purchased. Note Information is displayed in this field only for charges that are attached to an invoice line.
Actual invoice calculated value	The calculated value for the code for the invoice header, summary header, or invoice line. This field includes charges transactions only if the charges code has a debit or credit type of Customer/Vendor.
Expected invoice calculated value	The calculated value for the charges code for the purchase order header, summary header, or purchase order line, in the currency of the invoice. This control is available only if the form was opened from the Invoice matching details form.
* Currency converted	Displays an asterisk () if the expected calculated value for the invoice was converted from the currency of the charges on the purchase order. If the currency of the purchase order charge and the currency of the invoice differ from the accounting currency, the conversion first converts the value to the accounting currency, using the exchange rate from the invoice. The default exchange rate for the invoice is based on the following dates: The document date for the invoice, if the Use document date for vendor invoices* check box in the Accounts payable parameters form is selected. The posting date for the invoice, if the Use document date for vendor invoices check box in the Accounts payable parameters form is not selected. If the invoice currency differs from the accounting currency, the conversion then converts the value to the invoice currency. This control is available only if the form was opened from the Invoice matching details form.
Variance amount	The difference between the calculated charges code amounts for the invoice header, summary header, or line and the purchase order header, summary header, or line. This control is available only if the form was opened from the Invoice matching details form.