I want to set up a report criteria sheet in Excel. One of the criteria
items would be the month to be pulled from QuickBooks.

How can I setup a 'sp_report ProfitAndLossStandard' query (or any
sp_report query) to have the 'DateFrom' and 'DateTo' parameters look to
the value of a cell or cells to get the data rather than having to
manually modify the query in MS Query?

Thanks!

--
Bronson

You can't do this directly with the parameters available for this
report, however if you notice, a collapsed profit and loss report is
nothing more than level 0 accounts - some with children returning
"total...." plus the account name and amount; and some without
children returning just the account name and amount.

Chuck Vigeant



--- In qodbc@yahoogroups.com, "oreganoinvestments" <lutzb@...> wrote:
>
> Have you tried this....
>
> sp_report ProfitAndLossStandard show Amount_Title, Text, Label, Amount
> parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy
> = 'TotalOnly'
>
> Bernie
>

Have you tried this....

sp_report ProfitAndLossStandard show Amount_Title, Text, Label, Amount
parameters DateMacro = 'ThisMonthToDate', SummarizeColumnsBy
= 'TotalOnly'

Bernie

did you try the financial statement designer

Jeff Siegel
Siegel & Stacey LLC
1601 Trapelo Rd
Waltham MA 02451
781 487 7000
Sent from a Verizon Treo

-----Original Message-----

From:  "loosegroove2000" <bronson.elliott@...>
Subj:  [qodbc] Profit and Loss Report in Collapse mode
Date:  Sat Jun 2, 2007 4:01 pm
Size:  183 bytes
To:  "qodbc@yahoogroups.com" <qodbc@yahoogroups.com>

Hello all.  First post here.

Is there a way to pull a Profit and Loss Standard report in Collapse
mode using the QODBC driver?  I can't seem to figure it out.

--
Bronson

Hello all.  First post here.

Is there a way to pull a Profit and Loss Standard report in Collapse
mode using the QODBC driver?  I can't seem to figure it out.

--
Bronson

Dear members,

I would appreciate any feedback of this portable Receipt scanner from
<http://www.eztools.biz> www.eztools.biz. I like it since it also scans
business cards and regular size documents, but has anyone had any experience
with scanning  Receipts with Quickbooks?

Can't  go wrong for the price since it does a lot, but does it export the
information to QuickBooks better or some other financial software?  Any
feedback I would appreciate it, for I like to make this work with one
financial software (claims works with all) for I would like to offer it as a
package to recommend to my customers.

Thanks in advance,

Blake





[Non-text portions of this message have been removed]

Hi!

Quick question that I thought I could find either at qdeveloper.com or
qodbc.com.au, which seem to be more active but also seem to be down
right now.

I'm trying to re-write the following in a more straightforward manner:

sp_report BalanceSheetDetail show ClearedStatus, RowData, Amount where
ClearedStatus in ('Cleared','NotCleared') or ClearedStatus is NULL

Seems like the following should work but it doesn't:

sp_report BalanceSheetDetail show ClearedStatus, RowData, Amount where
ClearedStatus in ('Cleared','NotCleared',NULL)

When I try the latter I get a "Value in an IN expression must be a
simple value" error.

Thanks in Advance

limit by date range so the result set can fit under the 1000 transaction
limit imposed by QBOE.

At 07:08 PM 03/22/2007 +0000, you wrote:

>Version 7.00.00.207
>Evaluation Copy
>
>SELECT COUNT(*) FROM INVOICE
>
>returns
>
>0
>
>--- In <mailto:qodbc%40yahoogroups.com>qodbc@yahoogroups.com, "Matt
>Froncek" <matt@...> wrote:
> >
> > Kevin,
> >
> >
> >
> > That should be handled correctly inside the driver if you have the
>version
> > 7.x driver. It is free to download the most current evaluation. The
>only
> > time you have to pay an upgrade is when you upgrade your version of
> > QuickBooks as then you will be using the newer features of the SDK
>inside of
> > QODBC.
> >
> >
> >
> > Thanks,
> >
> > Matt Froncek
> > QODBC Development Support / FLEXquarters.com LLC Consultant
> > QODBC Driver for QuickBooks - Unleash your data at
><<http://www.qodbc.com/>http://www.qodbc.com/>
> > www.qodbc.com
> >
> >
> >
> > _____
> >
> > From: <mailto:qodbc%40yahoogroups.com>qodbc@yahoogroups.com
> [mailto:qodbc@yahoogroups.com] On
>Behalf Of
> > odakcm
> > Sent: Thursday, March 22, 2007 11:26 AM
> > To: <mailto:qodbc%40yahoogroups.com>qodbc@yahoogroups.com
> > Subject: [qodbc] Re: SELECT * FROM INVOICE Fails via
>ADODB.Connection
> >
> >
> >
> > Thanks for the replies. I understand I am running into the QBOE
>1000
> > row result set limit.
> >
> > I could break up the select into groups of < 1000, but first I need
> > to know some ranges. In my testing any aggregate call fails because
> > of > 1000.
> >
> > So select count(*) from Invoice
> > or select max(TxnNumber) from Invoice both fail.
> >
> > What strategy can I use to divide and conquer the Selects?
> >
> > Thanks
> >
> > --- In qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com>
>com, "odakcm"
> > <kevin@> wrote:
> > >
> > > I have a VB.NET application that "select * from <table> "
> > succesfully
> > > from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
> > > InvoiceLinkedTxn).
> > >
> > > I am using the following code. Does anyone know what is wrong
>with
> > > this for these tables? Also the VB Demo app does not return
>values
> > > for Invoice
> > >
> > > Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
> > > Security=SSPI;DATABASE=yyy"
> > > Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
> > >
> > > Dim oConnection As ADODB.Connection
> > > Dim oRecordset As ADODB.Recordset
> > >
> > > Sub Main()
> > >
> > > Dim sSQL As String
> > > Try
> > >
> > > oConnection = New ADODB.Connection
> > > oRecordset = New ADODB.Recordset
> > >
> > > oRecordset.CursorLocation =
> > > ADODB.CursorLocationEnum.adUseServer
> > > oRecordset.CursorType =
> > ADODB.CursorTypeEnum.adOpenStatic
> > >
> > > oConnection.Open(sConnectString)
> > >
> > > sSQL = "SELECT * FROM " + sTableName
> > > oRecordset.Open(sSQL, oConnection) ' Failure
> > >
> > > Exception: System.Runtime.InteropServices.COMException
> > (0x80040E21):
> > > ODBC driver does not support the requested properties.
> > > at ADODB.RecordsetClass.Open(Object Source, Object
> > > ActiveConnection, CursorTypeEnum CursorType
> > > , LockTypeEnum LockType, Int32 Options)
> > >
> > > any help is appreciated
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>


