Aaron in California was looking for a report showing both the Base Unit of Measure as well as the Purchasing Unit of Measure for each item.

Since we don’t have a report like that, we pointed him to the following utility, where he can export his Item Master File (or any other data) to Excel, including whatever fields he needs…
– PURCHASING > Utility > Data Interfaces > Export any table

Aaron replied with “Yes this was helpful. I see how I can create an endless number of reports using this“, which got us thinking that this would be a good topic for a blog post.  Thanks for the inspiration, Aaron.

So while we put that utility under the “Interfaces” section (since it’s a “data extract” utility), by all means feel free to use Export Any Table for ad-hoc reporting if there’s something that you’re looking for that isn’t on one of the system’s 100+ built-in reports.