Revaluation for moving average (form)

  • Article

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

Click Inventory management > Periodic > Revaluation for moving average.

Use this form to adjust the moving average of the selected product.

Note

You can select only products that have inventory on-hand and are in an item model group in which moving average is selected.

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

Buttons

Button

Description

Select

Select which product you want to adjust. You can select a product only one time. If you want to make another selection, you must first delete the selected product.

Delete

Delete the current selection.

Adjustment

Adjust all selected item receipts according to the method that you select, and assign a value to the Edit now field.

  • Item cost price – The cost price is adjusted to the item cost price for the selected product. The item cost price is specified in the Base price field in the Released product details form.

  • Fixed cost price – Enter a fixed cost price that is not checked against the item cost price used for individual products.

  • Amount – Enter the amount by which the product is to be adjusted. This is allocated to all transactions according to the selected allocation principle. If you select Value as the principle, the amount is allocated proportionally according to the value of the transactions. If you select Quantity as the principle, the amount is allocated proportionally according to the transactions' quantity.

  • Value – Specify the value to which you want to adjust. The value is allocated to all transactions according to the selected allocation principle. If you select Value as the principle, the amount is allocated proportionally according to the value of the transactions. If you select Quantity as the principle, the amount is allocated proportionally according to the transactions' quantity.

  • Percent – You can adjust the cost price by any percentage. All transactions are adjusted to the cost price assigned to them plus the entered percentage.

If you use different adjustment methods in the same selection, the value in the Edit now field will always be set according to the latest adjustment.

Post

Open a form where you can update the adjustments and change the cost value indicated in the Posted value field.

Select Total, Item group, or Item number to determine the level of detail that is posted to the general ledger accounts.

In the Note field, you can enter a note that pertains to this adjustment of on-hand inventory.

Print

Print a journal when you have finished changing cost prices. This journal contains the information found in the Adjust transactions form.

Fields

Field

Description

Item number

Displays the unique item number returned from the select criteria. This is a unique user-defined code that is assigned when items are created. We recommend avoiding special characters or spaces in the item number.

Item numbers can be system generated by linking the item number to a number sequence. For more information, see Number sequences (list page).

Site

The site that is assigned to the on-hand quantity of the product.

Posted quantity

The total quantity of on-hand inventory of the product.

Posted value

The total inventory value of the product.

Posted unit cost

The current moving average cost of the posted quantity of the product.

Edit now

Enter the value by which the product receipt is to be adjusted. If you enter a new moving average cost in the Unit cost field, the system calculates the Edit now field.

Unit cost

Enter the new moving average cost for the product. If you enter a new unit cost, the system calculates the Edit now field.

See also

About moving average

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