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