Warehouse balance enquiry (DMR11601)

Quantity situation for item matrix items

To view the quantity situation for item matrix items, enter the item code in its entirety or just the first segment of the item code and click OK. You will access the Warehouse balance enquiry, Item matrix panel where you can view the available, on hand and on order situation per warehouse.

Function keys

Non-conf certs

This function key is only displayed if you are viewing Quantity in QC/Usable on hand/Unusable on hand information. Access the Non-conformity certificate enquiry panel.

Inventory contracts

This function key is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated and an item was entered that is connected to an inventory contract. Access the Inventory contract balance enquiry for this item where you can view the balances for all inventory contract lines, per inventory contract, regardless of the status, available quantity, start and end dates.

Item information

Access the Item information panel.

View controls

This function key is only displayed if the STKOWNER (Stock Ownership) function is activated in the Function control file and is applicable for both the Stock ownership functionality as well as the Contract Managed Inventory functionality (if the DC1 Contract Managed Inventory (CMI) application is activated). Define the default view denoting what kinds of warehouses will be displayed, choosing from the following:

Code	Description
1	All warehouses
2	Only normal/logical warehouses
3	Only normal/physical warehouses

Item: Displays the item code and description identifying the item for which you are viewing warehouse balance information.

Unit: Displays the item’s unit, but can be changed. The type of unit displayed is governed by the default enquiry standard system unit defined for your user profile in the System user profile table (the Dft enq std sys unit field). The value in this field is retrieved in accordance with your user profile’s type of unit in relation to the definitions made for the item on the Item file/System units panel. If this field is changed, then the quantities on the panel are changed accordingly.

Sourcing pol: This field is only displayed if you accessed this program from the Customer service enquiry and the item/customer combination you entered there has a Sourcing policy. However, it is also displayed if a Sourcing policy is defined for the item in the Item file. This field displays the Sourcing policy code connected to your customer. The warehouses that are grouped under this Sourcing policy will be displayed according to the sequence defined in the Sourcing policy table. The warehouses listed beneath the dotted line also have the item in stock, but do not belong to the sourcing policy.

SP: This column is set to YES if a sourcing policy exists for the item/warehouse.

Warehouse: This column displays the warehouse(s) in which the item is stored. Warehouse 999 displays the total balance for all warehouses.

Available

This column 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: This column 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: This column 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.

Reserved: This column displays the total quantity on sales orders components, manually entered reservations and quantity on return notes. 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.

Transit on hand: This column displays the transit 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.

Transit on order: This column displays the total quantity on purchase orders and manually entered orders for transit stock. 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.

Transit reserved: This column displays the total quantity on sales orders components, manually entered reservations and quantity on return notes for transit stock. 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.

Quantity in QC: This column displays the total quantity currently under quality control. 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.

Usable on hand: This column displays the total usable quantity in the non-conforming stock. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as usable. 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.

Unusable on hand: This column displays the total unusable quantity in the non-conforming stock. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as unusable. 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.

Supplied from whs: This column displays the warehouse from which the item is supplied in a DRP environment.

Planning time: This column displays the planning time in days. For normal deliveries (i.e. not BtB) this is the sum of the administration days, lead time and transport time. For BtB (Back to back order) transit deliveries it is the sum of BtB lead time and transport time.

Lead time: This column displays the lead time indicating the number of days it normally takes from Purchase order generation to the goods being sent from the supplier’s premises.

Trpt time: This column displays the transportation time. The transport time is the time from when the item is sent from the supplier to the time when the item is reported to the receiving warehouse. The value is retrieved from the Supplier transport time table or the Internal transport time table.

Adm time: This column displays the administration time in days, which is the time it generally takes to handle a purchase order, from the creation of a purchase suggestion to creating the order. The administration time is retrieved from the DIS control file. No administration time is displayed if you set the Transit field to YES at the bottom of this panel.

Transit planning time: This column displays the planning time in days for transit stock. For normal deliveries (i.e. not BtB) this is the sum of the administration days, lead time and transport time. For BtB (Back to back order) transit deliveries it is the sum of BtB lead time and transport time.

Transit lead time: This column displays the lead time for transit stock indicating the number of days it normally takes from Purchase order generation to the goods being sent from the supplier’s premises.

