Inventory By Customer Dataset

Comments Off by in Business Intelligence, WebQuery
January 26, 2016

A new dataset has been added to WebQuery for P21 called Inventory by Customer. This will allow you to create inventory reports using customer partnumber and customer names. The dataset includes calculated fields such as last sales date, last purchase date, last xfer to/from date, last production order date. If you are interesting in this…

Read More

Customer Freight

Comments Off by in Business Intelligence, WebQuery
April 16, 2014

Currently you may or may not be able to get customer freight information in Sales. In the sales dataset you can only get freight line information and none of the specific header freight fields. We have a new data set just added which has freight in/out are tracked along with Invoice data. Please let us…

Read More

Price Library Dataset

Comments Off by in Business Intelligence, WebQuery
April 10, 2014

Price library has consistently been one of the most requested datasets. We do have a price library dataset but it is not a one size fits all solution and can’t just be given as part of our core datasets. The volume of data that needs combined to create this dataset is pretty significant which means…

Read More

Tackling Tough Reporting Needs

Comments Off by in Business Intelligence, WebQuery
August 8, 2013

Here is a fresh example of how we can help our customers tackle their tough reporting needs. Did you know that WebQuery can report on data from multiple databases and can pull data from just about any MS-SQL or MySQL database? We recently did a special project for one of our industrial supply customers who…

Read More

Inventory Aging Buckets

Comments Off by in Business Intelligence, Execukeys, WebQuery
July 11, 2013

We defined a new excess inventory calculation as anything not bought, sold or setup as new in the last 12 months for a customer recently. At his request we took this a step further and defined excess “aging buckets” The buckets consisted of assigning a flag to each item/ location that had not had any…

Read More

Exporting CSV files in WebQuery

Comments Off by in Business Intelligence, WebQuery
July 11, 2013

Many of you have to provide CSV files to outside sources for things like reports to vendors such as Parker Store, 3M, Eaton, Kennametal, Iscar reports, or any of the many others. Some provide CSV files to meet requirements for banking reports. Some even provide CSV files to other outside consultants for further manipulation or…

Read More