I am working with Microsoft Access and trying to get my application to insert deposit information into the Deposit and DepositLine table. My previous version...
Are you trying to create a deposit for a customer in lieu of receiving a payment against an invoice? Please clarify. I have two suggestions: First try and...
Chuck, I am not trying to deposit against an invoice, just a plain deposit and make the sales entries at that time. I took your first suggestion and started...
Sorry for the error on the DepositTotal as being insertable. All transaction totals are non-insertable, as the line amount will automatically total up that...
I have a routine that successfully creates invoice in quickbooks from Microsoft Access/SQL Server with 1 or many lines. 2 questions Is is possible to add an...
I am trying to run the stored procedure sp_lastinsertid using powerbuilder 6.5. Below are the statements: string ls_tablename ls_tablename = 'billpaymentcheck'...
HAI This is sriniavas from corporate solutions one of our client looking for Oracle DBA Professionals. About client: Surgical Information Systems. SIS Health...
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...
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.
