Item Warehouse Details

Form ID: (IN204500)

Note:
This form is available only if the Multiple Warehouses features is enabled on the Enable/Disable Features (CS100000) form.

By using this form, for each stock item, you can provide default storage settings, cost and price information, and replenishment settings that are specific to the warehouses where the item is stored.

For more details about stock items, see Stock Items: General Information. For more information about warehouses, see Warehouses: General Information.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Selection Area

In this area, you can select a stock item and a particular warehouse and view the details about the stock of the item at this warehouse.

Element Description
Inventory ID The stock item for which you want to specify properties in a warehouse. Select the item from the list.
Warehouse The specific warehouse where the selected stock item is stocked.
Status

The status of the stock item at this warehouse, which affects the update of the standard cost on the Update Standard Costs (IN502000) form. You can select one of the following options:

  • Active: The system updates the standard cost for the item.
  • Inactive: The system does not update the standard cost for the item.
Product Workgroup The product workgroup defined for the stock item at this warehouse.
Product Manager The product manager assigned to this stock item at this warehouse.

General Tab

On this tab, you can define specific settings for the stock item when it is stocked at this warehouse, including the storage settings, the sales and purchase units specific for the item at this warehouse, the inventory account (and subaccount) to be used to post inventory transactions with the item originating in this warehouse, and the physical inventory settings specific for the warehouse.

Table 1. Storage Defaults Section Here you can specify the default issue and receipt locations for the selected stock item at the warehouse.

This section appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form. If the feature is not enabled, the MAIN location is automatically assigned as the default issue and default receiving locations.

Element Description
Default Issue From The default location to issue the stock items from this warehouse.
Default Receipt To The default location to receive the stock items at this warehouse.
Table 2. Physical Inventory SectionThe elements in this section hold the physical inventory settings for the particular stock item at the specific warehouse.

This group of elements appears only if the Advanced Physical Counts feature is enabled on the Enable/Disable Features (CS100000) form.

Element Description
ABC Code Override A check box that indicates (if selected) that the ABC code assigned for the selected stock item can be overridden for this warehouse.
ABC Code The ABC code of the selected item at the selected warehouse.
Fixed ABC Code A check box that indicates (if selected) that the ABC code is fixed for the selected stock item at the warehouse.
Movement Class Override A check box that indicates (if selected) that the movement class assigned for the selected stock item can be overridden for this warehouse.
Movement Class The movement class for the selected stock item at the specific warehouse.
Fixed Movement Class A check box that indicates (if selected) that the movement class is fixed for the chosen stock item at the specific warehouse.
Table 3. Item Defaults
Element Description
Country of Origin The country of origin for the stock item stored in the warehouse. This value is used for informational purposes only.
Table 4. GL Accounts Section Here you can specify the General Ledger accounts to which the inventory transactions related to the specific stock item at the particular warehouse should be posted.
Element Description
Override Inventory Account/Sub.

A check box that indicates (if selected) that the item's preferred inventory account and subaccount have been overridden for the item stocked in this warehouse and that the system uses the account specified in the Inventory Account box and the subaccount specified in the Inventory Sub. box on this form for transactions with the item.

If this check box is cleared, the system uses the inventory account and subaccount generated according to the settings of the item's posting class as specified on the Posting Classes (IN206000) form.

If the Multiple Warehouses or Multiple Warehouse Locations features are disabled on the Enable/Disable Features (CS100000) form, the check box is cleared by default.

Inventory Account

The asset account to be used to post inventory transactions related to this stock item at this warehouse. This account is used if the Override Inventory Account/Sub. check box is selected.

The account selected in this box should be configured as a control account for the inventory subledger. That is, for this account, IN should be selected in the Control Account Module column on the Chart of Accounts (GL202500) form. For more information on control accounts, see Control Accounts: General Information.

Inventory Sub. The subaccount to be used to post inventory transactions related to this stock item at this warehouse. This subaccount is used if the Override Inventory Account/Sub. check box is selected.

