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 Item Creation: 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 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 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.

Replenishment 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 Replenishment 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 available only if the Inventory Replenishment or Manufacturing feature is enabled (or if both features are enabled) on the Enable/Disable Features (CS100000) form. When the Inventory Replenishment feature is disabled and the Manufacturing feature is enabled, only the following elements are displayed on the tab: the Override Replenishment Settings check box, the Replenishment Source box, and the Replenishment Warehouse box. By default, the system inserts the settings specified on the Manufacturing tab of the Stock Items form.

Table 5. Replenishment Settings Section
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 Replenishment tab of the Stock Items 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 form, you can select this check box to override the replenishment source specified on the Manufacturing tab of the Stock Items 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 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 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 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 6. Replenishment Parameters Section
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 7. Demand Forecast Result Section
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 8. Preferred Parameters Elements
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 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 form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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.

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 9. 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 10. 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 11. 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 effective date for the current cost value of the stock item.
Pending Cost	The pending cost value for the stock item, which becomes effective on the Pending Cost Date. This value can be set only if the Std. Cost Override check box is selected.
Pending Cost Date	The date when the pending cost value of the stock item will become effective. This value can be set only if the Std. Cost Override check box is selected.

Table 12. 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 for calculating the item's prices specific to this warehouse, the system will use the manufacturer's suggested price specified in the MSRP box instead of the default manufacturer's suggested price for the item. If this check box is cleared, the MSRP box displays the default manufacturer's suggested price for the item, which is specified on the Price/Cost tab of the Stock Items (IN202500) form.
MSRP	The manufacturer's suggested price of the stock item. This is the retail price suggested for stock item by its manufacturer.

Table 13. 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 14. 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.
Planning BOM ID	The default bill of material that the system uses for material requirements 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.
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 form.

Table 15. 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 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.
Planning BOM ID	The planning bill of material that the system uses in material requirements 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.

Table 16. 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 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 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 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 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 material requirements 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 material requirements 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 material requirements 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 material requirements planning if the Use Fixed Manufacturing Times check box is selected on the MRP 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 MRP Configuration: System Settings. 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 material requirements 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 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 form.

Table 17. 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.