Re: Receipts not posting to acc_trans table

[Benjamin L. <ben...@co...>]

I'm no authority on the code, although I have poked around a bit. ;-)

Firstly, I've honestly never seen this bug before.

Secondly, I suggest turning on the debugging of your SQL server
(e.g. Postgresql) and watch the SQL statements that are logged when
you click 'Process Receipts'... this will definitely show you where
the problem is.


On Sat, Jun 16, 2001 at 09:29:07PM -0500, Michael Bush wrote:
> Hi Everyone:
> 
> Does anyone know where in the SQL-Ledger AR code (i.e. filename, line 
> number) the receipts posting is done so I might track down my issue below?  
> Sorry, I am a little rusty on Perl coding and the program flow of 
> SQL-Ledger.
> 
> Thanks in advance.
> 
> Michael Bush
> -- 
> Digital Minds International
> http://www.DigitalMinds.net
> Tel: 615-661-7900
> Fax: 615-661-7949
> 
> > Hi Dieter:
> > 
> > Just following up our previous e-mail posts, it appears that when
> > posting  receipts under the Receipts menu they are not posting to the
> > acc_trans  table.
> > 
> > We are selecting all open receipts under the Receipts menu and then
> > getting  the results back.  Next, entering in the amounts from the
> > payment received  (note:  not all payments may have been received) we
> > click on Process  Receipts.  No errors messages appear and all looks
> > good.  However, when you  go to Account 1061 in the Account List and
> > search for receipts for the date  you received them on there are no
> > transactions.  I have viewed the acc_trans  table for the transactions
> > and they are not there.  To further confirm this  issue, the Checking
> > Account 1061 balance does not change.
> > 
> > Another note, the acc_trans table will be update if you edit an invoice
> >  payment amount to 0 and then put the amount back. However, the payment
> > date  is the date of the invoice.
> > 
> > Any quick ideas on how to track down and solve this issue?  It did not 
> > appear until upgrading from 1.2.9 to 1.4.3.  It is still happening on
> > 1.4.5.
> > 
> > Regards,
> > 
> > Michael Bush
> > -- 
> > Digital Minds International
> > http://www.DigitalMinds.net
> > Tel: 615-661-7900
> > Fax: 615-661-7949
> 
> 
> 
> 

-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
The trouble with telling a good story is that it invariably reminds
the other fellow of a dull one.
		-- Sid Caesar