Inventory Planning Tab

You use this tab to specify the replenishment settings for the item at this warehouse. You select a replenishment class, and by default, the settings that were specified for the class on the Inventory Planning tab of the Stock Items (IN202500) form are inserted. You can override most of these settings by selecting the Override Replenishment Settings check box.

This tab is shown only if either of the following conditions is met:

  • The Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form and DRP is selected in the Planning Method box (General tab) on the current form.
  • The Distribution Requirements Planning and Inventory Replenishment features are enabled on the Enable/Disable Features (CS100000) form, and DRP or Inventory Replenishment is selected in the Planning Method box (General tab) on the current form.
  • The Material Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.
  • The Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form and Inventory Replenishment is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form.
Table 5. Planning Method Settings Section
Element Description
Planning Method The planning method used for the stock items. One of the following options can be selected:
  • None (default): The option that is always available for selection and indicates that neither inventory replenishment nor inventory planning can be used to plan the stock item.
  • DRP: Inventory planning forms can be used to plan the stock item. The option is available for selection if the Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.
  • MRP: Inventory planning forms can be used to plan the stock item and includes production order planning. The option is available for selection if the Materials Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.
  • Inventory Replenishment: The inventory replenishment functionality can be used to plan the stock item if the Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form.

    Only items that have the Inventory Replenishment planning method will appear on the following forms:

Table 6. Replenishment Settings SectionThis section is shown only if the Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form and Inventory Replenishment is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form for this stock item.
Element Description
Replenishment Class The replenishment class to be used for this item at this warehouse. When you select the replenishment class, the system inserts the settings that were specified for the class on the Inventory Planning tab of the Stock Items (IN202500) form.
Override Replenishment Settings

A check box that you select if you want to override the replenishment settings for this item at this warehouse, which are filled in based on the selected replenishment class.

When the Inventory Replenishment feature is disabled and the Manufacturing feature is enabled on the Enable/Disable Features (CS100000) form, you can select this check box to override the replenishment source specified on the Manufacturing tab of the Stock Items (IN202500) form for the item and to specify the replenishment warehouse.

Seasonality The set of seasonality settings (by its ID) to be used with the replenishment class, which the system uses to adjust the replenishment quantities to low and high seasons. To define the seasonality settings, use the Replenishment Seasonality (IN206600) form.
Replenishment Source The replenishment source to be used for this stock item in this warehouse. By default, it is the replenishment source associated with the item. You can select one of the following options:
  • None: No replenishment is required for the item with this replenishment source.
  • Purchase: For the stock replenishment, the item will be purchased in the quantities calculated based on the replenishment settings for this warehouse.
    Note:
    To set up centralized purchasing for replenishment performed from a special warehouse (that serves as a distribution center), select this warehouse in the Replenishment Warehouse box.
  • Manufacturing: The item for the stock replenishment will be manufactured. The item with this source selected should have the default bill of material specified on the Manufacturing tab.
  • Transfer: The item will be transferred from a source warehouse to replenish its stock in this warehouse.
  • Drop-Shipment: No actual replenishment is performed for the item in this warehouse. The purchased item will not be received at this warehouse; the purchased quantity will be instead sent to the customer.

    This option appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

  • Purchase to Order: No actual replenishment is performed for the item at this warehouse. The item will be purchased only in the quantities required to fulfill customer orders.

    This option is available only if the Sales Order to Purchase Order Link feature is enabled on the Enable/Disable Features (CS100000) form.

Replenishment Method The replenishment method to be used for this stock item for the selected replenishment source in this warehouse. By default, it is the replenishment method associated with the item. The method can be one of the following options:
  • None: No replenishment will be performed for the stock item.
  • Min./Max.: The system will compute the replenishment quantity as the difference between the maximum and minimum quantities with the quantity on supply deducted. The quantity on supply is the quantity of the item on unreleased purchase orders, purchase receipts, and quantities in transit.
  • Fixed Reorder Qty.: The system will initiate replenishment for the item once the minimum stock level is reached and the quantity on replenishment request is equal to the Economical Order Quantity (EOQ) value specified for the chosen vendor.
