Item file enquiry, Warehouses (DMR17701)

Related topics

• About unit handling in DC1
• About working with items
• About working with stock count
• Setting up Item Classification pricing
• Setting up the container handling functionality
• Setting up the ePedigree functionality (Pharma US)

This panel displays the warehouse information for the item you have chosen, which has been entered in the corresponding panel in the Item file. Changes to the data can be made in the Work with items program.

Bin location 1

Indicates the first location where the item is stored.

Bin location 2

Indicates the second location where the item is stored.

Stock zone

Indicates the number of the stock zone where the item is stored. This field is used as selection criteria in the stock take module.

Minimum stock

This field is only displayed if DC1 Inventory Control is not installed. Indicates the minimum stock balance to be stored for an item within the warehouse. The information is used when internal replenishment suggestions are created.

Dispatch quantity

This field is only displayed if DC1 Inventory Control is not installed. This quantity is used when internal replenishment suggestions are created and together with the information in the Minimum stock and Stock on hand fields it determines the proposed quantity that should be delivered to the sub-warehouse from the main warehouse.

An example of the calculation is as follows:

Minimum stock 1500
Stock on hand. /. 200
Required stock 1300

Dispatch quantity = 37

Required stock/dispatch quantity = 36 (this figure was rounded up to the nearest tenth).

Proposed quantity: 37 x 36 = 1332

Note: If no dispatch quantity is entered the calculation for the proposed quantity to be delivered to the sub-warehouse from the main warehouse will be the minimum stock minus the stock on hand, (i.e. 1300).

Stock take status

The code in this field is automatically defined by the system and indicates the stock take status. The codes that could be displayed are:

Both DC1 Distribution and DC1 Warehouse Management items:

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

If DC1 Warehouse Management is installed and the Suspend if needed field was set to YES on the Stock take list printout:

Code

Description

9

Item is suspended because there is open activity for the item in this warehouse. This item is not included on the stock take list printout. No more activity can take place for the item in this warehouse until the item has been counted. To get the item back on the stock take list, once open activity has stopped, you have to print the stock take list again (either with the Suspended only field set to YES or NO. When the list is printed the status will be reset to 1 if everything is OK (e.g., no more open activity for the item). To then reset to status Blank, count the item which is on the stock take list (if desired) and update it. Note: The Update stock take transactions routine only resets the status on items that are available on a stock take list, i.e. not with status 9).

If DC1 Radio Frequency is installed and the R/F stock take field was set to YES on the Stock take list printout:

Code	Description
2	The item is under R/F count. Pick lists and reception notes can be printed for the item.

Last stock take date

This field, which is automatically updated by the system, indicates the date of the last stock take.

User defined 0003N

If the field name for this user defined numeric field has been defined in the DIS control file, it will be displayed here. You can use this field for whatever purpose you want, but is for your information only.

User defined ALPHA 3

If the field name for this user defined alpha field has been defined in the DIS control file, it will be displayed here. You can use this field for whatever purpose you want, but is for your information only.

Direct delivery

Indicates if the item is allowed to be included on BtB (Back to Back) orders with direct delivery (item is delivered from the supplier directly to the customer).

Order type direct

Indicates the default purchase order type to be used on BtB orders with direct delivery. This value is defined in the Purchase order type table

Transit delivery

Indicates if the item is allowed to be included on BtB (Back to Back) orders with transit delivery (item is delivered from the supplier to the transit warehouse and then to the customer).

Order type transit

Indicates the default purchase order type to be used for the item on BtB orders with transit delivery. This value is defined in the Purchase order type table.

Order allocation

Indicates if this item is to be handled by the Work with allocation routine. In the event of a shortage in stock the deliveries can be dispatched via this routine according to their priority. By using priority codes, special and individual treatment can also be provided to customers in terms of delivery service.

Sales MOT

Displays the manner of transport, if any is defined, that is used for sales order lines for this item/warehouse. When a sales order line is created, the manner of transport for the line will be decided in the following priority order:

