1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Item file maintenance, Warehouses...

Item file maintenance, Warehouses (DMR00701)

Related topics

On this panel you enter information for the item in the warehouse you have chosen. Depending on the template you have chosen, some fields may already be completed. Some may also be protected, i.e. the cursor will bypass them when you work your way through the fields.

This panel can be accessed through different programs and be displayed in different modes:

Default mode

Attribute mode

Enquiry mode

Forward maintenance program

If this panel is accessed from the Forward maintenance program then it will be titled Work with forward maintenance proposals, Warehouses.

Function keys

Bin location 1
Enter the first location where the item is stored. If DC1 Warehouse Management is not installed and activated, this information is printed on pick lists, transport notes and reception notes. The information is also used as selection criteria in the stock take module.
Bin location 2
Enter the second location where the item is stored. If DC1 Warehouse Management is not installed and activated, this information is printed on pick lists, transport notes and reception notes. The information is also used as selection criteria in the stock take module.
Stock zone
Enter 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 and activated. Enter the minimum stock balance to be stored for an item within the warehouse. The information is used when internal replenishment suggestions are created and should only be defined for the sub-warehouses.
Dispatch quantity
This field is only displayed if DC1 Inventory Control is not installed and activated. The quantity entered will be 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

Delivery quantity = 37

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

Proposed quantity: 37 x 36 = 1332

Note: If no delivery 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
This code is automatically defined by the system and indicates the stock take status. Click the following to see what codes are displayed.

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 activated 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 activated 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 is automatically updated by the system, displaying 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 anything you enter 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 anything you enter is for your information only.
Direct delivery
Indicate 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
Enter a code from the Purchase order type table indicating the default purchase order type to be used for the item on BtB orders with direct delivery.
Transit delivery
Indicate 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
Enter a code from the Purchase order type table indicating the default purchase order type to be used for the item on BtB orders with transit delivery.
Order allocation
Mandatory entry. Indicate 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
This field is optional. Enter the manner of transport 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
In the fields below the Whs value column heading you enter warehouse specific information to apply for the item in this warehouse, if it differs from the values displayed below the Item value column heading.

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

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

Supplier
Enter a supplier number at the warehouse level to override the main supplier defined for the item on the Supplier information panel in this file.
Planner
Enter a code from the Signature table at the warehouse level to override the planner defined on the Basic data panel in this file. The planner is used in several programs within DC1 as a selection parameter, for example when purchase suggestions and order proposals (in DC1 Manufacturing) is created.
Responsible
Enter a code from the Signature table identifying the employee responsible for this transaction. This will override the value previously defined on the Basic data panel (in this file).
Item class
Enter an item class at the warehouse level to override the item class defined for the item on the Inventory information panel in this file. This field 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.

Valid codes are:

Planning method
Enter a planning method at the warehouse level to override the planning method defined for the item on the Inventory information panel in this file. The planning method defines what function should be used when creating order proposals. If using the Purchase requisition functionality to create purchase orders, this field must be set to 0 (no suggestions) to be exempt from ranking any other supplier but the main supplier.

Valid codes are:

  • 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, you can override the Qty per pedigree lbl value that was defined on Item/Pharma information level (which is displayed under the Item value).

Enter the number of labels for the warehouse 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 you enter 99, one label will be printed

If you enter more than 0 but less than 99, 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 you enter 0, 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 maintenance, Warehouses (DMR00702)

Related topics

Data used in Sales and Purchase order statistics file is updated on this panel.

Default mode

Attribute mode

Function keys

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 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 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 issues 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 maintenance, Warehouses (DMR00703)

Related topics

On this panel you enter cost price information for the item in the warehouse. Depending on the template you have chosen, some fields may already be completed. Some may also be protected, i.e. the cursor will bypass them when you work your way through the fields.

Default mode

Attribute mode

Function keys

Upd cost from purchase price This function key is only displayed if the following conditions have been met:

  • The CLA-COPR (Classification costing/pricing) function is activated in the Function control file
  • Item has been created/generated via the Item classification functionality
  • The Automatic update of standard purchase price flag has been set to YES in the DIS control file
  • The Cost per warehouse flag has been set to YES in the DIS control file

Update the standard net purchase price/costs from the purchase price for this specific item. The following fields will be updated: Std net purch price, Standard cost and Standard cost sales.

Standard cost
The standard cost of the item. Automatically calculated by the system. If the item has been created/generated via the Item classification functionality you have the following two options for update:

  • Automatically update this field for this specific item via the Update cost from purchase price function key. See the help description for that function key for more information.
  • 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.

The calculation of this cost is done as follows:

Purchased items:
The standard cost is calculated as:

Stand purchase price + Sum of the standard landed costs

The standard purchase price is defined on this panel. Any standard landed costs are calculated using the Refresh landed costs menu item.

Note: The standard landed costs used in this calculation is the costs calculated for the warehouse you are currently working with.

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. The standard landed costs can be displayed by using the applicable option in the Item file enquiry program, Work with warehouses panel.

Manufactured items
(If DC1 Manufacturing is installed and activated, 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.

The value in this field can only be changed for either manufactured or fictitious items with the condition that the Cost type field is defined as Standard cost.

Note: If the Cost type is Standard cost and you change this field when there is stock on hand of the item, the stock value will be re-calculated and bookkeeping transactions will be created.

This field can only be maintained if the Cost type is Standard cost, as defined in DIS control file, and if the item is manufactured within the company, or if the item is fictitious. In addition, you can leave the field blank if no activity is currently ongoing for the item, for example, no stock on hand, no transit stock on hand, etc.

Stand net purch price
This is the current net purchase price without landed costs. 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 description for the Standard cost field on this panel. 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.
  • 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. See the description for that function key for more information.
  • 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.

If the Cost type field is defined as Standard cost, in either the:

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. 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).
Average cost
This field is used to define the average cost of the item. This value will be used to generate statistics and bookkeeping transactions.

If the Cost type field is defined as Average cost, in either the:

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

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

Note: If the Cost type is Average cost and you change this field when there is stock on hand of the item, the stock value will be re-calculated and bookkeeping transactions will be created.

If the Cost type field is Average cost, as defined in either the:

This field is also mandatory if:

  • the Cost per warehouse field (defined in the DIS control file, on the DMR15002 panel) is set to NO.
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.

Enter 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 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. Enter the start date for usage of the standard cost. Note: This field is mandatory when values have been entered in the Calc standard cost or New stand pur price fields.
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 this 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.

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 maintenance, Warehouses (DMR00704)

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 the set up of consolidated picking for containers as well as pick quality control.

Function keys



Item picking code
If you want to separate items into different delivery box containers during container assignment, enter 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
This field is only a mandatory entry if the Item picking code is set to S (Same pick category). Enter 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 you want a pick quality control to apply on item/warehouse level, enter 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. If you want a specific item/warehouse to hold a consolidation sequence, enter the item consolidation sequence from the Work with item consolidation sequence file. 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.