Replenishment Warehouse The warehouse for replenishment as follows:
  • If Purchase is selected in the Replenishment Source box, this is the warehouse to handle centralized purchasing for replenishment.
    Note:
    If replenishment of the item is to be performed by purchasing directly to the demand warehouse, select no warehouse in this box.
  • If Transfer is selected in the Replenishment Source box, this is the warehouse to be used as the source of replenishment by transfers.
Max. Shelf Life (Days) The maximum number of days that the stock item can be stored.
Override A check box that you select to override the maximum shelf life for this stock item at this warehouse.
Launch Date The date starting the date range when the replenishment settings apply to the stock item as initially defined on the Item Classes (IN201000) form.
Override A check box that you select to override the launch date for this stock item in this warehouse.
Termination Date The date ending the date range during which the replenishment settings apply to the stock item.
Override A check box you select to override the termination date for this stock item at this warehouse.
Service Level (%) The service level assigned to the item, which affects the safety stock.

For details, see Configuration of Replenishment: Demand Forecast Model.

Override A check box you select to override the service level assigned to this stock item at this warehouse.
Table 7. Replenishment Parameters SectionThis section is shown only if the Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form and Inventory Replenishment is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form for this stock item.
Element Description
Safety Stock The quantity of the stock item that is maintained in the warehouse to prevent possible stockouts during the time period between initiation of replenishment and receiving of the requested supply.
Override A check box that you select to override the safety stock for this stock item in this warehouse.
Reorder Point The stock level that, when reached, should prompt the system to replenish the stock of the item at this warehouse. Minimum quantities should be set equal to anticipated demand during the lead time plus a safety stock.
Override A check box you select to override the reorder point for this stock item in this warehouse.
Max. Qty. The maximum stock level for the replenishment. When the quantity of the item falls below the Reorder Point value, the order should be issued to replenish the stock up to the Max. Quantity value.
Override A check box you select to override the maximum quantity for this stock item in this warehouse.
Transfer ERQ The economic reasonable quantity (ERQ) for the item transfer. This value represents the level of inventory that minimizes the total transfer costs.
Override A check box you select to override the transfer ERQ for this stock item in this warehouse.
Table 8. Demand Forecast Result SectionThis section is shown only if the Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form and Inventory Replenishment is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form for this stock item.
Element Description
Daily Demand Forecast The forecasted average daily demand for this item at this warehouse.
Daily Demand Forecast Error (STDEV) The standard deviation calculated for average daily demand for this item in this warehouse.
Lead Time Average The average lead time calculated based on historical data.
Lead Time STDEV The standard deviation calculated for average lead time.
Safety Stock Suggested The safety stock of the item at this warehouse calculated based on the forecast and the specified service level.
Reorder Point Suggested The quantity to be used as the reorder point for stock item that is based on the forecast.
Last Forecast Date The date when the forecast was done last.
Table 9. Inventory Planning Settings SectionThis section is shown only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form and MRP or DRP, respectively, is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form for this stock item.
Element Description
Source The source of replenishment used for items of the class. One of the following options can be selected:
  • None: By default, no replenishment is required for items of the class with this replenishment class.
  • Purchase: By default, the items of the class for the stock replenishment will be purchased in the quantities calculated based on the replenishment settings.
  • Manufacturing: By default, the items for the stock replenishment will be manufactured. Inventory planning process uses the bill of material for these items to determine component requirements.
  • Transfer: By default, the items of the class will be transferred from a source warehouse to replenish their stock in the demand warehouse.

    This option appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

  • Drop-Shipment: No actual replenishment is performed for items of the class. By default, the items will be purchased through drop-shipment purchase orders, and the purchased goods will not be received at your company's warehouse.

    This option appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

  • Purchase to Order: No actual replenishment is performed for items of the class. By default, the items will be purchased only in the quantities required to fulfill customer orders.

    This option appears only if the Sales Order to Purchase Order Link feature is enabled on the Enable/Disable Features (CS100000) form.

  • Kit Assembly: The item is a kit and will be assembled on the Kit Assembly (IN307000) form. The inventory planning process will generate the demand requirements for the stock components of the kit according to the kit specification.

    This options appears only if the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form.

