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

Exporting CSV files in 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

Adding Sales Goals

June 11, 2013

Viewing sales goals(budgets, targets) compared to actual sales or gm in WebQuery and Execukeys is a great way to utilize both of these applications. The Gas gauges in Execukeys are terrific for comparing actual $ to goal $. Informediate will need to do a little work in SQL to make this information available for viewing…

Read More

Rolling Sales Value Fields

April 30, 2013

By default most of you have the R12 fields in Inventory. These fields represent a rolling 12 months value from sales for that field, so R12 Sales would be last 12 months sales. What you may not know is that we can define these for any time period. We could provide you with R3 fields…

Read More

Price Book

February 11, 2013

We have had some success making price book information available for viewing in WebQuery for some of our P21 customers. This can be a very, very large dataset so there might be some limitations depending on the amount of data you have and server resources. Let us know if this is something you would like…

Read More

Lists to find what is missing

January 27, 2013

Sometimes you want a simple report that is just a comparison between two fields to see where you might be missing data such as all Suppliers and their assigned Buyers. Very often these are difficult to identify without knowing where to look in your ERP system. We can usually help you generate these reports within…

Read More