Exporting Data to Excel from your Free Purchase Order Software

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.

Export Any Table in PO Software

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s