Item file enquiry, Inventory information (DMR17301)

Function keys

Time axis: Indicates if the item should be included and updated in the time axis function. The time axis is a planning instrument which in the Time axis enquiry program displays what is available for sale for an item/warehouse per day or week. It is also used in the Purchase suggestion routine (if DC1 Inventory Control is not installed) to evaluate if it is time to purchase the item.

Batch

Indicates if the item is to be batch handled. If set to YES, then when receiving the item in the purchase reception routines, the batch id to which the item belongs has to be defined. When picking the item for sales orders, the batch id from which the item was picked has to be defined.

Note: If running the ePedigree functionality for Pharma US installations, this field must be set to YES.

Serial no tracking

Indicates if serial number tracking is valid for this item.

Values that could be displayed include:

0	No serial number tracking
1	Mandatory at sales pick confirmation
2	Always mandatory

If set to 2, then when receiving the item in the purchase reception routines, a serial number has to be defined for each unique item received. If set to 1 or 2, then when picking the item for sales orders, the serial number picked has to be defined.

Batch selection rule

Denotes if and how to select batches during picking.

Values that could be displayed include:

0	No batch suggestion.
1	One batch FIFO sequence. Pick the ordered quantity from one batch in First in First Out sequence. (This is the creation date sequence, meaning the date when the batch was received into stock.)
2	Several batches, FIFO sequence. Pick the quantity from as many batches as required to cover the ordered quantity in First In First Out sequence. (This is the creation date sequence, meaning the date when the batch was received into stock.)
3	One batch, expiry sequence. Pick the quantity from one batch in expiry date sequence. (When the batch is date handled, the expiry date must be entered when the batch is received into stock.)
4	Several batches, expiry sequence. Pick the quantity from as many batches as required to cover the ordered quantity in expiry date sequence. (When the batch is date handled, the expiry date must be entered when the batch is received into stock.)

Backlog sales order: Indicates if a backorder is allowed for this item on a sales order line. If set to NO, the system will suggest that a backorder is not created even if the order line is not delivered in full.

Volume value code: The code indicates how important this item is. It can be manually decided after whatever principle preferred or calculated by the system. If calculated, the codes are decided after limits for the issued quantity the previous year multiplied with the average cost price. The valid codes are A, B or C. The volume value code is calculated by using the Segment inventory menu item.

Contrib to ord sum: Indicates if this item should contribute to order summary discounts. This flag is updated to the order/quotation line during line entry and controls if the line contributes to the summary of quantities and amounts in the basket qualification and the order summary discount calculation. This flag at the same time controls if the line benefits from any order line summary discounts (O-type) and header discounts (H-type). All lines that do not contribute to the order summary will NEVER benefit from it, in other words no order line summary discounts will be applied and no header discount will be apportioned over these lines. This flag is displayed on the line and can also be maintained.

Dispatch repricing: Indicates if sales order lines for this item should be repriced during Pick list confirmation (i.e. at dispatch). Note: If set to YES, only a reprice will take place for the line. This does NOT include a new run of the order summary discount calculation for the whole order. Sales order lines which have been manually priced during sales order entry will not automatically become repriced during pick list confirmation.

Cash discount base: Indicates if the value of this item on an invoice (created in DC1 Distribution), should be included in the cash discount base.

Turnover amount: Indicates if the value of this item on an invoice (created in DC1 Distribution), should be updated to the turnover amount in the Accounts Receivable in DC1 Financials.

Sales statistics: Indicates if the item should update the Sales statistics file.

Purchase statistics: Indicates if the item should update the Purchase statistics file.

Repair history: This field is only displayed if DC1 Service is installed and activated. Indicates if the item should be updated in the Object file when received on purchase orders and delivered on sales orders.

Handling/Hazard code: Displays a code from the Handling/hazard code table. The purpose of handling/hazard codes is to define any special requirements needed in the handling of items during their storage and transportation.

Display/entry segmnt: This field is only displayed if the D/E-UNIT (Display/Entry unit handling) function is activated in the Function control file. Indicates if the quantities for the display/entry unit (if such is defined) for this item will be displayed using the display/entry delimiter from the DIS control file. See About display/entry unit handling for more information.

Main cost warehouse: If not defined here the mandatory Main cost warehouse flag, defined in the DIS control file, will be used. If the Cost per warehouse field is set to NO in the DIS control file, the main cost warehouse of the item will be used for the landed costs calculation, i.e. if To warehouse in the landed costs definitions is similar to the item main cost warehouse, landed costs are updated for the item. If the Cost per warehouse field is set to YES in the DIS control file, the costs from the main cost warehouse will be retrieved to be used as a base for the sales pricing.

