On 7/31/07, Eduardo Huertas <[EMAIL PROTECTED]> wrote:
>
>
> --- Leah Kubik <[EMAIL PROTECTED]> escribió:
>
> > On Tuesday 31 July 2007 00:10, Chris Travers wrote:
> > > On 7/30/07, Eduardo Huertas <[EMAIL PROTECTED]>
> > 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
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
