Re: [GNC] 6.15.5.2. Assign a Destination Account to Multiple Transaction

2019-04-27 Thread David Cousens
The files to patch V3.5 to allow multiple selection and assignment of a transfer account to the selection are attached. Unfortunately only if you build from sources. Hopefully they will be in 3.6 when it is released. Rename import-main-matcher.c to import-main-matcher.c.old in

Re: [GNC] 8.1 Find (^F) set default search preferences?

2019-04-27 Thread Adrien Monteleone
I don’t know of a way to save search criteria, however, when you do a Find, you get a results tab. If you do a subsequent find, you’ll effectively be narrowing the search results. (because you’re running the find from the results tab, the new find window is using that as the data set) So if

[GNC] 8.1 Find (^F) set default search preferences?

2019-04-27 Thread Jeff Albrecht
I looked through '8.1 Find' https://www.gnucash.org/docs/v3/C/gnucash-help/tool-find.html hoping to find a way to save a default search criteria setup. I didn't see that in this section, is there a way? I've been searching repeatedly today as I enter some transactions for a bank that

Re: [GNC] sqlite error from gnucash 2.6.19

2019-04-27 Thread John Ralls
> On Apr 27, 2019, at 10:00 AM, Jeff Abrahamson wrote: > > I opened a gnucash file (sqlite, gnucash v2.6.19, built from version > c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace > >* 18:36:09 CRIT xaccAccountGetName: assertion >'GNC_IS_ACCOUNT(acc)' failed > > I

Re: [GNC] Quicken import and duplicate records

2019-04-27 Thread David Cousens
Priit, Are you following the suggestions on the following Wiki page https://wiki.gnucash.org/wiki/Quicken_Migration. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user

Re: [GNC] Paying business vendor invoice: enter vendor's name twice

2019-04-27 Thread Rich Shepard
On Sat, 27 Apr 2019, Adrien Monteleone wrote: "Billing Info - Vendor - the issuing vendor. If you remember the company name you entered in the New Vendor window for this vendor, start to type it in this field and GnuCash will try auto complete it for you. What's missing in this sentence are

Re: [GNC] Paying business vendor invoice: enter vendor's name twice

2019-04-27 Thread Rich Shepard
On Sat, 27 Apr 2019, Adrien Monteleone wrote: Notice the ‘else’ at the beginning of the second sentence. Only use that select button to open a find dialog if GnuCash doesn’t manage to give you the desired vendor in an auto-complete list. Ah so. Having the 'Select' button immediately adjacent

Re: [GNC] Tips for reporting

2019-04-27 Thread V. Vatsal via gnucash-user
Thank you both. Indeed, the Transaction Report in 3.5 works for what I want (Although I would have never guessed it from the name.) > On Apr 27, 2019, at 7:06 PM, D wrote: > > Maf, > > The transaction report capabilities have changed dramatically between 2.x and > 3.x, so the OP would

Re: [GNC] Tips for reporting

2019-04-27 Thread Maf. King
David, thanks for the reminder! Might save Nike some head scratching if he's still on a 2.x version. It is easy to forget exactly when certain options came into being! Maf. On Saturday, 27 April 2019 18:06:25 BST D wrote: > Maf, > > The transaction report capabilities have changed

Re: [GNC] Tips for reporting

2019-04-27 Thread D via gnucash-user
Maf, The transaction report capabilities have changed dramatically between 2.x and 3.x, so the OP would need to be using 3.5 to get those features. But otherwise you are correct. David On April 27, 2019, at 9:29 PM, "Maf. King" wrote: On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via

Re: [GNC] Paying business vendor invoice: enter vendor's name twice

2019-04-27 Thread Adrien Monteleone
From the Help manual 7.10.1. New Bills "Billing Info - Vendor - the issuing vendor. If you remember the company name you entered in the New Vendor window for this vendor, start to type it in this field and GnuCash will try auto complete it for you. Else, press the Select... button to access

[GNC] sqlite error from gnucash 2.6.19

2019-04-27 Thread Jeff Abrahamson
I opened a gnucash file (sqlite, gnucash v2.6.19, built from version c1b5e6c8d+) and saw a stream of errors in /tmp/gnucash.trace * 18:36:09  CRIT xaccAccountGetName: assertion 'GNC_IS_ACCOUNT(acc)' failed I presume this means some bit of corruption in the sqlite file, but googling

Re: [GNC] Changing account tree on large database

2019-04-27 Thread D via gnucash-user
Good points, Greg. I believe that echoes what the wiki says on the subject. David On April 27, 2019, at 8:01 PM, Greg Feneis wrote: Alternatively, Cricket, instead of exporting from Quicken, then arranging things as you like, then importing to GnuCash, or some variation of that, you could make

Re: [GNC] Quicken import and duplicate records

2019-04-27 Thread D via gnucash-user
Priit, I suspect you imported the transactions for Swedbank, and then imported ones from LHV, correct? When you do this, you must ensure that you take the time in the second import to ensure that the transaction from Swedbank to LHV is matched to the transaction from the first import. They

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 9:49 PM, Cricket Onebit > wrote: > > On Fri, 26 Apr 2019 at 22:14, Tommy Trussell > wrote: > >> >> On Fri, Apr 26, 2019 at 8:49 PM Cricket Onebit >> wrote: >> >>> The speed thing is disappointing. I thought 3.5 fixed that, but maybe not >>> enough. I planned to save

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 8:49 PM, Cricket Onebit > wrote: > > > > (Aside: https://wiki.gnucash.org/wiki/FAQ#SQL_Database recommends not using > the SQL just yet. Several posts on this list say otherwise. Out of date > manual, or optimistic / lucky users?) There was some display issue with

[GNC] Paying business vendor invoice: enter vendor's name twice

2019-04-27 Thread Rich Shepard
Just curious about this behavior that I finally noticed while paying vendor invoices this morning. Selecting Business -> New bill produces a dialog box with a text entry widget for the vendor's name. When I enter the name and click the 'Select' button, a new dialog pops up asking me to enter the

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Adrien Monteleone
> On Apr 26, 2019, at 4:28 PM, Cricket Onebit > wrote: > > > > Also, for this particular example, I’d opt for tags for each kid instead of > accounts, see below about Cars. > > I didn't think GNUCash supported tags. I plan to use #tagone in a text field. > That's one of the things I need

Re: [GNC] Tips for reporting

2019-04-27 Thread Maf. King
On Saturday, 27 April 2019 15:53:38 BST V. Vatsal via gnucash-user wrote: > Hello, > > I am trying to get a more granular look at one of my expense categories, and > hoping that one of the gurus can tell me how best to do it. > > Basically, I want to be able to set a date range, and see all the

[GNC] OFX Import requests (Mac OS)

2019-04-27 Thread V. Vatsal via gnucash-user
Hi, I have a couple of questions/requests about OFX importing on a Mac. Would it be possible to get the active field in the import window highlighted, so one can see which line is being edited? As it stands, clicking on an entry to adjust the account brings up another window for account

[GNC] Tips for reporting

2019-04-27 Thread V. Vatsal via gnucash-user
Hello, I am trying to get a more granular look at one of my expense categories, and hoping that one of the gurus can tell me how best to do it. Basically, I want to be able to set a date range, and see all the transactions in that range grouped according to the merchant, using the information

Re: [GNC] Changing account tree on large database

2019-04-27 Thread Greg Feneis
Alternatively, Cricket, instead of exporting from Quicken, then arranging things as you like, then importing to GnuCash, or some variation of that, you could make a copy of your Quicken working file and from within Quicken, arrange things as you like with a mind toward exporting to GnuCash, then

Re: [GNC] Quicken import and duplicate records

2019-04-27 Thread Greg Feneis
Hi, I get duplicate transactions sometimes too. I tend to download data from financial institutions and import it to GnuCash on a quarterly basis and catch things up. The matcher does a pretty good job of assigning accounts and so forth, but it's not perfect. I find I still have to survey its

[GNC] Quicken import and duplicate records

2019-04-27 Thread Priit Lilleleht
Greetings, dear GnuCash gurus! :) I wonder if there is an answer to my problem with Quicken data import? I have used Quicken 2000 Home & Business since year 2000 but recently I discovered GnuCash as a cute and at the same time much more serious alternative to this old Quicken ("serious" meaning

Re: [GNC] Need help reconciling

2019-04-27 Thread Michael Hendry
> On 27 Apr 2019, at 10:29, Liz wrote: > > On Sat, 27 Apr 2019 14:16:25 +0530 > "David T. via gnucash-user" wrote: > >> ToddAndMango, you might try reading the documentation. > > I'm going to put my education hat on here > > We all learn in different combinations of three main ways >

Re: [GNC] Need help reconciling

2019-04-27 Thread Liz
On Sat, 27 Apr 2019 14:16:25 +0530 "David T. via gnucash-user" wrote: > ToddAndMango, you might try reading the documentation. I'm going to put my education hat on here We all learn in different combinations of three main ways Hearing, Doing and Seeing It doesn't matter how. Most

Re: [GNC] Need help reconciling

2019-04-27 Thread David T. via gnucash-user
All of this is covered in the Guide at https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1 , especially 2.9.4.1, which includes a section regarding the starting balance, as well as

Re: [GNC] Need help reconciling

2019-04-27 Thread Colin Law
On Sat, 27 Apr 2019 at 08:48, Colin Law wrote: > > On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user > wrote: > > > > On 4/27/19 12:11 AM, Colin Law wrote: > > > I am sure we have been over this before. You should not generally > > > need to touch the reconcile column in the register

Re: [GNC] Need help reconciling

2019-04-27 Thread Colin Law
On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user wrote: > > On 4/27/19 12:11 AM, Colin Law wrote: > > I am sure we have been over this before. You should not generally > > need to touch the reconcile column in the register yourself. It is > > all done through the Reconcile feature.

Re: [GNC] Need help reconciling

2019-04-27 Thread ToddAndMargo via gnucash-user
On 4/27/19 12:11 AM, Colin Law wrote: I am sure we have been over this before. You should not generally need to touch the reconcile column in the register yourself. It is all done through the Reconcile feature. Open the credit card (or bank) account and select Options > Reconcile. Check the

Re: [GNC] Need help reconciling

2019-04-27 Thread Colin Law
I am sure we have been over this before. You should not generally need to touch the reconcile column in the register yourself. It is all done through the Reconcile feature. Open the credit card (or bank) account and select Options > Reconcile. Check the opening balance matches the opening

Re: [GNC] Need help reconciling

2019-04-27 Thread ToddAndMargo via gnucash-user
On 4/26/19 10:13 PM, Liz wrote: On Fri, 26 Apr 2019 19:59:32 -0500 (CDT) David Cousens wrote: Me: Where's the ? Wife: In the refrigerator. Me: No it isn't. Wife: Yes it is. Me: Definitely is not! Wife: Walks to refrigerator, opens the door grab.s . from the front of the middle