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!
Josh
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: Selecting Your Fields using the Excel Add-In
And for a complete of available fields I would browse the Wikis on Data Model Schemas: QuickBooks Desktop Data Schemas
Here is a sample of the sales data model: QQube Sales Details for QuickBooks
Remember that custom fields are extracted as text. Here is everything you need to know about custom fields: QuickBooks Custom Fields in QQube
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.
Any thoughts?
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
Forum :
Your session has expired. You are being logged out.