[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AP Invoice Entry Error

Lana Brummett wrote:

My husband just looked at the query and made the following change:

# diff LedgerSMB/Form.pm.orig LedgerSMB/Form.pm
2399a2400
 >     my $id_field = ( $vc eq 'customer' ) ? 'customer_id' : 'vendor_id';
2419c2420
< WHERE ct.id <http://ct.id> = (select customer_id from $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|; 
---
> WHERE ct.id <http://ct.id> = (select $id_field from $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|;
Was this the right thing to change or will this mess up something somewhere else? It seems to have fixed my problem but I just want to make sure that it will post right and that nothing else will break. 



Yes. This is actually fixed in the upcoming 1.2.6.

Joshua D. Drake



THanks again!
Lana
On 6/7/07, *Lana Brummett* <..hidden.. <mailto:..hidden..>> wrote: 

    We just switched over from sql-ledger 2.6.12 and we installed
    ledgersmb 1.2.5 and I am trying to enter a vendor
    invoice for the first time.  I get this error:

    *DBD::Pg::st execute failed: ERROR: column "customer_id" does not
    exist at character 189
    *


        Error!

    *
    SELECT ct.name <http://ct.name> AS vendor, ct.curr AS currency,
    ct.id <http://ct.id> AS vendor_id,
    current_date + ct.terms AS duedate,
    ct.notes ,
    ct.curr AS currency
    FROM vendor ct
    WHERE ct.id <http://ct.id> = (select customer_id from ap where 1 = 1
    AND vendor_id IS NOT NULL order by id DESC limit 1)
    ERROR: column "customer_id" does not exist at character 189

    It looks to me like it should be saying "select vendor_id" and not
    "select customer_id" but I can't see where this needs to be
    changed.  Any help would be appreciated!

    Thanks,
    Lana
    *--
    Start your own business for $10, ask me how today!!!
    www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett>
    Having a party? Need a cake?  Look no further,  ask for details!!!!
    www.creativecakecreations.com <http://www.creativecakecreations.com>
    Call Today (847)687-5794
    Proud mom to Samantha www.yetanotherdomain.org/samantha
<http://www.yetanotherdomain.org/samantha> 



--
Start your own business for $10, ask me how today!!!
www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett>
Having a party? Need a cake?  Look no further,  ask for details!!!!
www.creativecakecreations.com <http://www.creativecakecreations.com>
Call Today (847)687-5794
Proud mom to Samantha www.yetanotherdomain.org/samantha <http://www.yetanotherdomain.org/samantha> 


------------------------------------------------------------------------

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/


------------------------------------------------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/