Warehouses

Form ID: (IN204000)

Note: This form is available if either the Multiple Warehouses feature or the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.

You use this form to define, view, and modify warehouses and their settings. To create similar configurations of location in multiple warehouses, you can export the location table to an Excel file (in .xlsx format) and import the settings from the file to the same warehouse or another warehouse. After you have defined the settings for your company’s warehouses, you can use the Item Warehouse Details (IN204500) form to set up the specific relationships between existing warehouses and inventory items, and to define the warehouse settings specific to each item in each warehouse. For more information about warehouses, see Warehouses: General Information.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
Change ID	Opens the Specify New ID dialog box, which you can use to enter a new identifier for the warehouse.
Location Labels	Navigates to the Location Labels (IN619000) report.
Validate Addresses	Validates the warehouse addresses through integration with a specialized third-party software or service.

Address Lookup Dialog Box

In this dialog box, you can add a new address, update an existing address, and fill in the missing address information in a record that has address settings. You can also search for the name of the company and select the company's address. You can click the link to view the address in a new browser tab. If the address is correct, you can click Select to fill in the boxes in the Address section of the applicable form with the company location details. The addresses you can select from the list are limited to the countries specified for the address provider.

Tip:

If needed, you can use only a keyboard to select an address in the dialog box. When the Address Lookup dialog box has been opened, the system moves the focus to the Enter a Location box. You enter the known part of the address in the box, select the address by using the arrow keys, and press Enter. Then you can check the address and press Enter to close the dialog box.

You can expand the size of the Address Lookup dialog box to see the map in a larger scale by dragging the edges or corners of the dialog box.

This dialog box is available only if the *Address Lookup Integration* feature is enabled on the Enable/Disable Features (CS100000) form and integration with a web map service has been set up as described in Integration with Web Map Services.
Element	Description
Enter a Location	A box for searching for the company's address. You can find the address by doing the following: Find a company address by a postal code if no other address details are available: If you enter the postal code into this box, the system displays the address options with the cities and country (and the state, if the country has states) that are valid for the postal code. Find a full address by a street address: If you enter the street address into this box and select the address, the system will fill in the country (and the state, if applicable), city, and postal code on the form. The web service selected as an address provider on the Site Preferences (SM200505) form searches for the information that matches your search criteria and lists all the search results below this box. You can click the needed value in the list, and the web service populates the box with this value and displays the address in the map area.
Map area	The area that displays the map, which takes most of the space of the dialog box. Depending on the address provider, Google Maps or Bing Maps can be used. In this area, you can view the existing company location. If you click the Address Lookup button, the company address is shown in the dialog box as a location on the map.
This dialog box has the following buttons.
Select	Closes the dialog box and populates the current section with the address details that you have selected in this dialog box.
Cancel	Closes the dialog box and cancels the selection of the company address.

Summary Area

In this area, you can enter the ID of a new warehouse and its basic settings, and define how its locations can be added. You can also select an existing warehouse and view or change its settings.


Element	Description
Warehouse ID	The unique identifier of the warehouse.
Branch	The branch to which this warehouse belongs.
Replenishment Class	The replenishment class associated with this warehouse. Replenishment classes are created using the Replenishment Classes (IN208800) form. This box appears only if the Inventory Replenishment feature is enabled on the Enable/Disable Features form.
Active	A check box that indicates (if selected) that the warehouse is active and available for selection on the forms.
Description	A brief description of the warehouse. This element appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features form.
Location Entry	An option indicating whether warehouse locations can be added directly on any inventory document or only by using this form. Select one of the following options: Do Not Allow On-the-Fly Entry: On-the-fly entry of the warehouse locations is not allowed; new locations can be added only on this form. Warn But Allow On-the-Fly Entry: Users are allowed to enter new locations on the fly, but the system will warn the users before allowing new locations to be added. Allow On-the-Fly Entry: On-the-fly entry of the warehouse locations is allowed; while filling in a receipt or issue, a user can specify a new location.
Avg. Default Returns Cost	For items with the Average cost method, the option that defines which costs the system will specify in the Unit Cost column for customer returns on the Details tab of the Sales Orders (SO301000) form and for inventory receipts on the Receipts (IN301000) form. You can select one of the following options: Average: To use the average cost Last: To use the last cost This element appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features form.
FIFO Default Returns Cost	For items with the FIFO valuation method, the option that defines which costs the system will specify in the Unit Cost column for customer returns on the Details tab of the Sales Orders (SO301000) form, and for inventory receipts on the Receipts (IN301000) form. You can select one of the following options: Average: To use the average cost Last: To use the last cost This element appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features form.

