Article Contents
Introduction
The Movement Analytics page is a powerful tool that shows the complete movement history of items in your venue as they are:
Brought in via invoices
Moved between areas via transfers and
Removed via returns or depletions
Just select a time period, and filter by the following options:
Invoices
Transfers between areas
Returns
Depletions
By default, this data is sorted by year > month.
You can further refine what you want to see by using the search, or creating custom views to group and sort the data. Learn more here:
After refining your data, you can also export it to a spreadsheet if needed.
Note: This page shows the details of every action. The Invoices / Returns, Depletions, and Returns pages on the WISK Web Portal each have an "Analytics" tab that filters to only show those specific actions.
Viewing Item Data Example - Invoices
A common use of this page is to see how much of an item you’ve ordered over a period of time.
In the example below, we’ll check to see how much Grey Goose 750ml we’ve ordered so far in the current year.
Note: This number is based on your invoices, so make sure that you are every invoice to WISK.
Under “Reports / Analytics” click “Movement Analytics”
By default, it displays all movements for all items in the venue for the current year. You can use the search bar to find a specific item, or you can create custom grouping to show individual items
Click into the “Date Range” field to select a time period from the drop-down menu. There are a variety of options, but you can also set a custom range
At this point, it shows all types of movements. Select a movement type from the “Predefined Filters” drop-down to narrow it down. In this example, we’ll select Invoices
Note: You can only filter by movement types that exist in the venue. For example, if you haven’t created any returns they won’t appear as a filter option
All movements of the selected type display. In this example, we can see every invoice we added for the item, along with the total dollar value and number of units ordered (Displayed in the Item Total, and Line Measurement columns).
Export Data to Spreadsheet
At any time, you can export the information that is currently displaying in the table by clicking the "Export" icon.
This is a quick way to see your invoices and the amount spent on all items in the current year, but doesn’t provide the same flexibility as the page.
Other Uses
There are countless ways to manipulate and display the data on this page. Through use of custom views and even custom fields, you can create your own custom reports.
Some examples include:
Amount spent on orders to a specific distributor or all distributors / suppliers over a period of time
A full record of transfers in your venue from area to area
Learn more: