[GNC] Disabling Lots Manager

[David T.]

David,

Lots get activated on an account by account basis; in any given account, 
you open the View Lots window and either create/assign lots manually or 
"Scrub" an account to have GnuCash automatically assign your shares to 
lots. Over the years, I've opted to implement the lots on a substantial 
number of accounts (but not all of them), and now I'm faced with the 
prospect of manually removing those lots from all the accounts that I 
previously used them on. For the record, when I saved the file in SQLite 
format, the lots table had 1084 rows in it. That's a lot of editing!

Complicating this is the fact that every time I open the lots 
viewer-even if just to delete the lots themselves, the program 
recalculates the gains transactions (regardless of the reconcile 
status). This means I am having to reopen all of my (15 years) 
statements and verify that the gains transactions are still accurate.

I haven't had this much fun since I had gum grafts on my teeth!

Thanks for commiserating.

Davd T.

On 12/4/2022 6:01 PM, David Carlson wrote:
> David, IIRC for databases that have never had the lots functionality 
> enabled,  it remains disabled.   This leads to the hope that it would 
> be possible to disable it, but that may or may not work.  At least,  
> in my case I never enabled it outside of one dedicated test case and 
> it seems to remain disabled as far as I can tell.
>
> From your description,  it appears to be fraught with problems, so 
> let's hope that it's affects can be purged from a database.   In a 
> perfect world there would be a simple setting or procedure to 
> accomplish that.
>
> Can a developer or other user help with this?
>
>
>
> On Sun, Dec 4, 2022, 5:04 AM David T. via gnucash-user 
> <gnucash-user at gnucash.org> wrote:
>
>     Hello,
>
>     Gnucash 4.11 Windows 10
>
>     Having struggled once again with the extremely unreliable aspects
>     of the
>     Lots Manager, I am resigned to the fact that, while an admirable
>     endeavor in concept, the Lots Manager is more trouble than it is
>     worth,
>     and leads to books that cannot be considered accurate over the
>     long term.
>
>     For the worst of these, see
>     https://bugs.gnucash.org/show_bug.cgi?id=798583 regarding how the
>     Lots
>     Manager will change RECONCILED GAINS TRANSACTIONS silently. A second
>     complaint I have is that if there is a Lot-generated gain
>     transaction in
>     the register, deleting this gain transaction ALSO DELETES THE SALE
>     TRANSACTION. I can't imagine why this would be considered an
>     appropriate
>     linkage to embed in the code, and there's nothing in the register to
>     indicate this linkage. I'm also not pleased that I have had frequent
>     crashes using the Lot Manager, to the extent that I have had to
>     reconcile the same accounts multiple times in a single day. That gets
>     old faster than I do.
>
>     Today, I'm hoping for two things:
>
>     First, I'd like to be able to determine which accounts in my books
>     have
>     lots embedded in them, so that I can go through and remove the
>     lots and
>     ensure that my books don't get corrupted YET AGAIN by this code. Any
>     ideas on how to expose (and root out and eliminate) these lots is
>     welcome.
>
>     Second, I would like to find a way to disable the Lots manager
>     entirely
>     for my books, so that I don't EVER make the mistaken assumption
>     that the
>     Lot Manager is a tool I can use with confidence. I recognize that
>     this
>     second ask is unlikely to be possible, but I am nevertheless
>     curious to
>     know how complicated it might be to strip out the code altogether
>     in my
>     own fork so that it doesn't cause me any more anguish.
>
>     David T.
>
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org
>     To update your subscription preferences or to unsubscribe:
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>