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...
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:...
947
Matt Froncek
matt_froncek
Nov 19, 2004 12:34 pm
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 ...
946
ptrcktn
Nov 19, 2004 10:17 am
Hi, Is it possible to use sql UNION statements in QODBC? For example, how do i execute the following sql statement using QODBC? SELECT...
945
Steven R. Hinds
quickbooksqb...
Nov 19, 2004 10:17 am
The new mileage rate effective 2005 $.405 up from 2004 by .03 (.375), see IRS News Release IR-2004-139 issued November 17th at: ...
944
Chuck Vigeant
txbtech
Nov 12, 2004 12:50 am
Look at your iteminventory or itemassembly "tables" Chuck Vigeant M.Ed. MCSE, CCNA, Certified QuickBooks ProAdvisor Director, FLEXquarters solutions ...
943
Michael Warne
mydevelopmen...
Nov 12, 2004 12:11 am
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...
942
jackspellman
Nov 12, 2004 12:11 am
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...
941
ffierling
Nov 12, 2004 12:10 am
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...
940
jimk7577
Nov 9, 2004 6:24 pm
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...
939
Matt Froncek
matt_froncek
Nov 9, 2004 4:44 am
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...
938
Chuck Vigeant
txbtech
Nov 9, 2004 1:07 am
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...
937
ffierling
Nov 9, 2004 12:17 am
... 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?...
936
Robert Weis
robbie2e
Nov 9, 2004 12:16 am
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...
935
bigelow_tx
Nov 8, 2004 7:38 pm
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...
934
Chuck Vigeant
txbtech
Nov 8, 2004 4:13 am
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...
933
Chuck Vigeant
txbtech
Nov 8, 2004 3:49 am
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...
932
Chuck Vigeant
txbtech
Nov 8, 2004 3:35 am
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...
931
Chuck Vigeant
txbtech
Nov 8, 2004 2:53 am
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...
930
robbie2e
Nov 6, 2004 5:06 am
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...
929
ffierling
Nov 6, 2004 5:06 am
What field holds the cost at the time an inventory assembly item is sold?...
928
d. Taylor Singletary
graysweaters
Nov 6, 2004 5:06 am
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., &...
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...
926
saintdv
Nov 5, 2004 2:04 am
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...
925
Steven Deetz
sjdeetz
Nov 4, 2004 7:51 pm
I have had very good success using querys based on tables to append information into QuickBooks. I have done this with the Charge, ReceivePayment,...
924
Michael Warne
mydevelopmen...
Nov 4, 2004 4:57 pm
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...
923
geller090598@...
baton_rouge_...
Nov 4, 2004 4:54 pm
Can somebody help me out with this problem. Here is my connection string for QODBC: OdbcCnn = New OdbcConnection("DRIVER={QODBC Driver for ...
922
esjr0969
Nov 4, 2004 4:54 pm
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...
921
d. Taylor Singletary
graysweaters
Nov 4, 2004 4:53 pm
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,...
920
cwalker1767
Nov 4, 2004 4:53 pm
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...
