Re: Using Sale on POS

[Eduardo Huertas <..hidden..>]

--- Chris Travers <..hidden..> escribió:

> 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?'
> 
Yeap! As Leah said.

> Does an account with an  account number of 1200
> exist?
> 
Yes, 1200-Account Receivables. Now I'm using the US
for service company chart. (untouched)


> 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
> ..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/