Multiple Locations
Saturday, December 05th, 2009 | Author:

have two inventory locations and this is the way I handle it (there are probably other ways to do it too).

For each item I create a sub item which is titled to reflect the second location as an example:

Parent Item: widget
Sub Item: widget-A

where the “-A” tells me it is the second location.

When I buy inventory it is (in my case) received at my location so I bring it on the books under the parent item.

When I move some of the inventory to the second location I use the Inventory Adjust, mark it as a value adjustment. Then reduce the inventory quantity in the parent, at the bottom of the adjustment screen is the value of the adjustment, note that. Then increase the sub item by the same amount, and increase the sub item total value by the value you noted. This moves the quantity from one location to another and the expense of the adjustment zeros out since the reduction in one inventory item is offset by the increase of the other. I use the spoilage expense account for the adjustment, though since it zeros out any expense account could be used. The inventory quantities at each location for each item are easy to see in the item list.

When an item sells I use the widget item or the widget-A item depending on whether it sold from my location or the second location.