Re: [SL] Multiple Entries for Same Transaction

[Jerome J. A. <jer...@bo...>]

No DST for our timezone and TZ is set to local time.

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



Michael Hasse wrote:

>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
>
>
>------------------------------------------------------------------------------
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>