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 |
No Comments