On 7/31/07, Eduardo Huertas <..hidden..> wrote:
--- 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 :(
You changed it to simply hit '1200?'
Does an account with an account number of 1200 exist?
Best Wishes,
Chris Travers