1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Warehouse balance enquiry, Item...

Warehouse balance enquiry, Item matrix, availability (DMR12601)

Related topics

This enquiry displays the following quantity situation for item matrix items in the selected warehouse:

Available Displays the available quantity which is calculated according to the following formula:

Stock on hand
– Sales orders components within planning time
– Held batches
– Expired batches (only if batch controlled item has Date handling)
– Batches under incubation (only if batch controlled item has Date handling)
= Available

Depending on what has been activated/defined in the system, and if the unit you enter for the chosen item is equal to the D/E-unit for the item, the quantities will be displayed according to D/E-unit. This quantity will be displayed with two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.

On hand Displays the physical stock on hand quantity. Depending on what has been activated/defined in the system, and if the unit you enter for the chosen item is equal to the D/E-unit for the item, the quantities will be displayed according to D/E-unit. This quantity will be displayed with two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.
On order Displays the total quantity on purchase orders and manually entered orders. Depending on what has been activated/defined in the system, and if the unit you enter for the chosen item is equal to the D/E-unit for the item, the quantities will be displayed according to D/E-unit. This quantity will be displayed with two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.

Options

Time axis Select this option to access the Time axis enquiry for the selected item.

Function keys

Available Toggle to view the stock availability for the item matrix items in the warehouse.
On hand Toggle to view the on hand situation for the item matrix items in the warehouse.
On order Toggle to view the on order situation for the item matrix items in the warehouse.

Selection fields

Item
Displays the matrix base item code.
Sequence
This column lists the sequence from the item matrix template detail record to which the matrix items are connected. The sequence determines the order in which the template values are displayed on item matrix panels.
Value
This column lists the item matrix template value from the item matrix template detail record to which the matrix items are connected. The template value forms part of the item code.
Description
This column lists the description of the item matrix template value from the item matrix template detail record to which the matrix items are connected.

Warehouse balance enquiry, Select item for time axis enquiry (DMR12604)

From this panel you can drill down to the Time axis enquiry. Select the applicable item.

Options

Select Select this option to access the Time axis enquiry.
Item
Displays the matrix base item.
Warehouse
Displays the warehouse in which the item is stored.
Unit
Displays the unit for the item.

Item
Displays the item matrix item in this warehouse.
Available
Displays the available quantity which is calculated according to the following formula:

Stock on hand
– Sales orders components within planning time
– Held batches
– Expired batches (only if batch controlled item has Date handling)
– Batches under incubation (only if batch controlled item has Date handling)
= Available

Depending on what has been activated/defined in the system, and if the unit you enter for the chosen item is equal to the D/E-unit for the item, the quantities will be displayed according to D/E-unit. This quantity will be displayed with two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.