Transit trpt time: This column displays the transportation time for transit stock. The transport time is the time from when the item is sent from the supplier to the time when the item is reported to the receiving warehouse. The value is retrieved from the Supplier transport time table or the Internal transport time table.

Transit adm time: This column displays the administration time in days for transit stock, which is the time it generally takes to handle a purchase order, from the creation of a purchase suggestion to creating the order. The administration time is retrieved from the DIS control file. No administration time is displayed if you set the Transit field to YES at the bottom of this panel.

Unusable: This column displays the unusable 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.

Unsellable: This column displays the unsellable 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.

Unavailable: This column displays the unavailable 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.

Stock take: This column displays the quantity that is under stock take. 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.

QC location: This column displays the quantity that is in the QC location. 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.

NCC usable: This column displays the usable NCC 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.

NCC unusable: This column displays the unusable NCC 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.

In transfer: This column displays the total quantity of items on Internal Replenishment orders that are in transfer from this warehouse to others and have not yet been received. 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.

Service WIP: This column displays the quantity booked to service work in progress and identifies the number of items booked out of normal stock to an open service order. 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.

Transit service WIP: This column displays the transit quantity booked to service work in progress and identifies the number of items booked out of normal stock to an open service order. 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.

Del not invoiced: This column displays the delivered quantity, that has been dispatched but not yet invoiced, in each of the warehouses in which the item is active. 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.

Transit del not invoiced: This column displays the delivered transit quantity, that has been dispatched but not yet invoiced, in each of the warehouses in which the item is active. 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.

Warehouse characteristic code

This column can only be displayed if the STKOWNER (Stock Ownership) functionality is activated in the Function control file and is applicable for both the Stock ownership functionality as well as the Contract Managed Inventory functionality (if the DC1 Contract Managed Inventory (CMI) application is activated). The warehouse characteristic code, which is used to differentiate your warehouses into physical, normal and logical warehouses, denotes the type of stock the warehouse handles (for internally and/or externally owned stock).

The following warehouse characteristic codes can be displayed:

Code	Description
1	Normal warehouse
2	Trade warehouse (logical)
3	Wholesaler Consignment Stock (WCS) warehouse (logical)
4	Wholesaler Deposit Stock (WDS) warehouse (logical)
5	Supplier Consignment Stock (SCS) warehouse (logical)
6	Customer Deposit Stock (CDS) warehouse (logical)
9	Physical warehouse

Physical warehouse: This column can only be displayed if the STKOWNER (Stock Ownership) functionality is activated in the Function control file and is applicable for both the Stock ownership functionality as well as the Contract Managed Inventory functionality (if the DC1 Contract Managed Inventory (CMI) application is activated). The column displays the physical warehouse to which the logical warehouse is connected.

Held quantity: This column displays the held quantity for the batch controlled item in the warehouse. 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.

Expired quantity: This column is only displayed if the batch controlled item has Date handling defined in the Item file. Displays the sum of the item in the warehouse that has expired and is not available for sale. 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.

Under incubation: This column is only displayed if the batch controlled item has Date handling defined in the Item file. Displays the quantity of the item in the warehouse which is under incubation and expected to mature at a later date. 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.

Whs description: This column displays the description of the warehouse.

Item: Enter the item code, or item alias, for which you want to view warehouse balance information.

Unit

Displays the item’s unit, but can be changed. The type of unit displayed is governed by the default enquiry standard system unit defined for your user profile in the System user profile table (the Dft enq std sys unit field). The value in this field is retrieved in accordance with your user profile’s type of unit in relation to the definitions made for the item on the Item file/System units panel. If this field is changed, then the quantities on the panel are changed accordingly.

Note: If you enter a unit that is equal to the D/E-unit for the item, the quantities will be displayed according to D/E-unit. See About display/entry unit handling for more information.

Only with qty: Set this field to YES if you only want to view those warehouses that hold a quantity. Otherwise all active warehouses for the item will be displayed.

Physical whs: This field is only displayed if the STKOWNER (Stock Ownership) functionality is activated in the Function control file and is applicable for both the Stock ownership functionality as well as the Contract Managed Inventory functionality (if the DC1 Contract Managed Inventory (CMI) application is activated). Enter the physical warehouse identity to view the warehouse balance for the logical warehouse(s) that are connected to this physical warehouse.

Related topics

Quantity situation for item matrix items

Function keys