QODBC Driver for Quickbooks - Interactive QuickBooks data solutions at
http://qodbc.com
     ** Now included in QuickBooks Enterprise Edition! **
Brad Waddell ** FLEXquarters.com LLC ** voice-mail/fax: 703-935-7647

Version 7.00.00.207
Evaluation Copy

SELECT COUNT(*) FROM INVOICE

returns

0

--- In qodbc@yahoogroups.com, "Matt Froncek" <matt@...> wrote:
>
> Kevin,
>
>
>
> That should be handled correctly inside the driver if you have the
version
> 7.x driver. It is free to download the most current evaluation. The
only
> time you have to pay an upgrade is when you upgrade your version of
> QuickBooks as then you will be using the newer features of the SDK
inside of
> QODBC.
>
>
>
> Thanks,
>
> Matt Froncek
> QODBC Development Support / FLEXquarters.com LLC Consultant
> QODBC Driver for QuickBooks - Unleash your data at
<http://www.qodbc.com/>
> www.qodbc.com
>
>
>
>   _____
>
> From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On
Behalf Of
> odakcm
> Sent: Thursday, March 22, 2007 11:26 AM
> To: qodbc@yahoogroups.com
> Subject: [qodbc] Re: SELECT * FROM INVOICE Fails via
ADODB.Connection
>
>
>
> Thanks for the replies. I understand I am running into the QBOE
1000
> row result set limit.
>
> I could break up the select into groups of < 1000, but first I need
> to know some ranges. In my testing any aggregate call fails because
> of > 1000.
>
> So select count(*) from Invoice
> or select max(TxnNumber) from Invoice both fail.
>
> What strategy can I use to divide and conquer the Selects?
>
> Thanks
>
> --- In qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com>
com, "odakcm"
> <kevin@> wrote:
> >
> > I have a VB.NET application that "select * from <table> "
> succesfully
> > from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
> > InvoiceLinkedTxn).
> >
> > I am using the following code. Does anyone know what is wrong
with
> > this for these tables? Also the VB Demo app does not return
values
> > for Invoice
> >
> > Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
> > Security=SSPI;DATABASE=yyy"
> > Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
> >
> > Dim oConnection As ADODB.Connection
> > Dim oRecordset As ADODB.Recordset
> >
> > Sub Main()
> >
> > Dim sSQL As String
> > Try
> >
> > oConnection = New ADODB.Connection
> > oRecordset = New ADODB.Recordset
> >
> > oRecordset.CursorLocation =
> > ADODB.CursorLocationEnum.adUseServer
> > oRecordset.CursorType =
> ADODB.CursorTypeEnum.adOpenStatic
> >
> > oConnection.Open(sConnectString)
> >
> > sSQL = "SELECT * FROM " + sTableName
> > oRecordset.Open(sSQL, oConnection) ' Failure
> >
> > Exception: System.Runtime.InteropServices.COMException
> (0x80040E21):
> > ODBC driver does not support the requested properties.
> > at ADODB.RecordsetClass.Open(Object Source, Object
> > ActiveConnection, CursorTypeEnum CursorType
> > , LockTypeEnum LockType, Int32 Options)
> >
> > any help is appreciated
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

Use transaction date as a qualifier.   Test with VBdemo to eliminate SQL
statement errors from programming errors. I was able to create good
transactions with QBOE except for invoices with Sales taxes.






Robert Noche



   -----Original Message-----
   From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com]On Behalf Of
