Can I connect to both Qube and QODBC within one spreadsheet? For example, have Qube reports on one sheet and QODBC control sheet information in another? There are some user-defined fields used in the customer list that I need access to in order to perform a calculation and I don't see those fields in Qube.
Thanks for any thoughts!
All of the custom fields are available in QQube, and in fact we have everything that the QODBC driver has, PLUS some additional features from Enterprise that QODBC does not contain e.g. forecasts, serial/lot numbers, etc. In fact, we have more field information available in QQube than any type of extraction tool on the planet.
If you are using the Excel Add-In click on More Fields: https://clearify.com/wiki/view/117/selecting-your-fields
And for a complete of available fields I would browse the Wikis on Subject Schemas: https://clearify.com/wiki/view/163/qqube-schema-for-quickbooks-desktop
Here is a sample of the sales subject: https://clearify.com/wiki/view/218/sales
Remember that custom fields are extracted as text. Here is everything you need to know about custom fields https://clearify.com/wiki/view/201/custom-fields
Thanks for your detailed response! I cannot find the custom field information. I don't have a Custom LookUp Subject. I also have limited customer information, even when I select "more fields" at the top.
I found my issue. For some reason, I had to click the More Fields and Less Field a few times. Eventually the additional customer fields appeared.
Thanks for the help!
Choose a location