How can I track inventory in more than one location?

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.