So, I wrote a slick app to pull web orders and put the customer information into the Customer table. My clients has about 3500 records in the client table. My...
My company allows people to prepay for ad insertions in a newspaper. We accept, for example, $100 for four $25 insertions. I am trying to write a script that...
I am creating an interface to QuickBooks 2005 using QODBC where my application is the primary source of Vendor and Customer information. To be complete, I also...
Hi All- Hopefully someone can help me with this. I need to do multiple updates on the Customer table. In my code, when I run it it only processes 1 of X update...
I need to input about 600 invoices in QBOE and am trying to find a way to import the invoices. QODBC seems to be the only addin avaialble. Any advice on using...
If you have programming experience and SQL knowledge you can write some code to do this. Otherwise our office specializes in this type of job. Chuck Vigeant...
Here is a sample procedure for applying credits/payments to an invoice: CustomerRefListID = '790000-1071511999' (Required) DepositToAccountRefListID =...
Are you doing an querying of the table to see if it exists before hand? How large is the database file in total? How long does it take using VBDemo and a...
It is a limitation of the Intuit SDK at this time. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters solutions ...
What we do is try to update a Customer record, if it fails to find the customer, we run an INSERT, if it finds the Customer in the DB, thats when we attempt to...
Matt, When do the update, specify the FullName in the WHERE statement. If you specify just name then QuickBooks will send the entire list of 3500 names to ...
Ahh interesting! Right now what happens is I run an update query and use the WHERE argument Name = 'blah' ....will what you suggest still be successful if I...
Look at the schema at www.qodbc.com/schema It will show you the jumpins.. Fullname is a jumpin, name is not Chuck Vigeant M.Ed. MCSE, CCNA, Certified...
Matt, Sure, FullName is unique, Name is not, but as long as FullName is in the WHERE statement it will use it. If you use jobs you can duplicate Names under a...
I'm trying to include the ability to insert an ItemGroup record into the SalesOrder. We are able to insert items from ItemInventory, but am having trouble with...
The totalamount is calculated by QB, so you cannot insert that field. Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters...
I tried removing the totalamount from the itemgroupline, but I'm still getting the same error. Here are my new insert statements: INSERT INTO SalesOrderLine...
I run a batch sql statment for my inserts into quickbooks, only I've yet to be able to insert new invoices. I'm not sure what I'm doing wrong, any help would...
hi guys! i'm inserting a record in InvoiceLine, but i can't find where or what field does quickbooks save the Sales Order Number. I looked up the columns of...
To create and invoice you must create at least one invoice line. You do this using the InvoiceLine table. If you need include more than one line on the invoice...
Eric, Sorry Eric QODBC does not support the SONumber field. QODBC uses the Intuit SDK and they have not offered that functionality. You could create a Custom ...
Matt, Thanks for the information, and i am going to do what you have suggested. Thanks a lot. eric Matt Froncek <matt@...> wrote: Eric, Sorry Eric QODBC...
I just bought this product today and am impressed with how easy it is to use --- I did the entire set up and when testing the append to the Invoice Line table...
See FAQ at: http://www.qodbc.com/QODBCAutoFAQ.htm?faq_id=27 <http://www.qodbc.com/QODBCAutoFAQ.htm?faq_id=27&category_id=1> &category_id=1 Run the SQL: ...
Thanks for the help. only I'm still having some minor difficulties. My insert statement seams to be working but I do not see any data in Quickbooks(I made...
Set the FQSaveToCache to False and see if it makes it to Quickbooks --- that's all I needed to do.. Eileen Murphy epmConsulting, Inc. cell/voice mail:...
On the last line you insert into the invoiceline table set the FQSaveToCache = 0. If you only have one line, set it to 0. If it would make coding easier you...
You're very welcome. _____ From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of bnr1900 Sent: Tuesday, November 08, 2005 12:16 PM To:...
I have a speed problem with QODBC, and would be grateful for any pointers on how to improve things. I've read the FAQ entry on this, and it doesn't seem to be...
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.
