Addressing inaccuracies by location on Inventory value report


 

If you have multiple locations and use FIFO or LIFO inventory costing, the numbers on the Inventory value report (Operations Menu > Reports > Inventory > Inventory Value) will be correct if Total only is selected for the Location filter--but inaccurate when filtered for an individual location or All locations. The reason is that the first (or last) item purchased may not be the one sold from a given location.

 

Enabling Always Use Average Costs for Cost by Location (under Settings > Inventory Settings) allows viewing the value of the inventory at each location (average value per item x number of items at that location) while still using FIFO accounting overall.

 

Was this information helpful?
-