Re: [GNC] GNUCash beginner setup
In any register view you can highlight the account name in a split line if you are in the Auto-split ledger or transduction journal view, right click and select any account name in the drop-down list. If you happen to be in the only split line of a transaction that is the same as the current account register, it may take a short time for the program to react, but the transaction will eventually disappear from that register view because it no longer has a split assigned to that account. On Tue, Apr 7, 2020 at 3:33 PM jess wrote: > The opening balance in the previous message refers to the current balance I > have on my bank account in real life. > > I was able to solve this too. It works for resolution if the imbalanced > transactions are assigned an account inside the checking account > transaction > list. If you try to assign the account in the "Imbalanced" account, it does > not work. > > Why does this happen? > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Copy Scheduled Transaction
Bob, If you let the SX create a register transaction, then create a new SX from that register transaction, you will have half the duplication work done, all you would need is to substitute the calculations for the results from the register transaction. You might find it useful to have those computation expressions in a spreadsheet to copy and paste while doing that. On Mon, Apr 6, 2020 at 3:16 PM Bob Atwell wrote: > Perhaps I am not being clear. I have 2 fully functional SXs, one with > numerous transactions and one with one transaction but with a lot of > splits. Both have multiple variables and some simple math. Both work just > fine but both took about 30 minutes each to enter due to the complexity. > Now I want to create 4 more SXs virtually identical to either one of these > but without having to reenter everything all over again. As far as I can > tell, this is not possible. The duplicate button in the template tab just > duplicates one transaction within the SX, and cannot create a new SX. > > > > Sent from Samsung tablet > > > ---- Original message > From: David Carlson > Date: 4/6/20 11:36 AM (GMT-07:00) > To: Adrien Monteleone > Cc: Gnucash Users > Subject: Re: [GNC] Copy Scheduled Transaction > > Don't give up yet. There is a rudimentary computation capability in the SX > editor. It is used in the loan repayment calculator and it has been the > topic of several threads here over the years. > > See chapter 8.8 in the help manual for a start. > > On Mon, Apr 6, 2020, 12:36 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Open the SX editor. > > Select the SX you want to copy. > > Click the Edit button. > > Click the Template Transaction tab. > > Click the Duplicate button. > > > > Does this help? > > > > Regards, > > Adrien > > > > > On Apr 6, 2020 w15d97, at 11:43 AM, Bob Atwell > > wrote: > > > > > > Unfortunately using splits and creating a scheduled transaction from > > that doesn't help in my situation. Since my final scheduled transaction > > involves variables and math, none of that can be reproduced without being > > able to actually copy the original scheduled transaction. Based on the > > responses so far, that is not currently an available option in gnucash. > So > > I guess the real answer to my OP is no. > > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Copy Scheduled Transaction
Don't give up yet. There is a rudimentary computation capability in the SX editor. It is used in the loan repayment calculator and it has been the topic of several threads here over the years. See chapter 8.8 in the help manual for a start. On Mon, Apr 6, 2020, 12:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Open the SX editor. > Select the SX you want to copy. > Click the Edit button. > Click the Template Transaction tab. > Click the Duplicate button. > > Does this help? > > Regards, > Adrien > > > On Apr 6, 2020 w15d97, at 11:43 AM, Bob Atwell > wrote: > > > > Unfortunately using splits and creating a scheduled transaction from > that doesn't help in my situation. Since my final scheduled transaction > involves variables and math, none of that can be reproduced without being > able to actually copy the original scheduled transaction. Based on the > responses so far, that is not currently an available option in gnucash. So > I guess the real answer to my OP is no. > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Copy Scheduled Transaction
When Adrien says many split lines, he means many! I have a couple scheduled transactions that don't fit in one screen, ie more than 20 splits. On Mon, Apr 6, 2020, 9:52 AM wrote: >Thanks Adrien, that might actually be feasible. I'll try setting up a >test case to see if it really works for my situation. > >On Apr 6, 2020 7:20 AM, Adrien Monteleone > wrote: > > You can have as many splits as you like. (I’m sure there is a limit, > but I haven’t found it) > > You don’t need to have 5 separate transactions unless they need to > fire on 5 different dates. You can combine all of the splits into a > single transaction. > > Regards, > Adrien > > > On Apr 5, 2020 w15d96, at 7:46 PM, > wrote: > > > > When I said fairly complex I meant it is really about 5 > transactions happening at once. > > So, I can't select one transaction and make it a scheduled > transaction because that only gets me a fifth of what I want. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] importing transactions with splits
What I have been able to download from Amazon looks more like an invoice than a transaction. Same with purchases at Kohl's. I have so few transactions that I just open the page with a spreadsheet program then cut and paste the fields I want into a transaction. If someone has a better way I would love to see it On Sun, Apr 5, 2020 at 8:56 PM Jeremy Mordkoff wrote: > This has to be a solved problem, but I cannot find the solution. > > I am importing amazon transactions. Date and description are easy. But how > do I create a split transaction from the item cost, shipping, taxes and > total columns? Can I do that as a CSV or do I have to convert it to some > other format? > > -- > Jeremy Mordkoff > > *Let not any one pacify his conscience by the delusion that he can do no > harm if he takes no part, and forms no opinion. Bad men need nothing more > to compass their ends, than that good men should look on and do nothing.* > -- John Stuart Mill, 1867 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Copy Scheduled Transaction
You can create a scheduled transaction by starting from an existing transaction and editing it if desired. On Sun, Apr 5, 2020, 4:49 PM Bob Atwell wrote: > I want to create a new (fairly complex) scheduled transaction that is > almost identical to an exiting scheduled transaction. Is there any way > to copy/paste the existing transaction to a new one? Is there any > method I can use to avoid retyping everything all over again? > > Thanks, Bob. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 beginner setup
Denz, Could you share which version or build of GnuCash you are using and in which operating system? I believe there has been a major change to the csv importer in recent releases, so there may be a new bug [never happens]. David Carlson On Fri, Apr 3, 2020 at 2:42 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Does assigning it properly on import 2 still result in an improper match > with import 3? (maybe that transaction is pesky for some as yet unknown > reason) > > Otherwise, you’ve got me stumped then. Hopefully someone else can help. > > > Regards, > Adrien > > > On Apr 3, 2020 w14d94, at 2:16 PM, denz wrote: > > > >> Same ’Note’ or same ‘Description’? I thought it was keying off > > ‘Description’. > > > > Sorry, same 'Description'. > > > >> Do you mean, in 5 different imports, the assignment is different each > >> time, or in the same import? (creating 5 different transactions) > > > > Here's an example, > > > > Import 1 has the 5 same transactions (same description, same transaction > > amount) and I manually assign them to an "Expense Account". In Import 2, > > there's the exact same transaction just on a different date. Yet, it > assigns > > it to a different Expense Account. > > > >> Do those transactions have more than 2 splits? If so, do the additional > >> split lines in the CSV contain duplicate info from the main split? I > seem > >> to recall there is a way to specify that case. > > > > > > There are no splits in the transactions. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 beginner setup
It sounds like you did not do the account assignments during the import process, but after. The training only works during the import process, and only for that particular bank account. David Carlson On Fri, Apr 3, 2020, 11:46 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Did you conduct the imports in a single pass or did you import one month > (or so) at a time? > > The recommended procedure for several reasons (training the importer among > them) is to import in small batches. > > For clarity and consistency, GnuCash doesn’t have ‘categories’. GnuCash > has ‘accounts’ which in your case are most likely to be all under Expenses, > but some might also be assets or liabilities. I think the normal procedure > is to create those accounts first, then do the import. > > If you imported everything to Imbalance and *then* assigned accounts, the > importer didn’t learn anything. Create the accounts first. It only learns > what you assign *within* the import process. > > Regards, > Adrien > > > On Apr 3, 2020 w14d94, at 11:21 AM, denz wrote: > > > > Dear all, > > > > I am a new user to GNUCash and I have read the Help Manual [0] and some > > popular video tutorials [1]. I have also played around with the > software. I > > am now planning to transition to use an accounting software for full > time. > > > > Current Situation > > > > I have 3 checking bank accounts with prior transaction history and only > > transaction CSV export functionality. Bank 1 with ~ 1400 transactions > over > > last 4 years with the CSV format below (Bank1.csv attached with this > > message.) > > > > "Date","Payee","Account number","Transaction type","Payment > > reference","Category","Amount (EUR)","Amount (Foreign Currency)","Type > > Foreign Currency","Exchange Rate" > > "2016-05-24","XX","DE33XXX","Income","Num bank2.csv > > <http://gnucash.1415818.n4.nabble.com/file/t378947/bank2.csv> ber26 > > Maestro","Income","1000.0","","","" > > "2016-05-27","YY","","Transaction type > > unknown","","ATM","-100.0","-100.0","EUR","1.0" > > > > > > Bank 2 with ~80 transactions over last 1 year with CSV format below > > (Bank2.csv attached with this message) > > > > TTransaction date,Value date,Transaction type,Booking > > text,Amount,Currency,Account of initiator,Bank code of account of > > initiator,IBAN of account of initiator,Category > > 18.03.2020,18.03.2020,debit,"Monatsrechnung R206457 S0151396 270901 > > End-to-End-Ref.: 3656423 Mandatsref: MBSS0151396270930925 Gläubiger-ID: > > DE12ZZZ2150146 SEPA-BASISLASTSCHRIFT > > wiederholend",-25.98,EUR,987341500,1204,DEX,"Electricity, > > heating, water" > > 02.03.2020,02.03.2020,debit,"WEMAG AG Knr. 9946518 46.00/Abschlag vom 01. > > 03.2020 1633629/Obj.: 2144729 End-to-End-Ref.: 22182554 Mandatsref: > > SEPA0009946518G355224 Gläubiger-ID: DE70ZZZ0077958 > > SEPA-BASISLASTSCHRIFT > > wiederholend",-46.00,EUR,987341500,1204,DEXXX,"Electricity, > heating, > > water" > > > > > > Future Situation - What would I like to do? > > > > Categorised History of my Transactions with Categories - Electricity, > Heat, > > Water, Groceries, Restaurants, Travel, Shopping, Salary, Tax Refund, Drug > > Store etc. > > > > What did I do? > > > > 1. I opened two checking accounts for each of the banks with opening > > balance 0 > > 2. I used the import CSV function to import both Bank1.csv and > Bank2.csv, I > > marked all the required fields and it gets imported > > 3. I manually categorised a few months of transactions to achieve some > > "training" for the CSV import > > > > What do I observe? > > > > 1. I observe an Imbalanced EUR extra entry > > 2. Categorization is a hit and miss even for the same scheduled > transaction > > with same values. For example, the transaction named "rent" with the same > > EUR amount "xxx" will get classified as something else despite giving it > > training for many times > > 3. Opening account balances do not match after a final full import of > > transactional CSV data > > > > I compare this to KMyMoney [2] and import etc. just works out there wit
Re: [GNC] Backdated manual price entries
Exactly what happens after you click the add button? On Wed, Apr 1, 2020 at 5:24 AM James Edmunds wrote: > Yes I am using Price Database Editor .To clarify I am trying to > manually add backdated prices to shares I already own. > > -- > *From:* David Carlson > *Sent:* 31 March 2020 16:01 > *To:* James Edmunds > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Backdated manual price entries > > Jimmy, Are you using the Price Database editor? That doesn't even know > whether you own shares. > > On Tue, Mar 31, 2020 at 9:13 AM James Edmunds > wrote: > > I use F:Q 1.49 and GNC 2.6.12 running on Ubuntu 16.04 . I upgraded from > Ubuntu 14.04 to 16.04 in August 2019 , During the upgrade I removed the > existing GNC 2.6.12 ( from Ubuntu 14.04 ) using the Ubuntu Software Centre > and installed GNC 2.6.12 ( from Ubuntu 16.04 ) using the Ubuntu Software > Centre. > > > In both 14.04 and 16.04 I successfully used F:Q to upload prices for all > of my securities which I had set “ Get online quotes” and most of > currencies which I had set “ Get online quotes” most of the time . > > > Up to early 2019 I was able to manually input back dated prices for both > securities and currencies > > eg input a 31 Dec 19 price in Mar 2020. > > > Now I am not able to do this . I do not know the exact date of the change. > > > I find that for securities I can only input a backdated price if there are > no holdings in the security. > > > For currencies I can input a backdated price for some currencies but not > others I cannot. > > > Any help or suggestion would be appreciated. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > > > -- > David Carlson > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Printed Reports Being Cutoff
That is a well-known problem that cannot be fixed easily within the GnuCash program. Many of us use some combination of exporting as PDF or printing to PDF and then opening in a better quality PDF viewer and printing from there. David Carlson On Tue, Mar 31, 2020 at 4:53 PM Keith Fetterman wrote: > When I print an income statement that spans multiple pages, the accounts > are getting cut off at the bottom and top of the printed pages. I > experimented with changing the scale Page Setup tab on the print dialog, > but it doesn’t help. Anyone have ideas on how to prevent the lines from > being cutoff? The reports are being printed to an Epson Artisan 730 > printer from an iMac. > > Thanks > Keith > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Backdated manual price entries
Jimmy, Are you using the Price Database editor? That doesn't even know whether you own shares. On Tue, Mar 31, 2020 at 9:13 AM James Edmunds wrote: > I use F:Q 1.49 and GNC 2.6.12 running on Ubuntu 16.04 . I upgraded from > Ubuntu 14.04 to 16.04 in August 2019 , During the upgrade I removed the > existing GNC 2.6.12 ( from Ubuntu 14.04 ) using the Ubuntu Software Centre > and installed GNC 2.6.12 ( from Ubuntu 16.04 ) using the Ubuntu Software > Centre. > > > In both 14.04 and 16.04 I successfully used F:Q to upload prices for all > of my securities which I had set “ Get online quotes” and most of > currencies which I had set “ Get online quotes” most of the time . > > > Up to early 2019 I was able to manually input back dated prices for both > securities and currencies > > eg input a 31 Dec 19 price in Mar 2020. > > > Now I am not able to do this . I do not know the exact date of the change. > > > I find that for securities I can only input a backdated price if there are > no holdings in the security. > > > For currencies I can input a backdated price for some currencies but not > others I cannot. > > > Any help or suggestion would be appreciated. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Cycle between basic, autosplit, transaction views?
I am not sure what the status is of the drop-down menu displays is in release 3.9, but in release 2.6.19 in Ubuntu, A,J will invoke a* j*ump to account when the focus is on a split line for another account. Interestingly, the action keys are not underlined in the menu labels, but they are underlined in the pop-up menu triggered by the right mouse click, where the A prefix is not needed. On Sun, Mar 29, 2020 at 1:07 PM Michael Hendry wrote: > > On 29 Mar 2020, at 18:42, david whiting wrote: > > > > ViewStyleBasicAction > > On my Mac the relevant file is in ~/Library/Application Support/Gnucash. > > The term “Primary” on a Mac is the key, as opposed to the > key, so the effect on the relevant menu is: > > > > If the image doesn’t come through, try: > > > https://www.dropbox.com/s/hckcdyxjc8y5tlb/Screenshot%202020-03-29%2018.56.54.png?dl=0 > > Last July I set up J to provide a short-cut for the Jump button, > which is also very useful. > > See: > http://gnucash.1415818.n4.nabble.com/GNC-Accelerator-Key-for-Jump-button-td4711442.html#a4711485 > > Michael > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] looking for quicken alternative
Absolutely, you can do anything. But to correctly track the cost basis of stock when you have multiple purchases and sales you have to keep track of what you paid for each share, when you bought it, when you sold it, and how much were the fees and commission costs. Then, when selling fractional lots, you have to also track the remaining shares. in many jurisdictions it matters how long you held the shares and whether you use the the FIFO method, LIFO method, average cost or pick and choose method when there is a mixture of lots to evaluate. As you know, Gnucash is not inventory oriented, and it also requires you to be consistent with either tracking commissions and fees separately or burying them in your cost basis. In the US, the government does not like to trust individuals to make those calculations correctly, so they require stock brokers to make those calculations and report them directly. Thus you also have the burden of trying to match whatever they report. I am deliberately avoiding describing the details required to meet these challenges, because there are many ways to do it, depending on your preferences. David Carlson On Fri, Mar 27, 2020 at 4:13 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 3/27/2020 2:33 PM, David Carlson wrote: > > Ken, > > > > One issue that may be of concern to you is the way Gnucash tracks capital > > gains. It cannot follow tax law definitions exactly by default as that > > requires tracking expenses such as fees in a very complex way to apply > > partial fees to the cost basis when partial closing transactions occur. > > > > Many users track cost basis separately, especially if they have "lots" of > > transactions [pun intended]. See discussions about lot tracking for more > > details. > > > > David Carlson > > > I do not understand. Are you saying that transactions entered using old > fashioned pen and ink on paper bookkeeping could not follow tax law > definitions? > > Because ANYTHING you could do pen and ink on paper you could do using > gnucash. > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] looking for quicken alternative
Ken, One issue that may be of concern to you is the way Gnucash tracks capital gains. It cannot follow tax law definitions exactly by default as that requires tracking expenses such as fees in a very complex way to apply partial fees to the cost basis when partial closing transactions occur. Many users track cost basis separately, especially if they have "lots" of transactions [pun intended]. See discussions about lot tracking for more details. David Carlson On Fri, Mar 27, 2020, 11:09 AM Alton Brantley wrote: > I was in the same boat, and made the conversion, and would never go back. > > There are a few steps to take to accomplish the migration, and to > understand the conceptual differences between the two programs. > However, it’s worth it once you get the process working for you. > > If you have any questions, you can always contact this list or look up > past responses to similar questions in the archives. > > > Date: Fri, 27 Mar 2020 05:20:43 + (UTC) > > From: Ken Cohen mailto:kcoh...@yahoo.com>> > > To: "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>" < > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>> > > Subject: [GNC] looking for quicken alternative > > Message-ID: <57147887.1864901.1585286443...@mail.yahoo.com 57147887.1864901.1585286443...@mail.yahoo.com>> > > Content-Type: text/plain; charset=UTF-8 > > > > I have used Quicken for well over 15 years but continue to have problems > with the software. I am looking for a replacement that can download > transactions from my bank and Schwab brokerage and maintain detail security > information including lots purchased and cost basis. Is gnucash a program > that can accommodate that?thanks,Ken > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to start a new GC file for a new year?
A technique which has been mentioned in the past but not recently is to designate a backup file copy made at the same time as the year end reports as the final copy for the year. This could be manually marked read only by your file manager software. David Carlson On Sat, Mar 21, 2020, 11:08 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I covered that. > > It isn’t necessary, or even desirable. > > One can achieve the desired result without doing so. > > Keeping everything in one book retains the ability for varied reporting. > > Once transactions are archived, reporting becomes limited with respect to > historical transactions. (and with it, analysis of said transactions, to > some degree) > > The most versatility is retained by keeping all years in one book. > > Segregating by date, starts to introduce limitations. > > Regards, > Adrien > > > On Mar 21, 2020 w12d81, at 6:33 PM, Fran_3 > wrote: > > > > How about just creating a new account under Assets > Current Assets > > > and naming it Checking 2020 > > Then for the last transaction in Checking 2019 transfer the ending > balance to Checking 2020. > > This way everything is preserved and you have all your 2020 checking > transactions in one neat account. > > Wouldn't that work? > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Canceling QIF Import Erases ALL Transactions
Eric, You just published your GPG public key to the entire user group. On Sat, Mar 21, 2020 at 11:38 AM Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > I understand about security; I'm going to upload my GPG public key to > the bug report (and it should be attached to this email reply) and I ask > that any request which may involve personal data be encrypted > accordingly both ways. > > > Eric H. Bowen > e...@ehbowen.net <mailto:e...@ehbowen.net> > On 3/21/2020 11:20 AM, John Ralls wrote: > > > >> On Mar 21, 2020, at 12:53 AM, Eric H. Bowen via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> > >> Yesterday I ran into this...I was attempting a .QIF import of > transactions from my credit card company. The import seemed to progress > normally, up until the "Match Transactions" stage. When it got there, every > single one of the transactions which I had entered over the past 2+ years > appeared in the list. I hit the cancel button in the requester, got the > "busy" icon...and when Gnucash resumed, about ten minutes later, every one > of my transactions in every account had vanished (with the sole exceptions > of customer invoices and vendor bills)! > >> > >> I did have a fairly recent backup file available, so I restored to that > and tried the import again. The same thing happened a second time. > >> > >> My NAS keeps track of file history and automatically saves the most > recent versions every twenty minutes or so, so I do have versions from > before and after the failed import saved (to a new file under a new name) > as well as all of my log files. At the time of the import I was running > Build ID: 3.8b+(2019-12-29) on Ubuntu 18.04.4 LTS in a homebuilt machine > with AMD FX-4100 CPU, 8 GB RAM, and an ASUS M5A88-M motherboard and using > the SQLite3 backend. > >> > >> I opened a Bugzilla account and reported this (Bug 797651), but as > reconstructing this may mean sharing my personal financial data I > restricted the view access to the developer list. I have reconstructed my > working account file from my backup, so there's been no loss of critical > data. I'm sharing this for visibility and to ask if there is any additional > information I should provide in the bug report to facilitate a permanent > resolution to this problem. Thanks for any adviceEric. > > Chris has already responded to you on the bug report and will ask there > for any additional information he needs. > > > > A general note: I wouldn't trust the view access settings to protect > anything, it's at best security-by-obscurity. If one of us decides he needs > to look at your book he'll provide a direct email address to send it to. > > > > Regards, > > John Ralls > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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] PDF Reports
I added gnucash-user to the cc to distribute this to wider audience. I believe that if you export to pdf, then some pdf readers do split between lines. I think Firefox is one that works ok, but it has been a while since I tried it. David Carlson On Tue, Mar 17, 2020, 5:48 PM Alan Auerbach wrote: > I am a very new gnucash user and finding my way through the app. I am > finding it very easy to use and useful as a replacement for Quicken 2000. I > have one issue with the Reconciliation Report (I do not know if this issue > applies to other reports). > > > > I selected the Technicolor report which looks great. However, when I print > it as a PDF or export it as a PDF, the page breaks can come in the middle > of > a text line with the upper parts of the characters on one page and the > lower > parts on the next page. Is there a setting that I can select to resolve > this > anomaly? > > > > Best wishes, > /s/ Alan Auerbach > 14343 North Frank Lloyd Wright Boulevard, Apt. 1009 > Scottsdale, AZ 85260-3634 > (480) 657-7543 Home > (480) 922-0484 Text > (844) 395-7098 Fax > > > > ___ > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] AQBanking OFX DirectConnect
OFX direct connect is not the same as plain OFX, which is easier to use. I didn't have a good experience when I tried OFX D C with my banks long ago. On Sun, Mar 15, 2020, 5:18 PM chris graves wrote: > Not that it matters, but I concur with John. I also have been using AQB > OFX successfully for ~8 years, thanks to you devs! > > I continue successfully to use the AQB provided with GnuCash 3.7. > > Thanks for your support! > Chris > > > On Mar 15, 2020, at 1:21 PM, John Ralls wrote: > > > > > >> On Mar 15, 2020, at 12:47 PM, Martin Preuss > wrote: > >> > >> Hi, > >> > >> Am 15.03.20 um 20:17 schrieb John Ralls: > >>> I just made a MacOS build with the latest AQBanking so I could test it > with my bank (USAA). No go, and a bit of troubleshooting reveals that it's > because AQBanking now uses the XML-based OFX V2. AFAIK that's not supported > by any US bank. > >> [...] > >> > >> OFX2 is the only version I could get access to a test server for, so > >> thats what I implemented so far. > >> > >> However, since the OFX spec state that banks should also accept XML like > >> OFX requests (i.e. OFX files with closing XML elements) the code might > >> be adjustable for this... > >> > >> I will try to add a mode in which the plugin sends the headers > >> previously used for OFX1 and still send requests with closing XML > >> elements, at least according to the specs I read that should work... > >> > >> Anyway, as I wrote before I can't test it myself. There is only person - > >> so far - I heard of from the US who tested the latest code with a real > >> server and I really appreciate his help, but he seems to be using the > >> prebuilt Windows version which makes the debug process... well... > difficult. > >> > >> It would be extremely helpfull to have someone who could compile and > >> test a version from GIT, but given the different timezones the possible > >> OFX users and I live in that might be time consuming for both sides... > > > > Martin, > > > > As I said here and in my bug report, AQB 5's OFX backend works well and > has done for many years. If you just update it for the new AQB6 and Gwen5 > API it has a good chance of working. > > > > I can build from git and test. So far there's no need for debugging, > simply comparing the OFX from 5.8 and 6.1 showed me the problem: OFX > DirectConnect servers using V1 can't parse the XML you send in the request > and 400, see the transcripts in the bug report. > > > > The current OFX spec doesn't matter if the bank is using software > written for OFX V1 as nearly all in the US do. > > > > Regards, > > John Ralls > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file
Stu, I have been importing OFX files from my bank for years with three or four checking or savings accounts in one file, so I know GnuCash release 2.6.19 can import OFX files with multiple accounts. It is possible but unlikely that GnuCash has lost that ability in recent releases. You may have something else happening in your case. On Fri, Mar 13, 2020 at 9:58 AM Stu Perlman wrote: > Hello, > > I am using GNC on Windows 10. I have a fairly recent build, dated March 9 > from the maintenance branch. > > I noticed that I'm still unable to use AqBanking to get OFX data from Citi > into GNC. I Did a little exploring and discovered that if I manipulate the > file in C:\tmp\ofx.log and break it into separate parts for each account > that was downloaded that GNC will import the data just fine if it's limited > to one account per file. I also believe, but I need to confirm that I can > leave all of the data in a single file but that I need to eliminate a lot > lines starting with the closing tags for the first account's response body > and up to and including the opening tags for the subsequent accounts' > response bodies. > > Has anyone else encountered this issue and if so, do you have any ideas how > to fix this? Is it a defect? > > Thanks in advance for your help. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Price Editor
I noticed this too on 2.6.19 in Ubuntu. If I wait for an hour and come back I find that it completed. I susect that Yahoo is rate limiting due to crazy market conditions. On Thu, Mar 12, 2020 at 10:09 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Might be a Yahoo problem. AlphaAdvantage worked fine for me just now. > > Check your tracefile before restarting GnuCash and/or run from the command > line to see if you get any warnings or errors output to a terminal. See the > wiki for more instructions if you aren’t familiar with either. > > Regards, > Adrien > > > On Mar 12, 2020 w11d72, at 9:29 AM, Les wrote: > > > > What has happened to Price Editor? For the last 3 days, when prompted > to obtain quotes, the app displays a timer which I end up having to force > GC to close. Prior to this Price Editor worked as advertised. I only have > quote requests for 2 currencies and 4 AMEX accounts. > > > > Linux Mint 19.1 and GC 3.8. Requests are via Yahoo as JSON. > > > > Thanks, > > > > Les > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong currency when recording a stock purchase
Looking at the price database dialog, it is possible to select and edit the currency for each price entry when manually entering or editing existing price entries. This reduces the problem to tracking down a cause if it happens with automatically generated entries. David Carlson On Mon, Mar 9, 2020 at 9:11 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I recall correctly, the parent account of the account that holds the > stock sets the currency. Thus if you have a brokerage handling stock in > multiple currencies for you, you have to create placeholder sub-accounts > under the main brokerage account just to segregate the stocks for each > currency like so: > > Brokerage > |_Brokerage:Brokerage-USD > |_Brokerage:Brokerage-USD:StockABC > |_Brokerage:Brokerage-USD:StockVOO > |_Brokerage:Brokerage-CAD > |_Brokerage:Brokerage-CAD:StockDEF > |_Brokerage:Brokerage-CAD:StockXYZ > > Regards, > Adrien > > > On Mar 9, 2020 w11d69, at 6:19 PM, Nelson > wrote: > > > > 3.8 on Windows. > > > > So, I have a VOO stock type account. The account is years old and is > getting > > online quotes without any problems. > > > > Today I try to register a new purchase (VOO 200 at 252.25) and I realized > > that the reporting is no longer working - the purchase price seems to be > > corrupted. > > > > After a bit of troubleshooting I realized the currency for the record in > the > > price database, the one "user:price" source, is CAD instead of USD. > > > > As far as I know, there is now way to specify currency for a stock type > > account or for the entry in the stock account. > > > > How do I fix this? And how exactly is the currency for a a stock type > > account determined? > > > > Thank you. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Wrong currency when recording a stock purchase
Nelson, It is trivial to manually delete prices one at a time from the price database. Obviously the question is why it is in the wrong currency. Did you use a different computer, possibly with the Locale set to Canadian? Is there anything else that has recently changed? David Carlson On Mon, Mar 9, 2020, 6:22 PM Nelson wrote: > 3.8 on Windows. > > So, I have a VOO stock type account. The account is years old and is > getting > online quotes without any problems. > > Today I try to register a new purchase (VOO 200 at 252.25) and I realized > that the reporting is no longer working - the purchase price seems to be > corrupted. > > After a bit of troubleshooting I realized the currency for the record in > the > price database, the one "user:price" source, is CAD instead of USD. > > As far as I know, there is now way to specify currency for a stock type > account or for the entry in the stock account. > > How do I fix this? And how exactly is the currency for a a stock type > account determined? > > Thank you. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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
Barbara, Have you read the suggestions on this mail list for migration from other software? Testing the process in disposable data files with small import files makes it much easier to identify problems and decide how to address them. It is also useful to tell us which OS your computer is running and which version of Gnucash you are using. The qif importer does have some recently discovered flaws which will be fixed in the next 3.x release, but most users are not affected. There have been some changes over time, however. David Carlson On Sun, Mar 8, 2020, 9:58 PM Barbara A. Allen wrote: > I have downloaded the program, but when I try to import my QIF files, I > get as far as changing the names on a few accounts, and it kicks me back > to the start up screen and wants me to hit the start button and import > my files, then freezes. What do I do next? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help Find Feature
I agree that the purpose and the method are two different animals. I wanted to make sure that Gio was aware that the specific method of an expense account deletion will have consequences in other parts of his data, so he can avoid shooting himself in the foot. On Sun, Mar 8, 2020 at 5:36 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Looking at the example again, it still isn’t clear what the OP aims to > accomplish or why. (maybe this isn’t even the right rabbit hole) > > If they want to only delete transactions in AccountA that *do not* also > include splits with AccountB and AccountC, but do include splits with > Expense:E and Expense:F then probably two successive Find operations would > need to be done to narrow the result properly. (or just visually skip them > when deleting) > > Otherwise as David noted, AccountB and AccountC will also see those > transactions disappear and be affected. > > This might even be a case where the target transactions should be found, > then one-by-one, edited manually to exclude splits to Expense:E & Expense:F > and re-balance each transaction between only AccountA, B, & C. > > Regards, > Adrien > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help Find Feature
Deleting complete multi-split transactions would, of course, change running balances in all affected accounts, possibly affecting bank account reconciliations or whatever happens to be in those deleted transactions. On Sun, Mar 8, 2020 at 1:27 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The proper Find operation would be this: > > 1. Open the AccountA register. > 2. Edit > Find > 3. Set Criteria to “All Accounts” > 3a. If you want all transactions that contain *both* Expense:E and > Expense:F > -then select both accounts in the pop-up selector (use > CTRL/CMD-click to select non-adjacent accounts, or shift-click for a range) > 3b. If you want transactions that contain *either* Expense:E or > Expense:F > -then select Expense:E > -then Add another “All Accounts” criteria and select Expense:F > -then change the “Search for items where” to “any criteria are met” > 4. Click the Find button > > From the search results, delete each transaction as desired one-by-one. > > Note, you can further refine search results with additional Finds from the > resulting register of a previous Find. > > Regards, > Adrien > > > On Mar 8, 2020 w11d68, at 1:14 PM, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > Per a previous post Gio noted the intent to delete *some* expense > transactions. > > > > The example given was: > > > >> So example consider accountA. In it you would have transactions to/from: > >> AccountB > >> AccountC > >> Expense:E > >> Expense:F > >> > >> I want to be able to search so it will list Expense:E and F but NOT > >> Accounts B and C. Then I can delete these expenses. > > > > It still isn’t clear if the intent is to delete everything in Expense:E > & Expense:F or just those that also are split with AccountA. > > > > In the latter case, a proper Find operation I think is the fastest > route, deleting each one by one from that resulting list. (a search result > that is, not a report which does involve extra clicks as the OP noted.) > > > > Regards, > > Adrien > > > > > > > >> On Mar 8, 2020 w11d68, at 12:48 PM, Stephen M. Butler > wrote: > >> > >> Hmm. Did you say _every_ transaction involved in _all_ expense > accounts? > >> > >> Open your file and save off a copy. > >> > >> Then on the Accounts tab, find the top-level Expenses account and > >> highlight that. > >> > >> Click on Edit menu item and then on Delete Account. > >> > >> On the popup screen select the options to delete sub-accounts and to > >> delete transactions. > >> > >> Click on the Delete button on the lower right corner. > >> > >> POOF -- all transactions involving an expense account are gone. So are > >> all the Expense accounts! But you can add those back in as needed. > > > > > _______ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Help Find Feature
Gio, In GnuCash you cannot delete split lines without throwing the transaction out of balance. Hence, you need to replace the undesired account with a different account. If you want to delete every instance of an expense A and replace it with expense B you can do that in the account tree by relocating expense A under expense B then deleting expense A. If you want to only select a few instances of A and replace them with B, that probably means examining one transaction at a time and changing A to B individually. If you use the technique described by Tommy Trussell you can generate a "short list" of transactions that meet your criteria for finding the desired transactions, but you would still need to edit those transactions one at a time. David Carlson On Sat, Mar 7, 2020 at 10:10 PM Gio Bacareza wrote: > Thanks Tommy. This is a really interesting method and I can already think > of use cases. For my scenario though, as I mentioned earlier response, it > will add extra steps to what it is that I want to do. > > I want to be able to find transactions to/from expense accounts because I > need to delete them and I am looking for the fastest way to do that. Thanks > > On Sun, Mar 8, 2020 at 4:30 AM Tommy Trussell > wrote: > > > On Sat, Mar 7, 2020 at 5:43 AM Maf. King wrote: > > > > > On Saturday, 7 March 2020 11:34:33 GMT Gio Bacareza wrote: > > > > Hi, > > > > > > > > I've read the manual, tried everything and searched the lists but > can't > > > > seem to figure out how you can search for ALL expense transactions > > from a > > > > certain account. > > > > > > > > Any help would be appreciated. > > > > > > Try the transaction report, (or possibly the account report.) > > > > > > > I just happened to be wondering the same thing so here's what I did in > > detail > > > > 1) Go to the Accounts page and select the top-level item you want to > report > > under. In this case: > > Expenses > > > > 2) Edit--> Open SubAccounts [OR right-click --> Open SubAccounts] > > > > 3) A new register will open; GnuCash may warn you that it's read-only. In > > this case the tab says "Expenses+" to indicate it includes SubAccounts. > > > > 4) I wanted to see JUST last month's expenses so I chose > > View --> Filter By... > > o Select Range > > 2/1/2020 > > 2/29/2020 > > > > 5) Now that you have the transactions filtered, open the Account report: > > Reports --> Account Report > > > > 6) Play with the report settings till the report shows the detail you > need. > > (If you need to tinker further, you can copy the report contents and > paste > > into a spreadsheet.) > > > > - > > > 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 > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > -- > cheers, > > Gio > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Am I being a muppet?
iirc, it is one transaction with a gazillion splits. Thus it should also be easy to temporarily change the date to Jan 1 or the day after your fiscal year ends, run your report, then change it back or close without saving. David Carlson On Wed, Mar 4, 2020 at 11:52 AM Fred Bone wrote: > On 03 March 2020 at 17:50, Uttam Chakravorty said: > > > >1. Re: show previous years totals on account page? > > > (Adrien Monteleone) > > >"you can run the multicolumn Income Statement, from the Reports > > > > Experimental menu. Select a range of several years in Options > General > > > and also set Period duration to ‘Year’" > > > > > > The topic and Adrien's advice resonated so I had to have a go. And it > > works well. > > > > However, I did a 'close books' on 31st December 2018 (year = Jan - Dec). > > I am therefore getting nothing in the 2018 column and assume I won't > get > > anything even in the 2019 (Dec 2019) once I close it. This is not too > > horrible as I keep the html reports. However, I would like to know if > I'm > > missing a trick or just being stupid. > > You can always delete the closing transactions - probably best done from > the relevant Equity account, as they're easily found there. > > If you want them back, it's easy enough to re-do the "close books". Or, > if you're using the XML file format, just reopen the file without saving > it. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 - Unique Transaction Number & Dates
You can use Tools > General Ledger to see all transactions in one place. You will have to change View > Filter by... to Select Range > Earliest to see more than the last 30 days or so. Use Filter > Sort By > Number to check the last number used. You can check Save Filter if you want GnuCash to remember your choice. There is nothing to put a hard limit to the date range of a new transaction. There are tricks such as using the Reconcile feature and entering periodic transactions noting, say, balance as of a date to make errors easier to spot. I seem to recall there being a setting for a warning if entering a transaction date before some value, but now I cannot find it. Perhaps another user can help with that. David Carlson On Mon, Mar 2, 2020 at 4:28 AM Christopher Lam wrote: > On Mon, 2 Mar 2020 at 09:20, Mardem via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > Hello guys, > > The first thing that I noticed is that I cant have a unique number for > each > > transaction (that I will write on the hard copy i.e. invoice). This is > very > > strange to me being an accountant for 7 years now. > > I also need to remember where I have added my last transaction number in > > order to continue from there since every time I click a new account I can > > see the transactions related to that account. > > How you guys tackle this problem? > > > > You mean the Num field? You *can* have a counter: in the register, after > setting the date, press TAB to reach the Num field, and press + (or =) to > set Num to the next number. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Investment Portfolio Reporting
You won't get much out of GnuCash unless you had it collecting security prices at the appropriate times to use in your desired reports. If you did, try the assets over time reports. There may be some better reports in the 3.x family of releases. Otherwise, third party software or spreadsheets or a combination will work better. David Carlson On Sun, Mar 1, 2020, 10:53 AM rsbrux via gnucash-user < gnucash-user@gnucash.org> wrote: > I need some reports which show the performance of various investment > accounts over the past year. I don't find anything suitable in GC > 2.6.19 and don't have the chops (neither in accounting nor in guile) to > write my own. Surely I am not the first GC user with this need. The > only thing I found which looks useful is gnucash-portfolio: > > http://portfolio.alensiljak.tk/ > > https://github.com/MisterY/gnucash-portfolio > > However, as ignorant as I am about Python, I am not even sure how to > install it. Furthermore, it appears to require the GC DB stored in > SQLite, whereas mine is still in (compressed) XML. > > Does anyone have experience with gnucash-portfolio? > > What other approach could I use? > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] (no subject)
What version of GnuCash are you using and how did you install it? What folder did you use for your data file? David Carlson On Sun, Feb 16, 2020, 4:55 PM varda241 wrote: > > > > > Sent from my Verizon, Samsung Galaxy Tablet > > Original message ---- > From: David Carlson > Date: 2/16/20 2:52 PM (GMT-05:00) > To: Varda Rotenberg > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] (no subject) > > The setting sticks for each account once set. The setting in preferences > applies the first time the account is opened. > > David Carlson > > On Sun, Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Once in a while, I loose the double line on account. The option is >> checked at register default ,but I still get the single lines only. I use >> the double line for memos. What can be done?thanks, Varda >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > Thank you. So far, I saved the settings, closed the app, rebooted the >> computer, clicked on gnucash and when it came up, there no double line. I >> work in ubuntu 18.4 > > Varda > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] (no subject)
The setting sticks for each account once set. The setting in preferences applies the first time the account is opened. David Carlson On Sun, Feb 16, 2020, 1:49 PM Varda Rotenberg via gnucash-user < gnucash-user@gnucash.org> wrote: > Once in a while, I loose the double line on account. The option is checked > at register default ,but I still get the single lines only. I use the > double line for memos. What can be done?thanks, Varda > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)
When importing, the sign overrides the column name, so a negative withdrawal becomes a deposit. David Carlson On Sun, Feb 16, 2020, 1:33 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 2/16/2020 11:28 AM, Fran_3 via gnucash-user wrote: > > I imported a big bunch of checking transactions and guess I got the > Deposit & Withdrawal columns labeled wrong during the import process. > > Is there any way to select a bunch of checking transactions and change > Deposits to Withdrawals? > > Thanks for any help. > > Horse and barn doors, but this is worth pointing out. Take checkpoints. > > In other words, before doing a large import of data, make a backup copy > of the file. Then, as in a case like this, you can easily back out the > faulty import. > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)
In the future, be sure to save a copy of the file just before importing! David Carlson On Sun, Feb 16, 2020, 12:14 PM Fran_3 wrote: > They are the last 663 checking transactions and they were already saved > gnuCash and its going to be hard to go back to an earlier version. > > My plan is to export those last 633 transactions and edit them in a > spreadsheet... which I've already done > and I ended up with just 5 columns... Date, Num, Description, Deposit, > Withdrawal > > Next I need to delete the last 633 transactions from the check register > but I have not been able to select multiple checking transactions... > > Any idea on how do select multiple checking transactions so you can just > delete them all at once? > > Thanks for the help ! > > > On Sunday, February 16, 2020, 12:34:02 PM EST, David Carlson < > david.carlson@gmail.com> wrote: > > > The easiest way is to close gnucash without saving to abandon the current > data and import again. > > If you saved the file with the incorrect import, close it and open the > last save before the import. > > If you didn't notice the error until much later, there is no mass > correction possible, but you could import again if it was a qif import then > delete the ones that are wrong. > > David Carlson > > On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user < > gnucash-user@gnucash.org> wrote: > > I imported a big bunch of checking transactions and guess I got the > Deposit & Withdrawal columns labeled wrong during the import process. > Is there any way to select a bunch of checking transactions and change > Deposits to Withdrawals? > Thanks for any help. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to change MANY Deposits to Withdrawals? (Import error)
The easiest way is to close gnucash without saving to abandon the current data and import again. If you saved the file with the incorrect import, close it and open the last save before the import. If you didn't notice the error until much later, there is no mass correction possible, but you could import again if it was a qif import then delete the ones that are wrong. David Carlson On Sun, Feb 16, 2020, 10:30 AM Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > I imported a big bunch of checking transactions and guess I got the > Deposit & Withdrawal columns labeled wrong during the import process. > Is there any way to select a bunch of checking transactions and change > Deposits to Withdrawals? > Thanks for any help. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Fwd: Failed - import of QIF files from Quicken
Reply to gnucash-user@gnucash.org. *last warning* On Fri, Feb 14, 2020, 6:42 PM Ron wrote: > Well, I like Reply All better then no reply... > > Ron > > -Original Message- > From: gnucash-user > On Behalf Of David Carlson > Sent: Friday, February 14, 2020 7:40 PM > To: gnucash-user@gnucash.org > Subject: [GNC] Fwd: Failed - import of QIF files from Quicken > > Sorry, list, I used reply all and overlooked that you were not included > > David Carlson > > -- Forwarded message - > From: David Carlson > Date: Fri, Feb 14, 2020, 6:22 PM > Subject: Re: [GNC] Failed - import of QIF files from Quicken > To: Ron > > > > > On Fri, Feb 14, 2020, 6:06 PM Ron wrote: > > > Yes to both. Gnucash went thru a number of steps to actually start > > import…that is when I got message Failed. Nothing to support that > > message but I had already invested a lot of time! > > > > > > > > Ron > > > > > > > Please use 'reply all's so everyone can see it. > > Now I need to turn this over to persons who have experience with the qif > importer in recent 3.x releases, as I am still in release 2.6.19. > > David Carlson > > > *From:* David Carlson > > *Sent:* Friday, February 14, 2020 5:58 PM > > *To:* Ron > > *Cc:* gnucash-user@gnucash.org > > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > > > > > It would be a help to know at what point it failed. Were you able to > > choose an account to import into? Could you see the accounts GnuCash > > was proposing in the next step? > > > > > > > > David Carlson > > > > > > > > On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > > > > Liz sent me a message but I do not know how to do a Reply. > > > > Windows version. Quicken - latest Online subscription - that is why I > > want out. Gnucash just downloaded 3.8. > > > > I read that it might be better to import small files so I exported one > > account (category) and it still failed. Log was not helpful. > > > > > > > > Ron > > > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: Failed - import of QIF files from Quicken
Another -- Forwarded message - From: David Carlson Date: Fri, Feb 14, 2020, 6:34 PM Subject: Re: [GNC] Failed - import of QIF files from Quicken To: Ron On Fri, Feb 14, 2020, 6:30 PM Ron wrote: > Yes I am getting replies since I am responding to you. However, I did get > a response from Liz in the Archive, but there is no Reply option there. > > > > Ron > > > That mail from Liz was probably something like welcome to the list, which would not need a reply. Now you should reply to all or to list as recommended in several previous messages . David Carlson *From:* David Carlson > *Sent:* Friday, February 14, 2020 7:29 PM > *To:* Ron > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > > > On Fri, Feb 14, 2020, 6:18 PM Ron wrote: > > I am obviously in the wrong place. I am on a desktop, Win 10. > > I have been going to gnucash.org, then Mailing lists. I did subscribe and > was accepted. > > I went to gnucash-user archives, picked February, went to the bottom of > the list (by date) and found my message and a response. No Reply ability on > that page. So obviously I took a wrong turn, but no clue where! > > > > > > Depending on the option you chose when you registered, you should be > getting replies in your inbox at comcast.net either individually or in > some aggregation. > > > > > > David Carlson > > > > Ron > > > > *From:* David Carlson > *Sent:* Friday, February 14, 2020 5:58 PM > *To:* Ron > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > It would be a help to know at what point it failed. Were you able to > choose an account to import into? Could you see the accounts GnuCash was > proposing in the next step? > > > > David Carlson > > > > On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > > Liz sent me a message but I do not know how to do a Reply. > > Windows version. Quicken - latest Online subscription - that is why I want > out. Gnucash just downloaded 3.8. > > I read that it might be better to import small files so I exported one > account (category) and it still failed. Log was not helpful. > > > > Ron > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: Failed - import of QIF files from Quicken
And another -- Forwarded message - From: David Carlson Date: Fri, Feb 14, 2020, 6:34 PM Subject: Re: [GNC] Failed - import of QIF files from Quicken To: Ron On Fri, Feb 14, 2020, 6:30 PM Ron wrote: > Yes I am getting replies since I am responding to you. However, I did get > a response from Liz in the Archive, but there is no Reply option there. > > > > Ron > > > That mail from Liz was probably something like welcome to the list, which would not need a reply. Now you should reply to all or to list as recommended in several previous messages . David Carlson *From:* David Carlson > *Sent:* Friday, February 14, 2020 7:29 PM > *To:* Ron > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > > > On Fri, Feb 14, 2020, 6:18 PM Ron wrote: > > I am obviously in the wrong place. I am on a desktop, Win 10. > > I have been going to gnucash.org, then Mailing lists. I did subscribe and > was accepted. > > I went to gnucash-user archives, picked February, went to the bottom of > the list (by date) and found my message and a response. No Reply ability on > that page. So obviously I took a wrong turn, but no clue where! > > > > > > Depending on the option you chose when you registered, you should be > getting replies in your inbox at comcast.net either individually or in > some aggregation. > > > > > > David Carlson > > > > Ron > > > > *From:* David Carlson > *Sent:* Friday, February 14, 2020 5:58 PM > *To:* Ron > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > It would be a help to know at what point it failed. Were you able to > choose an account to import into? Could you see the accounts GnuCash was > proposing in the next step? > > > > David Carlson > > > > On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > > Liz sent me a message but I do not know how to do a Reply. > > Windows version. Quicken - latest Online subscription - that is why I want > out. Gnucash just downloaded 3.8. > > I read that it might be better to import small files so I exported one > account (category) and it still failed. Log was not helpful. > > > > Ron > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: Failed - import of QIF files from Quicken
Missed agsin -- Forwarded message - From: David Carlson Date: Fri, Feb 14, 2020, 6:28 PM Subject: Re: [GNC] Failed - import of QIF files from Quicken To: Ron On Fri, Feb 14, 2020, 6:18 PM Ron wrote: > I am obviously in the wrong place. I am on a desktop, Win 10. > > I have been going to gnucash.org, then Mailing lists. I did subscribe and > was accepted. > > I went to gnucash-user archives, picked February, went to the bottom of > the list (by date) and found my message and a response. No Reply ability on > that page. So obviously I took a wrong turn, but no clue where! > > > Depending on the option you chose when you registered, you should be getting replies in your inbox at comcast.net either individually or in some aggregation. > > David Carlson > > > Ron > > > > *From:* David Carlson > *Sent:* Friday, February 14, 2020 5:58 PM > *To:* Ron > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > It would be a help to know at what point it failed. Were you able to > choose an account to import into? Could you see the accounts GnuCash was > proposing in the next step? > > > > David Carlson > > > > On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > > Liz sent me a message but I do not know how to do a Reply. > > Windows version. Quicken - latest Online subscription - that is why I want > out. Gnucash just downloaded 3.8. > > I read that it might be better to import small files so I exported one > account (category) and it still failed. Log was not helpful. > > > > Ron > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Fwd: Failed - import of QIF files from Quicken
Sorry, list, I used reply all and overlooked that you were not included David Carlson -- Forwarded message - From: David Carlson Date: Fri, Feb 14, 2020, 6:22 PM Subject: Re: [GNC] Failed - import of QIF files from Quicken To: Ron On Fri, Feb 14, 2020, 6:06 PM Ron wrote: > Yes to both. Gnucash went thru a number of steps to actually start > import…that is when I got message Failed. Nothing to support that message > but I had already invested a lot of time! > > > > Ron > > > Please use 'reply all's so everyone can see it. Now I need to turn this over to persons who have experience with the qif importer in recent 3.x releases, as I am still in release 2.6.19. David Carlson *From:* David Carlson > *Sent:* Friday, February 14, 2020 5:58 PM > *To:* Ron > *Cc:* gnucash-user@gnucash.org > *Subject:* Re: [GNC] Failed - import of QIF files from Quicken > > > > It would be a help to know at what point it failed. Were you able to > choose an account to import into? Could you see the accounts GnuCash was > proposing in the next step? > > > > David Carlson > > > > On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > > Liz sent me a message but I do not know how to do a Reply. > > Windows version. Quicken - latest Online subscription - that is why I want > out. Gnucash just downloaded 3.8. > > I read that it might be better to import small files so I exported one > account (category) and it still failed. Log was not helpful. > > > > Ron > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Failed - import of QIF files from Quicken
It would be a help to know at what point it failed. Were you able to choose an account to import into? Could you see the accounts GnuCash was proposing in the next step? David Carlson On Fri, Feb 14, 2020, 2:37 PM Ron wrote: > Liz sent me a message but I do not know how to do a Reply. > > Windows version. Quicken - latest Online subscription - that is why I want > out. Gnucash just downloaded 3.8. > > I read that it might be better to import small files so I exported one > account (category) and it still failed. Log was not helpful. > > > > Ron > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 XML format compatibility
Adrian, I think your explanation is much clearer than mine was. Thanks David Carlson On Wed, Feb 12, 2020, 4:34 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I’m not sure that makes it any clearer as 10.1 is *also* codenamed > ‘Buster’. (the entire Debian 10 version, all releases, are ‘buster’) > > I think this is a confusion of terminology. > > It appears the questioner thought that a ‘major release’ is a specific > singular release and that minor releases follow the major one. > > The confusion is in referring to ‘major’ as a 'release’ when it in fact is > a ‘version’. There is no such thing as a ‘major release’. There are several > releases for each major ‘version’. There will of course, always be a first > x.0 release of a major version. (and we are now on release #9, dubbed 3.8 > of the major version 3 of GnuCash) > > As described previously, major *versions* were '2.4', '2.6', and now '3'. > > The reason for this difference is that prior to 3.0, a 3-number scheme was > used. (fundamental.major.minor/bug-fix) > > So there were several minor or 'bug-fix' releases in the 2.4.x > series/version. > > The same for the 2.6.x series/version. (the last of which was 2.6.21) > > Development versions were odd-numbered. (‘2.5’, ‘2.7’ for example) > > The third number was dropped for 3.0 (which would have been 2.8.0 had the > old scheme continued) There were long explanations and discussions as to > why this change was made. (now it is ‘major.minor’) > > There will be ‘3.9xx' versions (the first being '3.901’) which are the > development versions in the run-up to version ‘4’, the first release of > which will be ‘4.0’. If the pattern holds, there will at some point then be > ‘4.9xx’ development versions in the run-up to version ‘5’. > > > For the official outline of version numbering see the wiki: > https://wiki.gnucash.org/wiki/Development_Process#Release_Version_Numbering > > And for the planned release schedule: > https://wiki.gnucash.org/wiki/Release_Schedule > > Regards, > Adrien > > > > > On Feb 12, 2020 w7d43, at 11:40 AM, David Carlson < > david.carlson@gmail.com> wrote: > > > > If Gnucash releases had codenames like some Linux releases such as > Debian, > > it might be easier to understand. The first Debian "buster" release was > > Debian 10.0. > > > > David Carlson > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 XML format compatibility
If Gnucash releases had codenames like some Linux releases such as Debian, it might be easier to understand. The first Debian "buster" release was Debian 10.0. David Carlson On Wed, Feb 12, 2020, 11:22 AM David Carlson wrote: > Yes, there is a major release 3.x but it is a bucket containing minor > releases, which you can install on your computer. As you know, the first > number is zero, so the first minor release in the release 3.x bucket is > release 3.0. > > David Carlson > > On Wed, Feb 12, 2020, 10:57 AM Colin Law wrote: > >> On Wed, 12 Feb 2020 at 16:44, Peter West wrote: >> > >> > So is there a release called 3.x? >> >> The first digit is the major release number, so the current major >> release number is 3 and the next major release will be the first one >> starting with 4. The second digit is the minor release number, so 3.7 >> is major release 3, minor 7. >> >> This is known as Sematic Versioning, GC doesn't stick exactly to this >> concept but it is pretty close >> https://semver.org/ >> >> Colin >> >> > >> > Only a few days ago, someone said that he had upgrades from 3.x, and >> was asked just which release he had upgraded from, which is a perfectly >> reasonable question. >> > >> > All I can do is repeat my previous question, but I’m beginning to doubt >> I’ll get an answer. It’s like dealing with Pope Francis, who relishes >> ambiguity. >> > >> > Peter >> > >> > -- >> > Peter West >> > p...@pbw.id.au >> > “For from within, out of the heart of man, come evil thoughts, sexual >> immorality, theft, murder, adultery, coveting, wickedness, deceit, >> sensuality, envy, slander, pride, foolishness.” >> > >> > > On 13 Feb 2020, at 1:21 am, David Carlson < >> david.carlson@gmail.com> wrote: >> > > >> > > I believe Derek said 3.x is a major release and 3.0 is the first >> minor release in that series. >> > > >> > > David Carlson >> > > >> > > On Wed, Feb 12, 2020, 9:08 AM Peter West > p...@pbw.id.au>> wrote: >> > > So it is correct to say that 3.0 was the major release, and that 3.1, >> 3.2. etc were all subsequent minor releases? >> > > >> > > Saying 3.x is the major release is ambiguous, to say the least. In >> that case, 3.1, 3.2, etc would all be major releases, because they all >> qualify as 3.x. >> > > >> > > It took me a while to work out what you were saying, and maybe I >> still haven’t. >> > > >> > > Peter >> > > -- >> > > Peter West >> > > p...@pbw.id.au <mailto:p...@pbw.id.au> >> > > “For from within, out of the heart of man, come evil thoughts, sexual >> immorality, theft, murder, adultery, coveting, wickedness, deceit, >> sensuality, envy, slander, pride, foolishness.” >> > > >> > > > On 13 Feb 2020, at 12:54 am, Derek Atkins > de...@ihtfp.com>> wrote: >> > > > >> > > > Hi, >> > > > >> > > > Please remember to CC gnucash-user on all replies... >> > > > >> > > > Peter West mailto:p...@pbw.id.au>> writes: >> > > > >> > > >> I assume that you mean: >> > > >> 3.0 is the major release, and 3.1, 3.2. etc are all the minor >> releases. So the >> > > >> next major release will be 4.0. >> > > >> >> > > >> Is this the case? >> > > > >> > > > I said exactly what I mean. >> > > > >> > > > Technically, 3.0 was the first of the 3.x major-release cycle, and >> 3.1, >> > > > 3.2, etc were all subsequent minor releases of the 3.x major-release >> > > > cycle. The next major release will be 4.x, starting with 4.0 as its >> > > > first release in the 4.x release cycle. >> > > > >> > > >>On 12 Feb 2020, at 2:12 am, Derek Atkins > <mailto:de...@ihtfp.com>> wrote: >> > > >> >> > > >>First, note that we changed the numbering scheme between 2.x >> and 3.x. >> > > >>This means that 2.0, 2.2, 2.4, and 2.6 are all *major* >> releases, with >> > > >>minor releases denoted in the third number. Whereas 3.x is the >> major >> > > >>release and 3.0, 3.1, etc. are all the minor releases. >> > > > >> >
Re: [GNC] GNUCash XML format compatibility
Yes, there is a major release 3.x but it is a bucket containing minor releases, which you can install on your computer. As you know, the first number is zero, so the first minor release in the release 3.x bucket is release 3.0. David Carlson On Wed, Feb 12, 2020, 10:57 AM Colin Law wrote: > On Wed, 12 Feb 2020 at 16:44, Peter West wrote: > > > > So is there a release called 3.x? > > The first digit is the major release number, so the current major > release number is 3 and the next major release will be the first one > starting with 4. The second digit is the minor release number, so 3.7 > is major release 3, minor 7. > > This is known as Sematic Versioning, GC doesn't stick exactly to this > concept but it is pretty close > https://semver.org/ > > Colin > > > > > Only a few days ago, someone said that he had upgrades from 3.x, and was > asked just which release he had upgraded from, which is a perfectly > reasonable question. > > > > All I can do is repeat my previous question, but I’m beginning to doubt > I’ll get an answer. It’s like dealing with Pope Francis, who relishes > ambiguity. > > > > Peter > > > > -- > > Peter West > > p...@pbw.id.au > > “For from within, out of the heart of man, come evil thoughts, sexual > immorality, theft, murder, adultery, coveting, wickedness, deceit, > sensuality, envy, slander, pride, foolishness.” > > > > > On 13 Feb 2020, at 1:21 am, David Carlson > wrote: > > > > > > I believe Derek said 3.x is a major release and 3.0 is the first minor > release in that series. > > > > > > David Carlson > > > > > > On Wed, Feb 12, 2020, 9:08 AM Peter West p...@pbw.id.au>> wrote: > > > So it is correct to say that 3.0 was the major release, and that 3.1, > 3.2. etc were all subsequent minor releases? > > > > > > Saying 3.x is the major release is ambiguous, to say the least. In > that case, 3.1, 3.2, etc would all be major releases, because they all > qualify as 3.x. > > > > > > It took me a while to work out what you were saying, and maybe I still > haven’t. > > > > > > Peter > > > -- > > > Peter West > > > p...@pbw.id.au <mailto:p...@pbw.id.au> > > > “For from within, out of the heart of man, come evil thoughts, sexual > immorality, theft, murder, adultery, coveting, wickedness, deceit, > sensuality, envy, slander, pride, foolishness.” > > > > > > > On 13 Feb 2020, at 12:54 am, Derek Atkins de...@ihtfp.com>> wrote: > > > > > > > > Hi, > > > > > > > > Please remember to CC gnucash-user on all replies... > > > > > > > > Peter West mailto:p...@pbw.id.au>> writes: > > > > > > > >> I assume that you mean: > > > >> 3.0 is the major release, and 3.1, 3.2. etc are all the minor > releases. So the > > > >> next major release will be 4.0. > > > >> > > > >> Is this the case? > > > > > > > > I said exactly what I mean. > > > > > > > > Technically, 3.0 was the first of the 3.x major-release cycle, and > 3.1, > > > > 3.2, etc were all subsequent minor releases of the 3.x major-release > > > > cycle. The next major release will be 4.x, starting with 4.0 as its > > > > first release in the 4.x release cycle. > > > > > > > >>On 12 Feb 2020, at 2:12 am, Derek Atkins <mailto:de...@ihtfp.com>> wrote: > > > >> > > > >>First, note that we changed the numbering scheme between 2.x and > 3.x. > > > >>This means that 2.0, 2.2, 2.4, and 2.6 are all *major* releases, > with > > > >>minor releases denoted in the third number. Whereas 3.x is the > major > > > >>release and 3.0, 3.1, etc. are all the minor releases. > > > > > > > > -derek > > > > > > > > -- > > > > Derek Atkins 617-623-3745 > > > > de...@ihtfp.com <mailto:de...@ihtfp.com> > www.ihtfp.com <http://www.ihtfp.com/> > > > > Computer and Internet Security Consultant > > > > > > ___ > > > gnucash-user mailing list > > > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > > To update your subscription preferences or to unsubscribe: > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user < > https://lists.gnucash.org/mailman/listinfo/
Re: [GNC] GNUCash XML format compatibility
I believe Derek said 3.x is a major release and 3.0 is the first minor release in that series. David Carlson On Wed, Feb 12, 2020, 9:08 AM Peter West wrote: > So it is correct to say that 3.0 was the major release, and that 3.1, 3.2. > etc were all subsequent minor releases? > > Saying 3.x is the major release is ambiguous, to say the least. In that > case, 3.1, 3.2, etc would all be major releases, because they all qualify > as 3.x. > > It took me a while to work out what you were saying, and maybe I still > haven’t. > > Peter > -- > Peter West > p...@pbw.id.au > “For from within, out of the heart of man, come evil thoughts, sexual > immorality, theft, murder, adultery, coveting, wickedness, deceit, > sensuality, envy, slander, pride, foolishness.” > > > On 13 Feb 2020, at 12:54 am, Derek Atkins wrote: > > > > Hi, > > > > Please remember to CC gnucash-user on all replies... > > > > Peter West writes: > > > >> I assume that you mean: > >> 3.0 is the major release, and 3.1, 3.2. etc are all the minor releases. > So the > >> next major release will be 4.0. > >> > >> Is this the case? > > > > I said exactly what I mean. > > > > Technically, 3.0 was the first of the 3.x major-release cycle, and 3.1, > > 3.2, etc were all subsequent minor releases of the 3.x major-release > > cycle. The next major release will be 4.x, starting with 4.0 as its > > first release in the 4.x release cycle. > > > >>On 12 Feb 2020, at 2:12 am, Derek Atkins wrote: > >> > >>First, note that we changed the numbering scheme between 2.x and 3.x. > >>This means that 2.0, 2.2, 2.4, and 2.6 are all *major* releases, with > >>minor releases denoted in the third number. Whereas 3.x is the major > >>release and 3.0, 3.1, etc. are all the minor releases. > > > > -derek > > > > -- > > Derek Atkins 617-623-3745 > > de...@ihtfp.com www.ihtfp.com > > Computer and Internet Security Consultant > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 XML format compatibility
I omitted the word import as in transaction import matching scheme. David Carlson On Mon, Feb 10, 2020, 2:10 PM David Carlson wrote: > Isn't there also a change to the transaction matching scheme ? I thought > that was the main reason that only 2.6.21 could read both forms. > > David Carlson > > > On Mon, Feb 10, 2020, 11:57 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> If I recall correctly, dates are represented differently at some point in >> the 3.x series, but this might only be for SQL. >> >> Regards, >> Adrien >> >> > On Feb 9, 2020 w7d40, at 10:21 PM, David Carlson < >> david.carlson@gmail.com> wrote: >> > >> > According to the developers, the only pre-3.x version of GnuCash that is >> > expected to read data files that have been touched by a 3.x version is >> > release 2.6.21, possibly with a suffix depending on the OS it is run in. >> > When a file is first touched by 3.x there are some unspecified changes >> that >> > may be at least partially mentioned in other threads here. They do not >> > specify if there are any changes in the database variations, but there >> > probably are. >> > >> > David Carlson >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 XML format compatibility
Isn't there also a change to the transaction matching scheme ? I thought that was the main reason that only 2.6.21 could read both forms. David Carlson On Mon, Feb 10, 2020, 11:57 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I recall correctly, dates are represented differently at some point in > the 3.x series, but this might only be for SQL. > > Regards, > Adrien > > > On Feb 9, 2020 w7d40, at 10:21 PM, David Carlson < > david.carlson@gmail.com> wrote: > > > > According to the developers, the only pre-3.x version of GnuCash that is > > expected to read data files that have been touched by a 3.x version is > > release 2.6.21, possibly with a suffix depending on the OS it is run in. > > When a file is first touched by 3.x there are some unspecified changes > that > > may be at least partially mentioned in other threads here. They do not > > specify if there are any changes in the database variations, but there > > probably are. > > > > David Carlson > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 XML format compatibility
According to the developers, the only pre-3.x version of GnuCash that is expected to read data files that have been touched by a 3.x version is release 2.6.21, possibly with a suffix depending on the OS it is run in. When a file is first touched by 3.x there are some unspecified changes that may be at least partially mentioned in other threads here. They do not specify if there are any changes in the database variations, but there probably are. David Carlson On Sun, Feb 9, 2020 at 9:08 PM Wirawan Purwanto wrote: > Hi, > > I wonder if anyone has a pointer on the changes in Gnucash XML format > that can cause incompatibility across program versions. I have a > scenario where one OS uses Gnucash 2.6.x series whereas the other uses > 3.5. I am concerned when transporting data file back and forth, if > there is corruption due to incompatible file format. > > In my recent trial to migrate files back and forth between 2.6 and > 3.5, I noted that data seems to be intact. But in the 2.6 series, the > "cmdty:space" field has the value of "ISO4217" whereas in 3.5 it was > "CURRENCY". But I noted that a very old GNUCash version (2.4.10) > failed to read the dates correctly from the file that was saved by > 3.5. All dates became "1969-12-31" when read in the 2.4 program. > Because of this I am not quite sure what is safe to do or not safe. > Would be nice if there is a prominent / easy-to-find web page which > tells end-user like me regarding file version incompatibility. > > -- > Wirawan Purwanto > > ~ https://bfa.org ~ > "Get your own copy of a free study Bible" > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Does date order matter for Importing Checking Transactions?
Fran, If you are exporting them from a different program in, say, QIF format, I would suggest exporting one month first, them import it into GnuCash. After seeing how that went, do another month or three. David Carlson On Fri, Feb 7, 2020, 12:21 PM Fran_3 via gnucash-user < gnucash-user@gnucash.org> wrote: > Does date order matter when importing checking transactions? > I'm guessing they are ordered by date in the Check Register view and not > by the order in which they were entered or imported in the system... right? > I'm asking because this next account I'll be working on has almost 2,000 > transactions to import and a large number of the are debit cart > transactions that will not be applied as payment towards a Vendor Bill... > > So I was going to sort the downloaded checking transactions to separate > the casual debit card purchases...Then import those transactions which will > require Posting a BillThen apply those checking transactions.as payments > for each posted bill. > Then import the truck load of casual debit cart purchases... and either > put them all into an accoun named "Un-allocated Expenditures" or "Sort > Later" or "No Tax Impact Purchases" or whatever. > So, are there any consequences when you import checking transactions not > ordered by oldest date first? > Thanks for any help. > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] csv File downloads
Jane, The CSV transaction importer in various 2.6 releases of GnuCash is very touchy, particularly regarding the date format, and it does not remember the settings that you used last time. Be very careful to change the date format to the correct setting for your data every time and then it should work. It is normal after a crash to get that already open error, just select open anyway unless there is a chance that it really is open somewhere else. If 2.6.15 is working fine otherwise for you, you do not need to update into 3.8 right now. I am still holding off myself from updating. David Carlson On Thu, Jan 30, 2020, 2:22 AM Jane Knichel-Aldea wrote: > Hi: > Thank you for the response. > I am using version 2.6.15 I downloaded from gnucash website, but have not > done any updates. > I am using Windows 10 on a PC, not a mobile version. Gnucash closes when I > hit the final step of the csv import, and then I get an error message about > the file being in use when I re-open. > I have gotten it to work once or twice, but not consistently, so I am > confident it is user error. I was just hoping for some step-by-step > instructions so I can get it to work consistently. > Thank you > > Best Regards, > Jane Knichel Aldea > 201-725-3507 > > > On Mon, Jan 27, 2020 at 12:36 PM Tommy Trussell > wrote: > > > On Mon, Jan 27, 2020 at 3:18 AM wrote: > > > >> I am no longer able to download one of my credit card statements in > QFX > >>format, but every time I try to import a csv file, the system > crashes. > >>Where can I find proper instructions on how to get the csv import to > >>work? > >> > > ... > > > >> > >>Jane Knichel Aldea > >> > > ... > > > >>Sent from [1]Mail for Windows 10 > >> > >> References > >> > >>1. https://go.microsoft.com/fwlink/?LinkId=550986 > >> > > > > Greetings! > > > > I assume based upon the footer of your message you're using GnuCash on > > Windows. > > > > What version of GnuCash are you using? Where did you get it? The best way > > is to follow the download links from http://gnucash.org/ (There are > some > > "derivative" versions such as the "Portable Apps" versions, so if you're > > using those it might be an important distinction.) The current stable > > released version is 3.8. > > > > What do you mean by "the system crashes"? Do you see an error message? > > Does your screen turn a lovely shade of blue? (Hopefully I'm being silly > > there; I don't run Windows so I don't know if recent versions ever crash > > and make a "blue screen" anymore.) > > > > As noted below, please copy your response to the list so folks who know > > more than I > > > > > >> - > >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] mortage calc
Alan, GnuCash, unlike many other computer programs, does not assume that users are perpetually connected to the Internet and holding their breath waiting for the latest Spam E-Mails or announcements of software updates. If you *are* waiting for the latest version of GnuCash, you can check https://www.gnucash.org/news.phtml. You can also check https://wiki.gnucash.org/wiki/Release_Schedule for the approximate schedule for future releases, though that is not always followed rigorously. You can also just check the link to the website in the Help > About section of the menu from time to time. David Carlson On Wed, Jan 29, 2020 at 8:15 AM Alan Schold wrote: > Thanks. I did not realize there had been updates (do we get some sort of > notification?), but now I have Version 3.8 Build ID: 3.8b+(2019-12-29). > As you postulated, it now works as it should. > > On 1/28/2020 5:37 PM, Adrien Monteleone wrote: > > Is there a reason not to use the latest v3.8? > > > > I’d try that and see if you still get a crash. > > > > If so, check the wiki about obtaining the necessary logs on the Windows > platform for reporting a crash on Bugzilla. > > > > Regards, > > Adrien > > > >> On Jan 28, 2020 w5d28, at 5:02 PM, Alan Schold wrote: > >> > >> I am trying to enter data for a refi. I go to Actions>Scheduled > Transactions>Mortgage and Loan Repayment Setup. After a short "Not > Responding" message I fill in Loan Details then go to the Loan Repayment > Oprion screen. Since I don't us Escrow I leave it blank. When I push Next, > after a short pause, the entire GnuCash program shuts down, but the "lock" > program is still present. I have tried adding something to the escrow > screen, but the result is the same. > >> > >> I;m using version 3.4 build 3.4+ (2018-12-30). I have Windows 10 with > the newest upgrade. > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] two copies on the same computer.
Gary, It's easier than that. You can have as many data files as you want, kind of like when using Libre Office. The biggest restriction is that you should only have one file open at a time, else some strange things can happen . David Carlson On Sat, Jan 25, 2020, 9:53 PM Gary Stewart wrote: > I'm new to GNUcash and the mailing lists etc. > > > > Is it possible to have two copies of GNUCash running on the same computer? > One for personal, and one for business? > > > > Gary Stewart > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] computer can't find my gnucash file
The answer depends partly on whether your computer is a Windows, Linux or Mac machine, and on other factors such as whether your data file is on a local drive or cloud or NAS or USB key. Can you find the file with your file manager? Provide more details for a better answer. David Carlson On Fri, Jan 24, 2020 at 2:03 AM Susan Myers wrote: >Hi, >I've been using Gnucash for a little more than a year. When I went to >open it today my computer is telling me that the file can't be found. > I need advice ASAP on why this might be happening. >Thanks, >Susan > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Minimum window width
Tim, I usually run GnuCash on Ubuntu 18.04, but I use four desktops, one for GnuCash, one for a web browser and password manager, one for a pair of spreadsheets, and one for everything else. While I cannot see everything at once, it is trivial to use the task bar (or alt-tab) to switch from one program to another. If I need to copy text from one program to another, I just use the clipboard. David Carlson On Fri, Jan 17, 2020, 5:29 PM Tim Kallmer wrote: > Using 3.6 on Ubuntu 19.04. Is there some setting that sets the minimum > width the Gnucash window uses? I like to snap GC on one half of the screen > and have a browser with my bank website on the other half while I am > recording transactions. This works fine on my desktop with 1920x1080 > resolution. But on my laptop with with 1600x900, snapping doesn't work and > I can only shrink the width to what seems like 860 pixels, over one-half of > the screen, so it doesn't fit nicely, and I cannot see my full transactions > and GC simultaneously. And it takes a bit of mouse work to adjust the > window edges to tile them, then scroll the browser back and forth with the > bottom slide bar. Zooming the browser out to fit makes the text small and > difficult to read. I've been living with it, but thought I'd ask if there > is a simple solution. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QIF import - set default Transfer account
During the QIF import process GnuCash will try to assign an account to each transaction and it will give you a chance to accept the assignment or change it before you complete the import. There is no shortcut to change more than one account assignment at a time. In subsequent imports it will improve it's assignments so you will need to correct it less often, but it will probably still miss a few, so watch carefully. Good luck. David Carlson On Thu, Jan 16, 2020 at 1:44 AM malam via gnucash-user < gnucash-user@gnucash.org> wrote: > QIF import correctly imports data into the database.During import it sets > all > transactions as *'/Unspecified/'*.Is it possible to set a different > Transfer > account for ALL imported transactions ?BackroundAt the moment I am > interested in just few types of expenses,95% of all imported transactions > should be linked to my 'Other' expense account.I have lots of manual work > to > change the imported transactions > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mortgage & Loan Repayment schedule tool
Don, I think that the mortgage tool should not have a problem with fixed amount lines like escrow. There must be extra lines in the SX transaction that was created by the tool. You can manually edit that SX transaction after it has been entered once into the register or alternatively in the SX editor from the SX list. If I had escrow in my mortgage payment I would have separate transactions to document the respective payments, which would make the Escrow asset account balance accurate at all times. One of the minor annoyances of GnuCash is that it is hard to get to the SX editor for a particular SX until after it has been entered into the register at least once. David Carlson On Sat, Jan 11, 2020 at 3:54 PM Don Ireland wrote: > Thanks. I really understood that -- there are lots of variables that can > alter the interest versus principal portions of rhe payment (such as thr > payment was processed at the bank on the 15th but you entered it into the > system on the 20th. You now have 5 extra days of interest). > > But that's not what I was asking about. I'll say it again. The recurring > transactions created by the tool created transactions crediting the escrow > account for the insurance & taxes and debiting the escrow account to > transfer the money to the taxes and insurance accounts. So now the total > amount it takes from the account is equal to JUST THE P > > I ended up fixing it by entering it manually. > > On January 11, 2020 2:26:08 PM CST, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > >Do not fault the tool if it does not agree with the bank. I have > >written > >these things. There are simply too many assumption about how to do the > >calculation, where to round off, etc. << I ended up with a fancy > >version > >that allowed instructions where to adjust that could get agreement to a > > > >penny BUT it was not strictly speaking a "function" (a calculation) but > > > >a process using a repeated "trial and error" approach not unlike > >Newton's Method --- lenders frequently charge for an "amortization > >table" and I wanted to have that to be able to make additional payments > > > >of principle*. > > > >As for escrow amount calculation, this is really tricky. The bank will > >set an amount to fund an amount that will not only be sufficient to pay > > > >the taxes and insurance bills over the year but will do so on a "cash > >flow" basis. In other words, the fund will always have enough in it to > >meet these bills when they are due. The bank will recalculate ever year > > > >but based on the dates of the expected bills will tend to fluctuate > >more > >wildly than you expect**. I never wrote one of these, but again, a good > > > >candidate for repeated "trial and error*" > > > >Michael D Novack > > > > > >* If the amount you send in is the exact amount of the principle > >portion > >of the following payment then you can cross that payment off -- in > >effect you are jumping closer to the end of the mortgage. Especially > >when interest rates are high, as they were at the time, in early years > >you can cheaply buy time off the end of the mortgage. > > > >**( In other words, given an initial balance (in escrow) and making a > >series of payments at specified dates (the tax and insurance due dates > >and amounts) what is the least monthly input (or biweekly if that's > >what > >the mortgage payments are) that will prevent the escrow amount from > >going minus.) > > > > > >___ > >gnucash-user mailing list > >gnucash-user@gnucash.org > >To update your subscription preferences or to unsubscribe: > >https://lists.gnucash.org/mailman/listinfo/gnucash-user > >If you are using Nabble or Gmane, please see > >https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >- > >Please remember to CC this list on all your replies. > >You can do this by using Reply-To-List or Reply-All. > > Don Ireland > ___________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Mortgage & Loan Repayment schedule tool
One of many ways to start the loan wizard retroactively would be to set it up with the original figures to start with the first payment in the series and plan on deleting the past payments that it creates. That may or may not work well for your particular case. David Carlson On Fri, Jan 10, 2020, 10:19 PM Don Ireland wrote: > No I ran the tool FIRST. It did NOT create the past transactions -- and I > assumed that was because it would only create the scheduled transactions. > So I manually entered the last ones myself -- I used an amortization > schedule in an excel spreadsheet to tell me what each month's P & I would > be. > > What I'm having trouble with is the fact that the scheduled transaction > says the next due date is 4/1/2019. > > I'll take another look at the guide. > > On January 10, 2020 10:08:35 PM CST, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >You entered several payments manually, *then* decided to use the tool, > >and are confused as to why the tool doesn’t reflect your manually > >entered payments? > > > >*I’m* confused as to why you think it would. > > > >But my advice would be to either abandon the tool, or fix the manual > >entries to accommodate the tool. Then all will be well regardless of > >the choice. > > > >I’m no expert on the loan druid/wizard (whatever it is called) but I’d > >hazard the guess to otherwise, use 2/1/20 as the next payment date, > >*AND* use the balance as of that date, not the original loan balance. > >This may or may not accurately calculate your actual payments. Since > >you are only less than a year out, I’d personally opt to fix the > >historical transactions and stick with the original loan numbers. > > > >Finally, be certain to read over the Tutorial & Concepts guide > >concerning loans/mortgages to make sure you aren’t stumbling on any > >pitfalls/sandtraps. While the GnuCash workflow for many if not most > >things is fairly reasonable, it is based on standard accounting > >practices which most people are not familiar with in their personal > >finances. Thus, some things are not at first, as intuitive as you might > >expect. > > > >Regards, > >Adrien > > > >> On Jan 10, 2020 w2d10, at 9:54 PM, Don Ireland > > wrote: > >> > >> I have a mortgage on my home that I bought in March 2019. I used the > >mortgage & loan repayment schedule tool to schedule my monthly > >payments. When it asked for the loan beginning date, I entered 3/1/19 > >thinking it would need that to accurately calculate the payments. When > >I look at the resulting scheduled transaction, I see that it thinks the > >"next payment date" is April 1, 2019. > >> > >> If I chang that date to 2/1/20, will that mess things up? > >> > >> I already manually entered all the payments that I've already made so > >I don't need it to do that for me. > >> > >> Thanks! > >> Don Ireland > > > >___ > >gnucash-user mailing list > >gnucash-user@gnucash.org > >To update your subscription preferences or to unsubscribe: > >https://lists.gnucash.org/mailman/listinfo/gnucash-user > >If you are using Nabble or Gmane, please see > >https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >- > >Please remember to CC this list on all your replies. > >You can do this by using Reply-To-List or Reply-All. > > Don Ireland > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to change default book/file to open in GC 2.6 under
> > > > > Are you certain you don’t have more than one instance of GnuCash > running? (I > > know it is possible on Mac, not sure about Linux) > > > I can attest that it is not only possible but very easy to start two > instances of Gnucash 2.6.19 accidentally in Ubuntu linux 18.04 simply by > clicking on the initial splash screen while it is starting . > Be sure both instances are closed before re-starting Gnucash. David Carlson > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Chaning left sidebar spacing
Jack, There are many bugs open that long or longer. The developers are limited with the amount of time that they can donate to this fine program, so wish lists and minor annoyances tend to languish. They would love help from more volunteers. David Carlson On Thu, Jan 9, 2020, 4:33 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Bug number? > > Regards, > Adrien > > > On Jan 9, 2020 w2d9, at 4:15 PM, Jack Slater > wrote: > > > > Found it; bug since 2008. That seem really excessive!? > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Anyone noticing an issue with list messages 'un-threading'?
Testing the Select-before-reply process. Appears to work by putting the selected text at the end. Hard to tell for sure because of those three dots symbols that Gmail splatters all over the place ... Sometimes an inaccurate answer escapes my aging brain, so I know that not all of my thoughts deserve to be preserved in the Smithsonian, anyway, I was careful to not point fingers because that leaves three pointing back at me. David Carlson On Wed, Jan 8, 2020 at 1:14 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > There’s a trick with most mail clients, gmail included, that should help > trim some of that long message issue. > > Select the part you want to reply to, before hitting the reply button. > > This will only quote the selected portion. > > Of course, not everyone is so kind, (especially some newer digest users) > so you might end up with a few feet of scrolling occasionally anyway. > > Note, I just trimmed everything but your immediate message that I am > replying to. (and it is still top-posted) > > And for the record, I notice your messages frequently. They just don’t > normally require further comment. (at least not from me) > > Regards, > Adrien > > > On Jan 8, 2020 w2d8, at 11:23 AM, David Carlson < > david.carlson@gmail.com> wrote: > > > > I usually reply at the top of a message because that is the way GMail > tries > > to force me to do it. I get tired of scrolling down to see if I missed > > something, but sometimes I have to do that anyway. Years ago I tried to > > reply at the bottom, but 22 message long threads got the best of me. > > > > Maybe that is why sometimes my answers do not get the notice that I think > > they deserve. > > > > Since threading has always seemed broken in GMail to me, I would not care > > if became missing altogether. > > > > David Carlson > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Anyone noticing an issue with list messages 'un-threading'?
On Wed, Jan 8, 2020 at 11:37 AM Derek Atkins wrote: > David, > > On Wed, January 8, 2020 12:23 pm, David Carlson wrote: > > I usually reply at the top of a message because that is the way GMail > > tries > > to force me to do it. I get tired of scrolling down to see if I missed > > something, but sometimes I have to do that anyway. Years ago I tried to > > reply at the bottom, but 22 message long threads got the best of me. > > > > Maybe that is why sometimes my answers do not get the notice that I think > > they deserve. > > Replying at the bottom encourages people to trim replies :) > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > > Derek, I saw your reply clearly! However, trimming takes a lot of time too, and the way Gmail reconstructs messages makes it is terribly inefficient. This message wasn't too bad. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Anyone noticing an issue with list messages 'un-threading'?
I usually reply at the top of a message because that is the way GMail tries to force me to do it. I get tired of scrolling down to see if I missed something, but sometimes I have to do that anyway. Years ago I tried to reply at the bottom, but 22 message long threads got the best of me. Maybe that is why sometimes my answers do not get the notice that I think they deserve. Since threading has always seemed broken in GMail to me, I would not care if became missing altogether. David Carlson On Wed, Jan 8, 2020 at 10:38 AM Colin Law wrote: > The odd thing is that it started happening recently, so something > changed somewhere, and I have not seen the issue in any other lists. > > Colin > > On Wed, 8 Jan 2020 at 15:15, Fred Bone wrote: > > > > On 08 January 2020 at 0:13, Adrien Monteleone said: > > > > > David, > > > > > > It’s quite all right. I think it was just noticed first that some of > > > your replies were un-threaded. But as I noted also, this isn’t isolated > > > to just you. (and Derek might be on to something with the Android > angle) > > > > > > I guess we’ll see if changing Android clients ’solves’ the problem > > > from your end. That will be an interesting test. > > > > Whether it fixes the problem will depend partly on which client he > > switches to; and it isn't specific to any one operating system anyway. > > > > Generally, > > 1. Threading depends on the In-Reply-To: header, which should contain the > > data from the Message-ID: header in the message being replied to. > > 2. Some email clients fail to supply this header (when formatting the > > reply), in which case the threading is broken. > > 3. If you receive the plaintext (rather than MIME) digest, there is > > nowhere for the Message-ID: headers of the digested messages to go, so no > > mail client is going to be able to maintain threading. > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Anyone noticing an issue with list messages 'un-threading'?
I am also seeing it recently in my GMail client, but it is not every message, or even messages identifiable by any pattern that I can see. Since I have often seen Google change how things work without warning, I am not overly surprised. Those who are annoyed should complain to them about it. On Tue, Jan 7, 2020 at 3:57 PM David Cousens wrote: > Adrien, > > Also experiencing the same issue when using Evolution as the mail client on > Linux Mint. I mainly use the Nabble interface to reply to emails but also > have them coming up in my email server (usually not threaded but it is an > option) to alert me when new messages are posted and the threads are > disassociated . It may be that posts from particular mail clients cause > this > rather than the receiving client. The list server doesn't seem to recognize > the subject and associate it with previous use of the same subject for some > reason. Tends to suggest that some users mail clients may be subtly > altering > the subject content in an unexpected way. > > David Cousens > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to Handle Managed Securities Accounts in GnuCash
There used to be a section in one of the help manuals about tracking the value of fixed investments such as art. I am not near my computer so I am working from memory. You could create such an asset for that account and then update it's value quarterly or less as you please, following the statements you receive. Obviously, this would not provide tax information, but you are probably already using the tax info from your investment manager. David Carlson On Tue, Jan 7, 2020, 5:00 AM rsbrux via gnucash-user < gnucash-user@gnucash.org> wrote: > I have a couple of managed securities accounts which typically have a lot > of > transactions involving switching in and out of proprietary ETFs for which > public quotes are not readily available. > I am tired of trying to keep track of all of these transactions in GnuCash. > I would be grateful for any suggestions as to handle these accounts with > less (manual) effort. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up Gnucash for Household
Malcolm, If you're intent is to keep detailed tax records for your business, it is probably better to keep those in separate files. Ask your accountant about that. For casual personal purposes, including managing bank account balances to avoid overdraft s, it would be easier to have one data file with as many bank accounts, credit card accounts, etc. as you need. David Carlson On Sun, Jan 5, 2020, 9:28 PM gnucash--- via gnucash-user < gnucash-user@gnucash.org> wrote: > I want to use gnucash for tracking income and spending for my wife and I. > I'd like some rudimentary advice on setting up gnucash. > > Our bank allows us to set up sub-accounts, so we have ended up with four > accounts: a cheque account which is used by both of us for day to day > expenses; a "web saving" account which will attract a very small amount of > interest when money is stored there; my wife has an account for her > business use; and I also have an account for my business use. We transfer > money between these accounts as required. > > It seems as though we should have separate gnucash file for each of these > accounts. If so, how do we handle the transfers between them? If it isn't > necessary to have separate files for each account, how do I set up? > > thanks, > > Malcolm > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Chaning left sidebar spacing
Bummer. I would call that a bug. On Sat, Jan 4, 2020 at 4:25 PM Jack Slater wrote: > It does not. > > On Sat, Jan 4, 2020 at 3:58 PM David Carlson > wrote: > >> Generally, to make register defaults per account stick, you need to close >> the GnuCash program, just saving the file will not save register settings. >> I do not know if that also applies to the date column. It may not. >> >> David Carlson >> >> On Sat, Jan 4, 2020 at 2:49 PM Jack Slater >> wrote: >> >>> OK thank you! I'll try that out. >>> >>> On Sat, Jan 4, 2020 at 2:35 PM Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> >>> > That is something entirely different. >>> > >>> > There are threads about this issue, though I’m not sure what the >>> situation >>> > currently is on Win10. There might also be a bug filed on it already. >>> As >>> > far as I am aware, the registers *should* remember your column width >>> > settings. >>> > >>> > If not, a temporary work around is: >>> > >>> > 1 - don’t shut down GnuCash >>> > 2 - don’t close the registers you are interested in before shutting >>> down. >>> > (they will be re-opened on the next start, and *might* retain your >>> custom >>> > width) >>> > >>> > Otherwise, it is likely something the devs will have to fix. You can’t >>> > adjust this with a custom CSS file. (that I am aware of, others may >>> have >>> > found out how) >>> > >>> > Regards, >>> > Adrien >>> > >>> > > On Jan 4, 2020 w1d4, at 2:27 PM, Jack Slater >> > >>> > wrote: >>> > > >>> > > I'm getting in on this thread late and not sure if my question is >>> > related or not. >>> > > >>> > > Latest GC on Win 10. I resize the left column (date) to a wider >>> width. >>> > When I close and reopen, its back to original width. Nuisance having >>> to >>> > resize every time. Can I resize once and then save that format? >>> > > >>> > >>> > >>> > ___ >>> > gnucash-user mailing list >>> > gnucash-user@gnucash.org >>> > To update your subscription preferences or to unsubscribe: >>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> > If you are using Nabble or Gmane, please see >>> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> > - >>> > 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 >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> >> >> -- >> David Carlson >> > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Chaning left sidebar spacing
Generally, to make register defaults per account stick, you need to close the GnuCash program, just saving the file will not save register settings. I do not know if that also applies to the date column. It may not. David Carlson On Sat, Jan 4, 2020 at 2:49 PM Jack Slater wrote: > OK thank you! I'll try that out. > > On Sat, Jan 4, 2020 at 2:35 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > That is something entirely different. > > > > There are threads about this issue, though I’m not sure what the > situation > > currently is on Win10. There might also be a bug filed on it already. As > > far as I am aware, the registers *should* remember your column width > > settings. > > > > If not, a temporary work around is: > > > > 1 - don’t shut down GnuCash > > 2 - don’t close the registers you are interested in before shutting down. > > (they will be re-opened on the next start, and *might* retain your custom > > width) > > > > Otherwise, it is likely something the devs will have to fix. You can’t > > adjust this with a custom CSS file. (that I am aware of, others may have > > found out how) > > > > Regards, > > Adrien > > > > > On Jan 4, 2020 w1d4, at 2:27 PM, Jack Slater > > wrote: > > > > > > I'm getting in on this thread late and not sure if my question is > > related or not. > > > > > > Latest GC on Win 10. I resize the left column (date) to a wider width. > > When I close and reopen, its back to original width. Nuisance having to > > resize every time. Can I resize once and then save that format? > > > > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] subaccounts tabs vs windows
So, how do all these computers change preferences and/or settings when programs are updated? It seems that Android phones in particular do that a lot. David Carlson On Wed, Jan 1, 2020 at 7:03 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Nope, it’s a preference: > > Preferences > Register Defaults > Other Defaults > Register opens in a new > window. > > Un-check it. > > Regards, > Adrien > > > On Jan 1, 2020 w1d1, at 6:36 PM, Phil Reynolds > wrote: > > > > Hi Folks, > > New to the list with this msg > > > > Win 10, 3.8 > > All subaccounts open in a new window, not a tab > > > > Reverted to 3.3 ... no help. Switch is in data not program > > > > Thanks, ptf > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] v3.8
Finbar, Each release announcement is accompanied by a list of fixes and a list of remaining bugs that the developers believe may be important to some users. Those lists are best estimates and more issues may appear when the release reaches a wider audience. It is then up to the user to estimate and compare the risk of adopting that release or waiting for the next release, not knowing whether his or her 'showstopper' bug will be fixed by then. Most 'bugs' can be worked around somehow, but is that ok for you? The developers also try to keep a path open for users to revert to an older release if they have a problem with the current release. This last release illustrates how difficult that can be when circumstances outside of their control get in the way, as the situation with AQBanking in Germany made both the new and the old releases fail in one way or another. David Carlson On Wed, Jan 1, 2020 at 3:46 PM David Cousens wrote: > Finbar, > > GnuCash is not generally altered between the stable releases unless you > are using the "master" or "maint" branches from > the Github repository to build GnuCash. > > If you are using the release tarball or a release version from the website > or made available via a Linux distribution it > will not change until the next release. The minor release e.g. > 3.0->3.1->3.2->3.3->3.4->... are usually bug fixes. The > major bugs which are show stoppers if any are likely to be fixed in the > first minor release after the major,i.e. 3.0 > release but they are hopefully found in prerelease testing. The bug fixes > are unlikely to affect the core functionality > and are mainly convenience features. The major release e.g 2.x.y->3.0 are > often where major changes have been made in > the code and unforseen bugs might be introduced. This is perhaps where a > less confident user should delay going to the > new version. With the 2.x.y->3.0 transition by the release of v3.2 Gnucash > was pretty well usable by the majority of > users. GnuCash is generally sufficiently flexible in its approach that a > workaround any problem is likely to be > available. > > I have used each version in the V3.x series within a day or two of its > release and have never encountered any major > functionality problems in the accounting core of GnuCash. I have an > accounting background and some programming > experience which gives me the confidence I can survive any problems. I > also backup my data files before installing a new > release and mark them with the release they pertain to so I can go back if > necessary but I have never had to do so. > Occasionally there are problems you have to work around with display and > reports etc and occasionally problems where > changes in the user file locations occurred but these are generally > resolved within a few days with either a workaround > or a patched release. GnuCash has a unit testing program in place which > is designed to detect any major bugs affecting > the core accounting functionality which helps to minimize major bugs even > on a 2->3 transition. > > I think it is hard to define at which point a minor release version is > stable enough for all users and there is no way > the developers can absolutely guarantee that that is the case. If you are > a business user and your livelihood depends on > your bookkeeping you are going to be less tolerant of minor bugs which > interfere with your workflow but not the core > accounting. I'm retired so my accounting is optional in many ways so if > it stuffs up I can afford the time to go back > and sort it out. The nature of the queries and the replies in the User > mailing list is often the best indicator. When > they drop off in frequency and users problems are being resolved quickly > and most relate to cosmetic features is usually > the point where a new release is usable by a majority of the user base. > > > > On Wed, 2020-01-01 at 12:30 +0100, Finbar Mahon wrote: > > I very much appreciate, and depend a lot on, Gnucash. But could I make a > > small recommendation? > > > > When a new version is launched would it be possible to announce when It > > works for 'ordinary' users? > > > > I have no trouble waiting until it is 'clean' > > > > HYN 2020 to all. > > > > Finbar > > > > On 01/01/2020 00:34, David Cousens via gnucash-user wrote: > > > It should but you will have to install all the dependencies and their > > > development headers to build successfully. There is a breakout page > from the > > > building instruction which gives you the dependencies to install. > (There are > > > occasionally some that are not covered as it depends on what the > particular &g
[GNC] OFX/qfx Downloads from American Express
It seems that American Express and Intuit software are colluding on a new method of downloading ofx/qfx format files from American Express. They have changed the format so that, according to their website, one needs to Deactivate Online Banking Services for a Quicken Account, then Reactivate Online Banking Services for a Quicken Account in order to get a clean download. Since we do not have Quicken accounts, this will probably fail for us. It appears that this process will probably spread to all financial institutions that support qfx downloads via a license with Intuit software. American Express also supports CSV format, so I am now trying that method. If others have run into this problem and found a solution to make ofx/qfx work with this new interference, please post your experience here. I have noticed that while CSV is short for Comma Separated Values, many CSV files use a different separator, and some require text to be enclosed with quotes. Fortunately, the GnuCash CSV importer tolerates these anomalies. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 keeps crashing with Online Banking Setup Wizard
Online banking and OFX downloads are two completely different things. Very few users in the US, at least, are having good luck with online banking. I have seen some reports that the developers are not getting the help they need to debug the issues they are finding. However, OFX imports are usually successful. There may be a few financial institutions that are building bad files, but I have good luck with all the banks I use. I do import American Express OFX files, although the last one was in October, as I did not have enough transactions after that to be worth downloading. I am still using GnuCash 2.6.19, which is out of date, but I don't think that feature is broken in 3.7 or 3.8. David Carlson On Tue, Dec 31, 2019 at 4:53 PM Traveler12 wrote: > Same problem here, and not getting any answers, either. gnucash won't work > with Chase or Amex OFX downloads. > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Total Debt/Credit in Register Report
Welcome to GnuCash! You need to read the help manuals when you want to learn about how the program works. It strictly follows double entry bookkeeping rules, which sometimes seems confusing to newcomers familiar with some of the other programs such as Quicken. Once you have digested the section of the manual that applies to some aspect of the program you can ask specific questions, but 'not correct' is way too vague. In fact, it is correct, so you are missing something, but we cannot tell from that description what it might be. David Carlson On Fri, Dec 27, 2019 at 10:34 AM ceandyek laedon via gnucash-user < gnucash-user@gnucash.org> wrote: > I experiment further, I find out the "running balance" are not correct if > transactions contain multiple debits/credits. > Any advice is appreciated. > > Thanks > > Ceandyek > On Thursday, December 26, 2019, 9:19:38 PM EST, ceandyek laedon via > gnucash-user wrote: > > I notice that if transactions contain multiple debits and credits, the > total debit and total credit calculations in > the Register report is not correct (the same scenario shows with the > running balance). > > Please advise. > > Thanks > > Ceandyek > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Recommendation on how to close a GnuCash Account
Alan, A very simple method that I use is to append the word - Closed to the account name. If you want, you could also change the account to read only. David Carlson On Fri, Dec 20, 2019, 10:17 AM Alan A Holmes wrote: > I'm currently closing a couple of Savings accounts and moving them to other > banks to get a better rate on interest. > > > > In GnuCash I've created new accounts in Assets and transferred things > across > from the old accounts to the new accounts. That's no problem. > > > > I'd now like to "mark" the GnuCash" accounts as being closed so that I > don't > accidentally use them again in the future. Any recommendations or > suggestions on the best way to do this please? > > > > > > Alan A Holmes > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Find Transaction Dialog Box, v3.7, ubuntu 18.04.3, Problem
Michael, I think you want to use the Tweaks tool to mess with fonts in recent Ubuntu releases. You also probably need to make things smaller rather than larger. Play creatively! David Carlson On Thu, Dec 19, 2019 at 10:55 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Check the list archives from earlier this month or November. There is a > thread on this containing a fix for the interim until the next version is > released. (around the end of the year) > > Sorry I don’t recall the fix explicitly off-hand. Perhaps someone who does > can chime in if you can’t find it. > > Regards, > Adrien > > > On Dec 19, 2019 w51d353, at 10:48 AM, Michael A. Koerber < > makoerb...@gmail.com> wrote: > > > > Just upgraded gnucash from v2.6 to v3.7 (and upgraded ubuntu). > > > > The geometry of the Find Transaction dialog box makes it virtually > > impossible to enter a search. See below image. I can't find a way to > > make text input boxes large enough to use. Can anyone help with > > this? (I've tried to uninstall/reinstall with no improvements.) > > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Multiple-Select during QFX import
I really shouldn't reply because I cannot test my suggestion, but reading the reference that you kindly provided, if this feature is fully supported in release 3.4, the directions provided there should work. Are you running Buster or Stretch? David Carlson On Tue, Dec 17, 2019 at 11:37 AM Mike stagl wrote: > I am trying to get started with the QFX import feature of GnuCash. > > According to 6.15.5.2 of: > > https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#trans- > import-matcher > <https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#trans-import-matcher> > > I should be able to select multiple items in the import matcher. I > cannot seem to do so. Is this a feature of a later version of GnuCash? > I have tried all combinations I can think of with mouse buttons with > and withou CTRL and SHIFT keys. > > I am running 3.4 on Debian Linux. > > The screen I am attempting this on is titled "Generic import > transaction matcher." > > Thank to all the contributors! > > Mike > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
That tidbit of information may be useful to the developers. David Carlson On Sun, Dec 15, 2019 at 12:12 PM Axel Essbaum wrote: > > Restarting GC with open invoices results in all date fields collapsing to > the original too-narrow width. > > This is why I try to avoid closing GC (I typically have 30+ invoices open). > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > On 15 Dec 2019, at 18:38, David Carlson > wrote: > > Oops, Be sure to leave the invoice open with the resized date field when > you close GnuCash. > > On Sun, Dec 15, 2019, 11:34 AM David Carlson > wrote: > >> Axel, >> >> Try resizing the date field in one invoice, then close GnuCash >> altogether. Reopen GnuCash and reopen that invoice. >> >> You may get different results if you follow that procedure. >> >> David Carlson >> >> On Sun, Dec 15, 2019, 2:31 AM Axel Essbaum wrote: >> >>> >>> Updated to 3.7. Date field issue did not change. Calendar button still >>> pushes date off the left and double-click still collapses date field even >>> further. And date field with is still not remembered if the invoice tab is >>> closed and reopened. >>> >>> - Axel >>> >>> — >>> Axel Essbaum >>> a...@essbaum.com >>> >>> >>> >>> > On 14 Dec 2019, at 19:07, Adrien Monteleone < >>> adrien.montele...@lusfiber.net> wrote: >>> > >>> > Hmm... I didn’t notice this back when I was using 3.6 but it might >>> have happened for me as well. >>> > >>> > I’m presently on 3.7 and I’ve since upgraded to Catalina. >>> > >>> > Perhaps try 3.7 on Mojave and see if the problem is resolved. (3.7 was >>> released in September, and another is on the way at the end of this month) >>> > >>> > Regards, >>> > Adrien >>> > >>> >> On Dec 14, 2019 w50d348, at 11:13 AM, Axel Essbaum >>> wrote: >>> >> >>> >> >>> >> Manually widening the date field applies only to that invoice, and >>> only as long as the invoice's tab is open. If I close the invoice's tab and >>> reopen I get a narrow date fields again. Creating a new invoice also >>> results in a narrow date field. As far as I can tell no adjustment to >>> field widths is carried forward to subsequent invoices. >>> >> >>> >> Date order has no effect - MDY is also chopped off for me. >>> >> >>> >> I'm on macOS Mojave, GC 3.6 - Build ID: 3.6+(2019-06-29) >>> >> >>> >> - Axel >>> > >>> > ___ >>> > gnucash-user mailing list >>> > gnucash-user@gnucash.org >>> > To update your subscription preferences or to unsubscribe: >>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> > If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> > - >>> > 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 >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
Oops, Be sure to leave the invoice open with the resized date field when you close GnuCash. On Sun, Dec 15, 2019, 11:34 AM David Carlson wrote: > Axel, > > Try resizing the date field in one invoice, then close GnuCash > altogether. Reopen GnuCash and reopen that invoice. > > You may get different results if you follow that procedure. > > David Carlson > > On Sun, Dec 15, 2019, 2:31 AM Axel Essbaum wrote: > >> >> Updated to 3.7. Date field issue did not change. Calendar button still >> pushes date off the left and double-click still collapses date field even >> further. And date field with is still not remembered if the invoice tab is >> closed and reopened. >> >> - Axel >> >> — >> Axel Essbaum >> a...@essbaum.com >> >> >> >> > On 14 Dec 2019, at 19:07, Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> > >> > Hmm... I didn’t notice this back when I was using 3.6 but it might have >> happened for me as well. >> > >> > I’m presently on 3.7 and I’ve since upgraded to Catalina. >> > >> > Perhaps try 3.7 on Mojave and see if the problem is resolved. (3.7 was >> released in September, and another is on the way at the end of this month) >> > >> > Regards, >> > Adrien >> > >> >> On Dec 14, 2019 w50d348, at 11:13 AM, Axel Essbaum >> wrote: >> >> >> >> >> >> Manually widening the date field applies only to that invoice, and >> only as long as the invoice's tab is open. If I close the invoice's tab and >> reopen I get a narrow date fields again. Creating a new invoice also >> results in a narrow date field. As far as I can tell no adjustment to >> field widths is carried forward to subsequent invoices. >> >> >> >> Date order has no effect - MDY is also chopped off for me. >> >> >> >> I'm on macOS Mojave, GC 3.6 - Build ID: 3.6+(2019-06-29) >> >> >> >> - Axel >> > >> > ___ >> > gnucash-user mailing list >> > gnucash-user@gnucash.org >> > To update your subscription preferences or to unsubscribe: >> > https://lists.gnucash.org/mailman/listinfo/gnucash-user >> > If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> > - >> > 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 >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
Axel, Try resizing the date field in one invoice, then close GnuCash altogether. Reopen GnuCash and reopen that invoice. You may get different results if you follow that procedure. David Carlson On Sun, Dec 15, 2019, 2:31 AM Axel Essbaum wrote: > > Updated to 3.7. Date field issue did not change. Calendar button still > pushes date off the left and double-click still collapses date field even > further. And date field with is still not remembered if the invoice tab is > closed and reopened. > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > > On 14 Dec 2019, at 19:07, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > Hmm... I didn’t notice this back when I was using 3.6 but it might have > happened for me as well. > > > > I’m presently on 3.7 and I’ve since upgraded to Catalina. > > > > Perhaps try 3.7 on Mojave and see if the problem is resolved. (3.7 was > released in September, and another is on the way at the end of this month) > > > > Regards, > > Adrien > > > >> On Dec 14, 2019 w50d348, at 11:13 AM, Axel Essbaum > wrote: > >> > >> > >> Manually widening the date field applies only to that invoice, and only > as long as the invoice's tab is open. If I close the invoice's tab and > reopen I get a narrow date fields again. Creating a new invoice also > results in a narrow date field. As far as I can tell no adjustment to > field widths is carried forward to subsequent invoices. > >> > >> Date order has no effect - MDY is also chopped off for me. > >> > >> I'm on macOS Mojave, GC 3.6 - Build ID: 3.6+(2019-06-29) > >> > >> - Axel > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
David H, you have a good memory. I found < https://bugs.gnucash.org/show_bug.cgi?id=796736> which shows the same problem with the date. However, the penultimate comment by John Ralls states that when the size is manually set it should stick for subsequent use. I personally have found that it is necessary to also manually click on the File > Save button to really make such changes stick. If there has been an auto save somewhere along the line so that it is impossible to do a manual save, then it may be lost. I thought I had filed a bug report for that but now I cannot find it. David Carlson On Sat, Dec 14, 2019 at 4:44 PM David H wrote: > I don't use any of the business features/invoices either but this is the > default behaviour in normal account register windows on Win 10 as well. I > get around it by manually widening all date columns to allow for the drop > down arrow when the date is highlighted. If I double click the header to > autosize it the days are dropped off and instead of seeing 15/12/2019 > (dd/mm/ccyy) and the drop down arrow I get /12/2019. I thought there'd been > a bug/enhancement report raised a couple of years back to fix this > behaviour but I could be wrong. > > Cheers Dave H. > > > On Sun, 15 Dec 2019 at 04:11, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Hmm... I didn’t notice this back when I was using 3.6 but it might have > > happened for me as well. > > > > I’m presently on 3.7 and I’ve since upgraded to Catalina. > > > > Perhaps try 3.7 on Mojave and see if the problem is resolved. (3.7 was > > released in September, and another is on the way at the end of this > month) > > > > Regards, > > Adrien > > > > > On Dec 14, 2019 w50d348, at 11:13 AM, Axel Essbaum > > wrote: > > > > > > > > > Manually widening the date field applies only to that invoice, and only > > as long as the invoice's tab is open. If I close the invoice's tab and > > reopen I get a narrow date fields again. Creating a new invoice also > > results in a narrow date field. As far as I can tell no adjustment to > > field widths is carried forward to subsequent invoices. > > > > > > Date order has no effect - MDY is also chopped off for me. > > > > > > I'm on macOS Mojave, GC 3.6 - Build ID: 3.6+(2019-06-29) > > > > > > - Axel > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
When I asked about date format I was mainly fishing for more details about when and how this happens. I too have changing widths but I see that mostly when I copy the GCM stuff from one machine to another with a different display size, so I write it off to that, where it would be expected. David Carlson On Sat, Dec 14, 2019 at 11:46 AM D via gnucash-user < gnucash-user@gnucash.org> wrote: > Why would the format of the date have any effect on this? Whether it is > 12/12/2019 or 12/12/2019, the sequence of elements is immaterial. > > I should clarify that I see this in the registers, not invoices. I should > also say that it appears to me that the column width gets set, and then the > drop down widget gets super imposed on the column, pushing data off screen. > I have seen similar behavior in other apps, though, so I have always > chalked it up to an annoying but unavoidable behavior. > > David > > On December 14, 2019, at 10:38 PM, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > Ah, now I understand. > > Curious that it doesn’t show the entire first part of the date by default. > (it does for me) > > If you manually make the column wide enough to show the full date, (drag > the right-hand header divider to the right) and then post that invoice, > does the next new invoice carry over that width or does it default back to > truncating? > > Like David C., I’m also curious to know if MDY instead of DMY order has > any effect for you. (I use MDY) That would help narrow down the cause. > > Regards, > Adrien > > > On Dec 14, 2019 w50d348, at 7:48 AM, Axel Essbaum > wrote: > > > > > > What is the date for the bottom line (the line with the widget) in the > image? It appears to be 1.12.19 but it's actually 11.12.19 (the first "1" > is chopped off and not visible). > > > > - Axel > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
Now we making some progress! Since I do not use invoices and I am also living in the past on release 2.6.19 in Linux, my experience is not germane, but I will note that I see a tendency in regular account register windows for the date fields (and the three amount fields) to change width from week to week, tho they usually get wider, and I have not identified a pattern other than the fact that it happens in a VirtualBox machine that also seems to change it's size from time to time when it is re-booted. David Carlson On Sat, Dec 14, 2019 at 11:15 AM Axel Essbaum wrote: > > Manually widening the date field applies only to that invoice, and only as > long as the invoice's tab is open. If I close the invoice's tab and reopen > I get a narrow date fields again. Creating a new invoice also results in a > narrow date field. As far as I can tell no adjustment to field widths is > carried forward to subsequent invoices. > > Date order has no effect - MDY is also chopped off for me. > > I'm on macOS Mojave, GC 3.6 - Build ID: 3.6+(2019-06-29) > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > > On 14 Dec 2019, at 18:07, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > Ah, now I understand. > > > > Curious that it doesn’t show the entire first part of the date by > default. (it does for me) > > > > If you manually make the column wide enough to show the full date, (drag > the right-hand header divider to the right) and then post that invoice, > does the next new invoice carry over that width or does it default back to > truncating? > > > > Like David C., I’m also curious to know if MDY instead of DMY order has > any effect for you. (I use MDY) That would help narrow down the cause. > > > > Regards, > > Adrien > > > >> On Dec 14, 2019 w50d348, at 7:48 AM, Axel Essbaum > wrote: > >> > >> > >> What is the date for the bottom line (the line with the widget) in the > image? It appears to be 1.12.19 but it's actually 11.12.19 (the first "1" > is chopped off and not visible). > >> > >> - Axel > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
David T, Since you are seeing the same issue as Axel, I have to ask: Do you use a Day/Month/Year date format or Month/Day/Year? Does that make a difference? and for both David and Axel, When invoices are printed, are the printouts also cut off? There has been a lot of discussion here but so far, no action to define a basis for a bug report, which appears to be sorely needed. David Carlson David Carlson On Sat, Dec 14, 2019 at 7:51 AM Axel Essbaum wrote: > > What is the date for the bottom line (the line with the widget) in the > image? It appears to be 1.12.19 but it's actually 11.12.19 (the first "1" > is chopped off and not visible). > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > > On 14 Dec 2019, at 14:10, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > > If the first image is the default, (as it is for me) what is the > problem? Every part of the date is visible even with the widget. > > > > Regards, > > Adrien > > > >> On Dec 14, 2019 w50d348, at 2:37 AM, Axel Essbaum > wrote: > >> > >> > >> When I double-click the date header the date field shrinks to the width > of the date text (xx.xx.), which is actually worse than how it started. > >> > >> First image is how the date field is sized when I create an invoice > >> > >> http://essbaum.com/images/GC_before.png > >> After date field double click: > >> > >> http://essbaum.com/images/GC_after.png > >> > >> :-( > >> > >> - Axel > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Edit Cut and Copy greyed out
Tony and John; I don't think that it has ever been possible to Edit > Copy or Edit > Cut a full split line of a complex multi-split transaction from under the Edit > menu item. However, under the Transaction > menu copy, cut paste, duplicate and more are listed, and I think they all work fine. David Carlson On Fri, Dec 13, 2019 at 11:30 AM Tony Vanson wrote: > No John, v 3.7 has been going fine ever since I installed it a few days > after it was released as an update from 3.6. I suspect it may have > something to do with the slew of Windows updates lately but I cannot > specifically put my finger on anything as Cut and Copy works OK on all > other apps. Maybe a reinstall of GNUcash may be worth while? > Cheers > > On Fri, Dec 13, 2019 at 11:48 PM John Ralls wrote: > > > > > > > > On Dec 13, 2019, at 8:16 AM, Tony Vanson wrote: > > > > > > Hi All, > > > A problem that's just occurred in the last couple of days is that I can > > no > > > longer *Copy* or *Cut* a full line account item as both the *Cut* and > > > *Paste* in the *Edit* tab are greyed out and therefore unusable, > however > > > *Duplicate* works OK. > > > I am using Windows 10 and GNUcash V 3.7. > > > I can select part of the line item at which time Cut and Copy become > > > available. > > > Is this a deliberate change or am I missing something? > > > > It's not intentional. Did you install 3.7 in the last couple of days and > > see the change once you did? If so, do you know what version did you have > > installed before? > > > > If not, what else might have changed recently on your system? > > > > Regards, > > John Ralls > > > > > > -- > *Tony Vanson* > > *The older I get,* > *the better I was* > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Enhanced Jump feature proposal
I finally got around to writing up a specification for an enhanced jump feature that would allow jumping to transactions with transfer accounts not only to the transaction in the transfer account's home account windows, but to the same transaction in currently open special windows such as the journal window or search windows. At the same time it would also add a capability to extend the feature to work in many cases where the curser is not already sitting on a transfer split line in a transaction register. If anyone cares to review the specification an comment on it it is https://bugs.gnucash.org/show_bug.cgi?id=797523. When I was researching this bug I found several variations of enhancement requests to add a feature to go directly to today's date in the current account register. One of them is https://bugs.gnucash.org/show_bug.cgi?id=588836. I suggest that these be consolidated. Finally, I am considering further enhancing the go to today enhancement to allow going to an arbitrary date. If there is interest in that, I will post an appropriate enhancement request. -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
My experience is limited to register displays in releases up to 2.6.19, so I do not expect details to be identical. GnuCash uses variable width fonts so the digit one is less wide than other digits. Any date with a one in it is less wide than other dates, and about a third of all dates have single digit day numbers, a third have the digit one with another digit, and a third have the digit two or three with another digit. Two digit year formats are also less wide. I think the Gnome graphic renderer counts pixels when deciding how wide a string actually is . So GnuCash actually has no control over that anyway. David Carlson On Thu, Dec 12, 2019, 1:46 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Dec 12, 2019 w50d346, at 1:35 PM, David Carlson < > david.carlson@gmail.com> wrote: > > > > How would the code know how wide the entire date is when it may take > months to see a date with all wide digits when only selected dates appear. > Date field also randomly expands when that pesky calendar widget appears. > > Not sure what you mean by ‘wide digits’. > > I always see four digits for the year and 2 for both month and day. I > can’t even find a setting to change that. (in GnuCash or in MacOS) > > But my guess would be that it would either check or store the size of the > displayed date. How does it know how to size the column now when you double > click? Certainly it either knows or checks the size of the content. > > Yes, invoices are different. The widget overlays the date, it doesn’t > cause the column to grow. If you want to see the whole date with the > overlay, you have to manually resize the column, but then you get padding > in that column which may generate a scroll bar. > > I don’t think anything in this thread is concerning registers or any > suggestions to change how they work. The topic was about invoices. > > Regards, > Adrien > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
How would the code know how wide the entire date is when it may take months to see a date with all wide digits when only selected dates appear. Date field also randomly expands when that pesky calendar widget appears. Value fields at least seem to get properly fitted and. Stay fitted for a long time. Also, maybe invoices follow different style rules than registers. I don't use them so I don't know about that. David Carlson On Thu, Dec 12, 2019, 11:29 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I just tested this on a new invoice. Sure enough, the column does shrink > to fit, but it doesn’t take into account the down arrow calendar widget > which overlays the date. > > This is a tough design choice. > > Should the widget have forced padding? If so, then people with not as wide > screens will complain that they get horizontal scroll bars and don’t want > to have to adjust their Description column each time. > > Should the widget overlay the date? Then it might hide part of the date if > the column is not wide enough. > > I think the current approach is sane - the column *should* be wide enough > by default so that the widget does not cover any part of the date. If not, > maybe you accidentally shrunk it on a previous invoice. Also, the widget > only shows for the currently focused date field. Tab off it and the widget > should disappear. > > The only ‘flaw’ might be that the double-click on the header doesn’t > factor in the widget, but again, the user might intend to make the column > tight enough to hold just the date, with no widget padding. The only way > around this conundrum might be to overlay the widget into the column to the > right. But there again, I’m sure someone will take exception. > > Regards, > Adrien > > > On Dec 12, 2019 w50d346, at 10:12 AM, Axel Essbaum > wrote: > > > > > > Hi Greg, > > > > Thanks for the suggestion. Double-clicking on the date header collapses > the column even further, so that the entire day part of the date (I use > format day.month.year) on the bottom line disappears off the left side of > the screen. > > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Invoice date field starts too narrow
Axel, Your attachment did not make it as far as my inbox, but your description is very clear to me. However, I am not a developer, and I do not have any experience to offer suggestions for your issue with GnuCash. I do not know if it is an issue that is an artifact of the fact that your date format is not the U.S default, for example. Good luck. David Carlson On Thu, Dec 12, 2019 at 1:46 AM Axel Essbaum wrote: > > Trying again with attachment at the very end. > > GC retains the column width for each invoice over the life of that > invoice. The issue is that new invoices don't inherit any of this - they > all start with a narrow date field. > > See at the bottom (I hope). I can't tell if the date of the bottom line > is 01.12.2019 or 11.12 or 21.12, etc. without clicking on the calendar > selector. So I widen the Date field, and then shrink some other field to > remove the created horizontal scrollbar. For every invoice I create. > > Thanks, > > - Axel > > — > Axel Essbaum > a...@essbaum.com > > > > > On 12 Dec 2019, at 05:17, John Ralls wrote: > > > > Axel, > > > > Also make sure they're on the end of the email after all text including > signatures. The list server eats inline attachments. > > > > GnuCash is supposed to remember things like column widths so that you > need set them only once. Is that not working for the Invoice date > column--or perhaps any invoice columns? > > > > Regards, > > John Ralls > > > > > >> On Dec 11, 2019, at 3:52 PM, Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> > >> Hi Axel > >> > >> Am Mi., 11. Dez. 2019 um 08:53 Uhr schrieb Axel Essbaum < > a...@essbaum.com>: > >>> > >>> > >>> Hi All, > >>> > >>> MacOS Mojave, GnuCash 3.6. Pictures say it all (hope this list allows > attachments!) > >> : > >> There was no attachment, neither in the mail nor on the server: > >> > https://lists.gnucash.org/pipermail/gnucash-user/2019-December/088216.html > >> > >> That might be caused by sending mails in HTML format. In text format, > >> attachments should go through. > >> > >> Regards > >> Frank > >> ___ > >> gnucash-user mailing list > >> gnucash-user@gnucash.org > >> To update your subscription preferences or to unsubscribe: > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > >> If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > >> - > >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Price Database - can't just type ticker symbol, must scroll to select
I cannot comment on why that doesn't work in release 3.7 but it sure is a handy feature in the 2.6 series that is new to me. I hope it will get fixed. David Carlson On Tue, Dec 3, 2019, 10:45 AM George Riner wrote: > I'm on Windows 10, build 1903 > running Build ID: 3.7+(2019-09-07) > Finance::Quote: 1.47 (I don't use the downloading of prices) > > I'm manually entering prices in the Price Database. Apparently, the tab > order of the fields skips over the field value and will only land on the > down arrow to the right of the field. (yes, the focus will land on the > other fields in the window, just not the value for the security > ticker/name). > > Thus, I cannot type the security symbol to have the list select it once > I type in enough unique characters. I have to use the down arrow to > open the list and scroll through it with the mouse to get to the > security I want - many of mine are at the bottom of the list - tedious. > > This used to work in 2.x series of GnuCash - I could tab to the security > symbol/name list, start typing a symbol and the list would open up and > scroll to the first matching symbol. Usually with only 3-4 characters > typed I'd be at the intended security and could press Enter and it would > select it into the Security value field, and I could tab on from there > to put in the date and price. > > :George > Sebastpol, CA > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Locked out of gnucash
If I understand, Derek, you are proposing a change to GnuCash code to improve it's behavior. Going back to the original question, which was about the confusing wording of the warning, if the code is changed, should there be warnings tailored to each of the three cases? Note: Case 1 might mean that some third party app such as a file editor may be mucking around. Is this true? Is it possible to test the PID to see if it is dead or alive? On Mon, Nov 25, 2019 at 11:47 AM Derek Atkins wrote: > Adrien Monteleone writes: > > >> Again, if user A has a data file open, user B shouldn't also open > >> the file. I don't see how a check for Gnucash instances could work > >> to prevent precisely this problem, since my machine won't have any > >> Gnucash instances running--but the file IS being used. > > > > I agree, using the PID won’t work, because although GnuCash is not > > (yet) a multi-user app, some people do use it from various machines > > with the file stored on a network. A PID check won’t mean anything to > > one machine when that PID belongs to a different machine. > > Using a "machine-name + PID" will absolutely work, because: > 1) If the machine-name is the local machine, you can check the PID and >if the PID is not gnucash, you know it was an unclean exist. > > 2) If the machine-name is the local machine, you can check the PID and >if the PID IS gnucash, you know there is another running instance. > > 3) If the machine-name is NOT the local machine, then you cannot >differentiate what's going on and should ask. Most likely it IS open, >but there's no good way to tell. > > The good news is that #1 and #2 ARE the most common use-cases today, so > we should implement that. > > > Regards, > > Adrien > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable
Thanks for the clarification. Is there a good place in the documentation for this tidbit? On Mon, Nov 25, 2019 at 9:17 AM Derek Atkins wrote: > Hi David, > > David Carlson writes: > > > Derek, > > > > If what you call a rolling balance is what I call a running balance, > then I > > think that the account register view will show that when it is sorted in > > chronological order. In fact, as others have already noted, you can see > that > > in your top level accounts. Where you won't see it is in mixed > commodity/ > > mixed currency cases such as stock brokerage accounts or other mixed > currency > > accounts. For those cases it is necessary to use a report that can > evaluate > > appropriate exchange rates. > > Yes, rolling/running balance. However, while there is a balance column > being displayed, it might not show the *correct* balance because each > split shown has a precomputed balance for the actual account it is tied > to. This balance is recomputed whenever a split in the account is > modified. However, it is NOT computed in real-time for display. > > So when you do a "Open Subaccounts" view, it is not recomputing the > balance including everything, but rather it is still showing the > pre-computed balance of the split's account balance for that split. > > It *MAY* look correct at some points in time, but in general, no, it is > not. > > > David Carlson > > -derek > > > On Mon, Nov 18, 2019, 8:22 AM Derek Atkins wrote: > > > > Rick, > > > > Richard Danielson writes: > > > > > Re the subtotals issue, I used to have a number of subtotals > > > (e.g. groceries, snacks and restaurants in the food category) which > > > showed up in income accounts. That is what I can't figure out in > GC. > > > I can make accounts sub-accounts for heading accounts, and get the > > > totals for the sub-accounts to show in the income statement, but > can't > > > get the program to sum the sub-accounts into the heading accounts. > > > > Note that a parent account will only roll up the balance in > sub-accounts > > in the CoA or Reports. If you *open* the parent account then it wont > > show the transactions (or balances) from the sub-accounts. It is > > unclear from your question how/where you are trying to view the > > rolled-up balances. > > > > There is an option to "Open Subaccounts", which will merge all the > > transactions from the subaccounts, but it wont show a rolling > balance. > > > > Hope this helps, > > > > > Rick > > > > > Please remember to CC this list on all your replies. > > > You can do this by using Reply-To-List or Reply-All. > > > > -derek > > > > -- > >Derek Atkins 617-623-3745 > >de...@ihtfp.com www.ihtfp.com > >Computer and Internet Security Consultant > > > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation
I believe one scenario that could cause a starting balance to change might be in a case that involves multiple currencies or purchases or sales of securities, if the exchange rate embedded in a reconciled transaction changes (possibly due to editing the 'other side' of a reconciled transaction). Maybe that is a stretch, or maybe not. You tell me. David Carlson On Thu, Nov 21, 2019 at 6:49 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Or if that is a warning you can turn off, the user might have done so, and > would need to use the Reset Warnings function. > > Regards, > Adrien > > > On Nov 21, 2019 w47d325, at 6:35 PM, Stephen M. Butler > wrote: > > > > On 11/21/19 4:23 PM, Jack Lockard wrote: > >> Here is what does not make any sense to me. > >> > >> When I reconciled September's statement the beginning balance in > GNUcash did not match the bank statement. I went on and completed the > reconciliation process and when finished, the closing balance in GNUcash > and the bank statement did match. For discussion purposes lets say the > closing balance was $2,200. When I initiated the reconciliation process for > October the bank statement had a starting balance of $2,200 which was the > closing balance of September's statement as it should be. However, the > starting balance shown in GNUcash was now say $3,300. How can that change > in account balance occur? > >> > >> Jack > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation
David Cousens, This would be a great time to provide details on how to follow your suggestion. Would it be sufficient to try setting previous reconcile dates into the reconcile dialog and see what values appear in the start and end balances? If there are usually no reconciled transactions in the history on the reconcile dates, this might work, else it could get more complicated. Then what? mark all following transactions as unreconciled, then re-reconcile each period again? I think the thought of trying to do that is what makes us decide to just enter some sort of adjustment and forget about fixing history. Unfortunately, that may cause errors in the running balance. I hope the spell checker didn't change any of my comments. David Carlson On Thu, Nov 21, 2019 at 4:36 PM David Cousens wrote: > Jack, > > If both the starting balance and the ending balance do not agree with the > statement being reconciled against, then the reconciliation for that period > is actually invalid. The most likely reason for this to occur is entry of a > new transaction or deletion of a previously reconciled transaction in a > prior reconciliation period but there may be more subtle problems. A > transaction being entered incorrectly with a date in the far past (mistyped > date then saved) is another common problem. These unreconciled > transactions > usually come up in the reconcilation window at the top of the panes if they > are outside the current reconciliation period. i don't know if Gnucash > places a limit on how far back it searches for unreconciled splits in the > account being reconciled though. > > The only solution is to go back to a point where the starting and ending > balances are both in agreement for the period being reconciled, then > reconcile forward again, making sure you get agreement of both balances for > each reconciliation period and fix any errors on the way through. > > > David Cousens > > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation
On Thu, Nov 21, 2019 at 3:32 PM David Cousens wrote: > David, > > Thanks for your question. > In your experience are the "pending edits" preserved if the register > containing them is closed or are the edits to the transaction discarded on > closing the register. If you try to edit a transaction in two registers > AFAIK you get a warning that the transaction is opened for editing in > another register and similarly if you try to close a register with a > pending > edit still open, you get a warning with the option to save any changes or > discard the changes. With my workflow I do not tend to have a lot of > registers open generally so I rarely encounter the pending edit situation > in > practice. > > This is the most common scenario for my usage. I start editing a multi-line split transaction in one account register then I 'jump' to another account register to see how that account is affected. The warning that appears if I try to continue editing in that account does not tell me where the pending edit is located. Then I come back from dinner and by then I have forgotten where I started from and sometimes there are six different accounts to wade through plus one or more search windows and maybe a 'with child accounts' window or general ledger window where I may have started from. I thought that I had covered this in an enhancement request asking for visual clues when a particular split line was being edited to see it from other views and have a link to navigate back to that 'home' window, but I could not find it. I have a note to myself to re-enter that request when I have time. I would also want a flag of some sort in the account tab for each account register that has a pending edit. That should catch the complex window cases. As for what happens when GnuCash crashes or the power supply dies, I am not sure, but I sometimes wonder why a transaction that I thought I edited is not correct or missing. The other issue that I mentioned in another message recently is that the automagic backup feature will save the data file and grey out the Save button yet leave pending edits in place. Then using the Save button to trigger a search for them will fail unless I have first made the file 'dirty' by committing another edit. > I have encountered them during reconciliation if I have entered a register > to correct a transaction - I very occasionally have a transaction which > might differ by 0.01 in the value recorded in my original entry and the > value appearing on a statement for example or I may have entered a > transaction incorrectly. The reconciliation process normally updates on the > fly if a transaction is edited in the register provided it is closed and > saved in the register > > If there is a pending edit in the account being reconciled, I suspect it is handled correctly, but what if there is a pending edit in one of the 'other' account split lines? > David Cousens. > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Reconciliation
It is interesting that the condition that I call 'pending edits' appears in several of the previous comments. GnuCash has allowed users to start an edit to a transaction then navigate away from the incomplete edit, leaving it out of view, and incredibly difficult to find and resolve later in some cases. There is a good reason for allowing this, but it creates difficulties when trying to 'clean up'. First, my experience is limited to using the XML format data file. I am not sure how it works with database format files. I have usually been able to find and resolve 'pending edits' by periodically clicking on the 'Save' button and watching to see if it goes without incident or if it asks about an incomplete edit somewhere. I never say yes, because more than half the time if is an artifact of some spurious keystroke somewhere that started an edit that I did not want to make, and it would introduce an error if accepted. Many cat owners have this happen on a regular basis. GnuCash only gives a vague clue about how to actually find these pending edits. It seems to me that, if it knows about a pending edit, GnuCash could provide an internal link or three to navigate directly to the specific transaction(s) in the specific register view(s) for the user to review and resolve. I have an enhancement request < https://bugs.gnucash.org/show_bug.cgi?id=793225> that covers part of this, I thought I had a more generic one, but I am having trouble finding it today. It appears that the reconciliation process is a case that can be corrupted by the existence of 'pending edits' in transactions that are being processed. If that is the case, GnuCash should test for 'pending edits' at some point and require the user to resolve them. That would require a new bug report by someone who can reproduce the problem. David Carlson On Thu, Nov 21, 2019 at 11:12 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Simply re-reconciling and checking off those transactions should be > sufficient. You just want to set the flag. > > I wouldn’t necessarily call this a bug, but perhaps file an RFE to add a > check that there are no transactions in the affected register in an > ‘editing state’ when the reconcile window opens. That would prevent this > case. Though I’m not sure how difficult that would be to implement or if it > is so rare as to instead warrant a wiki or Help entry instead. > > Regards, > Adrien > > > On Nov 21, 2019 w47d325, at 10:57 AM, Dale Alspach > wrote: > > > > Something like this has happened to me (on linux Mint, several recent > > versions of gnucash) though not exactly what you are reporting. > > I do not usually check the starting balance so it could be the same. Here > > is a description of what happens. > > > > I mark the reconciliation box for some transactions in a register and > move > > around without ever hitting enter. This seems to leave these newly marked > > transactions in an odd (uncommitted) state. Clicking Reconcile produces > the > > usual window with these transactions and previously marked transactions > > listed as cleared. I complete the reconciliation and balances agree in > the > > reconciliation window. However upon finishing the reconciliation and > > examining the register, I find that those uncommitted transaction changes > > have been lost and those transactions are not marked reconciled. This > will > > disturb the balances for the next reconciliation. > > > > My workaround is to alter the balance I enter as the statement balance by > > the sum of these incorrectly marked transactions. It could be that if I > > check that the starting balance is off by that amount. > > > > Dale > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting Multiple Transactions
Ken, Would you care to give credit to your source? Also, if you have modified it, you might note where you have changed it. David Carlson On Mon, Nov 18, 2019 at 11:04 PM wrote: > To all gnu-cash users --- found this on the net today and it was a > lifesaver. Not sure if anyone else needs it - but it was extremely helpful > for me. > > "How can I delete multiple transactions in a batch in GnuCash?" > > For me I made a copy of my current file. Then on the copy I wanted to > delete any transaction after 1/1/2018. This file now become an archive > file. Now re-open my current file. Delete any transactions in it prior to > 1/1/2018. Before deleting, make note of account balance amounts so I can > make sure I am balanced once I delete. Enter new "Opening balance amounts" > as needed to ensure balances are current and balanced. Now I have a file > with just the last 2 years transaction. Did a search on the net and found > this: > > "As a workaround I made a shortcut key for deleting transactions. I > modified > the C:\Users\username\.gnu-cash\accelerator-map file (with gnucash closed) > by changing the line > > ; (gtk_accel_path > "/GncPluginPageRegisterActions/DeleteTransactionAction" "") > > To: > > (gtk_accel_path > "/GncPluginPageRegisterActions/DeleteTransactionAction" > > "Delete") > > Now I could delete transactions by pressing ctrl+delete. Pressing and > holding this key combination allowed continuous deleting at a predictable > rate so it was quite easy to delete a few hundred transactions quickly. > > Might not be the best solution if you have many thousands of transactions > that you want to delete but for a few hundred it was quite painless. > > As a follow-up to this very useful info, on a Windows PC, the file is > located in: > > C:\Users\UserName\AppData\Roaming\GnuCash\accelerator-map > > The way the edited line is displayed in the above answer is correct but it > may not be immediately obvious to everyone that like some other languages, > the semicolon needs to be removed as well. The semicolon is a comment tag > that disables the line it is on. > > Notes: > > is the same as "Command" on macs and "Ctrl" on Windows. Other > modifiers are and and they can be combined so to make it a > bit > more difficult to do accidentally, my new line is: > > (gtk_accel_path > "/GncPluginPageRegisterActions/DeleteTransactionAction" > "Delete") > > AKA: Control + Shift + Delete > > I presume it was the same in earlier versions but I am new to GNUcash so > it's also useful to note that, at least as of GNUcash 3.5, this keyboard > shortcut triggers the Yes/No dialog to confirm that the transaction should > be deleted. Additionally, you can select to ignore the dialog for the rest > of the session or never show the dialog. " > > This works in 3.7 (what I am using) for Windows. If you need or want to > delete multiple transactions - this is very handy. Thanks to all. > > One last comment - I am not sure if this will work when I upgrade to the > next version - or even if I shutdown Gnu-cash and re-open it. But > nevertheless, it is an easy fix for when I want to use the functionality of > deleting multiple transactions. > > Ken > > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Removing Orphan components from transaction
On Mon, Nov 18, 2019 at 10:50 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > > > > On Nov 17, 2019 w47d321, at 11:14 PM, Peter West wrote: > > > > I found a transaction in Orphan-AUD. It was a split, and the Orphan > component was zero. Maybe I had forgotten part of the split, and then > corrected it, leaving nothing in the Orphan-AUD account. > > > > I wanted to remove this transaction from Orphan-AUD. As I recall, I > tried to remove the Orphan line from the copy of the transaction under the > Orphan-AUD tab. Uh-uh. Something about the anchoring to another account. > > You can’t delete a split that is for the account in the current register. > (that is what anchors it to that account) > Yes, you can delete an anchor split and that is what I noted in my previous message. I called it the 'home' account split. > > > > So I went to the parent account (an asset account) of the split, and > tried to delete the null Orphan-AUD line. That seemed to work. > > Not sure what you mean by ‘parent account’ of the split. Which split? > You’re speaking of the Orphan-AUD split and it only has Expenses as a > parent. > > > > > Back to the Orphan-AUD tab, delete this transaction as a whole. Presto! > All gone. > > The transaction should have been removed from the Orphan-AUD register > automatically when you removed the Orphan-AUD split from another register. > That is normal. But if it hadn’t yet disappeared (because the register view > didn’t refresh for some reason), and then you deleted the transaction from > the Orphan-AUD register, then yes - you removed the entire transaction. > There should have been no need to do so. > > Peter may have navigated to another register view without first committing an edit, but I shouldn't speak for him. > > > > Bad mistake. Deleting transaction was good to its word, and deleted the > whole transaction. I lost the only references I had to the original > transaction (from August). > > > > What is the correct method? > > 1. When you want to remove a split from a transaction do not try to do so > from the same register as the split. If that is how you happened to find > the transaction, right-click on one of the other splits and choose ‘jump’ > which will open the transaction in that other split’s account register. > > 2. Go back to the original register and click on a different transaction. > (or close it entirely) > > 3. From the ‘jumped to’ register, either tab through and zero out the > desired split or right-click the split and choose ‘Delete split’. > > 4. Observe that only that split is removed. > > 5. Re-open (or go back to the original account register) and observe that > the transaction no longer shows up there since you removed the split > anchoring it there. (unless there was more than one such split assigned to > that account, in which case of course, it will still be there with that > remaining split) > > Good Advice! > Regards, > Adrien > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Locked out of gnucash
On Mon, Nov 18, 2019 at 10:01 AM Frank H. Ellenberger < frank.h.ellenber...@gmail.com> wrote: > Am Mo., 18. Nov. 2019 um 16:28 Uhr schrieb David Carlson > : > > > > I like Derek 's suggestion but I would see that and call with this > suggestion: > > > > There is a lock on the selected data file. Most likely this means that > the data file was not cleanly closed (due to a crash) after it was last > opened. > > I believe a more common reason than a crash is turning the computer > off without closing the program. > That's why so many users have flat foreheads [Oh S***]! > > > If you are sure that it is not currently in use by you or another user, > click "Open Anyway". Otherwise, click "Open Read-Only" or one of the other > options. > > > > And my note to dev's would include the caveat that PID is useless when > remote users have access. > > > > David Carlson > > ~Frank > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Locked out of gnucash
I like Derek 's suggestion but I would see that and call with this suggestion: There is a lock on the selected data file. Most likely this means that the data file was not cleanly closed (due to a crash) after it was last opened. If you are sure that it is not currently in use by you or another user, click "Open Anyway". Otherwise, click "Open Read-Only" or one of the other options. And my note to dev's would include the caveat that PID is useless when remote users have access. David Carlson On Mon, Nov 18, 2019, 8:30 AM Derek Atkins wrote: > Hi, > > I think I have a suggestion for some better wording. See below. > > David Carlson writes: > > > I think a better and more accurate wording would be "The data file has > not > > been cleanly closed since it was last opened. If you are sure that it > was > > not opened by another user, click 'Open Anyway'. Otherwise click one of > > the other options." > > How about: > > The data file is currently in use. Most likely this means that the data > file was not cleanly closed (due to a crash) after it was last opened. > If you are sure that it is not currently in use by you or another user, > click "Open Anyway". Otherwise, click one of the other options. > > Note to devs: does it make sense to put the gnucash PID into the lock > file and then check to see if that PID is currently running? That could > help detect whether there is a current process or a crash/unclean > shutdown? > > > To me the important part is that the data file has not been cleanly > closed, > > which is the real reason that the lock file exists. There may be better > > words to use as long as this idea is incorporated. > > I suppose that is one way to interpret it, as "currently in use". > > > David Carlson > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Moving from Sage Accounting and would like to keep sub-account totals viewable
Derek, If what you call a rolling balance is what I call a running balance, then I think that the account register view will show that when it is sorted in chronological order. In fact, as others have already noted, you can see that in your top level accounts. Where you won't see it is in mixed commodity/mixed currency cases such as stock brokerage accounts or other mixed currency accounts. For those cases it is necessary to use a report that can evaluate appropriate exchange rates. David Carlson On Mon, Nov 18, 2019, 8:22 AM Derek Atkins wrote: > Rick, > > Richard Danielson writes: > > > Re the subtotals issue, I used to have a number of subtotals > > (e.g. groceries, snacks and restaurants in the food category) which > > showed up in income accounts. That is what I can't figure out in GC. > > I can make accounts sub-accounts for heading accounts, and get the > > totals for the sub-accounts to show in the income statement, but can't > > get the program to sum the sub-accounts into the heading accounts. > > Note that a parent account will only roll up the balance in sub-accounts > in the CoA or Reports. If you *open* the parent account then it wont > show the transactions (or balances) from the sub-accounts. It is > unclear from your question how/where you are trying to view the > rolled-up balances. > > There is an option to "Open Subaccounts", which will merge all the > transactions from the subaccounts, but it wont show a rolling balance. > > Hope this helps, > > > Rick > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Removing Orphan components from transaction
Peter, You [re]discovered a quirk of GnuCash that it is possible to leave a transaction having an uncommitted pending edit, then edit the 'home' split line from a different account of the same transaction by deleting the 'home' account. GnuCash then automagically commits the edit and it disappears from view in that account. If the complete transaction disappeared rather than only the 'home' split line, I would consider that a true bug which should be reported. For the part about the 'home' split line disappearing, It would be an uphill battle to get this quirk fixed because some users consider that a feature rather than a bug. I have submitted a couple of enhancement bug reports without seeing any action. I personally try to discipline myself to always jump to a different account register to edit and never edit the account field in the 'home' split line of a transaction, but sometimes I slip up. As for finding lost pending edits, I try tricks like hitting the tab key to see if there is one in the current account register, or trying to save the file to see if a warning appears about an uncommitted edit in another account register. A complication to this is that the automagic backup can work without triggering the warning about uncommitted edits, which will then leave the Save button greyed out when there is still an uncommitted edit. Further, if there is an uncommitted edit in a special register such as the general ledger, a search result or 'with child' register, it gets harder to figure out exactly which register tab is the culprit. I'd better get off the soap box. David Carlson On Sun, Nov 17, 2019 at 11:19 PM Peter West wrote: > I found a transaction in Orphan-AUD. It was a split, and the Orphan > component was zero. Maybe I had forgotten part of the split, and then > corrected it, leaving nothing in the Orphan-AUD account. > > I wanted to remove this transaction from Orphan-AUD. As I recall, I tried > to remove the Orphan line from the copy of the transaction under the > Orphan-AUD tab. Uh-uh. Something about the anchoring to another account. > > So I went to the parent account (an asset account) of the split, and tried > to delete the null Orphan-AUD line. That seemed to work. > > Back to the Orphan-AUD tab, delete this transaction as a whole. Presto! > All gone. > > Bad mistake. Deleting transaction was good to its word, and deleted the > whole transaction. I lost the only references I had to the original > transaction (from August). > > What is the correct method? > > Peter > > > -- > Peter West > p...@pbw.id.au > But he cried out all the more, “Son of David, have mercy on me!” > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Locked out of gnucash
Is there a simple way to reword the warning to say that a lock file is present thus some instance of GnuCash has either abandoned it or is not finished working with the data. If you are sure that it was *not* opened by another user or still opened by yourself on another screen or computer click 'Open Anyway'. Otherwise click one of the other options." David Carlson On Sun, Nov 17, 2019 at 9:57 PM John Ralls wrote: > Except that the file was closed immediately after completing the session > load. GnuCash will rename it and write a new one if you have made changes > to the book in memory and tell it to save those changes or let it > auto-save, but you can certainly close the session and so delete the lock > file without saving. > > It really is about the lock file, not the data file. > > Regards, > John Ralls > > > > On Nov 17, 2019, at 4:24 PM, David Carlson > wrote: > > > > A comment about Stan Brown's suggestion. > > > > I think a better and more accurate wording would be "The data file has > not > > been cleanly closed since it was last opened. If you are sure that it > was > > not opened by another user, click 'Open Anyway'. Otherwise click one of > > the other options." > > > > To me the important part is that the data file has not been cleanly > closed, > > which is the real reason that the lock file exists. There may be better > > words to use as long as this idea is incorporated. > > > > David Carlson > > > > On Sun, Nov 17, 2019 at 4:35 PM Frank H. Ellenberger < > > frank.h.ellenber...@gmail.com> wrote: > > > >> Hello Stan et al. > >> > >> I like the idea. A short grep delivers 5 occurrences of likewise texts: > 4 > >> at > >> > >> > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L276 > >> and one further below: > >> > >> > https://github.com/Gnucash/gnucash/blob/de09259f13e8e3d7f2e50f97a353bd22eb45a4b6/gnucash/gnome-utils/gnc-file.c#L768 > >> I am not totally sure if the change can be applied on aloof them. > >> > >> BTW. Splitting the first 4 strings like the last would reduce the > >> burden for our translators. > >> > >> Regards > >> Frank > >> > >> Am So., 17. Nov. 2019 um 08:22 Uhr schrieb Stan Brown > >> : > >>> > >>> In the two years I've been reading this list, I think the single most > >>> common question has been about this "could not obtain the lock" > message. > >>> Seems like someone asks about it at least once a week. > >>> > >>> The text "that database may be in use by another user," while literally > >>> true, isn't helpful because it points to a less common case and gives > no > >>> guidance for the more common case. It's like hearing hoofbeats and > >>> hypothesizing "zebra" instead of "horse". > >>> > >>> I suggest that improving the message would be a huge boon to less > >>> experienced GC users, and very little effort for the developers. > >>> > >>> Why not replace the present text > >>> > >>>That database may be in use by another user, in which case you > >>>should not open the database. What would you like to do? > >>> > >>> with this: > >>> > >>>If your previous session crashed, select Open Anyway. If this is > >>>a shared database, wait for other users to finish using it or > >>>select Open Read-Only. For more information, see (link to sec > >>>2.5.3 of Tutorial). > >>> > >>> "What would you like to do?" can be omitted, in my opinion. Seeing > >>> buttons, users will know that they need to pick one. What they _do_ > need > >>> is text that is relevant to their situation. > >>> > >>> (I question the tutorial's advice to delete the lock files manually. > >>> David Cousens reports: > >>>> My experience on Linux is that when you select Open > >>>> Anyway, the previous .LNK and .LCK files will be deleted and new ones > >>>> created which should then be deleted when GNucash is closed properly. > >>> The same happens for me in Windows. Is there any OS where this > desirable > >>> behavior doesn't happen? If there is, the tutorial's advice should > >>> mention t