1. Sales MOT from Item/Warehouse.
2. Sourcing policy/warehouse MOT, but if the warehouse on the sourcing policy is defined with “Primary” in the Warehouse level field, it may be overridden from customer delivery address.
3. Sales MOT from customer delivery address.
4. MOT code from the sales order header.

Whs value and Item value

The fields below the Whs value column heading denote the values applicable for the item in this particular warehouse, if defined.

The fields below the Item value column heading denote the values defined for the item, irrespective of in which warehouse the item is stored.

If values are displayed below the Whs value column, those will override the values defined for the item, i.e. values displayed below the Item value column.

Supplier

Indicates the main supplier of the item in this warehouse and on item level.

Responsible

Identifies the employee that is responsible for the item in this warehouse and at the item level. This value is defined in the Signature table.

Item class

Indicates the item class for the item in this warehouse and on item level.

One of the following codes are displayed:

The item class is used to define if the item is kept in stock or if it is purchased/manufactured on demand.

A standard item, in contrast to a configurator product, is an item which is consistent. A standard item can either be a stock item or a non-stock item. Non-stock items are purchased/manufactured on demand.

Note: Configurator products can only be handled if DC1 Manufacturing is installed and activated.

Planning method

Indicates the planning method for the item in this warehouse and on item level. The planning method defines what function should be used when creating order proposals.

Indicates one of the following methods:

• Planning method 0 must be defined for fictitious items.
• Planning method 1 can only be used for items defined as item type 3 or 4 on the Manufacturing information panel in this file.
• Planning methods 2 – 5 are only valid if DC1 Manufacturing is installed and activated.
• Planning methods 6 – 7 are only valid if DC1 Supply Plan is installed and activated. In addition, these methods can only be used for items for which the Supply plan field is set to YES on the Inventory management panel in this file for at least one warehouse.

Handling status

The handing status indicates if specific restrictions apply for the item, e.g., the item is not allowed to be entered on a sales order. This value is defined in the Handling status table.

Qty per pedigree lbl

This field is only displayed if the ePedigree active field is set to YES in the Pharma control file and the ePedigree tracking field is set for the item on the Item file maintenance, Pharma information panel. If the warehouse in which the item will be stored is known, the Qty per pedigree lbl value that was defined on Item/Pharma information level (which is displayed under the Item value) may have been overridden on this level.

Displays the number of labels for the warehouse (under the Whs value) that will be printed when receiving batches that are defined as pedigrees. If the batch quantity is supplied, the number of labels (copies) to print is determined by the batch quantity and what is entered in this field (or in the equivalent field on Item/Pharma information level).

If 99 is displayed, one label will be printed

If more than 0 but less than 99 is displayed, the following formula will be used to calculate the number of labels that will be printed:

Batch quantity/Qty per pedigree lbl, rounded up to the nearest whole number.

If 0 is displayed, the quantity defined in the equivalent field on Item/Pharma information level will be used to determine the number of labels that will be printed.

Example:
Batch quantity received = 8.
The Qty per pedigree lbl value = 2.
The result will be 4 labels (8 / 2 = 4)

Labels, holding the Pedigree ID, batch and item number, are automatically printed during the reception. A re-print of the label can be performed via the ePedigree label enquiry.

Item file enquiry, Warehouses (DMR17702)

Related topics

This panel indicates stock information for the item in the warehouse you have chosen. The information is automatically updated/incremented by the system. There is no corresponding maintenance panel.

Normal stock

Indicates, in the fields below, statistical information for normal stock.

In quality control

Indicates the total quantity currently under quality control for the item in this warehouse.

On hand

Indicates the total quantity on hand for the item in this warehouse.

On purchase order

Indicates the total quantity on purchase order(s) for the item in this warehouse. These figures include items which may have been received, but are under quality control.

Reservations

Indicates the total quantity on sales orders order components and manual reservations for the item in this warehouse.

Disp not invoiced

Indicates the total dispatched quantity, not yet invoiced, for the item in this warehouse.

Service WIP

This field is only displayed if DC1 Service is installed and activated. Indicates the total quantity on service work in progress reports.

