Inventory Valuation
Inventory module> Reports> Reports List
Gives a report of all items cost, multiplied by quantity, to give the total value of stock. This can be given by warehouse, group codes and by various Work in Progress areas.
Inventory module> Reports> Reports List
| Work In Progress |
Select a work in progress document on the drop-down menu selection If you leave it on ALL report will display all work in progress documents |
| Sort By | Sort the report by selecting one option from the drop down arrow |
| Show Serials | Put a tick on to show serial numbers on the report |
| Warehouse | If you select all warehouses the report will fetch data from all warehouse If you want to search by a specific report, select the report on the warehouse selection |
| Sub Sort | Select the sort option from the drop down arrow |
| Show Zero | Put a tick on to show zero quantities |
| Show Inactive | Put a tick on to show inactive items |
| Stock Type | Select the stock type you wish to filter the report by |
| From Item | Select a from item on the drop down menu selection |
| Show Movement | Put a tick on to show movement |
| From Item | Select a from item on the drop down menu selection |
| Sum Fixed Assets | Put a tick on to sum fixed assests |
| Use Groups | Put a tick on to be able to use group codes |
| Summary | When selecting this option, the report will only show the group code on hand and total |
| Decimal Places | It is advisable to set decimals to two places You can view the report with any number of decimal places |
| Group Selection | Select a group selection on the drop down and move the group codes you wish to filter your report by to the selected window |
| 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 |