Item file enquiry, Inventory management (INVD2351)

Function keys

Display forecast

View the Forecast file.

Purchase type

Displays the purchase type code for this item/warehouse combination.

The three valid purchase type codes are:

Note: For internally supplied items, the purchase type must be 1.

For externally supplied items, two scenarios apply:

For SP items the purchase type can be 1 or 2.
For ROP items, the purchase type can be 1, 2 or 3.

Line code: If the Purchase type field is set to 2, then a line code is displayed in this field. An entry with the same line code for this product’s supplier must exist in Work with periodic purchase and order targets. If you leave the line code blank, then an entry with a blank line code for this product’s supplier must exist in Work with periodic purchase and order targets.

Volume value code: This code is updated when inventory segmentation is executed. It represents the volume value class to which this item/warehouse combination belongs.

Movability code: This code is updated when inventory segmentation is executed. It represents the movability class to which this item/warehouse combination belongs.

Trend code: Indicates if you want to use the results from a Trend analysis to forecast demand for the item/warehouse combination.

Season profile: Displays a season profile from Work with season profiles if you want to adjust forecast for seasonal changes.

Adjust workdays: Indicates if you want to adjust the forecast depending upon the number of actual working days instead of the average working days per period established in the IC control file.

Supply profile

This field is only displayed if DC1 Supply Plan is activated. Production (or purchase) can be done in advance to balance the sales forecast and the replenishment requirements allowing you to have an accurate picture of the stock level. To meet the sales order (forecast) you can define a Supply profile, or a Supply adjustment (see that field description below). This field displays the supply profile which is used to calculate the supply plan quantity based on yearly sales forecast.

The forecast adjustment can be done within the Supply plan. When the sales forecast has been retrieved into the Supply plan, the supply quantity is created based on the yearly sales forecast according to the Supply profile set-up defined here for the item.

Supply adjustment

This field is only displayed if DC1 Supply Plan is activated. Production (or purchase) can be done in advance to balance the sales forecast and the replenishment requirements allowing you to have an accurate picture of the stock level. To meet the sales order (forecast) you can define a Supply adjustment (i.e. adjust the sales forecast X periods back in time) or a Supply profile (see that field description above). This field displays the number of periods the supply quantity should be adjusted based on the sales forecast earlier in time.

The forecast adjustment can be done within the Supply plan. When the sales forecast has been retrieved into the Supply plan, the supply quantity will be “moved” X number of periods.

Distribution level

This field is automatically calculated and updated by the system. The distribution level is the classification indicating which level in the physical distribution network the warehouse resides, and from where the warehouse receives its items (i.e., other warehouse or external supplier). You can define as many distribution levels as you wish.

Independent warehouses are set to level 1, warehouses supplied from an independent warehouse are set to level 2, etc. This information is needed to speed up the Supply planning (SP) calculation.

Supplied from whs: Displays the warehouse code indicating the warehouse from which all items stored in this warehouse are normally supplied.

Supply exception pol: Displays a supply exception policy when you want suggestions to this warehouse to look for excess stock in other warehouses before suggesting a supply from an external supplier. Note: A Supply exception policy in this field is only allowed for Distribution level 1 (externally supplied warehouses) and Planning method 1 (Purchase suggestion according to ROP model), 2 (MRP), and 6 (Purchase suggestion, Supply plan).

Planned from whs

This field is used for IRO (Internal replenishment orders). Displays a code indicating if the item should be planned from the demanding or the supplying warehouse.

Valid codes are:

Code	Description
1	Demanding warehouse (Replenishment via Purchase suggestions and Purchase orders)
2	Supplying warehouse (Replenishment via Internal replenishment suggestions and Internal replenishment orders)

DRP SST percentage

Only shown when DC1 Supply plan is installed and activated. Indicates the percentage to determine how much safety stock should be stored in the supplying warehouse. Percentage is only allowed if the warehouse is supplied from another warehouse. Example: If 70 is entered, then 70% of the safety stock will be stored at the supplying warehouse and 30% at the demanding warehouse (i.e. current warehouse).

DRP is a planning method handled within DC1 Supply plan for analysing expected/actual demand and available stock level in future periods.

Internal lead time: Displays the internal lead time which represents the lead time at the warehouse when processing internal replenishment orders/suggestions to other supplied warehouses.

Internal pack size: Displays the internal pack size that you want stock units rounded up to a multiple of the value, which is applied on stock units in internal replenishment suggestions when sending something to this warehouse.

Supply qty rounding

Displays the applicable rounding type from Work with supply quantity rounding types if you want to apply the rounding rules for the automatically calculated supply (suggested) quantity for this item to this warehouse in the Create purchase suggestions and Create internal replenishment suggestions routines.

Rounding impact for purchase suggestions if this field is blank
If this field is blank for the item and warehouse combination, the automatically calculated supply (suggested) quantity will be:

Rounded up to the next multiple of pack size if Pack size is defined for the item and supplier combination (on the Item file maintenance, Purchase prices, details panel).
If the Pack size is not defined, then the calculated supply (suggested) quantity will not be rounded.

Rounding impact for Internal replenishment suggestions if this field is blank

If this field is blank for the item and warehouse combination, the automatically calculated supply (suggested) quantity will be:

Rounded up to the next multiple of Internal pack size if the Internal pack size field is defined on the Item file maintenance, Inventory management panel for the item and warehouse combination.
If the Internal pack size is not defined, the automatically calculated supply (suggested) quantity will be rounded up to the next multiple of Pack size if the Pack size is defined for the item and supplier combination (on the Item file maintenance, Purchase prices, details panel).
If the Pack size is not defined, then the automatically calculated supply (suggested) quantity will not be rounded.
See Setting up rounding rules for pack size and/or pallets for more information.

Period calculated: Displays the last period for which the purchase control values were calculated and updated in the system. The purchase control values consist of forecast, economic order quantity (EOQ), reorder point (ROP), and safety stock (SST). The values are calculated through inventory calculations.

On suggestion: Displays the latest date that this item/warehouse combination appeared on the purchase suggestion.

Supply plan: Only shown when DC1 Supply plan is installed and activated. Indicates if the item/warehouse should be included in supply plans.

Demand plan: Only shown when DC1 Demand plan is installed and activated. Indicates if the item/warehouse should be included in demand plans.

SP calculated: Only shown when DC1 Supply plan is installed and activated. Displays a date indicating the last time the supply plan was calculated.

Item file enquiry, Inventory management (INVD2351)

Related topics

Function keys

Item file enquiry, Inventory management (INVD2352)

Item file enquiry, Inventory management (INVD2353)