Inventory By Customer Dataset

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

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

FlashReview 2.0

April 15, 2014

FlashReview version 2.0 has been released and has some great new features. For administration, entering individual user filters has been both expanded and simplified. Admins can quickly set both global and individual users content. Individual users can now actively filter their own FlashReview pages by branch, customer, vendor, product group, item or salesrep. Individual users…

Read More

Price Library Dataset

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

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

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