Hi, I loaded up all the tables into Access and I don't see any way to relate customer info to an invoice. I'm trying to generate my own shipping labels and I...
OK, Got it: INNER JOIN on CUstomer Invoice.CustomerListRefID = Customer.ListID BTW, We could use access to the Other1 and Other2 fields on the invoice, too! ...
Mike, Invoice relates to Customer by the field CustomerRefListID. Use that field to find the invoices you need to print. Brad Waddell Product Manager, QODBC...
User defined files are on the way soon! brad ... Brad Waddell ** FLEXquarters.com LLC ** voice-mail/fax: 602-532-7019 Postal: 6965 El Camino Real Ste 105 #488...
It would be so very helpful for me, if the custom defined fields(maily from invoice lines) can be imported. lkallakuri. ... __________________________________ ...
Ever thought about joining or even visiting an Adult Nudist Community? We would imagine you have but some it is just not their style and that is ok but if you...
Hi all, Does anyone have any tips on what is the minimum permission level to configure in the Quickbooks company file that will still allow me to read...
That may have been a very realtive question. It appears that if you need to access other tables, that can change things as well. Anyway, for the purposes of...
Iam trying to insert a multi line invoice (that is:there are 3 invoice lines on an invoice). iam trying to follow exactly the same sql queries as given on...
Try adding the header information into the InvoiceLine table and complete the transaction on the third line and let me know how that works. brad ... Brad...
I try to locate all invoices for a particular customer. How would you recommend doing this ? I experience a 5 min wait time to look for invoices. My QB file is...
YES.That works. Thanks a lot. But i have a question now again. Is there a way of adding more invoice lines to the same invoice header again and again. That...
Yes, you can keep adding invoice lines to the same header until you save. The ability to modify an existing invoice is a brand new QuickBooks feature just...
To find invoices for a customer use CustomerRefListID. Several of the RefListID fields are optimized and perform better than partial searches on a field. Find...
We are planning to upscale our database to SQL Server from Access. Does QODBC support import of data into SQL Server directly? or do we need to use Access as...
Hello. I was just wondering if there was any progress on implementing the ability to query custom fields as part of the customer table. With each customer we...
We are trying out the 30 day trial software to see if this ODBC will be of use to us. Unfortunately, the programmer is trying to open up, for example, the bill...
If you use a date parameter to retrieve the data, it will only retrieve the subset you need. We are working on other fields that will produce the same...
The programmer should see the FAQ, which advises that the grid control in MS Access is incredibly slow at viewing data via any ODBC driver. If he will create...
Any word yet on whether the Other1 and Other2 fields from the invoice lines are supported in QODBC for QB2002 yet? Thanks, Michael Marinaro Gross, Mendelsohn,...
The list of tables does not change, you can see it in our schema document on the main qodbc.com web page. A feature to list tables via SELECT command is on the...
I saw a message about bill payments needing to be retrieved from both the tables check and billpaymentlinkedtxn, I'm using the r/w version of the 2003 driver...
Is there any way I can store barcodes in the ItemInventory table using QODBC or do I have to create a separate SQL table and relate it to the ItemInventory...
This is best served by using the sp_report sql statement. QODBC provides direct access to 95% of the report data that exists in Quickbooks i.e. Profit & Loss,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
