Re: Using Sale on POS

[Eduardo Huertas <..hidden..>]

--- Leah Kubik <..hidden..> escribió:

> On Tuesday 31 July 2007 00:10, Chris Travers wrote:
> > On 7/30/07, Eduardo Huertas <..hidden..>
> wrote:
> > > Seems there is a bug when trying to post a sale.
> > >
> > > DBD::Pg::st execute failed: ERROR: el valor null
> para
> > > la columna «chart_id» viola la restricción
> not null
> > > Error!
> > >
> > >
> > > INSERT INTO acc_trans
> > > (trans_id, chart_id, amount,
> > > transdate, source, memo, cleared)
> > > VALUES (?, (SELECT id FROM chart
> > > WHERE accno = ?),
> > > ?, ?, ?, ?, ?)
> > > ERROR: el valor null para la columna
> «chart_id»
> > > viola la restricción not null
> 
> For me this issues was because the file pos.conf.pl
> needed a default account 
> set for the till account.  We do not use different
> accounts for each till 
> (like 1300.13) or whatnot like this file is set up,
> there is just one account 
> that all POS transactions go into, so we just set
> the value to that account 
> where the line:
> 
> $pos_config{till_accno} = "1200";
> 
> Exists.
> 
> Maybe that will give you some ideas of where to
> look.
The only line I found in the pos.conf.pl file was
this:

$pos_config{till_accno} =
"$pos_config{coa_prefix}.$pos_config{till}";

And changing this to the one you wrote above, didn't
do the trick :(




> 
> > This does not sound like a bug.  Instead it sounds
> like  an issue with your
> > chart of accounts.  Which chart of accounts are
> you using?  Have you made
> > any modifications?
> >
> > Some background here:  This error message is
> telling me that the subquery
> > did not return a valid account id, and that our
> database rules prevent this
> > from being inserted.  SQL-Ledger does not do this
> and hence you can get
> > invalid data in your database pretty easily.
> >
> > Best Wishes,
> > Chris Travers
> 
> -- 
> Leah Kubik : d416-585-9971x692 : d416-703-5977 :
> m416-559-6511
> Frauerpower! Co. : www.frauerpower.com : Toronto, ON
> Canada
> MSN: ..hidden.. | AIM: frauerpower |
> Yahoo: h3inous
> F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6
> 
>
-------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? 
> Stop.
> Now Search log events and configuration files using
> AJAX and a browser.
> Download your FREE copy of Splunk now >> 
> http://get.splunk.com/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
>
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> 


__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/