The value in the Source box must match the value of the Source box in the Inventory Planning tab of the Stock Items (IN202500) form.

Override A check box that you select to change the value of the Source box.
Source Warehouse

The warehouse from which the stock item is replenished. The warehouse may be one of the following:

  • If Purchase is selected in the Source column, the warehouse to handle centralized purchasing for replenishment in the destination warehouse.
    Note:
    If replenishment of the item is to be performed by purchasing directly to the destination warehouse, select no warehouse in this column.
  • If Transfer is selected in the Source column, the warehouse to be used as the source of replenishment by transfers.

This column is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. If the Multiple Warehouses feature is enabled, the value in this column must match the value in the Source Warehouse value in the Inventory Planning tab on the Stock Items (IN202500) form.

Override A check box that you select to change the value of the Source Warehouse box.
Safety Stock The safety stock value for the stock item as specified on the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Safety Stock box.
Reorder Point The stock level that, when it has been reached, prompts the system to replenish the stock of the stock item. The minimum quantity of the stock item is specified on the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Reorder Point box.
Min Order Qty The minimum order quantity for the item of the class. The system copies the value from the Min Order Qty box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Min Order Qty box.
Max Order Qty The maximum order quantity for the item of the class. The system copies the value from the Max Order Qty box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Max Order Qty box.
Lot Size The lot size, which the system uses to apportion fixed costs, such as fixed labor costs and fixed overhead costs. The system copies the value from the Lot Size box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Lot Size box.
Manufacturing Lead Time The number of days required for transferring goods from the source warehouse. The system copies the value from the Manufacturing Lead Time box of Inventory Planning tab on the Stock Items (IN202500) form.

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features (CS100000) form.

Override A check box that you select to change the value of the Manufacturing Lead Time box.
Days of Supply

The number of days that the system uses by default for the consolidation of demand documents containing an item of this class during inventory planning. When the number of days is more than zero, the system groups into a single planned order all items with the same ID from all demand documents (such as sales orders) with the requested date within the number of days starting from the current date.

Tip:
Demand documents are documents that generate demand for items and cause items to be issued from one of the company's warehouses. The demand document may be a sales order, a forecast, or a production order for materials included in an item to be produced.

When an item of this class is created on the Stock Items (IN202500) form, the value specified in this box will be inserted in the Days of Supply box on the Manufacturing tab of that form as the default value, but it can be overridden for the item. If you later change the value in this box, the system updates the value in the Days of Supply box on the Stock Items (IN202500) form for each item of the class for which the default value has not been overridden.

Override A check box that you select to change the value of the Days of Supply box.
Table 10. Preferred Parameters Elements Section
Element Description
Override Preferred Vendor A check box that you select to override the preferred vendor for this item at this warehouse.
Preferred Vendor

The vendor from which the item will be purchased for stock replenishment in this warehouse. By default, the preferred vendor specified on the Stock Items (IN202500) form appears here.

The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true:
  • The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted.
  • A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
Preferred Location

The vendor location from which the item will be purchased for stock replenishment in this warehouse.

This box appears only if the Account Locations feature is enabled on the Enable/Disable Features (CS100000) form.

Default Subitem

The subitem whose vendor details will be used for replenishment for all subitems defined for the item. If a default subitem is not selected, the replenishment will be prepared only for subitems listed on the Subitem Replenishment Info tab.

This box is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form.

