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 > Inquiries > On-hand.

Use this form to obtain detailed information about items with on-hand inventory. On-hand inventory is divided among inventory dimensions.

On-hand inventory is generated and updated automatically when transactions are made in the inventory, whether they are forecasted, physical, or financial transactions.

Navigating the form

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

Tabs

Tab	Description
Overview tab	View all the items with on-hand inventory.
On-hand	View detailed information about the on-hand status for a particular item, such as its inventory dimensions.

Buttons

Button	Description
Transactions	View the transactions for specific product dimensions.
Net requirements	View a requirement profile for specific product dimensions. A requirement profile shows planned orders, inventory levels, and expected receipts and issues over time.
Intercompany on-hand	View the on-hand inventory for the current item that might be stored in different intercompany sections, such as subsidiaries, other plants, or warehouses.
Quantity adjustment	Open the Counting form to view or make adjustments to the current quantity in the item's inventory unit.
Counting history	View inventory counts of the current item. The journal of inventory counts shows the on-hand quantity counted compared to the inventory levels.
Dimensions display	Define which inventory dimensions to show on the Overview tab. The program automatically retrieves the standard setup from the Inventory and warehouse management parameters form.

Fields

Field	Description
Item number	Identifies the item.
Product name	Description of the item on the selected order line.
Physical inventory	Physical quantity in the inventory.
Physical reserved	Total quantity of the item that was physically reserved for the dimension.
Available physical	View the available quantity (not reserved) from the physical inventory.
Ordered in total	Total amount of ordered items.
Ordered reserved	Total quantity of the item that is reserved on ordered receipts for the dimension. Amounts appear in the field when you total all issue transactions with the status Ordered reserved. Items that are reserved as ordered are not physically available in inventory and therefore cannot be directly picked and delivered from inventory.
Total available	Total available quantity of an item.
Dimension No.	Identification of dimensions for the item.
Identification	Indicates whether the on-hand inventory has no quantity and value and is closed.
Show	Specify if the item should be calculated in the unit of measure that is defined for inventory, purchasing, sales, or another purpose.
Unit	Measurement that specifies the quantity of a unit in the form.
Configuration	Item configuration that specifies an item with specific attributes. Note If you work with purchase and sales orders, you cannot change the item configuration when you have updated order transactions, such as registration, packing slip and invoice update.
Size	Size of the item.
Color	Color of the item.
Warehouse	Enter the warehouse in which you will store your items.
Batch number	Enter the Batch number dimension. If you select Edit lines and Explode lines in the upper section of the Shipment form or the Receive form, you can modify the batch number for the transfer order line.
Location	Location inside a warehouse. If you select Edit lines and Explode lines in the upper section of the Shipment form or the Receive form, you can modify the location number for the transfer order line.
Pallet ID	Unique identification for the pallet (Serial Shipping Container Code).
Serial number	Serial number dimension. If you select Edit lines and Explode lines in the upper section of the Shipment form or Receive form, you can modify the serial number for the transfer order line.
Available for reservation	On-hand inventory that can be reserved. Note If the Reserve ordered items check box is selected in the Inventory and warehouse management parameters form, the quantity in this field includes expected receipts. If the check box is not selected, the quantity does not include expected receipts.
Physical cost amount	Inventory value for the physically updated quantity.
Financial cost amount	Total inventory value of the financial updates for the item that was posted in the General ledger module.
Cost price	Cost price provides an up-to-the-minute average cost price. The price = (Total Financial cost amount / Total Posted quantity). The price represents the value at which one unit of the item is picked from inventory the next time that the invoice is updated. You can also include physically updated quantities and values in the calculation of the average cost price. You can use the Include physical value field in the Item model groups form for this purpose. If you select the Fixed receipt price check box in the Item model groups form, the standard cost price is used.
Posted quantity	Financially entered quantity.
Deducted	All order lines have been delivered to the customer.
Picked	Quantity that has been picking list updated and therefore has the picked status.
Received	Physical quantity received, but not posted.
Registered	Quantity that has been registered by using the item reception.
Arrived	Quantity that has arrived in the item reception.
Ordered	Quantity ordered.
On order	Quantity from the selected order line that has been ordered.
Quotation receipt	Sales quotation with a negative quantity has been sent to the customer for approval. The sales quotation is not yet a credit note.
Quotation issue	Sales quotation has been sent to the customer for approval. The sales quotation is not yet a sales order.

See also

Released product details (form)

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