Let me explain what happens in QB when you import beginning balances, as it is much different than Peachtree. Peachtree allows you to create beginning balances...
This site just might make you blush. We don't and won't restrict your viewing pleasure. But the content just make you check over your shoulder to see who is...
I'm looking for some hot erotic fun! Are you up to it? If so meet me here http://www.altsexfinder.com/landing.asp?afl=FYHO If you ever want to chat sometime...
We have around 2000 customers on file to be imported. Any Suggestions? Thanks Lakshmi ... __________________________________ Do you Yahoo!? The New Yahoo!...
You did not answer my questions, so I can't help much further, other than to tell you we did find a speed problem which we are solving in the next build #50,...
Does anyone have any experience with QODBC and the Quick Books Enterprise ver 3? Is it supported? I have an access 2000 app that needs to access the...
Jim, QODBC works well with QuickBooks Enterprise 3. Please let us know if you have any other questions. brad ... Brad Waddell ** FLEXquarters.com LLC **...
I want to build a web server based application that will run on my intra-net. I want to "share" my qbooks client name address and job information with this...
Jack, Review this web page for details on the web version of our product: http://www.qodbc.com/docs/webtest/ Basically, QuickBooks can be running on the web...
Does anyone know if QB tracks a link between estimates and the invoices they are converted too? I don't see it in the schema but would be very helpful. Fred...
I believe that the two user fields should have been available in build 46. I have just downloaded the most recent build and the Other1 and Other2 fields still...
They are called CustomFieldOther, CustomFieldInvoiceLineOther1, CustomFieldInvoiceLine2, CustomFieldInvoiceLineGroupOther1, CustomFieldInvoiceLineGroupOther2,...
I am using Crystal 8.5 and the InvoiceLines table. I have the debug panel active and it seems to be getting stuck on InvoiceLine, Find First Record. Any...
You are probably selecting too large a recordset and the XML parser if running out of memory. Limit your select statement by a date range if possible: SELECT *...
Thanks for the reply Matt, I have tried using a month date range (5/1/05-5/31/03) and it seems to go through the Connecting to Quickbooks and XML Parse step...
What field did you limit? Can you include your SQL statement here? This table shows which fields will limit the list returned from QB to QODBC. The Customer...
Michael, Are the user defined fields setup in your QuickBooks data? They will only show up when they are defined. Also make sure you have updated QuickBooks ...
I believe we are talking about two different things. I am using QB 2002 in which there is an Other 1 and Other 2 field in the Invoice Line template. These...
Hey Matt, I'm restricting the TxnDate field using the Record Selection Formula inside of Crystal. I can read small tables such as the Customer masterfile...
Hello: I am using the "sp_report OpenInvoices.." for pulling up the report. Has anyone used this SQL STATEMENT in 3rd party application like ASP or COlD FUSION...
Kunal, I don't think there is an option to resort the results of QuickBooks pass-thru reports, though it's a pretty good idea. I would expect it would be easy...
Mike, Here is a quote from Intuit, basically the feature you want is in QuickBooks 2003 and higher: Because QB 2002 cannot process SDK 2.0 messages, there is...
When you use the "Select Expert" to create a selection formula, Crystal creates its own SQL statement to extract the data. Therefore using a Crystal Query...
I am an accountant with an accounting program in Access which I want to develop into an audit program. I have also decided to learn in depth just 2 commercial...
I would like to thank Data Access Worldwide - Asia Pacific for their reply. Australian, Singapore and NZ versions of QB, and QODBC, can read each other's...
When I first set QODBC up, it would attach to the company file, albeit slowly, without QB being open - you know the integrated application bit. Now it doesn't...
I am trying to Insert Into the Charge table and place in the RefNumber field a unique reference number. The Append Query in Access 2000 looks good and the...
Is there any way i can open an existing invoice and add more lines to it using QODBC instead of creating a new invoice again? Any help is greatly appreciated. ...
Lakshmi, Modification to invoices is coming soon, not available yet, as it was recently added feature of QuickBooks SDK. thanks! brad ... Brad Waddell **...
Brad: Thanks a lot for the prompt reply.That would be so wonderful for me if i can edit/add to existing invoice. That will really help us in our current ...