odakcm
   Sent: Thursday, March 22, 2007 11:26 AM
   To: qodbc@yahoogroups.com
   Subject: [qodbc] Re: SELECT * FROM INVOICE Fails via ADODB.Connection


   Thanks for the replies. I understand I am running into the QBOE 1000
   row result set limit.

   I could break up the select into groups of < 1000, but first I need
   to know some ranges. In my testing any aggregate call fails because
   of > 1000.

   So select count(*) from Invoice
   or select max(TxnNumber) from Invoice both fail.

   What strategy can I use to divide and conquer the Selects?

   Thanks

   --- In qodbc@yahoogroups.com, "odakcm" <kevin@...> wrote:
   >
   > I have a VB.NET application that "select * from <table> "
   succesfully
   > from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
   > InvoiceLinkedTxn).
   >
   > I am using the following code. Does anyone know what is wrong with
   > this for these tables? Also the VB Demo app does not return values
   > for Invoice
   >
   > Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
   > Security=SSPI;DATABASE=yyy"
   > Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
   >
   > Dim oConnection As ADODB.Connection
   > Dim oRecordset As ADODB.Recordset
   >
   > Sub Main()
   >
   > Dim sSQL As String
   > Try
   >
   > oConnection = New ADODB.Connection
   > oRecordset = New ADODB.Recordset
   >
   > oRecordset.CursorLocation =
   > ADODB.CursorLocationEnum.adUseServer
   > oRecordset.CursorType =
   ADODB.CursorTypeEnum.adOpenStatic
   >
   > oConnection.Open(sConnectString)
   >
   > sSQL = "SELECT * FROM " + sTableName
   > oRecordset.Open(sSQL, oConnection) ' Failure
   >
   > Exception: System.Runtime.InteropServices.COMException
   (0x80040E21):
   > ODBC driver does not support the requested properties.
   > at ADODB.RecordsetClass.Open(Object Source, Object
   > ActiveConnection, CursorTypeEnum CursorType
   > , LockTypeEnum LockType, Int32 Options)
   >
   > any help is appreciated
   >






[Non-text portions of this message have been removed]

Kevin,



That should be handled correctly inside the driver if you have the version
7.x driver. It is free to download the most current evaluation. The only
time you have to pay an upgrade is when you upgrade your version of
QuickBooks as then you will be using the newer features of the SDK inside of
QODBC.



Thanks,

Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at  <http://www.qodbc.com/>
www.qodbc.com



   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
odakcm
Sent: Thursday, March 22, 2007 11:26 AM
To: qodbc@yahoogroups.com
Subject: [qodbc] Re: SELECT * FROM INVOICE Fails via ADODB.Connection



Thanks for the replies. I understand I am running into the QBOE 1000
row result set limit.

I could break up the select into groups of < 1000, but first I need
to know some ranges. In my testing any aggregate call fails because
of > 1000.

So select count(*) from Invoice
or select max(TxnNumber) from Invoice both fail.

What strategy can I use to divide and conquer the Selects?

Thanks

--- In qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com, "odakcm"
<kevin@...> wrote:
>
> I have a VB.NET application that "select * from <table> "
succesfully
> from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
> InvoiceLinkedTxn).
>
> I am using the following code. Does anyone know what is wrong with
> this for these tables? Also the VB Demo app does not return values
> for Invoice
>
> Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
> Security=SSPI;DATABASE=yyy"
> Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
>
> Dim oConnection As ADODB.Connection
> Dim oRecordset As ADODB.Recordset
>
> Sub Main()
>
> Dim sSQL As String
> Try
>
> oConnection = New ADODB.Connection
> oRecordset = New ADODB.Recordset
>
> oRecordset.CursorLocation =
> ADODB.CursorLocationEnum.adUseServer
> oRecordset.CursorType =
ADODB.CursorTypeEnum.adOpenStatic
>
> oConnection.Open(sConnectString)
>
> sSQL = "SELECT * FROM " + sTableName
> oRecordset.Open(sSQL, oConnection) ' Failure
>
> Exception: System.Runtime.InteropServices.COMException
(0x80040E21):
> ODBC driver does not support the requested properties.
> at ADODB.RecordsetClass.Open(Object Source, Object
> ActiveConnection, CursorTypeEnum CursorType
> , LockTypeEnum LockType, Int32 Options)
>
> any help is appreciated
>





[Non-text portions of this message have been removed]

Thanks for the replies.  I understand I am running into the QBOE 1000
row result set limit.

I could break up the select into groups of < 1000, but first I need
to know some ranges.  In my testing any aggregate call fails because
of > 1000.

So select count(*) from Invoice
or select max(TxnNumber) from Invoice both fail.

What strategy can I use to divide and conquer the Selects?

Thanks

