1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Batch enquiry (DMR18101)

Batch enquiry (DMR18101)

This enquiry allows you to look into the batch situation. By entering different search concepts, a selection of batch lines with corresponding information will be displayed in the listing. Selections can be made by item code, warehouse, batch, and creation date.

Options

Batch/Fifo Select this option to access the Batch/FIFO enquiry where you can view all Batch/FIFO transactions for the selected batch.
Batch history Select this option to access the Batch history enquiry where you can view inventory transactions for the selected batch.
Locations This option is only valid if the warehouse where the batch is stored is activated for DC1 Warehouse Management. Select this option to view locations for the selected batch.
Text Select this option to view a batch’s text.
Non-conform Select this option to view non-conforming stock information for the selected batch.
Batch where used This option is only displayed if DC1 Manufacturing installed and activated. Select this option to display for which orders the batch is used.
Batch explosion This option is only displayed if DC1 Manufacturing is installed and activated. Select this option to display the material and order issues.
Order reservations Select this option to view orders that have reservations on the selected item/batch.

Function keys

Item
This field, in the top part of the panel, displays the selected item and description.

Warehouse
This field, in the top part of the panel, displays the selected warehouse.
Batch
This field, in the top part of the panel, displays the selected batch id.
Creation date
This field, in the top part of the panel, displays the selected date interval.
Whs
Displays the warehouse where the batch is stored.
Batch
Displays the batch id.
Crt date
Displays the date when the batch was received into the warehouse.
On hand
Displays the total quantity on hand for this batch of item in this warehouse.
Reserved
Displays the total quantity on sales orders and manual reservations for this batch of item in this warehouse.
Returns
Displays the total quantity on return orders to suppliers for this batch of item.
Available
Displays the available quantity of the batch, calculated as:

On hand – Reserved – Returns

Note: Returns means return orders to supplier.

Note: If the quantity of the batch is not available, then the following could be the reason:

  • The batch is held, or
  • The Used by date field in the Reception note confirmation is not zero and less than today’s date and the Allow sale after expiration date field on the Item file/Inventory information panel is set to NO,

    or

  • The Incubation date field in the Reception note confirmation is greater than today’s date and the Allow sale before incubation date field on the Item file/Inventory information panel is set to NO.

Item
Mandatory entry. This field can be used for selecting batches. If an existing item code is entered, together with an existing warehouse code and batch, the detailed panel for these selections will be displayed.
Whs
This field can be used for selecting batches. If an existing warehouse code is entered, together with an existing item code and batch, the detailed panel for these selections will be displayed.
Batch
This field can be used for selecting batches. If an existing batch id is entered, together with an existing item code and warehouse, the detailed panel for these selections will be displayed.
Creation date
Enter a from-to date to only view batches created within this date. This field must be completed in combination with the Item code.

Batch enquiry (DMR18103)

This panel displays detailed information for the entries in the Batch file. The Batch file is automatically updated by the system when the batch controlled item is moved in/out of stock.

Click OK to view more information.

Supplier
Displays the supplier number and name, from which the batch was received.
Bin location
This field is only displayed if DC1 Warehouse Management is not activated for the item in this warehouse. Displays the bin location where the item/batch is stored.
Hold
Indicates if the batch is being held from further processing.
Country of origin
Displays the country in which the item/batch was manufactured.
Batch retention days
Displays the number of days this batch information can be kept, after the Last dispatch date of this item, before it can be deleted via the Reorganise batch program.
Creation date
Displays when this batch was received the first time into the warehouse.
Last reception date
Displays the last date a reception occurred for this item in this batch.
Stock take status
Displays the stock take status of this item.

The following codes could be displayed:

Code Description
BLANK Item is not under stock take.
1 Item is under stock take.
(The item is on a stock take list. No pick lists or reception notes can be produced for this item when the stock status is 1. When the Stock take update routine is run, code 1 will change back to blank.)
Last dispatch date
Displays the last date a delivery was made for this item in this batch.
Last stock take date
Displays the last date a stock take was performed for this item.
Manufacturing date
Displays the date this item was manufactured.
Last arrival date
Displays the last date, (Dispatch time + Customer transport time), this item can arrive at the customer.
Incubation date
Displays the date to which the item, in this batch, must be kept in stock before it can be sold.
Batch security days
Displays the minimum number of days allowed during which an item must arrive at the customer before it expires (i.e. defined in the Use by date field in Reception note confirmation).
Use by date
Displays the last date this item is valid before it expires.
Inventory contract
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract ID.
Inv contract line
This field is only displayed if the DC1 Contract Managed Inventory (CMI) application is activated. If the item received belongs to an inventory contract, this field displays the inventory contract line number.
User defined date
If the User def date 1-4 text fields were defined on the Inventory information (DMR00303) panel, these fields will be displayed with those headings. These fields are used for informational purposes only.