On IR order

Indicates the total quantity delivered, not invoiced, on internal replenishment orders for the item in this warehouse.

On return order

Indicates the total quantity on return orders to suppliers for the item in this warehouse.

Transit stock

Indicates, in the fields below, statistical information for transit stock.

In quality control

Indicates the total quantity currently under quality control for the item in this warehouse.

On hand

Indicates the total quantity on hand for the item in this warehouse.

On purchase order

Indicates the total quantity on purchase order(s) for the item in this warehouse. These figures include items which may have been received, but are under quality control.

Reservations

Indicates the total quantity on sales orders and manual reservations for the item in this warehouse.

Disp not invoiced

Indicates the total dispatched quantity, not yet invoiced, for the item in this warehouse.

Service WIP

This field is only displayed if DC1 Service is installed and activated. Indicates the total quantity on service work in progress reports.

Usable non-conforming stock

Indicates, in the fields below, statistical information for usable non-conforming stock.

On hand

Indicates the total quantity on hand for the item in this warehouse. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as usable.

On return order

Indicates the total quantity on return orders to the supplier for the 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

Indicates, in the fields below, statistical information for unusable non-conforming stock.

On hand

Indicates the total quantity on hand for the item in this warehouse. This quantity has been rejected during the quality control function, or has been moved to the non-conforming stock, and is defined as unusable.

On return order

Indicates the total quantity on return orders to the supplier for the 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.

Item file enquiry, Warehouses (DMR17703)

Related topics

This panel indicates data from the Sales and Purchase order statistics files. The information is automatically updated/incremented by the system and corresponds to that found in the Item file.

No of issues YTD

This field, which is automatically updated by the system, indicates the total number of times picking has been done, year to date.

No of issues LY

This field, which is automatically updated by the system, indicates the total number of times picking has been done during last year.

Qty issued YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which has been delivered for sales orders year to date.

Qty issued LY

This field, which is automatically updated by the system, indicates the total quantity of this item which has been delivered for sales orders during the last year.

Last issuing date

This field, which is automatically updated by the system, indicates the last date a sales delivery was made for this item.

No of receipts YTD

This field, which is automatically updated by the system, indicates the number of times a purchase delivery order has been received for this item year to date.

No of receipts LY

This field, which is automatically updated by the system, indicates the number of times a purchase delivery order has been received for this item during last year.

Qty received YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which was received from purchase orders year to date.

Qty received LY

This field, which is automatically updated by the system, indicates the total quantity of this item which was received from purchase orders during last year.

Last reception date

This field, which is automatically updated by the system, indicates the last date a purchase delivery orders was received for this item.

No of returns YTD

This field, which is automatically updated by the system, indicates the number of times this item has been returned to the supplier year to date.

No of returns LY

This field, which is automatically updated by the system, indicates the number of times this item has been returned to the supplier during last year.

Qty returned YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which was returned to the supplier year to date.

Qty returned LY

This field, which is automatically updated by the system, indicates the total quantity of this item which was returned to the supplier during last year.

Qty adjusted YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which has been adjusted year to date.

Qty adjusted LY

This field, which is automatically updated by the system, indicates the total quantity of this item which has been adjusted during the last year.

Qty backlog YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which was put on backorder year to date.

Qty backlog LY

This field, which is automatically updated by the system, indicates the total quantity of this item which was put on backorder during last year.

No of late iss YTD

This field, which is automatically updated by the system, indicates the total number of times late deliveries to the customer occurred for this item, year to date.

No of late iss LY

This field, which is automatically updated by the system, indicates the total number of times late deliveries to the customer occurred for this item during last year.

Qty late issued YTD

This field, which is automatically updated by the system, indicates the total quantity of this item which had a late delivery to the customer year to date.

Qty late issued LY

This field, which is automatically updated by the system, indicates the total quantity of this item which had a late delivery to the customer during last year.

Item file enquiry, Warehouses (DMR17704)

Related topics

This panel indicates cost price information for the item in the warehouse you have chosen, which has been entered on the corresponding panel in the Item file. Changes to the data can be made in the Work with items program.