--- In qodbc@yahoogroups.com, "odakcm" <kevin@...> wrote:
>
> I have a VB.NET application that "select * from <table> "
succesfully
> from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
> InvoiceLinkedTxn).
>
> I am using the following code.  Does anyone know what is wrong with
> this for these tables?  Also the VB Demo app does not return values
> for Invoice
>
>     Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
> Security=SSPI;DATABASE=yyy"
>     Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
>
>     Dim oConnection As ADODB.Connection
>     Dim oRecordset As ADODB.Recordset
>
>     Sub Main()
>
>           Dim sSQL As String
>       Try
>
>             oConnection = New ADODB.Connection
>             oRecordset = New ADODB.Recordset
>
>             oRecordset.CursorLocation =
> ADODB.CursorLocationEnum.adUseServer
>             oRecordset.CursorType =
ADODB.CursorTypeEnum.adOpenStatic
>
>             oConnection.Open(sConnectString)
>
>             sSQL = "SELECT * FROM " + sTableName
>             oRecordset.Open(sSQL, oConnection) ' Failure
>
> Exception: System.Runtime.InteropServices.COMException
(0x80040E21):
> ODBC driver does not support the requested properties.
>    at ADODB.RecordsetClass.Open(Object Source, Object
> ActiveConnection, CursorTypeEnum CursorType
> , LockTypeEnum LockType, Int32 Options)
>
> any help is appreciated
>

Our technical support system is best staffed by those who can help with
this question, please see the FAQ search and support ticket system for help
on this issue:

http://www.qodbc.com/faq

thanks

Brad Waddell
Product Manager, QODBC the ODBC Driver for QuickBooks
www.QODBC.com


At 12:12 AM 03/21/2007 +0000, you wrote:
>I have a VB.NET application that "select * from <table> " succesfully
>from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
>InvoiceLinkedTxn).
>
>I am using the following code. Does anyone know what is wrong with
>this for these tables? Also the VB Demo app does not return values
>for Invoice
>
>Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
>Security=SSPI;DATABASE=yyy"
>Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"
>
>Dim oConnection As ADODB.Connection
>Dim oRecordset As ADODB.Recordset
>
>Sub Main()
>
>Dim sSQL As String
>Try
>
>oConnection = New ADODB.Connection
>oRecordset = New ADODB.Recordset
>
>oRecordset.CursorLocation =
>ADODB.CursorLocationEnum.adUseServer
>oRecordset.CursorType = ADODB.CursorTypeEnum.adOpenStatic
>
>oConnection.Open(sConnectString)
>
>sSQL = "SELECT * FROM " + sTableName
>oRecordset.Open(sSQL, oConnection) ' Failure
>
>Exception: System.Runtime.InteropServices.COMException (0x80040E21):
>ODBC driver does not support the requested properties.
>at ADODB.RecordsetClass.Open(Object Source, Object
>ActiveConnection, CursorTypeEnum CursorType
>, LockTypeEnum LockType, Int32 Options)
>
>any help is appreciated
>
>


QODBC Driver for Quickbooks - Interactive QuickBooks data solutions at
http://qodbc.com
     ** Now included in QuickBooks Enterprise Edition! **
Brad Waddell ** FLEXquarters.com LLC ** voice-mail/fax: 703-935-7647

Hi

Fellow Programmer,

I did used QODBC for one of my projects and it did fulfill all of my client
needs.

But it we were lucky cause we were working all around Liability accounts only.

For what you looking for I believe will be better to take advantage of
Quickbooks SDK 6.0
it has no limitations and there are plenty of examples including hardcoded demos
where you will find many ways to tackle your project.

Quickbooks SDK 6.0 is free as well as all examples.

Here is the link: http://developer.intuit.com/QuickBooksSDK/Downloads/

I hope this help.

I'll ready creaty few modules and they work faster than QODBC.

You have to focus on QBFC it will save you time and provide better performance
plus you will have you own way of extracting data from QBK's using what was
desing to do it.

Best Regards,

Jose Moreno




----- Original Message ----
From: odakcm <kevin@...>
To: qodbc@yahoogroups.com
Sent: Tuesday, March 20, 2007 4:12:03 PM
Subject: [qodbc] SELECT * FROM INVOICE Fails via ADODB.Connection

I have a VB.NET application that "select * from <table> " succesfully
from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
InvoiceLinkedTxn) .

I am using the following code. Does anyone know what is wrong with
this for these tables? Also the VB Demo app does not return values
for Invoice

Const sConnectionStringSQ LServer = "SERVER=xxx; Integrated
Security=SSPI; DATABASE= yyy"
Const sConnectString = "DSN=QBOE_Testing; OLE DB Services=-2; "

Dim oConnection As ADODB.Connection
Dim oRecordset As ADODB.Recordset

Sub Main()

Dim sSQL As String
Try

oConnection = New ADODB.Connection
oRecordset = New ADODB.Recordset

oRecordset.CursorLo cation =
ADODB.CursorLocatio nEnum.adUseServe r
oRecordset.CursorTy pe = ADODB.CursorTypeEnu m.adOpenStatic

oConnection. Open(sConnectStr ing)

sSQL = "SELECT * FROM " + sTableName
oRecordset.Open( sSQL, oConnection) ' Failure

Exception: System.Runtime. InteropServices. COMException (0x80040E21) :
ODBC driver does not support the requested properties.
at ADODB.RecordsetClas s.Open(Object Source, Object
ActiveConnection, CursorTypeEnum CursorType
, LockTypeEnum LockType, Int32 Options)

any help is appreciated






________________________________________________________________________________\
____
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265

[Non-text portions of this message have been removed]

