Re: [SL] Multiple Entries for Same Transaction

[Rich S. <rsh...@ap...>]

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

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863