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...
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...
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...
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...
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...
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...
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. 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...
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...
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....
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 all. First post here. Is there a way to pull a Profit and Loss Standard report in Collapse mode using the QODBC driver? I can't seem to figure it out. ...
Dear members, I would appreciate any feedback of this portable Receipt scanner from <http://www.eztools.biz> www.eztools.biz. I like it since it also scans ...
Hi! Quick question that I thought I could find either at qdeveloper.com or qodbc.com.au, which seem to be more active but also seem to be down right now. I'm...
I have a VB.NET application that "select * from <table> " succesfully from all the QBOE tables EXCEPT (Invoice, InvoiceLine, InvoiceLinkedTxn). I am using the...
Hi, I have to Udpate all the accounts number of Chart of Accounts. Even do I'm Using QODBC Read/Write I can not update any account and I do not know why, I...
This doesn't work: SELECT * FROM Item WHERE Type != 'ItemService' This does work: SELECT * FROM Item WHERE Type = 'ItemService' Am I building this query wrong?...
A client of mine purchased a QODBC license for V. 6 Read/Write in August of 2006. They never installed and the secretary never notified me until today that...
Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an error when m odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when the item...
I am using the QODBC driver that comes with QB Enterprise. I'm trying to automate the process for an unattended operation. I have assigned the specific...
We are preparing to import Bills from our MS SQL 2000 database into Quickbooks via QODBC. We have observed that, when a bill is created within Quickbooks it...
Hi All How to create customized Field in ItemService Table and QB and how how to insert data into these fields using INSERT QUERY If anybody knows this pls...
Does anyone know why this field would have IsPaid = False but in QuickBooks, this transaction shows as a fully paid bill? [Non-text portions of this message...
We are using multi-currency database in QuickBooks Enterprise 2004 - Canadian Edition. We are printing GL Transaction Detail by Account report in QuickBooks,...
Hi, I Created a Report in Crystal Report 10, I add two commands in our Reorts. When I use records from Command_1 my Report working normaly then I use a record...
Hello Group, Having a little problem getting a field to show up in a customer OPEN INVOICE report. The field I need printed or exported in the report is found...
whats the proper seguece for inserting journal entries? I have a debit entry and two credit enteries for one transactions. Do I need to enter a record into the...
Having problems with message search?