Locations Tab

On the tab, you can add new locations and modify the properties of existing ones. The tab includes a table that holds the list of locations and an area where you can select the receiving, drop-ship, shipping, and return material authorization (RMA) locations.

This tab appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form. If the Multiple Warehouse Locations feature is disabled, a single MAIN location is created automatically and is assigned as the default receiving, shipping, RMA, and drop-ship location.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar. Refer to Integration with Excel if you need to export the location table to an Excel file or to import the location table from such a file.

Table 1. Selection Elements
Element	Description
Receiving Location	The warehouse location to be used as the default receiving location for stock items in this warehouse.
Shipping Location	The warehouse location to be used as the default shipping location for this warehouse.
RMA Location	The RMA warehouse location. The location you select will be used for all goods return operations. The returned goods will be delivered to the specified location, regardless of the warehouse location selected by default for the receipt of these goods.
Drop-Ship Location	The warehouse location used by default for drop ship orders and all inventory documents that are automatically generated for drop-ship orders. The goods will actually be delivered directly from the vendor's location to the customer's location. This element is available only if the Drop Shipments feature is enabled on the Enable/Disable Features form.
Use Item Default Location for Picking	A check box that indicates (if selected) that when the system is finding the most appropriate warehouse location for an item in a shipment to be picked, it gives the highest priority to the location specified in the Default Issue From box on the General tab of the Stock Items (IN202500), if any. If the check box is cleared, the system does not consider the location specified for the item in the Default Issue From box. For more information, see Priorities of Warehouse Locations. By default, this check box is cleared. This check box is displayed only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features form.