I have a VB.NET application that "select * from <table> " succesfully
from all the QBOE tables EXCEPT (Invoice, InvoiceLine,
InvoiceLinkedTxn).

I am using the following code.  Does anyone know what is wrong with
this for these tables?  Also the VB Demo app does not return values
for Invoice

     Const sConnectionStringSQLServer = "SERVER=xxx;Integrated
Security=SSPI;DATABASE=yyy"
     Const sConnectString = "DSN=QBOE_Testing;OLE DB Services=-2;"

     Dim oConnection As ADODB.Connection
     Dim oRecordset As ADODB.Recordset

     Sub Main()

           Dim sSQL As String
       Try

             oConnection = New ADODB.Connection
             oRecordset = New ADODB.Recordset

             oRecordset.CursorLocation =
ADODB.CursorLocationEnum.adUseServer
             oRecordset.CursorType = ADODB.CursorTypeEnum.adOpenStatic

             oConnection.Open(sConnectString)

             sSQL = "SELECT * FROM " + sTableName
             oRecordset.Open(sSQL, oConnection) ' Failure

Exception: System.Runtime.InteropServices.COMException (0x80040E21):
ODBC driver does not support the requested properties.
    at ADODB.RecordsetClass.Open(Object Source, Object
ActiveConnection, CursorTypeEnum CursorType
, LockTypeEnum LockType, Int32 Options)

any help is appreciated

That answer my question.

We are using Pro Version 2006

Thank you!

----- Original Message ----
From: Matt Froncek <matt@...>
To: qodbc@yahoogroups.com
Sent: Sunday, January 14, 2007 8:58:01 PM
Subject: RE: [qodbc] Re: Chart of Accounts update













             What version of QuickBooks are you using? QODBC uses the Intuit SDK
and

Account information was not updatable until QuickBooks 2007.



Matt Froncek

QODBC Development Support / FLEXquarters. com LLC Consultant

QODBC Driver for QuickBooks - Unleash your data at  <http://www.qodbc. com/>

www.qodbc.com



_____



From: qodbc@yahoogroups. com [mailto:qodbc@yahoogroups. com] On Behalf Of

virtualjosemx

Sent: Sunday, January 14, 2007 6:08 AM

To: qodbc@yahoogroups. com

Subject: [qodbc] Re: Chart of Accounts update



--- In qodbc@yahoogroups. <mailto:qodbc% 40yahoogroups. com> com,

"virtualjosemx" <virtualjosemx@ ...> wrote:

>

> Hi,

>

> I have to Udpate all the accounts number of Chart of Accounts.

>

> Even do I'm Using QODBC Read/Write I can not update any account and I

> do not know why, I keep receiving this Error "ODBC --update on a

> linked Table Account Failed"

>

> I did test Vendor and there was no problem.

>

> If I do this manually directly from QuickBooks it does work.

> While does not work Using QODBC?

>

> Any Help will be welcome.

>

> Thank you in advance

>



So far I had to create a small routine to open and close windows as

well as adding the charaters require for the account format update.

It does work but it was done using sendkeys.



I'm still wondering if this is possible using QODBC or why it does not

allow me to update the account number.



[Non-text portions of this message have been removed]














<!--

#ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;
}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;
}
#ygrp-vitnav{
padding-top:10px;
font-family:Verdana;
font-size:77%;
margin:0;
}
#ygrp-vitnav a{
padding:0 1px;
}
#ygrp-actbar{
clear:both;
margin:25px 0;
white-space:nowrap;
color:#666;
text-align:right;
}
#ygrp-actbar .left{
float:left;
white-space:nowrap;
}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;
font-size:77%;
padding:15px 0;
}
#ygrp-ft{
font-family:verdana;
font-size:77%;
border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;
}

#ygrp-vital{
background-color:#e0ecee;
margin-bottom:20px;
padding:2px 0 8px 8px;
}
#ygrp-vital #vithd{
font-size:77%;
font-family:Verdana;
font-weight:bold;
color:#333;
text-transform:uppercase;
}
#ygrp-vital ul{
padding:0;
margin:2px 0;
}
#ygrp-vital ul li{
list-style-type:none;
clear:both;
border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;
color:#ff7900;
float:right;
width:2em;
text-align:right;
padding-right:.5em;
}
#ygrp-vital ul li .cat{
font-weight:bold;
}
#ygrp-vital a {
text-decoration:none;
}

#ygrp-vital a:hover{
text-decoration:underline;
}

#ygrp-sponsor #hd{
color:#999;
font-size:77%;
}
#ygrp-sponsor #ov{
padding:6px 13px;
background-color:#e0ecee;
margin-bottom:20px;
}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;
margin:0;
}
#ygrp-sponsor #ov li{
list-style-type:square;
padding:6px 0;
font-size:77%;
}
#ygrp-sponsor #ov li a{
text-decoration:none;
font-size:130%;
}
#ygrp-sponsor #nc {
background-color:#eee;
margin-bottom:20px;
padding:0 8px;
}
#ygrp-sponsor .ad{
padding:8px 0;
}
#ygrp-sponsor .ad #hd1{
font-family:Arial;
font-weight:bold;
color:#628c2a;
font-size:100%;
line-height:122%;
}
#ygrp-sponsor .ad a{
text-decoration:none;
}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;
}
#ygrp-sponsor .ad p{
margin:0;
}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;
}
#ygrp-text tt{
font-size:120%;
}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->









