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.
Navigating the form
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:
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 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
Adjust transactions (form) (Inventory)
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).