I am trying to write to the invoice line and invoice file using DAO recordsets with a linked table in Access. Although we have extracted and read lots of info...
Hi all, I'm still having a problem with this. My client has inserted invoice #16854 into Quickbooks by normal means. Then they deleted it. (Rather than void,...
I am trying to query the data out of the InvoiceLine table using the Txndate as the selection criteria into an Access database. I have linked the table in...
Hello Sir/Madam Please help me. I want to integrate crystal reports 8.5 with visual basic 6. I am unable to find any useful tutorials on the internet and also...
I'm trying to select a good set of software tools for my first QB SDK project. Alpha Five v6 gets some excellent reviews as a general database development tool...
927
Bocabeachguy
bocabeachguy@...
Nov 6, 2004 5:04 am
Welcome to QODBC and Quickbooks... nothing goes fast. Try using the TXNID >= something. I got better results with that Sure wish they had some better...
Hi all, Is there a need, since the SQL qODBC processes eventually is converted into SQL, to have to convert characters to html-style invocations? (e.g., &...
I need some help. I had the software working just fine before our sever went through a minor crisis. I am trying to resore qodbc, and I get this error: Error...
If you are going to create statements, better off using Crystal Reports to do it directly. You will still have some speed issues, but at least your data...
1. Run reboot.bat in \program files\intuit\quickbooks 2. If that doesn't work, see if rebooting the PC in safe mode, starting QB, then rebooting normally...
QuickBooks is based upon Avg costing, so there is no "storage" of costing information as you would expect with LIFO or FIFO. Running a sp_report on one of the...
I am sorry you are still having a problem. I just tested my advice/scenario again and it worked ok. I will repeat the steps: Insert an invoice programmatically...
We upgraded to Quickbooks Enterprise over the weekend. The QODBC driver no longer works and I get an error "ODBC-call failed". We were using QB Premiere and...
Thanks for the reply. However, this fix did not change things. Does it matter if I ran reboot.bat, and then worked in QB before I restarted in safe mode? The...
... costing ... sp_report on ... Profitablity ... Sorry, I'm confused. Are you saying the average cost of an item at the time it's sold is not recorded by QB?...
Internally it calculates based upon total number sold / total paid; hence "average costing"; it is not "stored" per se as you would when using LIFO or FIFO; in...
It is probably the DCOM servers that have become unregistered or their security reset. Follow the instructions at http://www.qodbc.com/QODBCweb.htm for setting...
Dave, I was checking back to see if there were any responses on your posting since I am interested in the same capabilities. I did use qlinker and it had...
Hi Chuck, ... - once ... We are so close! What I'd like to know is the average cost of an item at the time the invoice is posted (as you mention above). What...
My Excel application that uses QODBC has been working with Excel 2000 (from Office 2000), but recently Excel was updated to Excel 2003. Actually, the...
Sir I am getting this error on a client machine "Physical Database not found" I have already went through the following url and has done all the things that...
Patrick, QODBC does not support the Union statement. Can you not just make two recordsets and list them both in your report. What you asked for won't have ...
948
Bocabeachguy
bocabeachguy@...
Nov 21, 2004 11:07 am
just make two temporary tables, then use them in a union query ... From: ptrcktn To: qodbc@yahoogroups.com Sent: Wednesday, November 17, 2004 10:21 PM Subject:...
Hi, I've been trying to insert a transaction into receivepayment table without success when it's a payment in a different currency other than the home currency...
