Skip to main content

Inventory Transactions

Gives a total movement per inventory item by quantity or value for a specified date range.

Inventory module> Reports> Reports List

image.png

To generate the report, please select from the following fields:

Date From / To

Choose the date range for which you want to view the report from

Select a date range of when you want to see the datereport from on the menu drop down selection

to
Stock Type

SelectAllows theyou to select a stock type from the drop drop-down arrowMenu

Warehouse

SelectIf you select all warehouses the report will fetch data from all warehouses.
If you want to search by a specific warehouse, select the warehouse formfrom the drop down arrowmenu.

Stock Code From / To

SelectIf you leave the startstock item fields blank, all stock codeitems andwill be displayed on the endreport.

If you choose specific stock code foritems, the report will sort information by stock item code rather than description.

Select a stock Item on the drop-down menu.

Group Type

Select the group type and Date Type from the dropdrop-down downsmenu.

Sort By

Sort the report by selecting one option from the drop drop-down arrowmenu

Group Selection

Select a group selection on the drop drop-down menu

Employee

Select an employee you wish to filter the report by on the drop drop-down menu selection

Date To

Select the end date for the report

Document Type

Select the document type from the drop drop-down arrowmenu

Stock Selection

Select either a quality or value option for the report

Stock Code To

select the start stock code and the end stock code for the report

Date Type

Select a date type on the drop drop-down menu selection

Show Inactive Items

This option will show inactive items on the report if selected

Decimal Places

It is advisable to set decimals to two places

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

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, click copy on the report and past it into an Excel file