Stock valuation by location
MoneyWorks accounting software has a free plug-in, Multi-location, which allows you to track inventory from multiple locations, such as inventory in different warehouses, branches, or shops. In our earlier post, we explained how to print a Stocktake List report by the different location, which you have set up in the software. The Multi-locations plug-in adds a "location" extension behind the stock code such as "StockCode/A" or "StockCode/B" and also recorded the "location" in the Category 4 field of the item profile.
The Find by Field function at the Item list allows you to search items by location. For example, to have a product list for location "A", you can search for Category 4 containing "A". Once you have prepared the product list of the "location", highlight these items and print a Stock Valuation report (check the Highlighted Only checkbox in the report setting window).