Table 2. Location Table Columns
Column	Description
Location ID	The unique identifier of the warehouse location.
Description	A brief description of the warehouse location.
Active	A check box that indicates whether this location is active.
Sort Location	A check box that you select if this location is used for sorting items that have been picked in a batch. This column appears only if the Advanced Picking feature is enabled on the Enable/Disable Features form.
Include in Qty. Available	A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers.
Cost Separately	A check box that you select if the costs for goods available at this location will be calculated separately from costs calculated at the system-level; that is, for FIFO and Average valuation methods, separate cost layers will be created for this location. You cannot select this check box if this is the only location at the warehouse. CAUTION: We recommend that you not change this option once it has been set. If the location is linked to a project with the Track by Location inventory tracking mode, this check box is selected by default and cannot be edited.
Sales Allowed	A check box that you select if only issues (direct inventory issues as well as issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for inventory receipts generated for purchase receipts of the Return type. If during shipment creation, the system detects that some quantities are available only from this location, the system displays an error message and does not create a shipment.
Receipts Allowed	A check box that you select if the items can only be received at this location.
Transfers Allowed	A check box that you select if only transfers are allowed for this location.
Assembly Allowed	A check box that you select if assembly operations are allowed at this location. This column is displayed only if the Kit Assembly feature is enabled on the Enable/Disable Features form.
Production Allowed	A check box that you select if the production of items is allowed at this location. By default, this check box is selected for new locations. This column is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.
Pick Priority	A value that indicates the priority of this location when items are chosen. A higher value corresponds to a lower priority: The value 1 indicates the highest priority, 2 the next highest, and so forth to the lowest priority; 0 means that the pick priority is not defined. For details, see Warehouse Locations and Single-Step Transfers: General Information.
Path	A value that indicates the position of each location in the warehouse. Higher values correspond to distant locations. The values specified for all locations define the linear map of a warehouse. The system uses this map to calculate the best path for each picker to use when picking items in a batch or in a wave. This column is displayed only if the Advanced Picking feature is enabled on the Enable/Disable Features form.
Primary Item Validation	An option indicating whether the operations with the primary item should be validated for this location and how validation will occur. Select one of the following options: No Validation: No validation for this location is required. Primary Item Warning: Validation for this location is required only for the primary item. If another item is being received, a warning will be displayed. Primary Item Error: Validation for this location is required only for the primary item. The system generates an error if you try to save the purchase receipt if an item other than the primary item is being received. Primary Item Class Warning: Validation for this location is required for items of the primary item class. The system will display a warning if items of other than the primary item class are received. Primary Item Class Error: Validation for this location is required for items from the primary item class. The system generates an error if you try to save the purchase receipt with items from non-primary item class. Note: Primary item validation is enforced only for received goods.
Primary Item	The primary item for this location, which is the item that is received the most often or stored here in the highest volumes. Select the appropriate item from the list of available inventory items.
Primary Item Class	The primary item class for this location; items of this class are received the most often or stored here in the highest volumes. Select the appropriate item class from the list of available item classes.
Project	The project whose project tasks are to be associated with this location by default. Only the projects that have the Track by Location inventory tracking mode specified on the Summary tab of the Projects (PM301000) form are available for selection in this column. For more information on tracking project inventory by location, see Project Inventory Tracking by Warehouse Location: General Information. Note: To each combination of the project and project task, you can map only one warehouse location. To be able to use the same project with multiple warehouse locations, assign a separate project task to each of these locations. If you select a particular project task in the Project Task column, only the selected project task becomes associated with the location; if the Project Task column is left blank, each task related to this project is associated with this location unless is already associated with a different location. If this project is specified in a line of a sales order, the line item's ordered quantity will be picked from this location. To reduce the chance that the location related to a particular project will be used for shipping sales orders that are not related to this project, specify a higher Pick Priority value (that is, a lower pick priority) for this location. For more information on how the system selects locations when sales orders are shipped, see Warehouse Locations and Single-Step Transfers: General Information. This box is read-only if the item quantity assigned to this location is greater than zero. Once the quantity becomes zero, the location can be assigned to another project.
Project Task	The project task to be associated with this location by default. Only the projects that have the Track by Location inventory tracking mode specified on the Summary tab of the Projects form can be linked to warehouse locations. For more information on tracking project inventory by location, see Project Inventory Tracking by Warehouse Location: General Information. Note: To each combination of the project and project task, you can map only one warehouse location. To be able to use the same project with multiple warehouse locations, assign a separate project task to each of these locations. If no project task is selected, all tasks related to the project selected in the Project column are associated with this location, except for any task that is already associated with a different location. If the project task is specified for a particular line in a sales order, the ordered quantity will be picked from this location. To reduce the chance that the location related to a particular project task will be used for shipping sales orders that are not related to this project task, specify a higher Pick Priority value (that is, a lower pick priority) for this location. For more information on how the system selects locations when sales orders are shipped, see Warehouse Locations and Single-Step Transfers: General Information. This column is available only if a project has been selected in the Project column. The box is read-only if the item quantity assigned to this location is greater than zero. Once the quantity becomes zero, the location can be assigned to another project task.
MRP	A check box that indicates (if selected) that the on-hand quantity of items in this location is included in material requirements planning. You clear this check box for those locations used to store unusable material that is pending disposition such as scrap, rework, or return to vendor. Attention: If the check box is cleared for a warehouse location, then any production orders with this location as the planned receipt location are also excluded from material requirements planning. By default, this check box is selected for new locations. This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Carts Tab

On this tab, the list of carts used in warehouse operations is displayed. You can add new carts and deactivate or remove existing carts.

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

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
Assigned Totes	Opens the Assigned Totes window, in which you can review the list of totes assigned to the selected cart. This button appears on the table toolbar only if the Advanced Picking feature is enabled on the Enable/Disable Features form.

Table 3. Assigned Totes WindowIn the Assigned Totes window, you can review the totes assigned to a cart.
Element	Description
Tote ID	The identifier of the tote assigned to the cart.
Description	A brief description of the tote.
Active	A check box that indicates (if selected) that the tote is active and can be used in warehouse operations.

Table 4. Carts Table
Column	Description
Cart ID	The identifier of the cart.
Description	The description of the cart.
Assigned Number of Totes	The number of totes assigned to the cart. This column appears on the tab only if the Advanced Picking feature is enabled on the Enable/Disable Features form.
Active	A check box that indicates (if selected) that the cart is active and can be used in warehouse operations.

Totes Tab

On this tab, the list of totes used in advanced or paperless picking processes is displayed. You can add new totes and deactivate or remove existing totes.

This tab is displayed only if the Advanced Picking or Paperless Picking feature is enabled on the Enable/Disable Features (CS100000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 5. Totes Table
Column	Description
Tote ID	The unique identifier of the tote.
Description	The description of the tote.
Assigned Cart ID	The cart to which the tote is assigned.
Active	A check box that indicates (if selected) that the tote is active and can be used in the picking process.

GL Accounts Tab

You use this tab to specify the General Ledger accounts and subaccounts to be used for inventory transactions that originate in this warehouse.


Element	Description
Override Inventory Account/Sub.	A check box that indicates to the system (if selected) that the preferred inventory account and subaccount are overridden for the warehouse.
Inventory Account	The asset account to be used to maintain the balance of inventory at this warehouse. 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 with the inventory account for posting inventory transactions related to this warehouse.
Reason Code Sub.	The subaccount to be used with reason codes as follows: This subaccount is used as a source of segment values for reason code offset subaccounts that are generated according to the rules defined by the Combine offset Sub. from box on the Reason Codes (CS211000) form. This subaccount's segment values are used for those segments of the resulting subaccount that have the Warehouse (W) option selected in the Combine Offset Sub from box.
Sales Account	The income account to be used to record sales made from this warehouse.
Sales Sub.	The subaccount to be used for sales made from this warehouse.
COGS/Expense Account	The expense account to be used to record the cost of goods sold (COGS) when sales are made from this warehouse.
COGS/Expense Sub.	The subaccount to be used with the COGS account for this warehouse.
Standard Cost Variance Account	The expense account to be used to record differences between the extended standard costs of the inventory items received at this warehouse and their extended prices. This account is used only for transactions associated with inventory items for which the standard cost valuation method is assigned.
Standard Cost Variance Sub.	The subaccount to be used with the standard cost variance account.
Standard Cost Revaluation Account	The expense account to be used to record differences between the values of the items at this warehouse when standard costs are updated. This account is used only for standard-valued inventory items.
Standard Cost Revaluation Sub.	The subaccount to be used for this warehouse with the standard cost revaluation account.
PO Accrual Account	The liability account to be used to accrue amounts based on purchase orders for this warehouse. Whenever receipts based on purchase orders are released, the system generates a transaction between the PO accrual account and the inventory account. The account selected in this box should be configured as a control account for the purchase orders subledger. That is, for this account, PO 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.
PO Accrual Sub.	The subaccount to be used with the purchase accrual account for this warehouse.
Purchase Price Variance Account	The expense account to be used to record any differences between the extended purchase prices of items received at this warehouse on purchase receipts and the extended costs of the items on related accounts payable bills. This account is used for inventory items with non-standard cost valuation methods assigned.
Purchase Price Variance Sub.	The subaccount to be used with the purchase price variance account for this warehouse.
Landed Cost Variance Account	The expense account to be used for inventory items stored at this warehouse; this account is used to record the landed cost difference that occurred if landed costs are allocated to an item that has been sold.
Landed Cost Variance Sub.	The subaccount to be used with Landed Cost Variance account for inventory transactions related to this warehouse.
Work in Process Account	The asset account to be used to maintain the balance of work in process at this warehouse. This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.
Work in Process Subaccount	The asset subaccount to be used to maintain the balance of work in process at this warehouse. This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.
WIP Variance Account	The expense account to be used to record the work in process variance when production orders are financially closed. This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.
WIP Variance Subaccount	The expense subaccount to be used to record the work in process variance when production orders are financially closed. This box is displayed only if the Manufacturing feature is enabled on the Enable/Disable Features form.

Address Tab

You use this tab to specify the address of the warehouse and to provide contact information for the warehouse.

Table 6. Contact SectionIn this section, you can specify the contact information for the warehouse.
Element	Description
Company Name	The legal business name of the warehouse to appear on the documents.
Attention	The department or person to be noted on the attention line, if this line is used by your company.
Email	The email address of the contact person assigned to this warehouse.
Web	The URL of the webpage where information about the warehouse is published.
Phone 1	The primary phone number of the contact person assigned to this warehouse.
Phone 2	A secondary phone number of the contact person assigned to this warehouse.
Fax	The fax number of the contact person assigned to this warehouse.

Table 7. Building SectionIn this section, you can specify the warehouse building to be assigned to the warehouse. The warehouse building must be created on the Warehouse Buildings (IN204010) form before you can select it on the current form.
Element	Description
Building ID	The identifier of the warehouse building. In the lookup table of this box, the system displays only buildings assigned to the same branch as the one specified for this warehouse in the Branch box of the Summary area. After you select a warehouse building for this warehouse and save your changes, this warehouse is listed for the building on the Warehouses tab of the Warehouse Buildings form.

Table 8. Address SectionYou use these elements to define the warehouse address.
Element	Description
Validated	A check box that indicates (if selected) that the warehouse address has been validated with a third-party specialized software or service. This element appears only if the Address Validation feature is enabled on the Enable/Disable Features (CS100000) form.
Address Line 1	The first line in the address of the warehouse.
Address Line 2	The second line in the warehouse address.
City	The city of the warehouse address.
Country	The country where the warehouse is located.
State	The state where the warehouse is located.
Postal Code	The postal code of the warehouse address.
Carrier Facility	The facility code used by Canada Post for the shipping addresses. This box appears only if the Shipping Carrier Integration feature is enabled on the Enable/Disable Features form.
View on Map	A button you click to open the map specified on the Site Preferences (SM200505) form and provided by the Google Maps or Bing Maps web map service to view this address on a map, which is opened in a new tab. This button is displayed on the form if the Address Lookup Integration feature is disabled on the Enable/Disable Features (CS100000) form.
Address Lookup	A button you click to open the Address Lookup dialog box. For the description of the dialog box, see Address Lookup Dialog Box. This button is displayed on the form if the Address Lookup Integration feature is enabled on the Enable/Disable Features (CS100000) form and if the integration with web map services has been set up, as described in Integration with Web Map Services.

Manufacturing Tab

On this tab, you specify the default settings for the warehouse and its locations that the system uses in manufacturing processes.

Table 9. MRP Settings SectionThe check boxes in this section determine the supply and demand data that are considered by the system for this warehouse during material requirements planning (MRP). If you want to exclude the warehouse from material requirements planning, you clear all check boxes in this section. In a production system, we recommend that all check boxes are selected. You may want to clear some check boxes if you want to test how planning works when some of the data is excluded.
Element	Description
Forecasts	A check box that indicates (if selected) that the forecast records are included in MRP.
Inventory on Hand	A check box that indicates (if selected) that the on-hand quantities of stock items stored in this warehouse are included in MRP.
MPS	A check box that indicates (if selected) that the supply data generated by the master production schedule is included in MRP.
Shipments	A check box that indicates (if selected) that the quantities of items in shipments for which invoices have not been created are included in MRP.
Purchase Orders	A check box that indicates (if selected) that the quantities of items in not completed purchase orders are included in MRP.
Production Orders	A check box that indicates (if selected) that the quantities of items in not completed production orders are included in MRP.
Sales Orders	A check box that indicates (if selected) that the quantities of items in not completed sales orders are included in MRP.

Table 10. Scrap SectionThe settings in this section define the default scrap warehouse and location for the specified warehouse. The system applies these settings to a production order when *Warehouse* is selected in the Scrap Source box on the Production Order Types (AM201100) form for the production order type assigned to the order. For more information, see Configuration of Scrap, Waste, and By-Products in Production: Scrap Quarantine.
Element	Description
Scrap Warehouse	The warehouse that the system uses for scrap by default in production orders in which the warehouse matches the warehouse selected in the Warehouse box of the Selection area. This box appears only when the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Scrap Location	The warehouse location that the system uses for scrap by default in production orders in which the warehouse matches the warehouse selected in the Warehouse box of the Selection area. This box appears only when the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features form.

Table 11. Transfer Lead Time Table
In this table, you can view and add warehouses from which items can be transferred and specify the transfer lead time. When you add a row for a warehouse, the system also adds a reciprocal row for the warehouse currently selected on the form to the settings of the transfer warehouse. You add rows to this table when you would like the system to consider transfer lead times between the warehouses during material requirements planning.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column	Description
Replenishment Warehouse	The warehouse from which items can be transferred to the currently selected warehouse.
Transfer Lead Time (Days)	The number of days that it takes to transfer items from the replenishment warehouse to the currently selected warehouse and from the selected warehouse to the replenishment warehouse.