Locations table

The Locations table is used when the company has goods in different places or to keep track of incoming goods, goods to be shipped, etc. (see virtual warehouses below). You can also use locations to know if you have given goods on consignment, loan, or for other purposes.

In order to take into account the total number of items in and out of all inventories, by entering the ID for the locations in the Transactions table, in the columns Location and Transfer all the values of the items are known, also for a single warehouse and the relative movements.

Refer to the Transactions table for further information.

Places table columns

• RowId
  Identification of the location where the inventory is located.
• Description
  Name of the location where the inventory is located.
• Notes
  You can insert text for notes.

Locations and Virtual Warehouses

The Locations table is used to indicate where the warehouses are located, including virtual ones.

You can also set up virtual warehouses to keep track of orders or other purposes. For example:

• To Ship
  For ordered products waiting to be shipped.
• To Pick Up
  Products the customer needs to collect.
• To Reserve
  Waiting for the customer to decide whether to place the order.
• Incoming
  Products that have been ordered from the supplier and are awaiting arrival.
• Returns
  Products the customer has indicated they want to return.
• Trial
  Products provided to customers for testing, which have not yet been sold.

By using virtual locations, you can also manage more complex workflows, for example simulating that goods are in production, quality control, etc. See Advanced features.