Important:
The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Vendor Lead Time (Days) The lead time for the selected vendor's location, as defined on the Location Details tab of the Vendor Locations (AP303010) form.
Add. Lead Time (Days) The additional lead time for the selected vendor, which represents the additional time required by the vendor to produce, assemble, and dispatch the items. This value is added to the Vendor Lead Time value to calculate the resulting lead time required to deliver the purchased item from the vendor's location to your company's warehouse.
Min. Order Freq. (Days) The minimum purchase frequency for the item required when purchasing from this vendor.
Min. Order Qty. The minimum order quantity required for the item when purchasing from this vendor.
Max. Order Qty. The maximum order quantity of the item required when purchasing from this vendor.
Lot Size The lot size for the item when purchased from this vendor.
EOQ The economic order quantity (EOQ) when the item is purchased from this vendor. This value represents the level of inventory that minimizes the total inventory holding costs and ordering costs.
Table 11. Production Order Defaults SectionThis section is shown only if the Material Requirements Planning and Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form, and Inventory Replenishment is selected in the Planning Method box (General tab) on the Stock Items (IN202500) form for this stock item.
Element Description
Source The source of replenishment used for items of the class. One of the following options can be selected:
  • None: By default, no replenishment is required for items of the class with this replenishment class.
  • Purchase: By default, the items of the class for the stock replenishment will be purchased in the quantities calculated based on the replenishment settings.
  • Manufacturing: By default, the items for the stock replenishment will be manufactured. Inventory planning process uses the bill of material for these items to determine component requirements.
  • Transfer: By default, the items of the class will be transferred from a source warehouse to replenish their stock in the demand warehouse.

    This option appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

  • Drop-Shipment: No actual replenishment is performed for items of the class. By default, the items will be purchased through drop-shipment purchase orders, and the purchased goods will not be received at your company's warehouse.

    This option appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form.

  • Purchase to Order: No actual replenishment is performed for items of the class. By default, the items will be purchased only in the quantities required to fulfill customer orders.

    This option appears only if the Sales Order to Purchase Order feature is enabled on the Enable/Disable Features (CS100000) form.

This box is displayed if only if the Manufacturing feature is enabled and the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form.

The value in the Source box must match the value of the Replenishment Source box in the Inventory Planning tab of the Item Warehouse Details (IN204500) form.

Override A check box that you select to change the value of the Source box.
Source Warehouse If Purchase is selected in the Source column, the warehouse to handle centralized purchasing for replenishment in the demand warehouse.
Note:
If replenishment of the item is to be performed by purchasing directly to the demand warehouse, select no warehouse in this column.

If Transfer is selected in the Source column, this is the warehouse to be used as the source of replenishment by transfers.

This box is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. If the Multiple Warehouses feature is enabled, the value in this column must match the value in the Replenishment Warehouse value in the Inventory Planning tab on the Item Warehouse Details (AM204500) form.

Min Order Qty The minimum order quantity for the item of the class. The system copies the value from the Min Order Qty box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Min Order Qty box.
Max Order Qty The maximum order quantity for the item of the class. The system copies the value from the Max Order Qty box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Max Order Qty box.
Lot Size The lot size, which the system uses to apportion fixed costs, such as fixed labor costs and fixed overhead costs. The system copies the value from the Lot Size box of the Inventory Planning tab of the Stock Items (IN202500) form.
Override A check box that you select to change the value of the Lot Size box.
Manufacturing Lead Time The number of days required for transferring goods from the source warehouse. The system copies the value from the Manufacturing Lead Time box of Inventory Planning tab on the Stock Items (IN202500) form.

This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features (CS100000) form.

Override A check box that you select to change the value of the Manufacturing Lead Time box.
Days of Supply

The number of days that the system uses by default for the consolidation of demand documents containing an item of this class during inventory planning. When the number of days is more than zero, the system groups into a single planned order all items with the same ID from all demand documents (such as sales orders) with the requested date within the number of days starting from the current date.

Tip:
Demand documents are documents that generate demand for items and cause items to be issued from one of the company's warehouses. The demand document may be a sales order, a forecast, or a production order for materials included in an item to be produced.