Main supplier: Displays the main supplier of the item, used when Purchase suggestions are created. Note: A supplier can also be defined at warehouse level to override the supplier displayed in this field.

Currency clause

Availability check

Displays the code indicating if a stock availability check should be performed when this item is entered on a sales order. The check is done when the order line is entered. Note: This only applies for items being under time axis control.

Valid codes are:

Code	Description
1	Yes, a check should be performed. Entry will not be allowed if the available quantity (according to the time axis) is lower than the ordered quantity at the given date.
2	Yes, a check should be performed. Allow entry but with an on-line warning.
3	No check, allow all entries.

Note: The value displays in this field will override the value entered in the Av.check order entry field in the Sales order type table. If this field is left blank, the system will use the code defined in the Sales order type table when this item is entered on a sales order.

Avail check BOM: This field is only displayed if DC1 Manufacturing is activated. Indicates if an availability check should be made on the item’s base bill of material (variant 000). The availability check will only be performed for this item if the Availability check field is set to 1 (Not allowed if not available) or 2 (Only warning if not available). Note: This field cannot be used if the Availability check field is set to 3 (No availability check).

Item class

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

Displays one of the following item classes:

Note: The item class can also be defined at warehouse level to override the class entered in this field.

Avail check BOR: This field is only displayed if DC1 Manufacturing is activated. Indicates if an availability check should be made on the item’s base bill of routing (variant 000). The availability check will only be performed for this item if the Availability check field is set to 1 (Not allowed if not available) or 2 (Only warning if not available). Note: This field cannot be used if the Availability check field is set to 3 (No availability check).

Planning method

Planning method defines what function should be used when creating order proposals.

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

Note: The planning method can also be defined at warehouse level to override the method displayed in this field.

Avail check SOP: This field is only displayed if DC1 Manufacturing is installed and activated and if the SOP plan field is set to YES in the MFG control file. Indicates if an availability check should be made on the item’s sales and operation plan. The availability check will only be performed for this item if the Availability check field is set to 1 (Not allowed if not available) or 2 (Only warning if not available). Note: This field cannot be used if the field Availability check field is set to 3 (No availability check).

Margin cost basis

If not defined here the mandatory Margin cost basis flag, defined in the DIS control file, will be used. Indicates what cost should be used to calculate the profit margin, choosing from the following:

1 = Average purchase cost
2 = Standard cost (SC)
3 = Last purchase cost
4 = Purchase price 1
5 = Standard cost sales (SCS)

The gross margin percentage is displayed in Sales order entry and the cost price and value used for the margin calculation is displayed on the sales order line.

Sourcing policy: Displays a code from the Sourcing policy table indicating the sourcing policy for this item.

Auto source: Indicates if the system should search through all warehouses in the sourcing policy to find the requested quantity. This field and the equivalent field in the Sales order type table must be set to YES. Note: If you want to make an exception for an item, meaning you do not want the YES logic (set in the Auto source field in the Sales order type table) to apply to a particular item, set this field to NO in the maintenance program. See Set up auto source handling for more information.

Item file enquiry, Inventory information (DMR17302)

Function keys

Standard landed costs

Access the Landed costs enquiry program. If accessed from this panel, standard landed costs will be displayed for an item in the main warehouse (defined in the DIS control file), although the item may not be activated for that warehouse.

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 in the equivalent maintenance panel:

Automatically update this field for this specific item via the Update cost from purchase price function key in the equivalent maintenance panel. 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:

Std net purch price + Sum of the 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. Note: The standard landed costs used in this calculation is the costs calculated for the main warehouse (defined in the DIS control file).

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, Item type is set to 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 parameter is defined as Standard cost.

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

Std 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 Standard cost field on this panel for a 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 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 not displayed if:

the item is a manufactured 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 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:

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

This field is not mandatory when:

