Re: Using Sale on POS

[Eduardo Huertas <..hidden..>]

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

> On 8/1/07, Eduardo Huertas <..hidden..>
> wrote:
> >
> >
> > --- 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??
> 
> 
> The POS screen automatically assigns the asset
> account for handling
> payments.  This is the variable that Leah and I
> pointed you to before.  I
> would suggest changing that line to point to an
> account number from your
> chart of accounts for testing purposes.  If this
> does not work, please
> attack the HTML output of a chart of accounts report
> (sanitized if
> necessary) and an attempt to fix this using the
> pos.conf.pl.
> 
> Best Wishes,
> Chris Travers
> 
> 
Ok, I droped all DB. I tried first with Colombia's
chart accounts.  Added a customer, a vendor, an item.
Then a vendor's invoice with that item.  Now that I
had inventory tried POS->Sale and ... No way!!

Ok, then tried with another DB. This time with default
DB.  I thought this have to be bullet prooff ... Nah!
Same error!

Well, I tried with the same default DB, now with the
modified line:

$pos_config{till_accno} = 1200;

And ... NOP!

The same error!

So folks, I think you won't have any trouble
replicating this error, it's out of the box.

I don't know if anyone has this in production with
1.2.7 version.  Haven't tried another version.

I want to emphasize that Sales Invoice works
correctly.

So what happens with POS->Sale?

Thank you very much Chris and Leah for your help.

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