Re: Using Sale on POS

[Leah Kubik <..hidden..>]

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.

> 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