When an item of this class is created on the Stock Items (IN202500) form, the value specified in this box will be inserted in the Days of Supply box on the Manufacturing tab of that form as the default value, but it can be overridden for the item. If you later change the value in this box, the system updates the value in the Days of Supply box on the Stock Items (IN202500) form for each item of the class for which the default value has not been overridden.

Subitem Replenishment Info Tab

This tab provides information on replenishment parameters used for subitems of the item at this warehouse.

This tab is available only if the Inventory Replenishment feature is enabled on the Enable/Disable Features (CS100000) form.

Element Description
Override A check box that you select to override the replenishment parameters used for subitems of the item when they are stocked at this warehouse.
Table 12. Table Toolbar

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.

Button Description
Default Settings Displays the default replenishment parameters selected for subitems of this item on the Replenishment tab of the Stock Items (IN202500) form.
Table 13. Table Columns
Column Description
Subitem The subitem of the stock item.
Safety Stock The quantity of the subitem that should be maintained in the warehouse to prevent possible stockouts during the lead time.
Reorder Point The stock level that, when it is reached, should prompt the system to replenish the stock of the subitem at this warehouse. Minimum quantities should be calculated as anticipated demand during the lead time plus a safety stock.
Max. Qty. The maximum stock level for the replenishment. When the quantity of the item falls below the Reorder Point value, the orders should be issued to replenish the stock up to the Max. Quantity value in accordance with the Min./Max. replenishment method.
Safety Stock Suggested The safety stock of the subitem at this warehouse calculated based on the forecast and the specified service level.
Reorder Point Suggested The quantity to be used as the reorder point for subitem that is based on the forecast.
Max. Qty. Suggested The maximum quantity of the subitem according to the forecast.
Daily Demand Forecast The daily demand according to the last forecast.
Daily Demand Forecast Error (MSE) The mean squared error for the daily demand according to the forecast.
Transfer ERQ The economic reasonable quantity (ERQ) for the subitem transfer. This value represents the level of inventory that minimizes the total transfer costs.
Status The status of this subitem of the stock item; it can be one of the following options: Active, No Sales, No Purchases, No Request, and Inactive.

Price/Cost Tab

On this tab, you can view the standard cost and cost statistics for the selected stock item at the specified warehouse. You can also view the price management information for this stock item.

Table 14. Standard Cost SectionBy using these elements, you can view the standard cost information related to the stock item.
Element Description
Override Std. Cost A check box that indicates (if selected) that the standard cost can be overridden. Select this option to manually set the standard cost for the stock item at the warehouse.
Last Cost A read-only box displaying the last cost used for the stock item.
Current Cost A read-only box displaying the current cost of the stock item.
Effective Date A read-only box that displays the date copied from the Pending Cost Date box when the cost of the stock item has been updated. The new cost is used by the system immediately after the cost has been updated and regardless of this date.
Pending Cost The pending cost value for the stock item. This value can be set only if the Std. Cost Override check box is selected.
Pending Cost Date The date of the planned update of an item's standard cost. This value can be set only if the Std. Cost Override check box is selected.
Table 15. Price Management SectionThese settings provide information about the price workgroup and price manager responsible for the item price, as well as about the recommended price and standard costs of the stock item at this warehouse.
Element Description
Price Workgroup The workgroup responsible for the product pricing of the item at this warehouse. Select the group from the list of the groups that were defined on the Company Tree (EP204061) form.
Price Manager The manager responsible for the product pricing of the item at this warehouse. Select a company employee from the list of employees defined on the Employees (EP203000) form. If you have selected a specific workgroup as the Price Workgroup, the list of employees contains only the members of the selected workgroup.
Subject to Commission A check box that indicates (if selected) that commissions should be paid on sale of this stock item at this warehouse.
Override Markup % A check box that indicates (if selected) that for calculating the item's prices specific to this warehouse, the system will use the markup percentage specified in the Markup % box instead of the item's default markup percentage. If this check box is cleared, the Markup % box displays the default markup percentage for the item that is specified on the Price/Cost tab of the Stock Items (IN202500) form.
Markup % The markup percentage to be used for this item stored in this warehouse. The markup is a percentage of cost added to the cost to get the selling price.
Override Price