Cost per warehouse is set to YES
AND, Last purchase cost is not updated on item/warehouse level (i.e. in most cases, during the set up of the item

Last purchase cost is not allowed to be blank when:

Cost per warehouse is set to YES and Last cost price is found on the item/warehouse level. In this case the last purchase cost on the item/inventory level is the last Last purchase cost on the item/warehouse level.

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 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 stock. 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 and activated: PCU = actual pre-calculated manufacturing order cost per unit.

New std net pur prc

This field is only displayed if:

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

Displays 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 NO in the DIS control file. Displays the new purchase price plus any standard landed costs. 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 NO in the DIS control file. Displays 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 maintenance program.

For automatic update of standard cost sales for other items, (not item classification items), see the field descriptions for the following fields below: SCS calc basis, SCS calculation type and SCS calc value.

Safety stock type

Note: This field is not displayed if DC1 Inventory Control is installed and activated. This code indicates the type of safety stock the item should have.

Valid codes are:

Code	Description
‘ ‘	No safety stock
1	Safety stock in days
2	Safety stock in quantity

Type 1 is only valid for those items with YES in the Time axis field.

Safety stock: This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Displays the safety stock in days or quantity, depending on what is defined in the Safety stock type field. If safety stock in quantity is used, the safety stock is displayed in stock units. The safety stock is used when purchase suggestions are created. The suggested quantity to purchase may be increased according to the safety stock to guard against fluctuations in demand and/or supply.

OP calculation code

This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Indicates in which way the re-order point is set in the system. If set to YES, the re-order point is calculated by the system via the Calculate re-order point menu item. If set to NO and the Time axis field is also set to NO, the re-order point is manually defined, which is displayed in the Order point field on this panel.

Note: The order point (re-order point) is only calculated by the system if 1 is defined in the Item class field on the Inventory information panel in this file.

Order point: This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Displays the re-order quantity in stock units if the Time axis field in this file is set to NO. The re-order quantity is used when purchase suggestions are created. If the available quantity of the item falls below this quantity, the item will be included on a purchase suggestion the next time purchase suggestions are created.

EOQ calculation code

This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Indicates how the recommended order quantity is set in the system. If set to NO, the order quantity is manually defined, which is displayed in the Order quantity field on this panel. If set to YES, the order quantity is calculated by the system via the Calculate EOQ menu item. When the system has calculated the EOQ, the Order quantity field on this panel is updated with the calculated quantity.

Note: The economical order quantity (EOQ) is only calculated by the system if 1 is defined in the Item class field on the Inventory Information panel in this file.

Order quantity: This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Displays the recommended purchase quantity in stock units. The information is used when purchase suggestions are created. During that routine the suggested quantity to purchase should never be less than the displays entered in this field.

Annual forecast: This field is not displayed if DC1 Inventory Control is installed and activated. A corresponding field in DC1 Inventory Control will override it. Displays the forecast of the total quantity that should be dispatched for sale in a year. This is set manually and is not calculated by the system. The information is used when calculating the EOQ (via the Calculate EOQ menu item) and when calculating the re-order point (via the Calculate re-order point menu item).

SCS calc basis

This field, together with the two fields below, is used for automatic calculation of Standard cost sales for items (not item classification related items). This field displays the defined SCS calculation basis if automatic calculation of Standard cost sales is to be applied. Available SCS calculation bases are:

Permitted values:

Basis	Description
1	Average cost
2	Last purchase cost
3	Standard cost
4	Standard net purchase price

Whenever the selected SCS calculation basis gets a new value, either manually changed or in some automatic process, a new standard cost sales will be calculated. If the Cost per warehouse functionality is activated in the DIS control file, these SCS calculation fields will also be used to update the Standard cost sales on warehouse level.

SCS calculation type

When the standard cost sales will be calculated, it will use the defined basis from the SCS calc basis field, and either a percentage or an amount for the mark-up calculation. Displays the Standard cost sales calculation type to use per item.

Available types:

Type	Description
1	Amount
2	Percentage

SCS calc value: Depending on what was defined in the SCS calculation type field above, this field displays either a percentage value or an amount value.

Variable	Description
ORD	Order number
YMD	Transaction date in format YYMMDD
DMY	Transaction date in format DDMMYY
MDY	Transaction date in format MMDDYY
YWW	Transaction week
WYY	Transaction week in format WWYY
YMM	Transaction date in format YYMM (not century)
MYY	Transaction date in format MMYY (not century)
SER	Batch number created from number series defined in the MFG control file (For manufactured items only)
OLN	Order line number (For purchased items only)
EXP	Batch expiry date
TME	Time in format HHMMSS
RCN	Reception note number (For purchased items only)
RCL	Reception note line number (For purchased items only)

Item file enquiry, Inventory information (DMR17301)

Related topics

Function keys

Item file enquiry, Inventory information (DMR17302)

Function keys

Automatic calculation

Item file enquiry, Inventory information (DMR17303)

Item file enquiry, Inventory information (DMR17304)