Stock Location and Weight

Inventory module> Reports> Reports List 

 Gives the bin location with weight, unit of measure and quantity on hand for each item in a list. 

 

 

 

 

 Group Code 

 If you have set up Group Codes for your inventory you can select a group code from the drop-down menu to define your search to a specific group. 

 

 

 Warehouse 

 

 If you select all warehouses the report will fetch data from all warehouses 

 If you want to search by a specific report, select the report on the warehouse selection 

 

 

 

 Brand 

 When working with multiple branches this drop-down allows the user to select a specific branch to pull a report for. 

 

 

 Make 

 Select the Make from the drop-down menu to refine your search for your report. 

 

 

 Model 

 Select the Model from the drop-down menu to refine your search for your report. 

 

 

 Sort By 

 Sort the report by selecting one option from the drop-down menu allows the user to pull a report that will be sorted by either, Code, Description, Warehouse or Bin location. 

 

 

 Decimal Places 

 

 It is advisable to set decimals to two places 

 You can view the report with any number of decimal places. 

 

 

 

 Active 

 this option will show active stock locations and weight only if selected 

 

 

 Show Qty On Hand 

 this option as well will show the quantity on hand only when selected 

 

 

 Show Zero 

 By ticking this box, a column will be added to show items with zero quantities 

 

 

 Show Cost 

 By ticking this box, a column will be added to show the cost of each inventory item 

 

 

 Show UOM 

 By ticking this box, a column will be added to show the unit of measure for each inventory item 

 

 

 Generate Button 

 

 Click the "Generate" button to open the report 

 You will have options to copy, email, or print the report 

 To view the report in an Excel document, copy the report and paste it into an Excel file