Re: Using Sale on POS

[Leah Kubik <..hidden..>]

On Wednesday 01 August 2007 13:15, Chris Travers wrote:
> Line 89 says:
> $pos_config{till_accno} = "$pos_config{coa_prefix}.$pos_config{till}";
>
> I think that Leah was suggesting changing it to:
> $pos_config{till_accno} = '1200';
>
> If you go that route, I would suggest doing so for testing only and
> creating a single account for the cash in the tills.  The AR account is hit
> by the transactions anyway, so you probably don't want to be storing cash
> on-hand in the AR account :-)

Yeah, I meant to put in some account number there you want to use for cash in.  
On the chart of accounts I was working with, the 1200 account was a very 
specific AR account.


> On 8/1/07, Eduardo Huertas <..hidden..> wrote:
> > nn
> >
> > --- Chris Travers <..hidden..> escribiÃ:
> > > On 7/31/07, Eduardo Huertas <..hidden..>
> > >
> > > wrote:
> > > > --- 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)
> > >
> > > Can you include your full pos.conf.pl?
> > >
> > > > 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/
> >
> > -------------------------------------------------------------------------
> >
> > > > 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
> >
> >
> > -------------------------------------------------------------------------
> >
> > > 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
> >
> >
> > Hi Chris,
> >
> > I haven't touched the pos.conf.pl file until the
> > suggestion of Leah.  The problem remains anyway.
> >
> > I'll send you the one I'm using (untouched)
> >
> > Thank you very much for your attention.
> >
> > -edu-


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