Adjustment of on-hand inventory (form)

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 > Closing and adjustment. Select the adjustment entry and then click Adjustment > On-hand.

Use this form to adjust the cost value of complete on-hand inventories. For example, you can adjust the cost value for a quantity in the Posted value field by entering an amount in the Edit now field, or click an Adjustment button option.

Example

You have the following transactions:

  • February 1: Inventory financial receipt for a quantity of 2 at a cost of 10.00

  • February 5: Inventory financial receipt for a quantity of 1 at a cost of 13.00

  • February 19: Inventory financial issue for a quantity of 1 at a running average cost of 11.00

This item was set up with the First In, First Out (FIFO) inventory model, and inventory close was performed as of February 28. The financial issue transaction of 11.00 will be settled to the financial receipt dated February 1 and a 1.00 adjustment will be made.

The following inventory receipts will then contain open inventory quantities:

  • February 1: Quantity of 1 at a cost of 10.00

  • February 5: Quantity of 1 at a cost of 13.00

If the intention was to set the cost of these two items to 15.00, the on-hand adjustment would be used. The on-hand adjustment makes it possible to adjust the open, on-hand quantities as of the last inventory close period. It is important to notice that the posting date of the on-hand adjustment transaction will be the date of the last inventory close.

Note

You must run at least one closing before an item can be adjusted as on-hand inventory. For more information, see Closing and adjustment (form).

Negative on-hand inventory cannot be adjusted.

You can select only one item at a time to adjust the cost value of the on-hand inventory. To make another selection, first click Delete to delete the selected on-hand inventories.

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

Buttons

Button

Description

Select

Select the on-hand inventories to adjust. The selected on-hand inventories are displayed as a journal.

Delete

Remove the selection from the journal.

Adjustment

Automatically assign a value to the Edit now field based on various criteria. When you click Adjustment, all selected on-hand inventories are adjusted according to the method that you select.

The following methods are available:

  • Item cost price – Adjusts the cost price to the item cost price for an individual item. The item cost price is specified in the Price field in the Released product details form.

  • Fixed cost price – Using the Price field, you can specify any cost price. This price is not checked against other prices that have been used for the item.

  • Amount – Enter an amount to adjust by. This amount is allocated among all on-hand inventories according to the selected allocation principle and will be the total of the Edit now column in the on-hand journal. If you select Value as the principle, the amount is allocated proportionally according to the values of the on-hand inventories. If you select Quantity as the principle, the amount is allocated proportionally based on the quantity of the on-hand inventory.

  • Value – Specify a value to adjust to. The value entered will be the total of the new posted value found in the journal of the on-hand transaction. 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 by any percentage. All on-hand inventories are adjusted to the cost price that is assigned to them, plus the given percentage. Select whether the adjustment should be made based on positive on-hand inventory or the on-hand inventory total, where any negative on-hand inventories are calculated in the basis.

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

Update the adjustments. The posting date will be the date of the last inventory close that was selected before you opened the Adjustment of on-hand inventory form.

Print

Print a journal when you have finished changing cost prices. This journal contains the information from the Adjustment of on-hand inventory form.

Fields

Field

Description

Line

The transaction line number. The line is referenced when you adjust the cost value of on-hand inventory.

Item number

The unique identification of the item that is assigned when a new product is created from the All products and product masters list page.

Configuration

Select an item configuration to specify an item with specific attributes.

Size

The size of the item.

Color

The color of the item.

Site

Select the site for the items.

Warehouse

Enter the warehouse in which you will store the items.

Posted quantity

The value of inventory on hand as of the inventory close date that was selected before you opened the Adjustment of on-hand inventory form. This value cannot be edited.

Posted value

The total inventory value of the financial updates for the item that was posted in General ledger. The value is negative if items that have only been physically received in inventory have already been sold or invoice-updated. This field is displayed when you total the posted value amount for all transactions with statuses of Purchased or Sold at the warehouse.

Edit now

Enter the value that the item receipt will be adjusted by.

See also

Closing and adjustment (form)

Adjust transactions (form) (Inventory)

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