Re: error posting POS Sale

[john <..hidden..>]

Thanks for the quick reply, David.

Not sure exactly where to find the checkbox, though.  Sorry if i'm missing something simple.  Just getting started with LSMB.

i am using a default installation and have only created a single customer and a single service.  In the POS Sale screen, i have a customer selected, the "Record in" is set to 1200--Accounts Receivables, and only 1 item is specified with the cost and tax coming up correctly.  i enter the payment in the "Amount" field leaving "Memo" set to Cash, "Source" and "Credit Card Track" are left blank.  The only check box i see is "Tax Included" (unchecked) and 4 radio buttons (Screen, Printer, Epson, Laser).

i tried another transaction and noticed something i didn't mention before.  The first time i hit Print and Post nothing happens (screen reloads but no actions take place).  The second time i hit Print and Post the error i mentioned comes up and there is an entry in AR for the POS Invoice amount.

Lastly, likely an issue of not understanding accounting very well on my part, i'm not sure how to delete or reverse the AR entry, nor how to complete the transaction to get it into the Chequing Account or Petty Cash.

Thanks again for the help!

john


On Fri, 2008-02-01 at 08:37 -0500, David Mora wrote:
> Hi john, check if you have selectable accounts in the checkbox, if
> thats your case you should set at least one in the CoA
>
> On Feb 1, 2008 7:58 AM, john <..hidden..> wrote:
> >
> >  When i perform a POS Sale for either a service or product the following
> > error comes up:
> >
> >
> >  DBD::Pg::st execute failed: ERROR: null value in column "chart_id" violates
> > not-null constraint
> >
> >
> >  Error!
> >  INSERT INTO acc_trans
> >  (trans_id, chart_id, amount,
> >  transdate, source, memo, cleared)
> >  VALUES (?, (SELECT id FROM chart
> >  WHERE accno = ?),
> >  ?, ?, ?, ?, ?)
> >  ERROR: null value in column "chart_id" violates not-null constraint
> >
> >
> >  Using the following setup:
> >  - PostgreSQL 8.2
> >  - Perl v5.8.8
> >  - Apache 2.2.6
> >  LedgerSMB 1.2.12 from source
> >
> >
> >  Any help is most appreciated.  Thanks in advance.
> >
> >  john
> >
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2008.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users