Re: [SL] Multiple Entries for Same Transaction

[Michael H. <mh...@it...>]

Are they near the new/old DST time change?  :)


On Mar 31, 2009, at 11:02 PM, Jerome J. Auza wrote:

Hi Rich,

Did you manage to find the problem for this one?  I ran into a similar
problem happening to a client running version 2.8.13.  This problem
started to show in Dec 2008 where  a POS transaction is shown multiple
times on different dates in GL.  They just noticed it recently that
there are ghost entries.  The ghost entries just seem to be both a debit
and a credit on the same account so overall, there is no effect but the
question is why are they showing up on different dates when creating a
GL report.  The correct data is the latest one.

jerome

http://www.techsier.com - Blog
http://www.boholweb.com - Bohol tourism website
http://www.auza.net - enabling e-services in Bohol



Rich Shepard wrote:

> On Tue, 10 Feb 2009, Michael Hasse wrote:
>
>
>
>> Well, what I'm really wondering is if there's something funny on  
>> the back
>> end, like maybe a duplicate entry for an actual account, where the
>> bad/dupe/whatever record has always existed but previous versions  
>> of SL
>> did a "select unique" and so you only ever saw single entries. Your
>> reposting could be "cleaning" the entries but not necessarily  
>> curing the
>> underlying problem.  If the cause can be tracked down then it  
>> could be
>> fixed properly and not have the risk of it cropping back up.  Just my
>> $1.50, (inflation, y'know :).
>>
>>
>
> Michael,
>
>   You raise valid concerns. After I get things looking correct I'll  
> rummage
> around the tables using psql. Actually, what I want to do is set up  
> scema
> (scemae?), one for each year. I have to read the Douglas^2 book to  
> see if I
> can do this retroactively. I've 5 full years of data in the system.
>
> Thanks,
>
> Rich
>
>
>

------------------------------------------------------------------------ 
------
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users