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

  Intended Audience This Knowledgebase Article is intended for all staff that have access to running Izenda Reports. Izenda Reports are usually used\designed to provide information based on a line report style output. An Izenda report may or may not ...

• Syllabus IQanalytics Report Writing (Izenda)

  Download the attached PDF file for full list of fields

• 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’ field can be used to search specific sizes: Click the ‘Edit’ icon to edit an ...