Re: Using Sale on POS

[Eduardo Huertas <..hidden..>]

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

> On 8/1/07, Eduardo Huertas <..hidden..>
> wrote:
> >
> >
> > --- Chris Travers <..hidden..>
> escribió:
> >
> > > 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 :-)
> > >
> > > Best Wishes,
> > > Chris Travers
> >
> > I think you missed when I said that THAT change
> didn't
> > do the trick :(  See bellow.
> 
> 
> 
> Ok.  I misunderstood you.  Sorry.
> 
> There are a few other things that can cause this
> sort of error such as:
> 1)  No AR account
> 2)  Parts associated with bogus inventory, income,
> or expense accounts
> 
> To test, try to run a POS transaction without
> entering any payment info.  If
> you get the same error, then it is one of the above
> issues.
> 
> Best Wishes.
> Chris Travers

Thanks Chris,

If I don't enter any payment there's no error and an
invoice is generated for later payment.

I can pay that invoice with no problem in Receipt.

Conclusion??

-edu-





> 
> Same error with or without the change that Leah
> > suggested.
> >
> > What should I do?
> >
> > -edu-
> >
> >
> > >
> > > 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
> 
=== message truncated ===>
-------------------------------------------------------------------------
> 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/