About Warehouses

In the context of SyteLine, a warehouse is a location within a site that can contain on-hand inventory. This overview includes information about warehouses and how they can be used in the system.

Each site has at least one warehouse, designated as MAIN, which is created during system installation. In most cases, this also becomes the default, or primary, warehouse for the site, but you can change the default.

Multiple Warehouses

Many companies have more than one location in which to store inventory, so the system allows you to add warehouse locations to the list of warehouses available for various transactions. To add warehouses, use the Warehouses form. You can also use this form to view and update information for all warehouses in the system.

Item Stockroom Locations

Once you have your warehouses established in the system, before you can show inventory in those warehouses, you must establish item stockroom locations. Each warehouse can contain multiple item stockroom locations where you store inventory for lot-tracking and other audit-trail purposes. Add these item stockroom locations using the Locations form.

When you add an item to the system using the Items form, the system automatically creates an item stockroom location for the item, using both the default warehouse (Default Whse) and default location (Default Location) as defined on the Inventory Parameters form.

Item/Warehouse Records

When you add an item to the system using the Items form, the system automatically creates an item/warehouse association (or record) for the item. For this, the system uses the default warehouse as defined in the Default Whse field on the Inventory Parameters form. As mentioned in the previous section, the system also automatically creates an item stockroom location.

If you want to stock the item at other warehouses, you must create an item/warehouse association for each warehouse location in which you want to store the item. To create these item/warehouse associations, use the Item/Warehouse form. You can then use the Item Stockroom Locations form to add quantities of the item to locations within the designated warehouse.

Externally Controlled Warehouses

If Controlled by External Warehouse is selected, operations at this warehouse are controlled by an external application, and many standard SyteLine operations are not performed.

For a list of the forms and operations that are changed by this option, see the topic on Using an External Warehouse Application..

Consignment Warehouses

There are two ways to utilize a consignment warehouse:

  • You can specify some of your warehouses as vendor consignment warehouses, where vendor material is stored until you decide to consume/purchase them.
  • You can specify a customer's warehouse as a customer consignment warehouse, where you store some of your materials until the customer decided to consume/purchase them.

Warehouse Defaults

On forms where you can select a warehouse (in other words, where the warehouse field is not just display-only), many of them use a default warehouse setting. In all cases, you can override this default setting by selecting a different warehouse.

The values for these default warehouse settings come from various places, depending on the form. The following table lists those forms with default warehouse settings for new records and where the default settings come from.

Default Warehouse Settings

