On-hand inventory (form) [AX 2012]

Updated: January 28, 2014

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.

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

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.

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.

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.

NoteNote

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.

NoteNote

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.


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

Community Additions

Show: