[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: error posting POS Sale



Hi again John, unfurtunately im not very familiar with POS module, and
im also very new to LSMB, but i would suggest you to look for
documented bugs on the POS module (that behaviour you describe,
remembers me of some buggy code in SL).. cheers!

On Feb 1, 2008 9:31 AM, john <..hidden..> wrote:
>
>  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
>
>
> -------------------------------------------------------------------------
> 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
>
>