Today the IRS has increase the standard mileage rate to .485 (an increase of .08 per mile) IR-2005-99, Sept. 9, 2005 WASHINGTON – The Internal Revenue...
Dear all Although I can successfully add transactions to my QB file using QODBC and visual basic I am struggling to add new accounts. Whatever I try I end up...
Well, having stuggled for ages at this and finally posted a message I then find the answer after taking a break and starting again. The minimum set of fields...
If you run the stored procedure sp_columns "Account" you will see that the columns Name and AccountType are required. And it will show you that FullName is...
I have a requirement to delete items from a Bill but cannot work out what table I need to delete the line items from. I have tried to delete items for a given...
BillItemLine should be the table. What error do you get? What version of QuickBooks? You probably need to do one line at a time and you cannot delete the last ...
Thanks for the prompt reply. I have managed to get the DELETE sorted, all I have to sort out now is the Bill creation with the entire bill allocated to...
This was just released today by the IRS and is an interesting approach to Donations. Partners Spread the Word on Leave-Donation Program IR-2005-113, Sept. 30,...
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 ...
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.