Note:  This table lists only those forms that have a warehouse selection list box with a default value for new records. Forms that do not use default values are not listed here.
Form Default taken from
Combined Transfer Order Ship/Receive (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Customer Order Blanket Releases The Warehouse field on the Customer Orders form.
Customer Order Kit Builder The Warehouse field on the Customer Order Lines form.
Customer Order Lines The Warehouse field on the Customer Orders form.
Customer Order Shipping Error Processing The Default Whse field on the General tab of the Inventory Parameters form.
Customer Orders The Warehouse field on the Codes tab of the Customer Ship-Tos form.

When the customer or customer ship-to changes, the system assigns the default warehouse for the customer order as follows:

  • The default warehouse for the specified ship-to location.
  • If blank and ship to is not 0, then the system uses the default warehouse for the ship-to 0 location of the specified customer.
  • If blank, then the system uses the default user warehouse.
  • If blank, then the system uses the default warehouse from the Inventory Parameters form.

You can change the default setting for a customer, which changes this default, using the Set Default Warehouseform.

Cycle Count Generation The Default Whse field on the General tab of the Inventory Parameters form.
Cycle Count Posting The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Cycle Count Purge The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Cycle Count Setup The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Cycle Count Sheet Repor The Default Whse field on the General tab of the Inventory Parameters form.
Cycle Count Variance Report The Default Whse field on the General tab of the Inventory Parameters form.
Cycle Counting Error Processing The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Demand Summary - Scheduler The warehouse associated with the selected demand record.
EDI Customer Order Blanket Releases The Warehouse field on the General tab of EDI Customer Orders form.
EDI Customer Order Lines The Warehouse field on the General tab of EDI Customer Orders form.
EDI Customer Orders The Warehouse field on the Codes tab of the Customer Ship-Tos form.

If that field is blank, then the default is taken from the Default Whse field on the General tab of the Inventory Parameters form.

Estimate Project Resources The Default Whse field on the General tab of the Inventory Parameters form.
Freeze/Unfreeze Inventory The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Generate Goods Receiving Note Lines (Display-only) The Warehouse field in the header of the Goods Receiving Notes form.
Goods Receiving Notes The Warehouse field on the Ship From tab of the Vendors form.
Goods Receiving Notes Landed Costs (Display-only) The Warehouse field in the header of the Goods Receiving Notes form.
Goods Receiving Notes Lines (Display-only) The Warehouse field in the header of the Goods Receiving Notes form.
Inventory Pre-Adjustment Report (Display only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".

To produce a report for a different warehouse using this form, use the Change Warehouse form.

Item Availability (Display-only) The Warehouse field on the Item/Warehouse form.
Item Lot Locations (Display-only) The warehouse selected from the grid view in the left pane.

To view information and set controls for a different warehouse, select the warehouse you want from the grid view.

Item Stockroom Location Mass Creation The Default Whse field on the General tab of the Inventory Parameters form.
Item Stockroom Locations When adding items (using the Items form), the Default Whse field on the General tab of the Inventory Parameters form.

When creating a new item stockroom location using this form, the value of whatever record was selected prior to initiating the action to create a new item stockroom location.

Job Material Kit Builder The For Whse field on the Scheduling tab of the Job Orders form.
Job Material Transactions The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Job Orders The Default Whse field on the General tab of the Inventory Parameters form.
Job Receipt (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Just-In-Time Production Error Processing The Default Whse field on the General tab of the Inventory Parameters form.
Just-In-Time Production Transactions (Display-only) The Default Whse field on the General tab of the Inventory Parameters form.
Load Physical Inventory Records The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Material Planner Workbench Generation The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Miscellaneous Issue (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Misc Issue/Receipt And Qty Adjust Error Processing The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Miscellaneous Receipt (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Multi-Site Quantity Move The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Packing Slip The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Physical Inventory Approval The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Planning Detail Firm Transfer Order The Default Whse field on the General tab of the Inventory Parameters form.
PO Receiving List The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Post Job Transactions The Default Whse field on the General tab of the Inventory Parameters form.
Posted Transaction (Display-only) The Default Whse field on the General tab of the Inventory Parameters form.
Production Schedule Items The Default Whse field on the General tab of the Inventory Parameters form.
Project Resource Kit Builder The Warehouse field on the General tab of the Project Resources form.
Project Resources The Default Whse field on the General tab of the Inventory Parameters form.
Purchase Order Blanket Releases The Warehouse field on the General tab of the Purchase Orders form.
Purchase Order Lines The Warehouse field on the General tab of the Purchase Orders form.
Purchase Order Receiving The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Purchase Order Requisition Lines The Warehouse field on the Purchase Orders form.
Purchase Order Requisitions The Default Whse field on the General tab of the Inventory Parameters form.
Purchase Orders The Warehouse field on the Ship From tab of the Vendors form.

If that field is blank, then the default is taken from the Default Whse field on the General tab of the Inventory Parameters form.

You can change the default setting for a vendor, which changes this default, using the Set Default Warehouse form.

Quantity Adjustment (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Quantity Move (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Reservations for Item The Default Whse field on the General tab of the Inventory Parameters form.
Reservations for Order (Display-only) The Warehouse field on the Codes tab of the Customer Ship-Tos form.

If that field is blank, then the value is taken from the Default Whse field on the General tab of the Inventory Parameters form.

RMA Return Transaction (Display-only) The Warehouse field on the General tab of the RMAs form.
RMAs The Warehouse field on the Codes tab of the Customer Ship-Tos form.

If that field is blank, then the default is taken from the Default Whse field on the General tab of the Inventory Parameters form.

Set Tag Sheet Controls (Display-only) The warehouse selected from the grid view in the left pane.

To view information and set controls for a different warehouse, select the warehouse you want from the grid view.

Time Phased Inventory Status The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".
Transfer Order Kit Builder The From Whse field on the header of the Transfer Order Line Items form.
Transfer Order Line Items (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Transfer Order Receive (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Transfer Order Receive Error Processing (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Transfer Order Ship (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Transfer Order Ship Error Processing (Display-only) The From Whse and To Whse fields on the Transfer Orders form.
Unposted Job Transactions The For Whse field on the Scheduling tab of the Job Orders form.
Warehouses (Display-only) The warehouse selected from the grid view in the left pane.

To view information and set controls for a different warehouse, select the warehouse you want from the grid view.

Note:  Because one purpose of this form is to allow you to add new warehouses, when adding a new warehouse, this field by default is blank.
Work Center Material Transactions (Display-only) The "current warehouse" as defined and recognized by the system. See About the "Current Warehouse".

About the "Current Warehouse"

Many forms take as their default value the warehouse that the system recognizes as the "current warehouse," which can change on a per-user, per-session basis. When designating the "current warehouse," the system uses the following rules:

  • When you log in, the system designates the warehouse from the your profile as the "current warehouse" for that session.

This setting is defined in the Whse field on the Additional Info tab of the Users form.

  • If that field is blank, the system uses the Default Whse field on the General tab of the Inventory Parameters form.
  • At any point after logging in, you can change the "current warehouse" setting for that session using the Change Warehouse form.
Note:  This "current warehouse" setting is valid only on a user-session basis. That is, the "current warehouse" setting can be different for each user logged in to the system. Also, this setting is only in effect as long as you are logged in. After you log out, the setting reverts to your default user setting, if any, when you log in again.

Setting Warehouse Defaults Manually

The system offers several ways to manually change warehouse default settings. You can:

  • Change the system default warehouse using the Default Whse field on the General tab of the Inventory Parameters form.
  • Change a user's default "current warehouse" setting using the Whse field on the Additional Info tab of the Users form.
  • As a user, change the "current warehouse" setting for your current session using the Change Warehouse form. .
  • Change the default warehouse for a range of customers using the Set Default Warehouse form.
  • Change the default warehouse for a range of vendors using the Set Default Warehouse form.
  • Change the default warehouse for a range of users using the Set Default Warehouse form.

How MRP, APS, and MPS Processor Use Warehouses

The MRP, APS, and MPS Processor planning functions view on-hand inventory as the total on-hand quantity (that is, On Hand - Qty Reserved for customer orders) at all nettable stockroom locations across all warehouses at the site.

EXAMPLE: Suppose you have a customer order for 150 of an item. The item is stored at three warehouses, A, B, and C. Warehouse A contains 50 on-hand, warehouse B contains 75 on-hand, and warehouse C contains 40 on-hand. When you run MRP or APS Planning or the MPS Processor, the system allocates on-hand from all three warehouses to satisfy the demand, and no planned orders are needed. This planning behavior occurs regardless of any specific warehouse specified on the customer order.

Dedicated Remote Warehouses

Warehouses with dedicated inventory are useful for serving demands tied to that warehouse and which do not affect planning for the remainder of the site. In the example above, suppose you wanted to "protect" the inventory at warehouse C so it could be used only for specific customer orders. To do this, select the Dedicated Inventory check box on the Warehouses form for that warehouse.

When you run the MRP or APS Planning or MPS Processor, the system ignores the inventory in the dedicated-inventory warehouse. Likewise, these planning functions ignore all demands and supplies that specify a dedicated-inventory warehouse.

Note: 
  • You cannot select the Dedicated Inventory option for a warehouse selected as the default warehouse (Default Whse) on the Inventory Parameters form.
  • You cannot perform the Get ATP or Get CTP function on a line item (for example, on the Customer Order Lines form) that is associated with a dedicated-inventory warehouse.
  • The Planning Detail and Planning Summary forms do not display any inventory transactions related to dedicated-inventory warehouses.
  • The exception message "Initial On-Hand Quantity Negative" (which appears on the Planning Detail form and on the Exceptions Report) does not consider inventory at dedicated-inventory warehouses.
  • The planning functions ignore demands set to ship from dedicated-inventory warehouses and supplies set to supply dedicated-inventory warehouses.

Dedicated Inventory and Planning of Transfer Orders

  • Outgoing transfer orders are not planned as demands at the current, local site if the warehouse specified in the From Whse field is a dedicated-inventory warehouse. However, that transfer order is planned as a supply if it is sent to a warehouse at the same site that is a non-dedicated inventory warehouse (that is, if the To Whse field contains a warehouse in which the Dedicated Inventory check box is not selected).
  • Incoming transfer orders are not planned as supplies at the current, local site if the warehouse specified in the To Whse field is a dedicated-inventory warehouse. However, that transfer order is planned as a demand if it is received from a warehouse at the same site that is a non-dedicated inventory warehouse (that is, if the From Whse field contains a warehouse in which the Dedicated Inventory check box is not selected).

Distribution Warehouses

Distribution warehouses are dedicated-inventory warehouses that are designated to plan intra-site transfer using the transit time between the default warehouse and a distribution warehouse. For these transfers, the original demand is ignored, but the pre-planning process generates planned transfer orders based upon the demand at the distribution warehouse. New planned intra-site transfers represent demand for the planning engines.

Sourcing Percentages of Planned Orders

You can set rules that automatically split planned transfer orders for a certain item or product code between multiple sites and warehouses, specifying what percentage of the order comes from which site/warehouse.

Moving Inventory Between Locations

Use transfer orders to move inventory from one warehouse to another (within the same site or across sites).

A hypothetical shipping and receiving scenario, in which both warehouses are within the same site, is shown below:

  • Warehouse A transfers to Warehouse B.
  • Warehouse A ships to a Transit Location, which is maintained at Warehouse B.
  • When Warehouse B receives the item, it is moved from the Transit Location to a Stock Location within Warehouse B.

The following diagram shows this process.

ebd_Ebd1.gif

Moving Quantities Between Locations

To move inventory between:

  • Different sites, warehouses within the same site, or locations within a single warehouse, you can use the Multi-Site Quantity Move utility.
  • Two warehouses within the same site, you can use the Warehouse to Warehouse Bulk Transfer utility.
  • Different locations within a single warehouse, you can use the Quantity Move utility.

Transferring Lot-Tracked Items

When you transfer a lot-tracked item from a warehouse at one site to a warehouse at another site, there are issues to consider regarding whether the lot number exists at each site and in which location it will be created.

See the topic About Multi-Site Transfer Order Lot Tracking for several examples that illustrate this process.

Counting Warehouse Inventory

Keeping count of inventory is done at the warehouse level. There are two primary ways to take a count of the existing inventory at each warehouse:

  • Performing a cycle count: Cycle counting involves counting your inventory quantities at each warehouse and stock location on a scheduled, cyclical basis. You can define cycle-count triggering options at each warehouse to instruct the system to create a cycle count record each time a particular inventory event occurs at that warehouse.

    For more information, see the topic About Cycle Counts.

  • Performing a physical inventory: Doing a physical inventory involves someone doing an actual physical count of the inventory in a warehouse. This process involves printing out tags and/or sheets for personnel to take an actual count of the inventory in stock and then manually entering that information into the physical inventory system.

    For more information, see the topic About Physical Inventories..

Cycle Counting at Warehouses

Cycle counting involves counting your inventory quantities at each warehouse and stock location. At each warehouse, you can define cycle-count triggering options that instruct the system to create a cycle count record each time a particular inventory event occurs at that warehouse.

EXAMPLE: The system can create a count record each time a receipt or issue transaction is processed against an item or each time the on-hand level falls to zero. For more information, see the the help for the Cycle Type field on the Warehouses form.