I want to set up a report criteria sheet in Excel. One of the criteria items would be the month to be pulled from QuickBooks. How can I setup a 'sp_report...
Hello, I'm new using QODBC. I'm programming in Delphi and using an ADO connection to QODBC. I'm sending information to quickbooks to create an Estimate....
Chuck Vigeant? Are you here as well? We are having quite a bit of success using QODBC to transfer QB ES data to an .opt file using Optimization and then...
Yep I am here Shea... I had partnered with FLEXquarters for three years leading up to the inclusion into Enterprise. I now consult with Intuit - and teach...
Hi. I have the latest versions of the driver and QuickBooks Enterprise 7. I use Access 2003. Pass Thru queries work just great until I try to restrict by...
Dates have a specific format requirement for being passed within the WHERE clause: {d'YYY-MM-DD'} So, you need to format your fiel as appropriate so that it...
I have been running a MS Access with Quickbooks Enterprise for awhile now pretty successfully. I have written customized queries and packing lists with it...
hi tim please post your extremely well researched question to our support forum at forum.qodbc.com for immediate action. we did have to make changes to the 8.0...
I am working remotely with an office in Tokyo. They have an installation of QuickBooks 7.0 and routinely enter addresses and names in Japanese with little...
Does anyone know the syntax for date fields on the where clause? I am trying to query this: "SELECT Top 10* FROM Customer where > '2008-12-22'" but it is...
you need something on the left side of the comparison, like this: "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'" to see the date format,...
Oh... my mistake on my copy-paste. Actaully it is like this "SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'" but it still gives me the same...
the date format can vary depending on the tool you are using, it should be listed in the SQL/ODBC syntax of your product documentation. or as i said last...
and again, I misspelled it.... it is "ModifiedTime". The problem still is cause by the operant ">" (or any) so I am thinking that the format is different....
the most common date format is this one: DateFrom = {d'2007-01-01'}, DateTo= {d'2008-01-01'} i found this by doing a search of our web support system from ...
Hi, I am Visual Basic developer using the UK vesion of QuickBooks Pro 2006 and QODBC to create reports and need to find which table in QuickBooks has the UK...
pretty sure thats in the company file - but the UK version lags behind in SDK support so you may have to upgrade your QuickBooks version to get that ...
UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003 Hi, I am running the "sp_report Txn List By Customer" in VB6 to create a list of monthly statements but...
I'm using the QODBC Server 9.0 Driver and trying to perform the following query. I have looked at it to long and need some else to look please help. Everytime...
terry, run the previous month report and save it to get the ending figures from that month. Our technical support system is best staffed by those who can help...
cory my guess is the comma inside the first field. Our technical support system is best staffed by those who can help with this question, please see the FAQ...
I've never seen that figure in a table. Perhaps you can run the Aging sp_report as of your end date and capture the customers from those results. (I have found...
yes - we included the sp_reports, and although they are somewhat difficult to reformat, being report images instead of tables, often they include information...
Try using {d'2009-05-31'} format on the TxnDate field. Robert Noche Diskmate Bookkeeping and Tax Services CTEC Registered Tax Preparer Certified Quickbooks Pro...
Hi, We are using the UK QuickBooks 2006 Pro version with a company data file that has multi-currency switched-on. Does anyone know if it's possible to use...
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.
