Add Note fields to Datasets

January 11, 2013

We can’t typically can’t add note fields directly to any dataset. This is because you usually can have more than a single note for order or po and WebQuery requires a one to one relationship between tables. What we have done to get around this issue with several of our customers is to write a…

Read More

Customer Mailing Lists

December 30, 2012

A customer recently requested the ability to quickly generate a customer mailing list out of WebQuery. Some of the necessary fields weren’t available in the existing Customer dataset. With just a couple minor field additions we were able to provide this customer the ability to generate this list of customers quickly.

Read More

Sales Not Showing Components

December 11, 2012

A recent customer request: I need to provide a report to our vendor using all the columns I have set up in my report example. However, I just discovered this report is not including Components on a Production order. How do I set up the parameters to include these items? We don’t include components in…

Read More

Serial Number Dataset

November 11, 2012

We just created a new dataset for a customer to show serial number information. This data set only contains invoice number, serial number, item number and customer id. We can’t provide sales metrics for this dataset. If you are interested in seeing this information let us know.

Read More