The Multiple-Warehouse module of EBMS is an optional inventory enhancement feature that allows a single inventory item to be purchased, stored, and sold from multiple locations. This inventory feature allows a company to track inventory counts within multiple stores or warehouses as well as maintaining a sales and purchase history for each location. Multiple warehouses may identify actual warehouses, store locations or service vehicles. The flexibility of this module can be used to associate warehouses with departments, profit centers or company divisions.
The Multiple Warehouse module is an optional feature that can be added to the standard or deluxe versions of Eagle Business Management System.
The following types of companies benefit from this feature:
Retail stores with multiple sales locations.
Distributors or wholesalers with warehouses in different locations.
Service companies with multiple service trucks that carry inventory on the vehicle.
A warehouse is often associated with a department or profit center. This relationship can be set up as one of the following options:
Each warehouse is directly related to a single department.
For example:
Warehouse A is associated with department 010;
Warehouse B is associated with department 020;
Warehouse C is associated with department 030.
This option allows both the warehouse and department to be set within an invoice using a single entry. The revenue from a sale of an inventory item would be posted to department 010 if the item were sold from warehouse A, but would be posted to department 020 if the same item was sold from warehouse B. This method is useful if a department identifies a store location or company division. Review the Creating New Warehouses > Associating each Warehouse with a single Company Division or Department section for setup details.
This option should be used if a warehouse affects the department setting, but many departments exist within a warehouse.
For example, a hardware store with multiple locations contains multiple departments within each location:
Store 1 = Warehouse A
Department 110 – Hardware Department
Department 120 – Paint Department
Department 130 – Electrical Department
Store 2 = Warehouse B
Department 210 – Hardware Department
Department 220 – Paint Department
Department 230 – Electrical Department
Department 240 – Plumbing supplies Department
Store 3 = Warehouse C
Department 310 – Hardware Department
Department 320 – Paint Department
Department 340 - Plumbing supplies Department
Departments are identified based on a combination of the warehouse or location and the inventory item. Review the Creating New Warehouses > Associating Multiple Departments to Each Inventory Item section below for setup details.
This option applies when the department is associated with the inventory item or product and is not affected by the warehouse at all. Since the warehouse has no affect on the department, the department is set within the advanced tab of each inventory item. It is recommended that this option should be used if EBMS is set up with no departments or profit centers.
Location 1 = Warehouse A
Department 010 – Hardware Department
Department 020 – Paint Department
Department 030 – Electrical Department
Location 2 = Warehouse B
Department 010 – Hardware Department
Department 020 – Paint Department
Department 030 – Electrical Department
Department 040 – Plumbing supplies Department
Location 3 = Warehouse C
Department 010 – Hardware Department
Department 020 – Paint Department
Department 040 – Plumbing supplies Department
Notice that the departments are the same no matter where the inventory item is located. This method is also the most popular when warehouse settings identify service trucks or other smaller inventory locations. Review the Creating New Warehouses > Associating a Single Department to an Inventory Item section for setup details.