A check box that indicates (if selected) that the manufacturer's suggested price in the MSRP box on the Price/Cost tab of the current form can be edited.

If the check box is cleared, the MSRP box is unavailable for editing.

MSRP

The retail price suggested for the stock item by its manufacturer.

This price is used for calculating the warehouse-specific price of the item on the Sales Price Worksheets (AR202010) form. By default, it is copied from the MSRP box on the Price/Cost tab of the Stock Items (IN202500) form.

For more details on updating the sales prices of an item, see Mass-Update of Sales Prices: General Information.

Table 16. Cost Statistics SectionHere you can view the cost statistics data for the item at this warehouse.
Element Description
Last Cost The last cost defined for the stock item.
Average Cost A read-only box that shows the average cost value defined for the stock item.
Min. Cost A read-only box that shows the minimum cost value defined for the stock item.
Max. Cost A read-only box that shows the maximum cost value defined for the stock item.

Manufacturing Tab

You use this tab to specify the general settings of planning and production that the system applies to the selected stock item at the specified warehouse. By default, the system inserts the settings specified on the Manufacturing tab of the Stock Items (IN202500) form in this box. You can change the settings of the item that are warehouse-specific.

This tab is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features (CS100000) form.

Table 17. General Section
Element Description
Default BOM ID The default bill of material that the system uses to produce the selected item in the specified warehouse. If you have more than one active bill of material for the item, you can specify one of them as the default. You can also click the Edit button to create a new BOM.
Planning BOM ID The default bill of material that the system uses for inventory planning. If this box is empty, the system uses the bill of material specified in the Default BOM ID box when creating a planning order. You can also click the Edit button to create a new BOM.
Configuration ID

The configuration definition for this stock item in the specified warehouse.

This box is displayed only when the Product Configurator feature is enabled on the Enable/Disable Features (CS100000) form.

Table 18. Subitem Defaults Section

In this section, you can specify default settings for subitems of the selected stock item in the specified warehouse.

This section is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form.

Important:
The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Element Description
Subitem The identifier of the subitem.
Default BOM ID

The default bill of material that the system uses to produce the subitem.

You can specify a different bill of material for each subitem, or if the Allow Empty BOM Item Sub Item ID is selected on the BOM Preferences (AM101000) form, you can use a single bill of material for all subitems. You can also click the Edit button to create a new BOM. The system specifies the default warehouse in the Warehouse tab of the Bill of Material (AM208000) form.

Planning BOM ID The planning bill of material that the system uses in inventory planning for this subitem. If this box is empty, the system uses the bill of material specified in the Default BOM ID box of this section. You can also click the Edit button to create a new BOM. The system specifies the default warehouse in the Warehouse tab of the Bill of Material (AM208000) form.
Table 19. Planning Settings SectionIn this section, you specify manufacturing-related replenishment settings that the system uses for calculating lead times in production. You can view and change the replenishment source and replenishment warehouse on the Replenishment tab even when the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form. The system populates the values of the boxes in this section with the values of the corresponding boxes on the Manufacturing tab of the Stock Items (IN202500) form.
Element Description
Safety Stock

The quantity of the stock item in the specified warehouse that is maintained in the warehouse to prevent possible stockouts during the time period between initiation of replenishment and receiving of the requested supply.

This box is available only when the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form and the Override check box right of this box is selected. When the Inventory Replenishment feature is enabled, you specify the safety stock value on the Replenishment tab.

Override

A check box that you select to change the value of the Safety Stock box.

This check box is displayed only when the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form.

Reorder Point

The stock level that, upon its reach, should prompt the system to replenish the stock of the item at this warehouse. Minimum quantities should be set equal to anticipated demand during the lead time plus a safety stock.