________________________________________________________________________________\
____
8:00? 8:25? 8:40? Find a flick in no time
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news

[Non-text portions of this message have been removed]

What version of QuickBooks are you using? QODBC uses the Intuit SDK and
Account information was not updatable until QuickBooks 2007.



Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at  <http://www.qodbc.com/>
www.qodbc.com



   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
virtualjosemx
Sent: Sunday, January 14, 2007 6:08 AM
To: qodbc@yahoogroups.com
Subject: [qodbc] Re: Chart of Accounts update



--- In qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com,
"virtualjosemx" <virtualjosemx@...> wrote:
>
> Hi,
>
> I have to Udpate all the accounts number of Chart of Accounts.
>
> Even do I'm Using QODBC Read/Write I can not update any account and I
> do not know why, I keep receiving this Error "ODBC --update on a
> linked Table Account Failed"
>
> I did test Vendor and there was no problem.
>
> If I do this manually directly from QuickBooks it does work.
> While does not work Using QODBC?
>
> Any Help will be welcome.
>
> Thank you in advance
>

So far I had to create a small routine to open and close windows as
well as adding the charaters require for the account format update.
It does work but it was done using sendkeys.

I'm still wondering if this is possible using QODBC or why it does not
allow me to update the account number.





[Non-text portions of this message have been removed]

--- In qodbc@yahoogroups.com, "virtualjosemx" <virtualjosemx@...> wrote:
>
> Hi,
>
> I have to Udpate all the accounts number of Chart of Accounts.
>
> Even do I'm Using QODBC Read/Write I can not update any account and I
> do not know why, I keep receiving this Error "ODBC --update on a
> linked Table Account Failed"
>
> I did test Vendor and there was no problem.
>
> If I do this manually directly from QuickBooks it does work.
> While does not work Using QODBC?
>
> Any Help will be welcome.
>
> Thank you in advance
>

So far I had to create a small routine to open and close windows as
well as adding the charaters require for the account format update.
It does work but it was done using sendkeys.

I'm still wondering if this is possible using QODBC or why it does not
allow me to update the account number.

Hi,

I have to Udpate all the accounts number of Chart of Accounts.

Even do I'm Using QODBC Read/Write I can not update any account and I
do not know why, I keep receiving this Error "ODBC --update on a
linked Table Account Failed"

I did test Vendor and there was no problem.

If I do this manually directly from QuickBooks it does work.
While does not work Using QODBC?

Any Help will be welcome.

Thank you in advance

Yup, how soon we forget!

Glad it helped..