Batch enquiry, Stock information (DMR18104)

This panel displays stock information for the entries in the Batch file. The Batch file is automatically updated by the system when the batch controlled item is moved in/out of stock.

Normal stock

Statistical information for normal stock is displayed in the fields below.

In quality control
Displays the total quantity currently under quality control for this batch of item in this warehouse.
On hand
Displays the total quantity on hand for this batch of item in this warehouse.
Reservations
Displays the total quantity on sales orders and manual reservations for this batch of item in this warehouse.
On pick/kitt list
Displays the total quantity printed on pick lists but not yet confirmed, for this batch of item in this warehouse. Note: If DC1 Manufacturing is installed and activated, kitting list quantities are also included.
Disp not invoiced
Displays the total dispatched quantity, not yet invoiced, for this batch of item in this warehouse.
Service WIP
Displays the total quantity, delivered on service orders, but not yet invoiced, in this warehouse.
On IR order
Displays the total quantity delivered, not invoiced, on internal replenishment order for this batch of item in this warehouse.
On return order
Displays the total quantity on return orders to suppliers for this batch of item in this warehouse.

Transit stock

Statistical information for transit stock is displayed in the fields below.

In quality control
Displays the total quantity currently under quality control for this batch of item in this warehouse.
On hand
Displays the total quantity on hand for this batch of item in this warehouse.
Reservations
Displays the total quantity on sales orders and manual reservations for this batch of item in this warehouse.
On pick list
Displays the total quantity printed on pick lists but not yet confirmed, for this batch of item in this warehouse.
Disp not invoiced
Displays the total dispatched quantity, not yet invoiced, for this batch of item in this warehouse.
Service WIP
Displays the total quantity, delivered to service orders, but not yet invoiced, in this warehouse.

Usable non-conforming stock

Statistical information for usable non-conforming stock is displayed in the fields below.

On hand
Displays the total quantity on hand for this batch of item in this warehouse. This quantity has been rejected during the quality control function but is defined as usable.
On return order
Displays the total quantity on return orders to the supplier for this batch of item in this warehouse. This quantity has been rejected during the quality control function and is entered on a return order to the supplier, not yet confirmed as delivered.

Unusable non-conforming stock

Statistical information for unusable non-conforming stock is displayed in the fields below.

On hand
Displays the total quantity on hand for this batch of item in this warehouse. This quantity has been rejected during the quality control function and is defined as unusable.
On return order
Displays the total quantity on return orders to the supplier for this batch of item in this warehouse. This quantity has been rejected during the quality control function and is entered on a return order to the supplier, not yet confirmed as delivered.

Batch enquiry (DMR18105)

This panel displays additional text defined for the Item code/Warehouse/Batch.

Text
Displays the text defined for the batch you are viewing.

Batch enquiry, Non-conformity (DMR18107)

This panel displays non-conforming stock information defined for the Item code/Warehouse/Batch. Item in the non-conforming stock are items that have been entered on a non-conformity certificate in either the Confirm quality control note program or the Work with inventory (Inventory movement) program.

NCC no
Displays the non-conformity certificate number on which the item has been entered.
Stk cat
Displays the stock category code, from the Non-conforming stock category table. The stock category table controls whether the item(s) in the batch are usable or not.
Description
Displays the description of the stock category.
Quantity
Displays the rejected quantity of the item on this certificate, which has been placed in the non-conforming stock.
Usable
Indicates if the item(s) in the batch are usable or not.

Batch enquiry (DMR18109)

This panel is only displayed if DC1 Warehouse Management is installed and activated and there are existing zone/locations for the item.

Supplier
Displays the supplier number and name, from which the item was received, retrieved from the purchase order.
Quantity on hand
Displays the quantity on hand for this batch.
Zone
Displays the zone for the item/batch.
Location
Displays the location in which the item/batch is stored.
Quantity
Displays the quantity on hand for the item/batch in this location.