[GNC] Disabling Lots Manager
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@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.
Re: [GNC] gnucash in tandem with SuiteCRM or other CRMs
I don't use a CRM with Gnucash, but you might be able to achieve what you need - it depends on what you mean exactly by "keeping customer contacts/accounts up to date". Do you mean: 1. Adding customers to the CRM, 2. Importing them into gnucash so that you have the same customers in your CRM and gnucash 3. Using gnucash the handle the invoices and payments I see that SuiteCRM can export info as csv files, and gnucash can import customer details, so you might be able to have a workflow that accomplishes this via csv files. See this page for info on the gnucash csv import structure: https://www.gnucash.org/docs/v4/C/gnucash-guide/busnss-imp-customer-vendor.html David On Fri, 2 Dec 2022 at 09:02, slidinghorn via gnucash-user < gnucash-user@gnucash.org> wrote: > Hello, > > I tried to join the IRC via the matrix bridge, but there's no way to speak > in the room if you aren't registered on the server, and you can't register > without an IRC client... > > Anyway, this isn't really a support request as much as it is a request for > anyone who uses gnucash in tandem with a CRM (Customer Relationship > Management) application - most specifically SuiteCRM. I wanted to know if > anyone does this successfully, how they manage the workflow in terms of > keeping customer contacts/accounts up to date, if they have to manually > enter everything in both places, etc. > > I'm looking into starting my own small business, and while I think it's > almost certain to remain small enough that entering that kind of > information twice won't be *too* much of a hassle, it would definitely be > nice if someone's figured out a way to not have to duplicate that work. > > Thanks in advance for any stories or input you can provide! > > P.S. If/when I get a reply, I assume I should "Reply All", correct? It's > been years since I've used a mailing list, and I'm rusty on the practice, > lol > > > Sent with Proton Mail secure email. > ___ > gnucash-user mailing list > gnucash-user@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. > -- David Whiting ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Disabling Lots Manager
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@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@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Disabling Lots Manager
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 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@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. ___ gnucash-user mailing list gnucash-user@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.
[GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Hi all: New user questions follow, I'm afraid... I have no trouble following the directions in the wiki for migrating from Quicken. I made the QIF file, imported it into GnuCash, and watched it very unhelpfully create 100 different accounts. The instructions do mentions this, and it's ability to match against Quicken categories is impressive, but it's not what I desire. In Quicken this account is a simple, flat, checking account. How can I take the 100 separate accounts and represent them in a simple, flat, single checking account register? Is there no way to do this? Thanks, Scott ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Hi Scott, This took some getting used to when I moved from Quicken 7 years or so ago. The categories become accounts. This is required for double entry accounting and makes sense. When you pay your electric bill, money moves from checking to the electric company. GNUCash has to show money moving between accounts. Once I got my head around it it was pretty simple. Michael On Sun, Dec 4, 2022 at 9:46 AM Scott Traurig wrote: > Hi all: > > New user questions follow, I'm afraid... > > I have no trouble following the directions in the wiki for migrating from > Quicken. I made the QIF file, imported it into GnuCash, and watched it very > unhelpfully create 100 different accounts. The instructions do mentions > this, and it's ability to match against Quicken categories is impressive, > but it's not what I desire. > > In Quicken this account is a simple, flat, checking account. How can I take > the 100 separate accounts and represent them in a simple, flat, single > checking account register? Is there no way to do this? > > Thanks, > > Scott > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott -- Forgive me if I misinterpreted your request -- but if I am reading it correctly, what you describing is not in line with the way GNU-Cash works. You see GNU-cash works as a double-entry (two-sided) accounting system. What that means is that for every transaction - there must be an opposite and equal counter-transaction. Let me give you an example: If I purchase groceries with a check, in the GNU-Cash world, there will exist at least two transactions. One (a debit to my checking account - which decreases the balance); and a second counter-transaction which will post the credit. In many cases, you might have an expense account called - Expenses: Groceries. That accounts balance will increase by the amount you just purchased. To make this more concrete, let's use an example: Balance in Checking Account: $220 Balance in Expense Groceries Account: $0 You go to the store - purchase $50 in groceries - and write check 1001 for $50, reducing your checking account balance to $170. Transaction in the Checking register: Date| NUM| Description | Transfer |Deposit |Withdrawal| Balance | 12/4/2022 | 1001| Local Grocery Store |Expenses:Groceries | | 50.00|170.00| Meanwhile, this transaction has also generated a separate equal and corresponding transaction in the Expenses"Groceries account that looks like this: Date| NUM| Description | Transfer |Expense |Rebate| Balance | 12/4/2022 | 1001| Local Grocery Store |Expenses:Groceries | 50.00| |50.00| So every transaction has a separate and equal "counter-transaction". In this way, everything remains in balance. So you see, the reason you are seeing so many accounts is because each category that you spend on will have a separate account. The nice thing about this, is that if you want to know how much you spent on any separate area (groceries, utilities, etc.) you will always have a separate account which shows how much you have spent. As I said, I hope this helps explain why you are seeing what you are seeing. You should just have one account (register) for your checking account. The other accounts are all the counter expense (or deposit) accounts. Ken -Original Message- From: gnucash-user On Behalf Of Scott Traurig Sent: Sunday, December 4, 2022 7:45 AM To: gnucash-user@gnucash.org Subject: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account Hi all: New user questions follow, I'm afraid... I have no trouble following the directions in the wiki for migrating from Quicken. I made the QIF file, imported it into GnuCash, and watched it very unhelpfully create 100 different accounts. The instructions do mentions this, and it's ability to match against Quicken categories is impressive, but it's not what I desire. In Quicken this account is a simple, flat, checking account. How can I take the 100 separate accounts and represent them in a simple, flat, single checking account register? Is there no way to do this? Thanks, Scott ___ gnucash-user mailing list gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
This is a common concern whenever someone (including me) is migrating to Gnucash. As is noted elsewhere, it's a conceptual change based on Quicken Category => Gnucash Account. What I realized when I converted years and years of data over is just how terrible I was at maintaining some sort of consistency in Categories. I'd have dozens of accounts, each with maybe one or two transactions, that all were basically the same thing. They were likely the result of typing errors or "eh, I'll fix it later" transaction entries. Once I had converted all my data, I found that it was much easier to organize the accounts that were categories into a reasonable structure. It takes a bit of work, but it is nice to have "clean" accounts without the weird random categories I had in Quicken. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
I do understand double-entry accounting and that it is the GnuCash paradigm. What I didn't understand is that on the import GnuCash did create the requisite checking account, plus all the expense accounts. I did not see the checking account as it was lost in a sea of expense accounts. Now that I've gotten that far, is there any way to move accounts en masse into a top level "Expenses" account? Or do I have to laboriously edit each and every one? Thanks, Scott ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Stock spinoff
Companies used to send shareholders a letter stating the relative valuations of the spun off and original shares, but the last couple of spinoffs I've had they instead posted it on the original company's website and I had to Google for it. In some cases you might have to find the SEC filing for the spinoff to get the ratio. You then apply that ratio to the basis of each lot of the original stock that you own. It can be pretty tedious to create all of the splits required to reflect the basis in GnuCash. I often do it in a spreadsheet and make a docllink to that on the spinoff transaction instead. Regards, John Ralls > On Dec 3, 2022, at 9:33 PM, David T. via gnucash-user > wrote: > > Well said, Geoff. > > I'd add that creating the new share is a simple process of making a > transaction that adds the new share to its account. > > It's the determination of cost basis (for both the original shares and the > new share you received) that complicates things. These affect future gains > calculations. > > David T. > > On Dec 4, 2022, 3:49 AM, at 3:49 AM, Geoff wrote: >> Hi Fred >> >> First up you need more details on this transaction to determine the >> exact nature of the spin-off, the valuations, and whether ABC treated >> it >> as a dividend, capital reduction, or combination of both. Was there a >> cash payment as well? Any fractional shares involved? Were capital >> gains/losses crystallised or carried forward? >> >> ABC should have sent you information about this, otherwise Google it. >> >> You may find this article helpful:- >> https://www.henssler.com/spin-offs/ >> >> Once you have all the details, we can suggest how to record it in >> GnuCash. >> >> >> Regards >> >> Geoff >> = >> >> On 4/12/2022 11:15 am, Fred Tydeman wrote: >>> In looking at the Help file within GnuCash, I found a section on >> Splits and >>> Mergers. After reading that section, I still do not know how to >> enter a >>> Spinoff. That it, I have 25 shares of ABC stock. They did some kind >> of >>> spin off and gave me 1 share of XYZ stock. I still have 25 shares of >> ABC. >>> How do I record this? >>> ___ >>> gnucash-user mailing list >>> gnucash-user@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. >> ___ >> gnucash-user mailing list >> gnucash-user@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. > ___ > gnucash-user mailing list > gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
An easy way to "move" many entries is to *delete* the offending account and let GnuCash move it to another account. Say you have utilities:water as an account but also utilities:Watercompany. Then you simply delete one and ask GnuCash to move all transactions to the other. All in one fell swoop. Moving from Quicken (single entry) to GnuCash (Double entry) is at times a good deal of work before you have it the way you like it. It may even be of value to you to redo the import as you better understand GnuCash. On Sun, Dec 4, 2022 at 9:55 AM Scott Traurig wrote: > I do understand double-entry accounting and that it is the GnuCash > paradigm. > > What I didn't understand is that on the import GnuCash did create the > requisite checking account, plus all the expense accounts. I did not see > the checking account as it was lost in a sea of expense accounts. > > Now that I've gotten that far, is there any way to move accounts en masse > into a top level "Expenses" account? Or do I have to laboriously edit each > and every one? > > Thanks, > > Scott > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
On 04 December 2022 at 11:54, Scott Traurig said: > I do understand double-entry accounting and that it is the GnuCash > paradigm. > > What I didn't understand is that on the import GnuCash did create the > requisite checking account, plus all the expense accounts. I did not see > the checking account as it was lost in a sea of expense accounts. > > Now that I've gotten that far, is there any way to move accounts en masse > into a top level "Expenses" account? Or do I have to laboriously edit each > and every one? What *might* work is to delete the unwanted accounts. When you delete an account, Gnucash will ask what you want to do with the transactions in it. You can move them to another (already existing) account. This will let you (for example) consolidate the grocery transactions, with 17 different vendors, into one "Expenses:Grocery" account. If you really want all the expenses in a single account then I suggest you don't want an accounting system and Gnucash is not the solution you are looking for. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Nope, sorry, you gents did not understand my question. I don't have any unwanted accounts. Indeed, all of my categories in Quicken were well thought out and organized, and well replicated as separate expense accounts in GnuCash via the import process. But with some 100 different, well organized and well thought out expense accounts, I don't want them all at the top level, which is where GnuCash puts them upon import. In the GnuCash paradigm, I now have top level placeholder accounts for assets, liabilities, income and expenses. For income, assets and liabilities it was not much of a chore to move those few accounts that were imported to be under their proper, respective placeholders in the hierarchy. But now I need to move all 100 or so expense accounts, intact, from the top level to underneath the top level, placeholder expense account. That's a huge PITA if I have to edit the properties of each one individually. Drag and drop would be a modern UI method for this, alas it does not exist in GnuCash. Is there an easy way to do this, or just grunt it out? Thanks, Scott ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Disabling Lots Manager
If I understand correctly, the AR & AP accounts use them to track links between payments and bills/invoices. If you don't use the Business Features, then those two shouldn't be an issue. I'm not so sure simply using View Lots is how they are activated for an account. Some accounts have none anyway. (like a cash account) I would think that some types of accounts use them and others do not. And I didn't think they were optional or that I had the ability to turn them on or not. But if so, there should certainly be a way to turn them off. The bugs you mention are pretty bad, especially the one about auto re-calculating gains just by viewing them. That's a nightmare. I'd call it a 'blocking bug' or at least very high severity. (along with the bug that silently deletes linked sale transactions) Regards, Adrien On 12/4/22 9:16 AM, David T. via gnucash-user wrote: 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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott, If I understand correctly, what you expected was a chart of accounts with one asset account for checking and all other accounts lumped under expenses. Maybe one account for income. You should be able to get to that result with an import from Quicken but it may take some or perhaps a lot of manipulation depending on the condition of your source. You don't really need to reduce all the expense accounts into one because they are already collected under the single top account called Expense. Good luck On Sun, Dec 4, 2022, 11:57 AM Fred Bone wrote: > On 04 December 2022 at 11:54, Scott Traurig said: > > > I do understand double-entry accounting and that it is the GnuCash > > paradigm. > > > > What I didn't understand is that on the import GnuCash did create the > > requisite checking account, plus all the expense accounts. I did not see > > the checking account as it was lost in a sea of expense accounts. > > > > Now that I've gotten that far, is there any way to move accounts en masse > > into a top level "Expenses" account? Or do I have to laboriously edit > each > > and every one? > > What *might* work is to delete the unwanted accounts. > > When you delete an account, Gnucash will ask what you want to do with the > transactions in it. You can move them to another (already existing) > account. This will let you (for example) consolidate the grocery > transactions, with 17 different vendors, into one "Expenses:Grocery" > account. > > If you really want all the expenses in a single account then I suggest > you don't want an accounting system and Gnucash is not the solution you > are looking for. > > > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
[GNC] Is there a way to change font and font size (Windows 10 and 11)?
I found this wiki entry: https://wiki.gnucash.org/wiki/GTK3 And I found this directory: C:\Users\my-user-name\AppData\Local\gtk-3.0 I created the settings.ini file as shown in the wiki and set the new font definition. But no changes are evident when I restart GnuCash. Is there any way to do this on Windows 10 and 11? Thanks, Scott ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
That was the politest "No, you are stuck doing it manually" response I've ever seen ;-) Thanks, Scott On Sun, Dec 4, 2022 at 1:25 PM David Carlson wrote: > Scott, > > If I understand correctly, what you expected was a chart of accounts with > one asset account for checking and all other accounts lumped under > expenses. Maybe one account for income. > > You should be able to get to that result with an import from Quicken but > it may take some or perhaps a lot of manipulation depending on the > condition of your source. You don't really need to reduce all the expense > accounts into one because they are already collected under the single top > account called Expense. > > Good luck > > On Sun, Dec 4, 2022, 11:57 AM Fred Bone wrote: > >> On 04 December 2022 at 11:54, Scott Traurig said: >> >> > I do understand double-entry accounting and that it is the GnuCash >> > paradigm. >> > >> > What I didn't understand is that on the import GnuCash did create the >> > requisite checking account, plus all the expense accounts. I did not see >> > the checking account as it was lost in a sea of expense accounts. >> > >> > Now that I've gotten that far, is there any way to move accounts en >> masse >> > into a top level "Expenses" account? Or do I have to laboriously edit >> each >> > and every one? >> >> What *might* work is to delete the unwanted accounts. >> >> When you delete an account, Gnucash will ask what you want to do with the >> transactions in it. You can move them to another (already existing) >> account. This will let you (for example) consolidate the grocery >> transactions, with 17 different vendors, into one "Expenses:Grocery" >> account. >> >> If you really want all the expenses in a single account then I suggest >> you don't want an accounting system and Gnucash is not the solution you >> are looking for. >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Let's get this cleared up: You're telling us that *all* of your expense accounts are *not* under the top-level 'Expenses' account but exist as each their own top-level account? (but maybe of 'type' Expense) If so, that sounds like an error (I'll hazard, user) in the import. The easiest thing would be to ditch that book and do it again, being certain this time to indicate that the categories are expense accounts and belong under the top-level Expense account as a parent. I'm not certain of the UI mechanics there as I've never done this transition myself. Others can likely help. (or maybe you missed something in the Wiki?) If they are already under Expenses, such as: Expenses:Telephone Then if you simply want to create intermediate hierarchy levels like: Expenses:Utilities:Telephone Create the intermediary accounts, mark them as Placeholders, then re-parent the relevant accounts under them. Regards, Adrien On 12/4/22 12:15 PM, Scott Traurig wrote: Nope, sorry, you gents did not understand my question. I don't have any unwanted accounts. Indeed, all of my categories in Quicken were well thought out and organized, and well replicated as separate expense accounts in GnuCash via the import process. But with some 100 different, well organized and well thought out expense accounts, I don't want them all at the top level, which is where GnuCash puts them upon import. In the GnuCash paradigm, I now have top level placeholder accounts for assets, liabilities, income and expenses. For income, assets and liabilities it was not much of a chore to move those few accounts that were imported to be under their proper, respective placeholders in the hierarchy. But now I need to move all 100 or so expense accounts, intact, from the top level to underneath the top level, placeholder expense account. That's a huge PITA if I have to edit the properties of each one individually. Drag and drop would be a modern UI method for this, alas it does not exist in GnuCash. Is there an easy way to do this, or just grunt it out? ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
What you need to do is start a new file and position those expenses correctly under the the top expense level during the import process. That is not really very hard with a couple of expendable tries to see how it works. On Sun, Dec 4, 2022, 12:17 PM Scott Traurig wrote: > Nope, sorry, you gents did not understand my question. > > I don't have any unwanted accounts. Indeed, all of my categories in Quicken > were well thought out and organized, and well replicated as separate > expense accounts in GnuCash via the import process. > > But with some 100 different, well organized and well thought out expense > accounts, I don't want them all at the top level, which is where GnuCash > puts them upon import. > > In the GnuCash paradigm, I now have top level placeholder accounts for > assets, liabilities, income and expenses. For income, assets and > liabilities it was not much of a chore to move those few accounts that were > imported to be under their proper, respective placeholders in > the hierarchy. But now I need to move all 100 or so expense accounts, > intact, from the top level to underneath the top level, placeholder expense > account. That's a huge PITA if I have to edit the properties of each one > individually. Drag and drop would be a modern UI method for this, alas it > does not exist in GnuCash. > > Is there an easy way to do this, or just grunt it out? > > Thanks, > > Scott > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
So I did the import wrong. Crap. Too late, I already gutted it out and manually rearranged it all! Thanks, Scott >> ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Disabling Lots Manager
Adrien, I don't know anything about the business features. My statement regarding lot activation wasn't clear; you must open the Lot Manager *AND* create lots-- either manually, or by using the scrub feature. David T. On Dec 4, 2022, 9:22 PM, at 9:22 PM, Adrien Monteleone wrote: >If I understand correctly, the AR & AP accounts use them to track links > >between payments and bills/invoices. If you don't use the Business >Features, then those two shouldn't be an issue. > >I'm not so sure simply using View Lots is how they are activated for an > >account. Some accounts have none anyway. (like a cash account) > >I would think that some types of accounts use them and others do not. >And I didn't think they were optional or that I had the ability to turn > >them on or not. But if so, there should certainly be a way to turn them >off. > >The bugs you mention are pretty bad, especially the one about auto >re-calculating gains just by viewing them. That's a nightmare. I'd call > >it a 'blocking bug' or at least very high severity. (along with the bug > >that silently deletes linked sale transactions) > >Regards, >Adrien > >On 12/4/22 9:16 AM, David T. via gnucash-user wrote: >> 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. > >___ >gnucash-user mailing list >gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Is there a way to change font and font size (Windows 10 and 11)?
Scott,
The following works for me on Win10 and is in C:\Users\\AppData\Roaming\GnuCash\gtk-3.0.css .
I assume you're using Gnucash 4.12 ???
Cheers David H.
/* This is an example GTK CSS file that can be used with Gnucash.
Simply copy this file to the location specified below according
to your platform and then restart gnucash.
- Windows: CSIDL_APPDATA/GnuCash
(or the default is users\%USERNAME%\AppData\Roaming\GnuCash)
- OS X: $HOME/Application Support/GnuCash
- Linux: $XDG_CONFIG_HOME/gnucash
(or the default is $HOME/.config/gnucash)
These settings are mainly to do with register colors and can be seen
when the preference setting 'Register\Use GnuCash built-in color theme'
is unset.
Note: Widgets obtained from Glade files will not be addressable
directly by name as these are not brought in when loaded, only
the widget type can be configured unless they are named in code.
*/
/* Application wide font setting */
* {
font: 14px arial;
}
/* Register User Colors, remove 'user' for builtin register values */
.gnc-class-user-register-header {
background-color: seagreen;
color: white;
}
.gnc-class-user-register-primary {
background-color: pink;
}
.gnc-class-user-register-primary:disabled {
background-color: plum;
}
.gnc-class-user-register-secondary {
background-color: lightgreen;
}
.gnc-class-user-register-secondary:disabled {
background-color: plum;
}
.gnc-class-user-register-split {
background-color: lightblue;
}
.gnc-class-user-register-split:disabled {
background-color: plum;
}
.gnc-class-user-register-cursor {
background-color: #00BFFF;
color: white;
border-radius: 0px;
}
On Mon, 5 Dec 2022 at 04:28, Scott Traurig wrote:
> I found this wiki entry:
>
> https://wiki.gnucash.org/wiki/GTK3
>
> And I found this directory:
>
> C:\Users\my-user-name\AppData\Local\gtk-3.0
>
> I created the settings.ini file as shown in the wiki and set the new font
> definition. But no changes are evident when I restart GnuCash.
>
> Is there any way to do this on Windows 10 and 11?
>
> Thanks,
>
> Scott
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] New user: how to migrate Quicken checking account as a single, flat, checking account
Scott You can edit the accounts and in the dialoguechange the account type to Expense and the parent to the top level expenses account.Unfortunately its a one at a time operation David Cousens On Sun, 2022-12-04 at 13:39 -0500, Scott Traurig wrote: > So I did the import wrong. Crap. Too late, I already gutted it out and > manually rearranged it all! > > Thanks, > > Scott > > > > > > ___ > gnucash-user mailing list > gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
[GNC] searching for inventory tags -- bind keys -- best ways
I buy and sell things, tracking the cost of goods sold, and each item or quantity of identical items gets an alphanumeric tag Like CCB, CCD, CCD, etc. After I make a sale with an invoice I sometimes do several more sales, then expense cost of goods sold for all of them. I put the inventory tag in the description on an invoice, but that does not show in the receivables account. Is there a good way to search for tags so I can find all matching entries for a tag? I use f a lot, which gives me by default the description to search on and seems to not depend on selecting a line in an account -- it works to find a tag in assets even if expense is selected. It won't find a tag in an invoice though, and the entry for an invoice in accounts receivable does not include the description line so it does not match there either. AR entries are not editable, so I cannot go and put the tag there after posting an invoice. So, my general question is: "Do you know a good way to search for inventory tags so as to make sure COGS has been expensed, and see the sale as a search result?" If I search on memo, and have the tag in all the memo lines the search results are pretty good for checking my work. Is there a way to create bind keys like the f for search on description? I'd like one for search on memo... PS: since posing these questions, I've looked more at memo lines and find that AR payment memo lines *ARE* editable. So now I will be adding my inventory tags to those AR memo lines when doing a payment , or after! Any other ideas for doing inventory well? ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Is there a way to change font and font size (Windows 10 and 11)?
This worked, David, thank you.
Scott
On Sun, Dec 4, 2022 at 2:35 PM David H wrote:
> Scott,
>
> The following works for me on Win10 and is in C:\Users\ name>\AppData\Roaming\GnuCash\gtk-3.0.css .
>
> I assume you're using Gnucash 4.12 ???
>
> Cheers David H.
>
> /* This is an example GTK CSS file that can be used with Gnucash.
>Simply copy this file to the location specified below according
>to your platform and then restart gnucash.
> - Windows: CSIDL_APPDATA/GnuCash
> (or the default is users\%USERNAME%\AppData\Roaming\GnuCash)
> - OS X: $HOME/Application Support/GnuCash
> - Linux: $XDG_CONFIG_HOME/gnucash
> (or the default is $HOME/.config/gnucash)
> These settings are mainly to do with register colors and can be seen
> when the preference setting 'Register\Use GnuCash built-in color theme'
> is unset.
> Note: Widgets obtained from Glade files will not be addressable
> directly by name as these are not brought in when loaded, only
> the widget type can be configured unless they are named in code.
> */
>
> /* Application wide font setting */
> * {
> font: 14px arial;
> }
> /* Register User Colors, remove 'user' for builtin register values */
> .gnc-class-user-register-header {
> background-color: seagreen;
> color: white;
> }
>
> .gnc-class-user-register-primary {
> background-color: pink;
> }
>
> .gnc-class-user-register-primary:disabled {
> background-color: plum;
> }
>
> .gnc-class-user-register-secondary {
> background-color: lightgreen;
> }
>
> .gnc-class-user-register-secondary:disabled {
> background-color: plum;
> }
>
> .gnc-class-user-register-split {
> background-color: lightblue;
> }
>
> .gnc-class-user-register-split:disabled {
> background-color: plum;
> }
>
> .gnc-class-user-register-cursor {
> background-color: #00BFFF;
> color: white;
> border-radius: 0px;
> }
>
> On Mon, 5 Dec 2022 at 04:28, Scott Traurig
> wrote:
>
>> I found this wiki entry:
>>
>> https://wiki.gnucash.org/wiki/GTK3
>>
>> And I found this directory:
>>
>> C:\Users\my-user-name\AppData\Local\gtk-3.0
>>
>> I created the settings.ini file as shown in the wiki and set the new font
>> definition. But no changes are evident when I restart GnuCash.
>>
>> Is there any way to do this on Windows 10 and 11?
>>
>> Thanks,
>>
>> Scott
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
>
___
gnucash-user mailing list
gnucash-user@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.
[GNC] Colum headers missing on all accounts
GnuCash 4.12 on Windows 10 Pro.
I was rearranging the sizes of the columns in one of the account ledgers
and now both the Transfer and Reconcile ("R") column labels are gone.
No amount of rearranging or double clicking of columns is bringing those
labels back.
This is affecting ALL accounts.
I tried uninstalling GnuCash, I even manually deleted the appdata and
program files folders. This was no help.
I tried making a new account, it appears the same way. Again this affects
all accounts in the file.
Opening the oldest backup makes no difference.
Creating a brand new file with brand new accounts exhibits the same problem.
Given that I have nearly an entire day involved now in migrating from
Quicken and polishing up the books this is fairly disastrous.
Is there any way to get these column labels back?
Thanks,
Scott
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Adding to this: I installed on another Windows machine and the account
(.gnucash) file is 100% fine. The missing column labels are not missing on
the new machine.
So somewhere on my main PC resides a file or registry entry that is NOT
removed by Windows uninstall that is causing the problem in a persistent
manner. Does anyone know where this file or registry entry is so I can kill
it?
Thanks,
Scott
On Sun, Dec 4, 2022 at 4:06 PM Scott Traurig
wrote:
> GnuCash 4.12 on Windows 10 Pro.
>
> I was rearranging the sizes of the columns in one of the account ledgers
> and now both the Transfer and Reconcile ("R") column labels are gone.
>
> No amount of rearranging or double clicking of columns is bringing those
> labels back.
>
> This is affecting ALL accounts.
>
> I tried uninstalling GnuCash, I even manually deleted the appdata and
> program files folders. This was no help.
>
> I tried making a new account, it appears the same way. Again this affects
> all accounts in the file.
>
> Opening the oldest backup makes no difference.
>
> Creating a brand new file with brand new accounts exhibits the same
> problem.
>
> Given that I have nearly an entire day involved now in migrating from
> Quicken and polishing up the books this is fairly disastrous.
>
> Is there any way to get these column labels back?
>
> Thanks,
>
> Scott
>
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
You have shrunk those columns down to nothing and very carefully need to
drag right to open them up again - happens now and then. First you need to
remember where they are, difficult to see but they may be a little wider
than the other column markers? Or you could just delete the prefs for that
file on that pc.
Cheers David H.
On Mon, 5 Dec 2022, 7:44 am Scott Traurig, wrote:
> Adding to this: I installed on another Windows machine and the account
> (.gnucash) file is 100% fine. The missing column labels are not missing on
> the new machine.
>
> So somewhere on my main PC resides a file or registry entry that is NOT
> removed by Windows uninstall that is causing the problem in a persistent
> manner. Does anyone know where this file or registry entry is so I can kill
> it?
>
> Thanks,
>
> Scott
>
>
>
> On Sun, Dec 4, 2022 at 4:06 PM Scott Traurig
> wrote:
>
> > GnuCash 4.12 on Windows 10 Pro.
> >
> > I was rearranging the sizes of the columns in one of the account ledgers
> > and now both the Transfer and Reconcile ("R") column labels are gone.
> >
> > No amount of rearranging or double clicking of columns is bringing those
> > labels back.
> >
> > This is affecting ALL accounts.
> >
> > I tried uninstalling GnuCash, I even manually deleted the appdata and
> > program files folders. This was no help.
> >
> > I tried making a new account, it appears the same way. Again this affects
> > all accounts in the file.
> >
> > Opening the oldest backup makes no difference.
> >
> > Creating a brand new file with brand new accounts exhibits the same
> > problem.
> >
> > Given that I have nearly an entire day involved now in migrating from
> > Quicken and polishing up the books this is fairly disastrous.
> >
> > Is there any way to get these column labels back?
> >
> > Thanks,
> >
> > Scott
> >
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
On 2022-12-04 13:06, Scott Traurig wrote:
> GnuCash 4.12 on Windows 10 Pro.
>
> I was rearranging the sizes of the columns in one of the account
> ledgers and now both the Transfer and Reconcile ("R") column labels
> are gone.
As you might expect, yours is a Frequently Asked Question. You'll want
to bookmark the FAQ at
Your specific question is answered at
It tells you how to restore a disappeared column.
While you're at it, you might want to bookmark the documentation portal:
https://www.gnucash.org/docs.phtml
Stan Brown
Tehachapi, CA, USA
https://BrownMath.com
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] [GNC-dev] Missing column header labels after resizing columns (Windows 10, GC version 4.12)
That's a user-list question. I've changed the CC for your convenience.
The file you're looking for is the book's metadata file, see
https://wiki.gnucash.org/wiki/Metadata_File. It stores among other things
window sizes and column widths for registers.
Regards,
John Ralls
> On Dec 4, 2022, at 1:56 PM, Scott Traurig wrote:
>
> Dev's,
>
> After resizing some column headers in an account, the labels for the
> Transfer and Reconciled ("R") columns have disappeared. The header blocks
> for both are now combined into a single blank field.
>
> I tried un-installing, including manually removing the folders in %appdata%
> and Program Files (x86), but the problem persists after re-installing
> GnuCash.
>
> I grabbed another Windows 10 machine, installed on it, and opened the
> .gnucash file that I normally use from it's normal directory on my NAS
> without the same problem appearing--all column headers are fine. So the
> .gnucash file is OK.
>
> Thus it would appear that there is a file that is not removed during a
> Windows uninstall (or the manual files I deleted), or a registry setting
> that persists and continues to cause this behavior on my main PC.
>
> If someone could identify the offending file or registry setting for me so
> that I can kill it it would be most appreciated.
>
> Thanks,
>
> Scott
> ___
> gnucash-devel mailing list
> gnucash-de...@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Stan,
That FAQ entry looked promising, but it does not solve the problem. There
are no entries in the .gcm file showing zero width to edit.
Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
name\AppData\Roaming\GnuCash directory, including all .gcm files such that
they would be reconstituted from scratch, does not work either.
Interestingly, somewhere in the system it remembers what book I had open
even through an uninstall/reinstall cycle. I suspect it has something to do
with that.
Thanks,
Scott
On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
wrote:
>
>
> On 2022-12-04 13:06, Scott Traurig wrote:
> > GnuCash 4.12 on Windows 10 Pro.
> >
> > I was rearranging the sizes of the columns in one of the account
> > ledgers and now both the Transfer and Reconcile ("R") column labels
> > are gone.
>
> As you might expect, yours is a Frequently Asked Question. You'll want
> to bookmark the FAQ at
>
>
> Your specific question is answered at
> <
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
> >
> It tells you how to restore a disappeared column.
>
> While you're at it, you might want to bookmark the documentation portal:
> https://www.gnucash.org/docs.phtml
>
> Stan Brown
> Tehachapi, CA, USA
> https://BrownMath.com
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
There are also settings in the Registry ?
Cheers David H.
On Mon, 5 Dec 2022, 10:00 am Scott Traurig, wrote:
> Stan,
>
> That FAQ entry looked promising, but it does not solve the problem. There
> are no entries in the .gcm file showing zero width to edit.
>
> Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
> name\AppData\Roaming\GnuCash directory, including all .gcm files such that
> they would be reconstituted from scratch, does not work either.
>
> Interestingly, somewhere in the system it remembers what book I had open
> even through an uninstall/reinstall cycle. I suspect it has something to do
> with that.
>
> Thanks,
>
> Scott
>
> On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
> wrote:
>
> >
> >
> > On 2022-12-04 13:06, Scott Traurig wrote:
> > > GnuCash 4.12 on Windows 10 Pro.
> > >
> > > I was rearranging the sizes of the columns in one of the account
> > > ledgers and now both the Transfer and Reconcile ("R") column labels
> > > are gone.
> >
> > As you might expect, yours is a Frequently Asked Question. You'll want
> > to bookmark the FAQ at
> >
> >
> > Your specific question is answered at
> > <
> >
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
> > >
> > It tells you how to restore a disappeared column.
> >
> > While you're at it, you might want to bookmark the documentation portal:
> > https://www.gnucash.org/docs.phtml
> >
> > Stan Brown
> > Tehachapi, CA, USA
> > https://BrownMath.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Can you point me to them?
Thanks,
Scott
On Sun, Dec 4, 2022 at 7:11 PM David H wrote:
> There are also settings in the Registry ?
>
> Cheers David H.
>
> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
> wrote:
>
>> Stan,
>>
>> That FAQ entry looked promising, but it does not solve the problem. There
>> are no entries in the .gcm file showing zero width to edit.
>>
>> Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
>> name\AppData\Roaming\GnuCash directory, including all .gcm files such that
>> they would be reconstituted from scratch, does not work either.
>>
>> Interestingly, somewhere in the system it remembers what book I had open
>> even through an uninstall/reinstall cycle. I suspect it has something to
>> do
>> with that.
>>
>> Thanks,
>>
>> Scott
>>
>> On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
>> wrote:
>>
>> >
>> >
>> > On 2022-12-04 13:06, Scott Traurig wrote:
>> > > GnuCash 4.12 on Windows 10 Pro.
>> > >
>> > > I was rearranging the sizes of the columns in one of the account
>> > > ledgers and now both the Transfer and Reconcile ("R") column labels
>> > > are gone.
>> >
>> > As you might expect, yours is a Frequently Asked Question. You'll want
>> > to bookmark the FAQ at
>> >
>> >
>> > Your specific question is answered at
>> > <
>> >
>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
>> > >
>> > It tells you how to restore a disappeared column.
>> >
>> > While you're at it, you might want to bookmark the documentation portal:
>> > https://www.gnucash.org/docs.phtml
>> >
>> > Stan Brown
>> > Tehachapi, CA, USA
>> > https://BrownMath.com
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@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.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
>
___
gnucash-user mailing list
gnucash-user@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.
[GNC] Why doesn't GnuCash have an Export function?
Hi all and forgive me if this has been asked and answered before. I'm trying to get used to this particular list server and how it functions and my search didn't seem to return what I thought it should. I was trying to migrate from Linux (Suse Leap 15.3) to Windows 11. I'm being forced into this because of customers and Teams (which crashed my Linux system), and the lack of Adobe Acrobat for Linux. I finally gave up (even though I have a file server that all my systems are connected to) and started from scratch on Windows, having to hand enter all of this years records (thankfully this has been a short year). But, to the question, now that we have covered the problem that brought me to this question: Why doesn't GnuCash have an export functions so that one can more easily migrate from one computer system to another? And it may be needed to migrate from Gnucash's data format to another system used by one's CPA. Regards, Steve Thompson Indy area USA ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Stock spinoff
The company says that they will post an IRS Form 8937 later this week with the information. On Sat, Dec 3, 2022 at 6:48 PM Geoff wrote: > Hi Fred > > First up you need more details on this transaction to determine the > exact nature of the spin-off, the valuations, and whether ABC treated it > as a dividend, capital reduction, or combination of both. Was there a > cash payment as well? Any fractional shares involved? Were capital > gains/losses crystallised or carried forward? > > ABC should have sent you information about this, otherwise Google it. > > You may find this article helpful:- > https://www.henssler.com/spin-offs/ > > Once you have all the details, we can suggest how to record it in GnuCash. > > > Regards > > Geoff > = > > On 4/12/2022 11:15 am, Fred Tydeman wrote: > > In looking at the Help file within GnuCash, I found a section on Splits > and > > Mergers. After reading that section, I still do not know how to enter a > > Spinoff. That it, I have 25 shares of ABC stock. They did some kind of > > spin off and gave me 1 share of XYZ stock. I still have 25 shares of > ABC. > > How do I record this? > > ___ > > gnucash-user mailing list > > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Hi, did you look in the "books" folder?
C:\Users\\AppData\Roaming\GnuCash\books
Each book will have it's own .gcm file
In it, the columns will be something like this:
date_width=177
num_width=74
reconcile_width=239
balance_width=140
transfer_width=318
debit_width=140
credit_width=140
On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
> There are also settings in the Registry ?
>
> Cheers David H.
>
> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
> wrote:
>
> > Stan,
> >
> > That FAQ entry looked promising, but it does not solve the problem. There
> > are no entries in the .gcm file showing zero width to edit.
> >
> > Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
> > name\AppData\Roaming\GnuCash directory, including all .gcm files such
> that
> > they would be reconstituted from scratch, does not work either.
> >
> > Interestingly, somewhere in the system it remembers what book I had open
> > even through an uninstall/reinstall cycle. I suspect it has something to
> do
> > with that.
> >
> > Thanks,
> >
> > Scott
> >
> > On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
> > wrote:
> >
> > >
> > >
> > > On 2022-12-04 13:06, Scott Traurig wrote:
> > > > GnuCash 4.12 on Windows 10 Pro.
> > > >
> > > > I was rearranging the sizes of the columns in one of the account
> > > > ledgers and now both the Transfer and Reconcile ("R") column labels
> > > > are gone.
> > >
> > > As you might expect, yours is a Frequently Asked Question. You'll want
> > > to bookmark the FAQ at
> > >
> > >
> > > Your specific question is answered at
> > > <
> > >
> >
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
> > > >
> > > It tells you how to restore a disappeared column.
> > >
> > > While you're at it, you might want to bookmark the documentation
> portal:
> > > https://www.gnucash.org/docs.phtml
> > >
> > > Stan Brown
> > > Tehachapi, CA, USA
> > > https://BrownMath.com
> > > ___
> > > gnucash-user mailing list
> > > gnucash-user@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.
> > >
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
That approach failed, Glenn. Please read my email chain and you'll see that.
On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote:
> Hi, did you look in the "books" folder?
>
> C:\Users\\AppData\Roaming\GnuCash\books
>
> Each book will have it's own .gcm file
>
> In it, the columns will be something like this:
>
> date_width=177
> num_width=74
> reconcile_width=239
> balance_width=140
> transfer_width=318
> debit_width=140
> credit_width=140
>
> On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
>
>> There are also settings in the Registry ?
>>
>> Cheers David H.
>>
>> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
>> wrote:
>>
>> > Stan,
>> >
>> > That FAQ entry looked promising, but it does not solve the problem.
>> There
>> > are no entries in the .gcm file showing zero width to edit.
>> >
>> > Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
>> > name\AppData\Roaming\GnuCash directory, including all .gcm files such
>> that
>> > they would be reconstituted from scratch, does not work either.
>> >
>> > Interestingly, somewhere in the system it remembers what book I had open
>> > even through an uninstall/reinstall cycle. I suspect it has something
>> to do
>> > with that.
>> >
>> > Thanks,
>> >
>> > Scott
>> >
>> > On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
>> > wrote:
>> >
>> > >
>> > >
>> > > On 2022-12-04 13:06, Scott Traurig wrote:
>> > > > GnuCash 4.12 on Windows 10 Pro.
>> > > >
>> > > > I was rearranging the sizes of the columns in one of the account
>> > > > ledgers and now both the Transfer and Reconcile ("R") column labels
>> > > > are gone.
>> > >
>> > > As you might expect, yours is a Frequently Asked Question. You'll want
>> > > to bookmark the FAQ at
>> > >
>> > >
>> > > Your specific question is answered at
>> > > <
>> > >
>> >
>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
>> > > >
>> > > It tells you how to restore a disappeared column.
>> > >
>> > > While you're at it, you might want to bookmark the documentation
>> portal:
>> > > https://www.gnucash.org/docs.phtml
>> > >
>> > > Stan Brown
>> > > Tehachapi, CA, USA
>> > > https://BrownMath.com
>> > > ___
>> > > gnucash-user mailing list
>> > > gnucash-user@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.
>> > >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@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.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
>>
>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Why doesn't GnuCash have an Export function?
I'm using Gnucash on MacOS and under the menu there is File->Export which has options to export: Account Tree to CSV Transactions to CSV Active Register to CSV Accounts But to be honest, if you want to migrate to another system, you could look here: https://lists.gnucash.org/docs/C/gnucash-guide/basics-migrate-settings.html Which I found by typing "gnucash migrate to new system" into a search engine. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Home after a bus ride and now able to take a look. Glenn is correct, that
is indeed where the preferences for GnuCash are in Win 10 Pro - it's in the
C:\Users\AppData\Roaming\GnuCash\books folder and is called
whatever you saved your file as eg x.gnucash.gcm. Deleting or
renaming the file in my case gives me a basic register view and I lose all
my settings for open register tabs, yada, yada, yada. One of my register
segments looks like the following
[Register 7175cf7f4c095fe37cd54271eb7bef36]
date_width=99
num_width=54
reconcile_width=25
balance_width=80
transfer_width=763
debit_width=80
credit_width=86
This is it after I shrunk the Reconcile file down to nothing...
[Register 7175cf7f4c095fe37cd54271eb7bef36]
date_width=99
num_width=54
*reconcile_width=1*
balance_width=80
transfer_width=763
debit_width=80
credit_width=86
So you should be looking for a column width = 1 NOT 0
You should also notice the column that has been shrunk right down has a
slightly thicker dividing line - see below, the line between Transfer and
Deposit is thicker than the other separator lines. It is possible to
carefully right click on the thicker line and drag it right to re-expand
the column...
Cheers David H.
[image: image.png]
On Mon, 5 Dec 2022 at 11:44, Scott Traurig wrote:
> That approach failed, Glenn. Please read my email chain and you'll see
> that.
>
>
>
> On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote:
>
>> Hi, did you look in the "books" folder?
>>
>> C:\Users\\AppData\Roaming\GnuCash\books
>>
>> Each book will have it's own .gcm file
>>
>> In it, the columns will be something like this:
>>
>> date_width=177
>> num_width=74
>> reconcile_width=239
>> balance_width=140
>> transfer_width=318
>> debit_width=140
>> credit_width=140
>>
>> On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
>>
>>> There are also settings in the Registry ?
>>>
>>> Cheers David H.
>>>
>>> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
>>> wrote:
>>>
>>> > Stan,
>>> >
>>> > That FAQ entry looked promising, but it does not solve the problem.
>>> There
>>> > are no entries in the .gcm file showing zero width to edit.
>>> >
>>> > Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
>>> > name\AppData\Roaming\GnuCash directory, including all .gcm files such
>>> that
>>> > they would be reconstituted from scratch, does not work either.
>>> >
>>> > Interestingly, somewhere in the system it remembers what book I had
>>> open
>>> > even through an uninstall/reinstall cycle. I suspect it has something
>>> to do
>>> > with that.
>>> >
>>> > Thanks,
>>> >
>>> > Scott
>>> >
>>> > On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
>>> > wrote:
>>> >
>>> > >
>>> > >
>>> > > On 2022-12-04 13:06, Scott Traurig wrote:
>>> > > > GnuCash 4.12 on Windows 10 Pro.
>>> > > >
>>> > > > I was rearranging the sizes of the columns in one of the account
>>> > > > ledgers and now both the Transfer and Reconcile ("R") column labels
>>> > > > are gone.
>>> > >
>>> > > As you might expect, yours is a Frequently Asked Question. You'll
>>> want
>>> > > to bookmark the FAQ at
>>> > >
>>> > >
>>> > > Your specific question is answered at
>>> > > <
>>> > >
>>> >
>>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
>>> > > >
>>> > > It tells you how to restore a disappeared column.
>>> > >
>>> > > While you're at it, you might want to bookmark the documentation
>>> portal:
>>> > > https://www.gnucash.org/docs.phtml
>>> > >
>>> > > Stan Brown
>>> > > Tehachapi, CA, USA
>>> > > https://BrownMath.com
>>> > > ___
>>> > > gnucash-user mailing list
>>> > > gnucash-user@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.
>>> > >
>>> > ___
>>> > gnucash-user mailing list
>>> > gnucash-user@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.
>>> >
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remembe
Re: [GNC] Why doesn't GnuCash have an Export function?
Hi Steve, The data file is cross platform. You can simply copy it to a USB and put it in your new computer and it will work. From: gnucash-user on behalf of Steve Thompson Sent: Sunday, December 4, 2022 8:24 PM To: gnucash-user@gnucash.org Subject: [GNC] Why doesn't GnuCash have an Export function? Hi all and forgive me if this has been asked and answered before. I'm trying to get used to this particular list server and how it functions and my search didn't seem to return what I thought it should. I was trying to migrate from Linux (Suse Leap 15.3) to Windows 11. I'm being forced into this because of customers and Teams (which crashed my Linux system), and the lack of Adobe Acrobat for Linux. I finally gave up (even though I have a file server that all my systems are connected to) and started from scratch on Windows, having to hand enter all of this years records (thankfully this has been a short year). But, to the question, now that we have covered the problem that brought me to this question: Why doesn't GnuCash have an export functions so that one can more easily migrate from one computer system to another? And it may be needed to migrate from Gnucash's data format to another system used by one's CPA. Regards, Steve Thompson Indy area USA ___ gnucash-user mailing list gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Sorry for the confusion, my reply went out before the POP3 timer pulled
down new messages.
Have you tried Help -> About ?
There are now filepath links there in the latest version but I'm not sure
if it changes if your paths are not the default.
On Sun, Dec 4, 2022 at 8:44 PM Scott Traurig
wrote:
> That approach failed, Glenn. Please read my email chain and you'll see
> that.
>
>
>
> On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote:
>
>> Hi, did you look in the "books" folder?
>>
>> C:\Users\\AppData\Roaming\GnuCash\books
>>
>> Each book will have it's own .gcm file
>>
>> In it, the columns will be something like this:
>>
>> date_width=177
>> num_width=74
>> reconcile_width=239
>> balance_width=140
>> transfer_width=318
>> debit_width=140
>> credit_width=140
>>
>> On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
>>
>>> There are also settings in the Registry ?
>>>
>>> Cheers David H.
>>>
>>> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
>>> wrote:
>>>
>>> > Stan,
>>> >
>>> > That FAQ entry looked promising, but it does not solve the problem.
>>> There
>>> > are no entries in the .gcm file showing zero width to edit.
>>> >
>>> > Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
>>> > name\AppData\Roaming\GnuCash directory, including all .gcm files such
>>> that
>>> > they would be reconstituted from scratch, does not work either.
>>> >
>>> > Interestingly, somewhere in the system it remembers what book I had
>>> open
>>> > even through an uninstall/reinstall cycle. I suspect it has something
>>> to do
>>> > with that.
>>> >
>>> > Thanks,
>>> >
>>> > Scott
>>> >
>>> > On Sun, Dec 4, 2022 at 5:30 PM Stan Brown
>>> > wrote:
>>> >
>>> > >
>>> > >
>>> > > On 2022-12-04 13:06, Scott Traurig wrote:
>>> > > > GnuCash 4.12 on Windows 10 Pro.
>>> > > >
>>> > > > I was rearranging the sizes of the columns in one of the account
>>> > > > ledgers and now both the Transfer and Reconcile ("R") column labels
>>> > > > are gone.
>>> > >
>>> > > As you might expect, yours is a Frequently Asked Question. You'll
>>> want
>>> > > to bookmark the FAQ at
>>> > >
>>> > >
>>> > > Your specific question is answered at
>>> > > <
>>> > >
>>> >
>>> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
>>> > > >
>>> > > It tells you how to restore a disappeared column.
>>> > >
>>> > > While you're at it, you might want to bookmark the documentation
>>> portal:
>>> > > https://www.gnucash.org/docs.phtml
>>> > >
>>> > > Stan Brown
>>> > > Tehachapi, CA, USA
>>> > > https://BrownMath.com
>>> > > ___
>>> > > gnucash-user mailing list
>>> > > gnucash-user@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.
>>> > >
>>> > ___
>>> > gnucash-user mailing list
>>> > gnucash-user@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.
>>> >
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>>>
>>
___
gnucash-user mailing list
gnucash-user@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.
Re: [GNC] Why doesn't GnuCash have an Export function?
All you need to do is copy your data file to another machine so you don't need an export function just Ctrl/Cmd-C Ctrl/Cmd-V. I quite happily copy/sync Data file / Saved Reports/ Preferences between MacOS, Win 10 Pro, Win 11, Ubuntu. See the wiki entry re migrating to another pc for more details on what files you should copy over / backup. Cheers David H. On Mon, 5 Dec 2022 at 11:24, Steve Thompson wrote: > Hi all and forgive me if this has been asked and answered before. > I'm trying to get used to this particular list server and how it > functions and my search didn't seem to return what I thought it > should. > > I was trying to migrate from Linux (Suse Leap 15.3) to Windows > 11. I'm being forced into this because of customers and Teams > (which crashed my Linux system), and the lack of Adobe Acrobat > for Linux. > > I finally gave up (even though I have a file server that all my > systems are connected to) and started from scratch on Windows, > having to hand enter all of this years records (thankfully this > has been a short year). > > But, to the question, now that we have covered the problem that > brought me to this question: Why doesn't GnuCash have an export > functions so that one can more easily migrate from one computer > system to another? > > And it may be needed to migrate from Gnucash's data format to > another system used by one's CPA. > > Regards, > Steve Thompson > Indy area USA > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Why doesn't GnuCash have an Export function?
Steve you might want to read https://wiki.gnucash.org/wiki/Backup ... Cheers David H. On Mon, 5 Dec 2022 at 12:19, David H wrote: > All you need to do is copy your data file to another machine so you don't > need an export function just Ctrl/Cmd-C Ctrl/Cmd-V. I quite happily > copy/sync Data file / Saved Reports/ Preferences between MacOS, Win 10 > Pro, Win 11, Ubuntu. See the wiki entry re migrating to another pc for > more details on what files you should copy over / backup. > > Cheers David H. > > On Mon, 5 Dec 2022 at 11:24, Steve Thompson wrote: > >> Hi all and forgive me if this has been asked and answered before. >> I'm trying to get used to this particular list server and how it >> functions and my search didn't seem to return what I thought it >> should. >> >> I was trying to migrate from Linux (Suse Leap 15.3) to Windows >> 11. I'm being forced into this because of customers and Teams >> (which crashed my Linux system), and the lack of Adobe Acrobat >> for Linux. >> >> I finally gave up (even though I have a file server that all my >> systems are connected to) and started from scratch on Windows, >> having to hand enter all of this years records (thankfully this >> has been a short year). >> >> But, to the question, now that we have covered the problem that >> brought me to this question: Why doesn't GnuCash have an export >> functions so that one can more easily migrate from one computer >> system to another? >> >> And it may be needed to migrate from Gnucash's data format to >> another system used by one's CPA. >> >> Regards, >> Steve Thompson >> Indy area USA >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Colum headers missing on all accounts
Sorry, looks like that's a left click on the separator, right click tends
to display the context menu :-)
Cheers David H.
On Mon, 5 Dec 2022 at 12:13, David H wrote:
> Home after a bus ride and now able to take a look. Glenn is correct, that
> is indeed where the preferences for GnuCash are in Win 10 Pro - it's in the
> C:\Users\AppData\Roaming\GnuCash\books folder and is called
> whatever you saved your file as eg x.gnucash.gcm. Deleting or
> renaming the file in my case gives me a basic register view and I lose all
> my settings for open register tabs, yada, yada, yada. One of my register
> segments looks like the following
>
> [Register 7175cf7f4c095fe37cd54271eb7bef36]
> date_width=99
> num_width=54
> reconcile_width=25
> balance_width=80
> transfer_width=763
> debit_width=80
> credit_width=86
>
> This is it after I shrunk the Reconcile file down to nothing...
>
> [Register 7175cf7f4c095fe37cd54271eb7bef36]
> date_width=99
> num_width=54
> *reconcile_width=1*
> balance_width=80
> transfer_width=763
> debit_width=80
> credit_width=86
>
> So you should be looking for a column width = 1 NOT 0
>
> You should also notice the column that has been shrunk right down has a
> slightly thicker dividing line - see below, the line between Transfer and
> Deposit is thicker than the other separator lines. It is possible to
> carefully right click on the thicker line and drag it right to re-expand
> the column...
>
> Cheers David H.
>
> [image: image.png]
>
> On Mon, 5 Dec 2022 at 11:44, Scott Traurig
> wrote:
>
>> That approach failed, Glenn. Please read my email chain and you'll see
>> that.
>>
>>
>>
>> On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote:
>>
>>> Hi, did you look in the "books" folder?
>>>
>>> C:\Users\\AppData\Roaming\GnuCash\books
>>>
>>> Each book will have it's own .gcm file
>>>
>>> In it, the columns will be something like this:
>>>
>>> date_width=177
>>> num_width=74
>>> reconcile_width=239
>>> balance_width=140
>>> transfer_width=318
>>> debit_width=140
>>> credit_width=140
>>>
>>> On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
>>>
There are also settings in the Registry ?
Cheers David H.
On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
wrote:
> Stan,
>
> That FAQ entry looked promising, but it does not solve the problem.
There
> are no entries in the .gcm file showing zero width to edit.
>
> Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
> name\AppData\Roaming\GnuCash directory, including all .gcm files such
that
> they would be reconstituted from scratch, does not work either.
>
> Interestingly, somewhere in the system it remembers what book I had
open
> even through an uninstall/reinstall cycle. I suspect it has something
to do
> with that.
>
> Thanks,
>
> Scott
>
> On Sun, Dec 4, 2022 at 5:30 PM Stan Brown >>> >
> wrote:
>
> >
> >
> > On 2022-12-04 13:06, Scott Traurig wrote:
> > > GnuCash 4.12 on Windows 10 Pro.
> > >
> > > I was rearranging the sizes of the columns in one of the account
> > > ledgers and now both the Transfer and Reconcile ("R") column
labels
> > > are gone.
> >
> > As you might expect, yours is a Frequently Asked Question. You'll
want
> > to bookmark the FAQ at
> >
> >
> > Your specific question is answered at
> > <
> >
>
https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
> > >
> > It tells you how to restore a disappeared column.
> >
> > While you're at it, you might want to bookmark the documentation
portal:
> > https://www.gnucash.org/docs.phtml
> >
> > Stan Brown
> > Tehachapi, CA, USA
> > https://BrownMath.com
> > ___
> > gnucash-user mailing list
> > gnucash-user@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.
> >
> ___
> gnucash-user mailing list
> gnucash-user@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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
Re: [GNC] Colum headers missing on all accounts
Respectfully, some of you are not reading my emails ;-) ;-)
The .gcm file is not, repeat not, the problem in this case. This is a new
bug that is not covered by the FAQ.
Proof: I was just able to solve the problem a few minutes ago by deleting
the registry information under HKEY_CURRENT_USER/software/Gsettings. That
was where the problem was. I did not try to identify precisely which
registry key was at fault, I do not have sufficient knowledge of the
software to do so efficiently. Instead I uninstalled, deleted the registry
info, manually deleted the %appdata%/gnucash folder for good measure, then
reinstalled.
And, because this bug (and it is a bug) affects literally every book on the
machine, I dare not replicate it again on any of my production machines. I
will have to grab another machine here that I am not using for production,
install GnuCash, and try to replicate it there so I can submit a proper bug
report.
Thanks,
Scott
On Sun, Dec 4, 2022 at 9:26 PM David H wrote:
> Sorry, looks like that's a left click on the separator, right click tends
> to display the context menu :-)
>
> Cheers David H.
>
>
> On Mon, 5 Dec 2022 at 12:13, David H wrote:
>
>> Home after a bus ride and now able to take a look. Glenn is correct,
>> that is indeed where the preferences for GnuCash are in Win 10 Pro - it's
>> in the C:\Users\AppData\Roaming\GnuCash\books folder and is
>> called whatever you saved your file as eg x.gnucash.gcm. Deleting or
>> renaming the file in my case gives me a basic register view and I lose all
>> my settings for open register tabs, yada, yada, yada. One of my register
>> segments looks like the following
>>
>> [Register 7175cf7f4c095fe37cd54271eb7bef36]
>> date_width=99
>> num_width=54
>> reconcile_width=25
>> balance_width=80
>> transfer_width=763
>> debit_width=80
>> credit_width=86
>>
>> This is it after I shrunk the Reconcile file down to nothing...
>>
>> [Register 7175cf7f4c095fe37cd54271eb7bef36]
>> date_width=99
>> num_width=54
>> *reconcile_width=1*
>> balance_width=80
>> transfer_width=763
>> debit_width=80
>> credit_width=86
>>
>> So you should be looking for a column width = 1 NOT 0
>>
>> You should also notice the column that has been shrunk right down has a
>> slightly thicker dividing line - see below, the line between Transfer and
>> Deposit is thicker than the other separator lines. It is possible to
>> carefully right click on the thicker line and drag it right to re-expand
>> the column...
>>
>> Cheers David H.
>>
>> [image: image.png]
>>
>> On Mon, 5 Dec 2022 at 11:44, Scott Traurig
>> wrote:
>>
>>> That approach failed, Glenn. Please read my email chain and you'll see
>>> that.
>>>
>>>
>>>
>>> On Sun, Dec 4, 2022, 20:35 Glenn Fowler wrote:
>>>
Hi, did you look in the "books" folder?
C:\Users\\AppData\Roaming\GnuCash\books
Each book will have it's own .gcm file
In it, the columns will be something like this:
date_width=177
num_width=74
reconcile_width=239
balance_width=140
transfer_width=318
debit_width=140
credit_width=140
On Sun, Dec 4, 2022 at 7:10 PM David H wrote:
> There are also settings in the Registry ?
>
> Cheers David H.
>
> On Mon, 5 Dec 2022, 10:00 am Scott Traurig,
> wrote:
>
> > Stan,
> >
> > That FAQ entry looked promising, but it does not solve the problem.
> There
> > are no entries in the .gcm file showing zero width to edit.
> >
> > Worse, uninstalling GnuCash and deleting the entire C:\Users\my user
> > name\AppData\Roaming\GnuCash directory, including all .gcm files
> such that
> > they would be reconstituted from scratch, does not work either.
> >
> > Interestingly, somewhere in the system it remembers what book I had
> open
> > even through an uninstall/reinstall cycle. I suspect it has
> something to do
> > with that.
> >
> > Thanks,
> >
> > Scott
> >
> > On Sun, Dec 4, 2022 at 5:30 PM Stan Brown <
> the_stan_br...@fastmail.fm>
> > wrote:
> >
> > >
> > >
> > > On 2022-12-04 13:06, Scott Traurig wrote:
> > > > GnuCash 4.12 on Windows 10 Pro.
> > > >
> > > > I was rearranging the sizes of the columns in one of the account
> > > > ledgers and now both the Transfer and Reconcile ("R") column
> labels
> > > > are gone.
> > >
> > > As you might expect, yours is a Frequently Asked Question. You'll
> want
> > > to bookmark the FAQ at
> > >
> > >
> > > Your specific question is answered at
> > > <
> > >
> >
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_resize_my_register_columns.3F_Why_can_I_not_shrink_the_description_column.3F
> > > >
> > > It tells you how to restore a disappeared column.
> > >
> > > While you're at it, you might want to bookmark the documentation
> portal:
>>>
Re: [GNC] Why doesn't GnuCash have an Export function?
But, to the question, now that we have covered the problem that brought me to this question: Why doesn't GnuCash have an export functions so that one can more easily migrate from one computer system to another? Because the DATA is not dependent on the computer. This is NOT different from other data you are moving between computers, even ones under different operating systems. You do not have to export/import, you just have to move the FILE. You are picturing export from the gnucash data file to a file, move that file to another computer, import that file (into the gnucash data file on the new computer). You don;t have to do that. You just move (copy) the data file to the new computer.(where if the PROGRAM gnucash is installed, you can now open the file). Michael D Novack And it may be needed to migrate from Gnucash's data format to another system used by one's CPA. THAT is another matter. If what you mean is "move to the accountant's computer" same as another of your own IF the accountant willing to install gnucash to ope it. But if you mean move data so that it can be opened/read by another accounting application, yes, now an export/import pair is needed along with a data converter since in general a different data format (I mean logical format, but physical data format difference might also be involved). The problem is, there is no agreed standard for an exported general ledger that all accounting applications have agreed to use for export/import. << what makes you think that this other application would be able to import the exported data without a data conversion step. One specific to that pair of applications. THAT is the sort of thing they used to pay me to write -- "quick Mike, we need some data from X converted so that we can import it into our system >> Michael D Novack ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] searching for inventory tags -- bind keys -- best ways
I would absolutely *not* edit directly in AR. (I'm surprised they are even editable) If you want to change them, you need to unpost the invoice, edit, then repost. Any changes you make otherwise might cause havoc. If you do not 'consolidate splits on posting' (that's a per invoice or book-wide option) then those memo splits are exposed in AR for the individual line items and you can run reports that filter off them for your tags. Regards, Adrien On 12/4/22 2:48 PM, John Griessen wrote: PS: since posing these questions, I've looked more at memo lines and find that AR payment memo lines *ARE* editable. So now I will be adding my inventory tags to those AR memo lines when doing a payment , or after! ___ gnucash-user mailing list gnucash-user@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.