Function keys

Standard cost

This field is used to define the cost of the item in this particular warehouse, if the cost type defined in DIS control file is Standard cost. The specified cost, whether it is FIFO, Average cost or Standard cost (this field), will be used in the statistics and bookkeeping. The value in this field is automatically calculated by the system if one of the following applies:

Purchased items:
The standard cost is calculated as:

Std net purch price + Standard landed costs

The standard net purchase price is defined on this panel. Any standard landed costs are calculated using the Refresh landed costs menu item. Landed costs are those cost, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods. The standard landed costs can be displayed by using the applicable template on the Work with warehouses panel in this program.

Manufactured items:
(If DC1 Manufacturing is installed, Item type is 1 or 2)

The standard cost is calculated according to the structure of the manufactured item, i.e. the costs of the material and operations in the structure.

Std net purch price

Indicates the current net purchase price, for buying the goods from the supplier, without landed costs and receiving it to this particular warehouse. If supplier discounts are defined for the item they are also reduced, with the exception of limit dependent discounts. This price, together with any standard landed costs, is used to automatically calculate the Standard cost for purchased items. See the Standard cost field on this panel for the description. There are four ways in which this field can be updated:

• Manually enter the standard net purchase price, i.e. after deduction of supplier discounts, in the equivalent maintenance panel.
• Automatically update this field for this specific item via the Item file update program.
• Automatically update this field for this specific item via the Update cost from purchase price function key in the equivalent maintenance panel.
• Automatically update this field via the download functionality in the Item classification definition. The download of costs/prices from the Item classification definition level is done for all items connected to the Standard purchase price grouping structure of the item classification definition.

This field is only displayed if:

• the item is a purchased item (not manufactured within the company) item and the Cost type is standard cost, as defined in DIS control file.
• the item is fictitious

Last purchase cost

The value in this field can either be automatically calculated by the system or manually entered for this particular warehouse in the equivalent maintenance program. The value represents the latest recorded cost for reception of the item into stock from supplier, reported via goods reception or from manufacturing when goods have been manufactured in DC1 Manufacturing. When the cost type is not FIFO for the item (see description of Cost type), the value will be used as the cost in the FIFO transaction creation during all methods of reception of goods (i.e. manual inventory transaction, goods reception from supplier or reception of goods from manufacturing).

The field is mandatory when:

• Cost per warehouse is set to YES
• the Cost type is FIFO and the item is a purchased item. This is in order to guarantee a cost value for positive stock take differences

  OR

• the Margin cost basis is defined as Last purchase cost

Automatic calculation

The cost is calculated according to the following:

Purchased items:

• If the item is a purchased item (not manufactured within the company) the cost is calculated as: Net purchase price + sum of all discrete and distributed landed costs on order line. Landed costs are those costs, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods.

Manufactured items:

• If the item is manufactured within the company, this is the actual pre-calculated manufacturing cost of the item the last time it was manufactured.

The Cost type parameter can be defined at:

• the company level (DIS Control file)
• and at the item level (Item file, Inventory information panel).

Average cost

This field is used to define the cost of the item in this particular warehouse, if the cost type defined in DIS control file is average cost. The specified cost, whether it is FIFO, average cost (this field) or standard cost, will be used in the statistics and bookkeeping. The value in this field is automatically calculated by the system when the item is received to this warehouse. The cost is calculated according to the following:

Purchased items:

((qty in stock + qty on IRO) x avg cost)+(rec’d qty x TLC) ——————————————————————— (qty in stock + qty on IRO + received quantity) where TLC (total landed cost) is calculated as: TLC = Net purchase price + sum of all discrete and distributed landed costs on order line Landed costs are those cost, such as freight, duty, insurance and handling costs, which are over and above the price paid to a supplier for the goods.

Manufactured items:

((qty in stock + qty on IRO) x avg cost)+(rec’d qty x PCU) ——————————————————————— (qty in stock + qty on IRO + received quantity) where PCU means one of the following: If DC1 Manufacturing is installed: PCU = actual pre-calculated manufacturing order cost per unit.

