(CHN) Inventory in/out status (form)

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

Click Inventory management > Inquiries > Inventory in/out status.

Use this form to view the in/out status of inventory items, and generate a detailed Inventory in/out status report for inventory transactions that are generated during a specified period. If a period is not selected, the first date of the current month is used as the starting date, and the current date is used as the ending date. You can view the quantities of individual items that were received or issued through purchase orders, sales orders, production orders, transfer orders, bill of material (BOM) journals, and other inventory transactions.

Task that uses this form

(CHN) Generate the inventory summary reports

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

Tabs

Tab

Description

Parameters

Select filtering criteria to view information about the issue or receipt of an inventory item.

On-hand inventory periodic transactions

View detailed issue and receipt information about an on-hand inventory item based on the filtering criteria selected on the Parameters FastTab.

Buttons

Button

Description

Query

Run a query to retrieve issue and receipt details about a specific inventory item. You must specify filtering criteria for the query on the Parameters FastTab.

Transactions

Open the Inventory transactions form to view all inventory transactions for a selected item number.

Dimensions display

Open the Dimensions display form to select additional item dimensions to display in the Inventory in/out status report. Additional dimensions can include product dimensions, such as item configuration, color, size, serial number, and batch number. You can also include details about the warehouse in which an item is stored, and the item location in the warehouse.

Print

Print the inventory in/out status report.

Fields

Field

Description

Item group

Select an item group to view its inventory status details.

Item number

Select an item number to view its inventory status details.

Start date

Select the starting date of the transaction or reporting period. If you do not enter a starting date, the first day of the current month is used as the starting date.

End date

Select the ending date of the transaction or reporting period. If you do not enter an ending date, the current date is used as the ending date. The ending date must not be earlier than the starting date.

Show zero lines

Select to include items without physical quantity or dimension value in the Inventory in/out status report.

Product name

The inventory item name.

Unit

The inventory unit for the item.

Beginning quantity

The quantity that is available at the starting date of the reporting period.

In purchase

The total quantity that is received through purchase orders.

In production

The total quantity that is received through a production order or a BOM journal.

In transfer

The total quantity that is received through journal transfer.

In physical counting

The total quantity that is received through a physical count.

In others

The total quantity that is received through other inventory receipt transactions.

Out sales

The total quantity that is issued through sales orders.

Out production

The total quantity that is issued through a production order or a BOM journal.

Out transfer

The total quantity that is issued through a transfer journal.

Out physical counting

The output quantity that is generated through a physical count.

Out others

The total quantity that is issued through other inventory issue transactions.

Ending quantity

The quantity that is available on the ending date of the reporting period.

See also

Using inventory journals

Released product details (form)

(CHN) Inventory status (form)

(CHN) Item model groups (modified form)

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