take care,
robynz

   ----- Original Message -----
   From: Matt Babineau
   To: qodbc@yahoogroups.com
   Sent: Friday, January 12, 2007 06:50 PM
   Subject: RE: [qodbc] Problem with Query??? !=


   Awesome...that makes sense. I've been in MySQL too long!


   Thanks,

   Matt Babineau
   Criticalcode
   858.733.0160
   matt@...
   http://www.criticalcode.com <http://www.criticalcode.com/>

   TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...


   _____

   From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
   Robyn Zelickson
   Sent: Wednesday, January 10, 2007 3:07 PM
   To: qodbc@yahoogroups.com
   Subject: Re: [qodbc] Problem with Query??? !=

   Not sure what you're using to run the query, but in Access you have to say:

   SELECT *
   FROM Item
   WHERE Type<>'ItemService';

   ----- Original Message -----
   From: Matt Babineau
   To: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
   Sent: Wednesday, January 10, 2007 12:46 PM
   Subject: [qodbc] Problem with Query??? !=

   This doesn't work:
   SELECT * FROM Item WHERE Type != 'ItemService'

   This does work:
   SELECT * FROM Item WHERE Type = 'ItemService'

   Am I building this query wrong? I just want to find every Item that is NOT
   of Type "ItemService"..

   Thanks,

   Matt Babineau
   Criticalcode
   858.733.0160
   matt@criticalcode. <mailto:matt%40criticalcode.com> com
   http://www.critical <http://www.criticalcode.com> code.com

   TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...

   [Non-text portions of this message have been removed]

   [Non-text portions of this message have been removed]

   [Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

Awesome...that makes sense. I've been in MySQL too long!



Thanks,

Matt Babineau
Criticalcode
858.733.0160
matt@...
http://www.criticalcode.com <http://www.criticalcode.com/>

TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...





   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
Robyn Zelickson
Sent: Wednesday, January 10, 2007 3:07 PM
To: qodbc@yahoogroups.com
Subject: Re: [qodbc] Problem with Query??? !=



Not sure what you're using to run the query, but in Access you have to say:

SELECT *
FROM Item
WHERE Type<>'ItemService';

----- Original Message -----
From: Matt Babineau
To: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
Sent: Wednesday, January 10, 2007 12:46 PM
Subject: [qodbc] Problem with Query??? !=

This doesn't work:
SELECT * FROM Item WHERE Type != 'ItemService'

This does work:
SELECT * FROM Item WHERE Type = 'ItemService'

Am I building this query wrong? I just want to find every Item that is NOT
of Type "ItemService"..

Thanks,

Matt Babineau
Criticalcode
858.733.0160
matt@criticalcode. <mailto:matt%40criticalcode.com> com
http://www.critical <http://www.criticalcode.com> code.com

TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

Not sure what you're using to run the query, but in Access you have to say:

SELECT *
FROM Item
WHERE Type<>'ItemService';


   ----- Original Message -----
   From: Matt Babineau
   To: qodbc@yahoogroups.com
   Sent: Wednesday, January 10, 2007 12:46 PM
   Subject: [qodbc] Problem with Query??? !=


   This doesn't work:
   SELECT * FROM Item WHERE Type != 'ItemService'

   This does work:
   SELECT * FROM Item WHERE Type = 'ItemService'

   Am I building this query wrong? I just want to find every Item that is NOT
   of Type "ItemService"..

   Thanks,

   Matt Babineau
   Criticalcode
   858.733.0160
   matt@...
   http://www.criticalcode.com

   TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...


   [Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

Try:

SELECT * FROM Item WHERE Type <> 'ItemService'



Matt Froncek
QODBC Development Support / FLEXquarters.com LLC Consultant
QODBC Driver for QuickBooks - Unleash your data at  <http://www.qodbc.com/>
www.qodbc.com



   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of Matt
Babineau
Sent: Wednesday, January 10, 2007 12:47 PM
To: qodbc@yahoogroups.com
Subject: [qodbc] Problem with Query??? !=



This doesn't work:
SELECT * FROM Item WHERE Type != 'ItemService'

This does work:
SELECT * FROM Item WHERE Type = 'ItemService'

Am I building this query wrong? I just want to find every Item that is NOT
of Type "ItemService"..

Thanks,

Matt Babineau
Criticalcode
858.733.0160
matt@criticalcode. <mailto:matt%40criticalcode.com> com
http://www.critical <http://www.criticalcode.com> code.com

TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]

This doesn't work:
SELECT * FROM Item WHERE Type != 'ItemService'

This does work:
SELECT * FROM Item WHERE Type = 'ItemService'

Am I building this query wrong? I just want to find every Item that is NOT
of Type "ItemService"..


Thanks,

Matt Babineau
Criticalcode
858.733.0160
matt@...
http://www.criticalcode.com

TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...




[Non-text portions of this message have been removed]

Matt,

No they are running 2006.  They did an upgrade last summer.

Steve





--- In qodbc@yahoogroups.com, "Matt Babineau" <matt@...> wrote:
>
> Are they running QB 2007? I ran into this problem. Basically QODBC 6
will
> work with all versions of QB up to 2006. QODBC 7 will work with
versions up
> to 2007.
>
> Etc...
>
> So that would mean a new license would be required :-\
>
> I was slightly bummed when I found out about this, but I'll make
sure to not
> wait too long before using my licenses!
>
>
>
> Thanks,
>
> Matt Babineau
> Criticalcode
> 858.733.0160
> matt@...
> http://www.criticalcode.com <http://www.criticalcode.com/>
>
> TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me
how...
>
>
>
>
>
>   _____
>
> From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
> sjdeetz
> Sent: Tuesday, January 09, 2007 12:54 PM
> To: qodbc@yahoogroups.com
> Subject: [qodbc] Activation Code Expired?
>
>
>
> A client of mine purchased a QODBC license for V. 6 Read/Write in
> August of 2006. They never installed and the secretary never notified
> me until today that they cannot get the QODBC connection to QuickBooks
> to work.
>
> I entered the CD Key Code to automatically activate and the message
> came back activation was successful but the QODBC driver will not
> connect to QuickBooks and the Purchase QODBC screen keeps popping up.
> I tried the manual activation and got the Serial Number, Name, and
> Activation Code off of the web site and was told the activation was
> successful but QODBC keeps telling me the trial use of QODBC has
expired.
>
> My customer is running V. 6.00.00.176. Any help on getting the
> product properly activated would be helpful.
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

Are they running QB 2007? I ran into this problem. Basically QODBC 6 will
work with all versions of QB up to 2006. QODBC 7 will work with versions up
to 2007.

Etc...

So that would mean a new license would be required :-\

I was slightly bummed when I found out about this, but I'll make sure to not
wait too long before using my licenses!



Thanks,

Matt Babineau
Criticalcode
858.733.0160
matt@...
http://www.criticalcode.com <http://www.criticalcode.com/>

TAKE ORDERS from the WEB and add them right into QUICKBOOKS! Ask me how...





   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
sjdeetz
Sent: Tuesday, January 09, 2007 12:54 PM
To: qodbc@yahoogroups.com
Subject: [qodbc] Activation Code Expired?



A client of mine purchased a QODBC license for V. 6 Read/Write in
August of 2006. They never installed and the secretary never notified
me until today that they cannot get the QODBC connection to QuickBooks
to work.

I entered the CD Key Code to automatically activate and the message
came back activation was successful but the QODBC driver will not
connect to QuickBooks and the Purchase QODBC screen keeps popping up.
I tried the manual activation and got the Serial Number, Name, and
Activation Code off of the web site and was told the activation was
successful but QODBC keeps telling me the trial use of QODBC has expired.

My customer is running V. 6.00.00.176. Any help on getting the
product properly activated would be helpful.







[Non-text portions of this message have been removed]

A client of mine purchased a QODBC license for V. 6 Read/Write in
August of 2006.  They never installed and the secretary never notified
me until today that they cannot get the QODBC connection to QuickBooks
to work.

I entered the CD Key Code to automatically activate and the message
came back activation was successful but the QODBC driver will not
connect to QuickBooks and the Purchase QODBC screen keeps popping up.
  I tried the manual activation and got the Serial Number, Name, and
Activation Code off of the web site and was told the activation was
successful but QODBC keeps telling me the trial use of QODBC has expired.

My customer is running V. 6.00.00.176.  Any help on getting the
product properly activated would be helpful.

You will have to provide a loop to check for which Price "field" is
applicable to that item.  If an item is performed or bought from a
subcontractor it changes from SalesOrPurchase to SalesAndPurchase.  Do a
query of your items to see which field is being used, and how the check box
for reimbursable services or non inventory items comes into play.



Chuck Vigeant  M.Ed., Certified QuickBooks and POS ProAdvisor

Managing Partner

ACCOUNTiGRATE, LP

Participant: Accountant and Advisor Customer Council for Intuit Inc.,
2004-2005, 2005-2006

Member, Intuit Speaker's Bureau

  "QuickBooks solutions experts, specializing in accounting, custom reports,
utilities, and data integration"

   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of
praefex
Sent: Wednesday, January 03, 2007 8:36 PM
To: qodbc@yahoogroups.com
Subject: [qodbc] Problem Updating ItemService



Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an
error when m
odifying a ItemService. Cannot use SalesOrPurchaseMod aggregate when
the item i
s reimbursable. , SQL state S0000 in SQLExecDirect in
E:\WWW\processes\qb_connec
t.php on line 182

I'm not sure why this would happen, I'm only modifying the Description
and Price. Some products are fine, others have this SQL error.

Any clues?

Thanks
Matt





[Non-text portions of this message have been removed]

Warning: odbc_exec(): SQL error: [QODBC] Error: 3170 - There was an
error when m
odifying a ItemService.  Cannot use SalesOrPurchaseMod aggregate when
the item i
s reimbursable. , SQL state S0000 in SQLExecDirect in
E:\WWW\processes\qb_connec
t.php on line 182


I'm not sure why this would happen, I'm only modifying the Description
and Price. Some products are fine, others have this SQL error.

Any clues?

Thanks
Matt

Probably the .lgb file.  The .ND file is a configuration file, that usually
doesn't need to be removed, but just remember to rename them to .old  I
never like to delete files.



Chuck Vigeant

   _____

From: qodbc@yahoogroups.com [mailto:qodbc@yahoogroups.com] On Behalf Of Rod
Lewis
Sent: Wednesday, December 06, 2006 9:00 PM
To: qodbc@yahoogroups.com
Subject: RE: [qodbc] Automatically logging into QuickBooks



Chuck,

Your suggestion worked for one company. For another I had to do what
they suggested on the QODBC site (moving all related files except for
the QBW). So, I believe that between the 2 methods, I have it licked.

Thanks again,

Rod

________________________________

From: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
[mailto:qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com] On Behalf
Of
Chuck Vigeant
Sent: Tuesday, December 05, 2006 11:30 PM
To: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
Subject: RE: [qodbc] Automatically logging into QuickBooks

(1) Get everybody out of QB

(2) Go into QB>Edit>Preferences>Integrated Applications. Remove any ODBC
listings.

(3) Go to your directory where the QB file is located. Rename the .tlg
file
to .old

(4) Go to your ODBC configuration panel and click on the Test Connection
button. QB will prompt you to log in as .. Choose your Admin. Ok any
other
prompts.

Should be free.

Chuck Vigeant M.Ed., Certified QuickBooks and POS ProAdvisor

Managing Partner

ACCOUNTiGRATE, LP

Participant: Accountant and Advisor Customer Council for Intuit Inc.,
2004-2005, 2005-2006

Member, Intuit Speaker's Bureau

"QuickBooks solutions experts, specializing in accounting, custom
reports,
utilities, and data integration"

_____

From: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
<mailto:qodbc%40yahoogroups.com>
[mailto:qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
<mailto:qodbc%40yahoogroups.com> ] On
Behalf Of Rod
Lewis
Sent: Tuesday, December 05, 2006 11:08 PM
To: qodbc@yahoogroups. <mailto:qodbc%40yahoogroups.com> com
<mailto:qodbc%40yahoogroups.com>
Subject: [qodbc] Automatically logging into QuickBooks

I am using the QODBC driver that comes with QB Enterprise. I'm trying
to automate the process for an unattended operation. I have assigned
the specific company and setup the access to use the Admin user.
However, it continues to pause for the password. I tried changing it to
no password, but it still pauses for me to click the button to proceed.
I am not sure what I am missing as the documentation appears to suggest
that this is possible to do.

Any assistance you can provide would be appreciated.

Rod Lewis

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]