If you’ve ever stared at a mountain of data in a SYSPRO listview and thought, ‘There’s got to be a better way…’, this one is for you. Besides being a productivity booster, a data filter helps you zero in on exactly what you need without much work. Today, we’re going over how to filter a listview by column with a real-world example that’ll make you a SYSPRO filter pro in no time.
The Scenario
You’re working in the WIP Query program, querying for details about job 140. Specifically, you need material transactions for stock code B1209 because there’s a question about the quantity issued. Rather than searching endlessly, SYSPRO will filter the data so you can get straight to what you need in just a few clicks.
Step-by-Step: Adding a Data Filter to Your Listview
- Open the Listview
Head over to the WIP Query program (Work in Progress > WIP Query).- Enter 140 in the Job field and press Tab.
- Click on the Material Transactions tab to bring up the data you need.
- Right-Click for Options
Once your data is displayed, find the Stock Code column. Right-click on the header for a menu of options.
- Select “Filter by Column”
Click on this option and watch as a header row appears with a handy drop-down in each column.
- Pick Your Data Filter
In the Stock Code column, click the drop-down and select B1209. Your listview now displays only the rows you need. No more searching, no more headaches.
- Clear the Filter When Done
Need to go back to the full dataset? Simply deselect “Filter by Column,” and you’re back to where you were. - Exit the Program
Once you’ve got your answer, you can close out.
Why Should You Use Data Filters?
That old saying, ‘Time is money,’ is never truer when you’re knee-deep in data. Employees save an average of 3.6 hours weekly through automation, which includes data filtering processes like this one. SYSPRO’s filtering by column is more than a cool trick. It helps you find data faster, reduces errors, and keeps everything running smoothly. Plus, don’t you find it incredibly satisfying to watch rows of unnecessary info disappear with just a click? Just us? Alright.
Pro Tip
Filters aren’t just for stock codes. Whether you’re searching by date, amount, or any other column value, the process is exactly the same. This makes filters one of the most versatile tools in your SYSPRO toolkit.
So, give it a try! The next time you’re faced with a sea of data, use SYSPRO’s listview filter and shine a light on what you’re looking for. If you have questions on how you can optimize SYSPRO’s features and tools, don’t be shy and talk to us today.
