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.
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.