New std net pur prc

This field is only displayed if:

• DC1 Manufacturing is installed and activated.
• The item type is 3 or 4 (purchased).
• The Cost per warehouse field is set to YES in the DIS control file.

Indicates the new standard net purchase price for buying the goods from the supplier. This price together with any standard landed costs is used to update the Calc standard cost field.

Total structure cost

This field is only displayed for a parent item with a structure type defined to have either of the following price calculation codes:

• 1 – Parent price is used. Component prices are zero set.
• 3 – Component prices are summarised and added to parent price.
• 4 – Same as 3 but calculation occurs during invoicing.

Displays the total structure cost for a parent item (including component costs).

Calc standard cost

This field is only displayed if DC1 Manufacturing is installed and activated and the Cost per warehouse field is set to YES in the DIS control file. Indicates a calculated standard cost price. This field is used in combination with the Calc effect date field when you calculate product costing (basic data) with a future date. This field can also be updated from product costing for sub-assemblies and end items when you save a product costing based on a future date.

Calc effect date

This field is only displayed if DC1 Manufacturing is installed and activated and the Cost per warehouse field is set to YES in the DIS control file. Indicates the start date for usage of the standard cost.

Standard cost sales

Standard cost sales is always calculated from the standard cost. This field is used as cost basis for margin calculation and sales pricing. The value is stored in cost unit. If the CLA-COPR (Classification costing/pricing) function is activated in the Function control file this field is automatically updated for item classification items, via the following, using up-marks defined from the Standard purchase price (SPP) group in the item classification definition:

• The Update cost from purchase price function key on the equivalent maintenance panel. The update will be done for this specific item.
• Via the download functionality in the Item classification definition. The download of costs/prices from the Item classification definition level is done for all items connected to the Standard purchase price grouping structure of the item classification definition.

Otherwise the field must be updated manually in the equivalent maintenance panel.

For automatic update of standard cost sales for other items, (not item classification items), the SCS calculation fields on Item/Inventory information level (i.e. SCS calc basis, SCS calculation type and SCS calc value) will be used to update the Standard cost sales field here, if the Cost per warehouse functionality is activated in the DIS control file.

Item file enquiry, Warehouses (DMR17705)

Related topics

This panel is only displayed if the CONTAINR (Container handling) function is activated in the Function control file. The fields on this panel relate to consolidated picking for containers as well as pick quality control.

Item picking code

If products are to be separated into different delivery box containers during container assignment, this field displays the panel value code denoting how the picked item in this warehouse is to be separated into delivery box containers.

Valid codes are:

Code	Description
I	Isolated from all other items (i.e. can only be put in a container together with the same item)
N	No pick restrictions (i.e. can be put in a container together with any other item)
S	Same pick category (i.e. can be put in a container together with items of the same picking category)

Item pick category

If the Item picking code is set to S (Same pick category), this field displays the item picking category.

Pick qual ctl type

A pick quality control (PQC) allows you to flag that the assigned container be checked before it is confirmed, i.e. that the correct quantity has been put in the container. The PQC type can be set on one or all of the following levels. If one of the levels holds a PQC type the container will be flagged for PQC.

• Zone – this applies if you have automated picking in your warehouse, (e.g., conveyor belt or some type of A-frame pick).
• Customer – this applies if the customer always wants to make sure the quantities are controlled.
• Item/Warehouse – this applies if, e.g., you have expensive or dangerous items.

If a pick quality control should apply on item/warehouse level, this field displays the pick quality control type for the item/warehouse.

Item cons sequence

This field is used to reduce the number of containers by consolidation sequence in the event of separate picking. This field displays the item consolidation sequence for the item/warehouse. This information is used to sort the items picked by consolidation sequence. Once the items have been sorted, the container assignment function checks if there is still room in the last container for a specific consolidation sequence. If so, the container assignment function will assign the next picked item to the last container that has a different consolidation sequence. If you enter a value in this field, the items that are to be put into a container can be added to the first or last containers.