Warehouses
Form ID: (IN204000)
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
Element | Description |
---|---|
Enter a Location |
A box for searching for the company's address. You can do the following by using this box:
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 (CS100000) 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 (CS100000) 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:
|
Average Default Cost |
For items with the Average valuation method, the option that defines which cost the system will specify in the Unit Cost column on the following forms:
You can select one of the following options:
This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. |
FIFO Default Cost |
For items with the FIFO valuation method, the option that defines which cost the system will specify in the Unit Cost column on the following forms:
You can select one of the following options:
This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) 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.
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 (CS100000) 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) form, 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 (CS100000) form. |
Picking Location for Non-Stock Items |
The default warehouse location for the picking of non-stock items. When you create a shipment and add a line with a non-stock item that requires shipping—that is, a non-stock item that has the Require Shipment check box selected on the Non-Stock Items (IN202000) form—the system copies this location to the Location column on the Details tab of the Shipments (SO302000) form for this line. The designated location will be used for picking the non-stock item when a pick list is created for the shipment. |
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 (CS100000) 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.
Attention: 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 selected on the Projects (PM301000) form, 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 (CS100000) 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 (CS100000) 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 0 indicates the highest priority, 1 the next highest, and so forth to the lowest priority; only integer values are supported. 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 (CS100000) 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:
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: In each warehouse, you can map only one warehouse
location to each combination of a project and a project task. To be able to use the same
project with multiple warehouse locations of a single warehouse, you need to 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 (PM301000) 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: In each warehouse, you can map only one warehouse
location to each combination of a project and a project task. To be able to use the same
project with multiple warehouse locations of a single warehouse, you need to 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. |
Inventory Planning |
A check box that indicates (if selected) that the on-hand quantity of items in this location is included in inventory 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 inventory
planning.
By default, this check box is selected for new locations. This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) 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 (CS100000) form. |
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. |
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 (CS100000) 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.
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 element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
Work in Process Subaccount |
The asset subaccount to be used to maintain the balance of work in process at this warehouse. This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
WIP Variance Account |
The expense account to be used to record the work in process variance when production orders are financially closed. This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
WIP Variance Subaccount |
The expense subaccount to be used to record the work in process variance when production orders are financially closed. This element is displayed only if the Material Requirements Planning or Distribution Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
Address Tab
You use this tab to specify the address of the warehouse and to provide 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. |
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. |
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 (IN204010) form. |
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 (CS100000) 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 Integrating MYOB Acumatica 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.
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 (CS100000) form. |
Inventory Planning Tab
You use this tab to select the supply and demand data that is considered by the system for this warehouse during inventory planning. Also, can view and add warehouses from which items can be transferred to this warehouse and specify the transfer lead time.
This tab is shown only if either of the following features is enabled on the Enable/Disable Features (CS100000) form:
- Distribution Requirements Planning
- Material Requirements Planning
Element | Description |
---|---|
Forecasts | A check box that indicates (if selected) that the quantities from the forecast records are included in inventory planning. |
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 inventory planning. |
MPS |
A check box that indicates (if selected) that the supply data generated by the master production schedule is included in inventory planning. This check box is shown only if the Material Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
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 inventory planning. |
Purchase Orders | A check box that indicates (if selected) that the quantities of items in purchase orders that have not been completed are included in inventory planning. |
Production Orders |
A check box that indicates (if selected) that the quantities of items in production orders that have not been completed are included in inventory planning. This check box is shown only if the Material Requirements Planning feature is enabled on the Enable/Disable Features (CS100000) form. |
Sales Orders |
A check box that indicates (if selected) that the quantities of items in sales orders that have not been completed are included in inventory planning. |
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. |