90 Day Stock Movement Report

90 Day Stock Movement Report



 

The following outlines the process to obtain a report on stock that has had no movement in the past 90 days.

 

From the 'Inventory' header, select 'Groups" from dropdown:

 


 


First under the 'Create Group' header, create a new group called 'Movement Check', make sure you tick the active box to activate your group.




Next we want to add items to this group.


Refresh this screen fully by going back to the top menu Inventory>Groups 


Once you've refreshed the screen your new group should appear in the dropdown list of groups at the bottom.




Select ‘all’ transaction types.

Select transactions older than ‘90 days’.

Add items to group ‘Movement Check’.

Check box to ‘Remove items from Existing Group’.

Click ‘Go’

 


The group will update with items that fit the specified selection:

You will receive a success message when items are added.

 


Now from the ‘Inventory’ list, select ‘Items’ from the dropdown:

 


 

 

Select the show items from the ‘Group’ called ‘Movement Check’ only:

 

This will list all stock that had had no transactions logged against them for the last 90 days. Click the ‘Export PDF’ button to export a pdf file:


 

 

 


    • Related Articles

    • Reports - Designing a Report

      If your system is licensed for IQanalytics Report Writer, you may design your own reports. For a more comprehensive guide on how to design Izenda report, please scroll down to the end of the article to download the attachment. *All credit to the ...

    • Reports - Data Sources (Views / Tables)

      If your system is licensed for IQanalytics Report Writer, you may design your own reports. In order to design reports, please refer to Knowledge Base Article here. Designing reports requires an understanding of the available data sources and their ...

    • IQ Standard Reports

      A brief walkthrough and explanation of standard reports included with IQ... Customer \ Customer Activity in Selected Period This report provides a list of ALL of your active customers showing Job activity in the selected date range. The sorting logic ...

    • Stock - Inventory Stock Sizes

      How to set up Stock sizes are created under Admin/Configuration: Inventory / Stock Sizes: This will open an admin screen listing all existing stock sizes: The ‘Search’ fieed can be used to search specific sizes: Click the ‘Edit’ icon to edit an ...

    • Syllabus IQanalytics Report Writing (Izenda)

      Download the attached PDF file for full list of fields