The best way to track inventory in multiple locations in Sage 50—Edition is to set up inventory items by location. See below for an example
Scenario:
Company operates two retail stores. They would like to track inventory in each store separately so they know how much stock in each store and also cost/sales of items by store
Solution:
- Option I: Create a master stock item with substock items per location. Include the store name or number on the substock item.
- Option 2: Create stock items for each store separately. When creating the item ID, include a store name or number so it is easy to identify which store the item is in:
-
- Widget-store 1
- Widget-store 2
- In the location field on the Inventory Item record, enter the store name or number
- When making a purchase or a sale, take care to select the item from the correct store.
- To see the sales and purchases of each store separately on the financial reports, create separate general ledger accounts for each store. See Article ID 11876: DocLink: How to create general ledger (GL) accounts.
-
- Sales - Store 1: 40000-01
- Sales - Store 2: 40000-02
You can also use the account segments to further customize the financial reports. See Article ID 10325: DocLink: How do I set up account segments?.
There are also third-party add-on applications for Sage 50 that offer multiple location or warehouse tracking capability. These add-on programs are listed on the Sage Partner Solution Source.