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...
1326
Ana Maria Gonzalez
ana_glez_oro
Aug 5, 2007 8:33 am
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....
1327
sheaschultze
Aug 5, 2007 8:34 am
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...
1328
patrickplc
Aug 5, 2007 8:35 am
I have historical data that need to be recreated in Quickbooks Pro. Would appreciate any advice if the above can be automated with QODBC and HOW....
1329
Chuck Vigeant
accountigrate
Aug 5, 2007 9:11 pm
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...
1330
sheaschultze
Sep 15, 2007 6:07 pm
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...
1331
Rod Lewis
ddprlewis
Sep 17, 2007 1:47 pm
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...
1332
avalon_acres_farms
avalon_acres...
Jan 31, 2008 9:20 am
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...
1333
Brad Waddell
flexq
Jan 31, 2008 10:34 am
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...
1334
d_coltrin
Apr 11, 2008 8:45 pm
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...
1335
Dan
gsystemscorp
Jun 6, 2008 7:48 am
Hello, Will the current version of QODBC (8) work with QuickBooks version 5? Thanks, Dan...
1336
Brad Waddell
flexq
Jun 6, 2008 8:25 am
QuickBooks versions 2002 and higher support add-on products like QODBC, i think version 5 is from around 1998. brad...
1337
sjdeetz
Oct 13, 2008 8:37 pm
A client of mine just upgraded from Office 2000 to Office 2003. In my application the user will run a deposit routine that posts to the Deposit and...
1338
Robert
rob_jurado
Dec 24, 2008 6:57 pm
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...
1339
Brad
flexq
Dec 24, 2008 7:12 pm
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,...
1340
Robert
rob_jurado
Dec 24, 2008 7:50 pm
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...
1341
Brad
flexq
Dec 24, 2008 7:51 pm
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...
1342
Robert
rob_jurado
Dec 24, 2008 7:54 pm
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....
1343
Brad
flexq
Dec 24, 2008 7:57 pm
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 ...
1344
twarwick1
Apr 23, 2009 12:37 pm
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...
1345
Brad
flexq
Apr 23, 2009 12:42 pm
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 ...
1346
twarwick1
Jun 13, 2009 9:05 am
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...
1347
lkside79
Jun 13, 2009 9:06 am
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...
1348
Brad
flexq
Jun 13, 2009 9:21 am
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...
1349
Brad
flexq
Jun 13, 2009 9:22 am
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...
1350
sheaschultze
Jun 13, 2009 4:27 pm
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...
1351
Brad
flexq
Jun 13, 2009 4:35 pm
yes - we included the sp_reports, and although they are somewhat difficult to reformat, being report images instead of tables, often they include information...
1352
Robert Noche
rnoche
Jun 14, 2009 5:36 am
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...
1353
twarwick1
Jul 3, 2009 9:34 am
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...
1354
Chuck Vigeant
accountigrate
Jul 3, 2009 7:45 pm
... Not possible... and probably good that it isn't... too many ramifications if that happened in error....