This box is available only when the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form and the Override check box right of this box is selected. When the Inventory Replenishment feature is enabled, you specify the safety stock value on the Replenishment tab.

Override

A check box that you select to change the value of the Reorder Point box.

This check box is displayed only when the Inventory Replenishment feature is disabled on the Enable/Disable Features (CS100000) form.

The values of the following boxes are used by the system only when the value of the Replenishment Source box on the Replenishment tab is Manufacturing.
Min. Order Qty.

The minimum quantity of the item in the specified warehouse used by the system for inventory planning. The system also uses this value in the cost roll process when the lot size is zero.

This box is available only when the Override check box right of it is selected.

Override A check box that you select to change the value of the Min. Order Qty. box.
Max. Order Qty.

The maximum quantity of the item in the specified warehouse used by the system for inventory planning.

This box is available only when the Override check box right of it is selected.

Override A check box that you select to change the value of the Max. Order Qty. box.
Lot Size

The multiple that the system uses in inventory planning for the item in the specified warehouse, as the suggested order quantity for production orders, and in the cost roll process to allocate fixed costs.

This box is available only when the Override check box right of it is selected.

Override A check box that you select to change the value of the Lot Size box.
MFG Lead Time

The fixed manufacturing lead time of this item at the specified warehouse, which the system uses during inventory planning if the Use Fixed Manufacturing Times check box is selected on the Inventory Planning Preferences (AM100000) form. This setting is used for all production orders if the Use Fixed Manufacturing Times check box is selected on the Production Preferences (AM102000) form, and for production orders with the Use Fixed Mfg Lead Times for Order Dates check box selected on the Production Order Maintenance (AM201500) form. For more information, see Inventory Planning Configuration: Lead Times.

This box is available only when the Override check box right of it is selected.

Override A check box that you select to change the value of the MFG Lead Time box.
Transfer Lead Time

The time required to transfer this item between the warehouse specified in the Selection area and the warehouse specified in the Replenishment Warehouse box of the Replenishment tab.

The system copies the default value from the Transfer Lead Time column of the Manufacturing tab on the Warehouses (IN204000) form if the value of the Replenishment Source box on the Replenishment tab of the current form is Transfer.

This box is available only when the Override check box right of it is selected.

Override A check box that you select to change the value of the Transfer Lead Time box.
Days of Supply

The number of days that the system uses for the consolidation of demand documents containing the specified item in the specified warehouse during inventory planning. When the number of days is more than zero, the system groups into a single planned order all items with this ID in the specified warehouse from all demand documents (such as sales orders) with the requested date within the specified number of days starting from the current date.

Tip:
Demand documents are documents that generate demand for items and cause items to be issued from one of the company's warehouses. The demand document may be a sales order, a forecast, or a production order for materials included in an item to be produced.

The default value in this box is copied from the Days of Supply box on the Stock Items (IN202500) form of the specified item.

This box is displayed only when the Material Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

Override

A check box that you select to override the value in the Days of Supply box.

This check box is displayed only when the Material Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form.

Table 20. Scrap SectionThe settings in this section define the default scrap warehouse and location for the selected stock item at the specified warehouse. The system uses these settings when creating a production order if the Item value is specified in the Scrap Source box on the Production Order Types (AM201100) form for the type assigned to the order. For details, see Configuration of Scrap, Waste, and By-Products in Production: Scrap Quarantine.
Element Description
Scrap Override A check box that you select to override the scrap settings copied from the Stock Items (IN202500) form, which are initially used to populate this section.
Scrap Warehouse

The warehouse that the system uses by default for scrap in production orders in which the warehouse matches the one specified in the Warehouse box of the Selection area.

This box is available only when the Scrap Override check box is selected.

Scrap Location

The warehouse location that the system uses by default for scrap in production orders in which the warehouse matches the one in the Warehouse box of the Selection area.

This box is available only when the Scrap Override check box is selected.