Re: my first real problem, cash receipt

[ario <..hidden..>]

On Tue, 2011-02-01 at 08:24 -0800, Chris Travers wrote:
> On Mon, Jan 31, 2011 at 10:14 PM, ario <..hidden..> wrote:
> > I'm not in a terrible hurry and there is a workaround for this problem:
> > cancellation and reposting with the new payment included.
> 
> Ick.....

:)

> >
> > As for the log file: From startup to encountering the problem the file
> > is empty, then the same errors as I pasted earlier from the browser
> > window are exactly the same there in the log file:
> 
> Ok, what is happening is that somehow it is not picking up one of the
> accounts.  The question is why.
> 
> The query that is failing is the one which inserts into the AR
> account.  Can you do this in LSMB?
> 
> go to system/chart of accounts/list accounts
> click on the account number for your ar account
> tell me what checkboxes are checked.

ar account: 
   Account type: Asset
   Is this a summary...: AR

account to be debited:
Account: 1010
   Account type: Asset
   Is this a summary...: none
   Receivables: Payment
   Payables: Payment

I hope this helps.
thanks,
ario


> >
> > 2011-01-30 07:15:21 GMT STATEMENT:
> > INSERT INTO acc_trans
> >            (trans_id, chart_id, transdate,
> >            amount)
> >     VALUES ($1, $2,
> >            $3,
> >            $4)
> > 2011-01-30 07:16:47 GMT ERROR:   null value in column "chart_id"
> > violates not-null constraint
> >
> >
> > These sequences are repeated various times as I have retried the same
> > kind of transaction until I shut down the virtual machine with the
> > LedgerSMB on it:
> >
> >
> > 2011-01-30 07:23:22 GMT LOG:  incomplete startup packet
> > 2011-01-30 07:23:22 GMT LOG:  received fast shutdown request
> > 2011-01-30 07:23:22 GMT LOG:  aborting any active transactions
> > 2011-01-30 07:23:22 GMT LOG:  autovacuum launcher shutting down
> > 2011-01-30 07:23:22 GMT LOG:  shutting down
> > 2011-01-30 07:23:22 GMT LOG:  database system is shut down
> >
> >
> > Detail: I'm running 3 'company' databases with LedgerSMB on that virtual
> > machine, nothing else, and the error occurrs in at least 2 of those. So
> > it doesn't appear to be an error in one specific database.
> >
> >
> > thanks,
> > ario
> >
> >
> > On Mon, 2011-01-31 at 09:48 -0800, Chris Travers wrote:
> >> On Sun, Jan 30, 2011 at 11:47 PM, ario <..hidden..> wrote:
> >> > AR: 1100 -- ACCOUNTS RECEIVABLE, with attribute AR set.
> >> > Account: 1010 -- hw cash, with attributes AR_paid & AP_paid.
> >>
> >> Can you check your PostgreSQL log?  There may be more information as
> >> far as what is being passed in over there.  I haven't seen this sort
> >> of case very often.  It may be something specific to the invoice, or
> >> it could be an issue with the setup.  It could be something else.  If
> >> this is urgent, I'd recommend hiring someone (such as myself or
> >> Command Prompt) for support so we can take a look at it, do some
> >> debugging, and figure out what exactly is causing this issue.
> >> Otherwise we could continue to try to gather information on the
> >> problem in hopes of fixing it or, if paid support does become
> >> necessary, reducing the effort to fix it.
> >>
> >> Best Wishes,
> >> Chris Travers
> >>
> >> ------------------------------------------------------------------------------
> >> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> >> Finally, a world-class log management solution at an even better price-free!
> >> Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> >> February 28th, so secure your free ArcSight Logger TODAY!
> >> http://p.sf.net/sfu/arcsight-sfd2d
> >> _______________________________________________
> >> Ledger-smb-users mailing list
> >> ..hidden..
> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
> > ------------------------------------------------------------------------------
> > Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> > Finally, a world-class log management solution at an even better price-free!
> > Download using promo code Free_Logger_4_Dev2Dev. Offer expires
> > February 28th, so secure your free ArcSight Logger TODAY!
> > http://p.sf.net/sfu/arcsight-sfd2d
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> 
> ------------------------------------------------------------------------------
> Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
> Finally, a world-class log management solution at an even better price-free!
> Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
> February 28th, so secure your free ArcSight Logger TODAY! 
> http://p.sf.net/sfu/arcsight-sfd2d
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users