Re: [Ledger-smb-devel] 1.3 error in AP->vendor invoice query

2009-06-28 Thread Chris Travers
I have committed a change here-- joining "account" instead of "chart" in the IR.pm in all appropriate places. Best Wishes, Chris Travers -- ___ Ledger-smb-devel mailing list Ledg

Re: [Ledger-smb-devel] 1.3 error in AP->vendor invoice query

2009-06-26 Thread Chris Travers
On Fri, Jun 26, 2009 at 7:49 PM, David A. Bandel wrote: > > I will note, however, that the duplicates are of different > charttype(s), the sought after value having a charttype A (the other > being H). Changing the subselect from to include "and c.charttype = > 'A'" in IR.pm fixes the problem for

Re: [Ledger-smb-devel] 1.3 error in AP->vendor invoice query

2009-06-26 Thread Chris Travers
On Fri, Jun 26, 2009 at 7:54 PM, Chris Travers wrote: > > > On Fri, Jun 26, 2009 at 7:49 PM, David A. Bandel > wrote: > >> Chris and crew: >> >> While testing 1.3 from svn, I got the following error when selecting >> AP -> Vendor Invoice: >> ERROR: more than one row returned by a subquery used as

Re: [Ledger-smb-devel] 1.3 error in AP->vendor invoice query

2009-06-26 Thread Chris Travers
On Fri, Jun 26, 2009 at 7:49 PM, David A. Bandel wrote: > Chris and crew: > > While testing 1.3 from svn, I got the following error when selecting > AP -> Vendor Invoice: > ERROR: more than one row returned by a subquery used as an expression > > I ran the query subselect by subselect and found th

[Ledger-smb-devel] 1.3 error in AP->vendor invoice query

2009-06-26 Thread David A. Bandel
Chris and crew: While testing 1.3 from svn, I got the following error when selecting AP -> Vendor Invoice: ERROR: more than one row returned by a subquery used as an expression I ran the query subselect by subselect and found that the offending query subselect is: SELECT value::int FROM defaults