Re: [GNC] The Tutorial and Concepts Guide

2020-03-08 Thread D. via gnucash-user
Frank, You're right. My perspective on the documentation is beside the point now, and I have to remind myself not to engage in these discussions any more. Maybe the German users have a need for the xslt; haven't seen much traffic on the English lists on the topic. David T. Origina

Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-08 Thread km22
Hi all, Can anyone advise a very simple and safe way of install gnucash 3.8 in Debian 10? I've read posts like this: https://unix.stackexchange.com/questions/107689/how-do-i-install-a-single-package-from-debian-testing-or-unstable-on-stable But I am very reluctant to start messing with things l

Re: [GNC] Report Options was hiding expense and income accounts with zero balances

2020-03-08 Thread John Ralls
> On Mar 7, 2020, at 10:10 PM, Liz wrote: > > On Sat, 7 Mar 2020 23:30:59 -0600 > Adrien Monteleone wrote: > >> Curious... >> >> Where are you right-clicking to get Options? > > Not any more > I started about Gnucash 1.6, and it went away, to be replaced by the > current scheme. > Some

Re: [GNC] hiding expense and income accounts with zero balances

2020-03-08 Thread Adrien Monteleone
For starters, how do you have your accounting period defined in Preferences > Accounting Period? Second, make sure in Options > General for the report, the Start and End date are correct. I normally run with a calendar year accounting period, so the report for me was 12 months from jan20-dec20

Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-08 Thread Adrien Monteleone
You were also offered the option of installing the Flatpak. (with links) Another option is that one user has kindly packaged it as a .deb and linked it here on the list, but you’ll have to do a list search for it. I think it was packaged for Ubuntu (based on testing) so it might not install on d

Re: [GNC] Report Options was hiding expense and income accounts with zero balances

2020-03-08 Thread Adrien Monteleone
Ah, got it now, thanks! Regards, Adrien > On Mar 8, 2020 w11d68, at 12:10 AM, Liz wrote: > > On Sat, 7 Mar 2020 23:30:59 -0600 > Adrien Monteleone wrote: > >> Curious... >> >> Where are you right-clicking to get Options? > > Not any more > I started about Gnucash 1.6, and it went away,

Re: [GNC] Help Find Feature

2020-03-08 Thread Stephen M. Butler
On 3/7/20 8:03 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 e

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
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

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
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 no

Re: [GNC] Help Find Feature

2020-03-08 Thread David Carlson
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>

Re: [GNC] Help Find Feature

2020-03-08 Thread Stephen M. Butler
On 3/8/20 11:14 AM, Adrien Monteleone wrote: > Per a previous post Gio noted the intent to delete *some* expense > transactions. AHA.  Insight (to quote Martin Gardner). > > The example given was: > >> So example consider accountA. In it you would have transactions to/from: >> AccountB >> AccountC

[GNC] Transfers to subaccounts, hide the transaction?

2020-03-08 Thread Nate Bargmann
This is a bit complicated, of course! I have a main checking account with a number of subaccounts. So far so good as it is a concept that is working well. After a couple of months of this I can see some things becoming unwieldy, particularly when reconciling as I have numerous "transfer" transac

Re: [GNC] Transfers to subaccounts, hide the transaction?

2020-03-08 Thread Stephen M. Butler
On 3/8/20 3:07 PM, Nate Bargmann wrote: > This is a bit complicated, of course! > > I have a main checking account with a number of subaccounts. So far so > good as it is a concept that is working well. After a couple of months > of this I can see some things becoming unwieldy, particularly when

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
Certainly. I can’t imagine anyone thinking they can delete transactions and *not* affect running balances or reconciliations. We don’t know the original purpose to the pursuit of the deletion, but that might very well be the intent. Maybe the current balances are off. Maybe there are lots of kno

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
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 Exp

Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-03-08 Thread David Cousens
Ken As Adrien has indicated once you move past installing the distributions repository version, you are relying on an individual making a package available or buidling the version from sources yourself. There are so many different Linux distributions that it is really not possible to produce total

Re: [GNC] Transfers to subaccounts, hide the transaction?

2020-03-08 Thread Adrien Monteleone
There’s no reason you can’t reconcile the transfers. You can even do them separately if you like, though Stephen’s method of just marking them clear as you go is probably better and simpler. I don’t see why a deposit between Income and Checking along with extra splits between Checking and Check

Re: [GNC] Transfers to subaccounts, hide the transaction?

2020-03-08 Thread Nate Bargmann
* On 2020 08 Mar 17:45 -0500, Adrien Monteleone wrote: > There’s no reason you can’t reconcile the transfers. You can even do > them separately if you like, though Stephen’s method of just marking > them clear as you go is probably better and simpler. I'm not quite understanding how that would wor

Re: [GNC] Help Find Feature

2020-03-08 Thread David Carlson
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 Adrie

Re: [GNC] Transfers to subaccounts, hide the transaction?

2020-03-08 Thread Adrien Monteleone
> On Mar 8, 2020 w11d68, at 6:09 PM, Nate Bargmann wrote: > > * On 2020 08 Mar 17:45 -0500, Adrien Monteleone wrote: >> There’s no reason you can’t reconcile the transfers. You can even do >> them separately if you like, though Stephen’s method of just marking >> them clear as you go is probabl

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
Yes, wise indeed. Regards, Adrien > On Mar 8, 2020 w11d68, at 6:42 PM, David Carlson > wrote: > > 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

Re: [GNC] Help Find Feature

2020-03-08 Thread Gio Bacareza
Hi Adrien, thanks for the response. To answer your questions: The reason I want to delete these transactions is because of a faulty multi-currency import. See, I imported a year's worth of multicurrency accounts and now I am fixing these as gnucash does not handle multi-currency accounts export we

Re: [GNC] Help Find Feature

2020-03-08 Thread Gio Bacareza
Hi David, thanks for the response. Sorry If my original post was not clear. My bad. I was not planning to delete split lines. I was planning to delete the whole transaction. I understand that any transaction has at least 2 splits: a debit and a credit account or left or right or source or target.

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
Gio, I recall the multi-currency thread. This puts some things in perspective. In order to help you find the best method, there are a few more questions, here’s the first: Do any of those transactions in AccountA-USD that have splits with the expense accounts also have splits with AccountB-PHP?

Re: [GNC] Help Find Feature

2020-03-08 Thread Gio Bacareza
Hi Stephen, thanks for the response. Once again, I want to apologize if my initial and following posts were not clear. My bad. As I have explained to Adrien in my earlier response (I respond on a FIFO basis.) the reason I cannot do what you have suggested is that it doesn't apply. The Expense acc

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
Yes, it is blank, because you missed this step: >>-then change the “Search for items where” to “any criteria are met” Thus, with ‘all criteria’ you’re asking it to return transactions where ‘all' of those accounts have splits in the *same* transaction, of which there are none. By chang

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
To be clear, a transaction can involve *more* than two accounts. I’m trying to ascertain if you have that case (it is not uncommon) and if any of these will be effected by your deletions. That fact will change the recommended procedure. Regards, Adrien > On Mar 8, 2020 w11d68, at 9:30 PM, Adr

Re: [GNC] Help Find Feature

2020-03-08 Thread Gio Bacareza
Hi Adrien, thanks for being patient with me. I think my earlier illustration was not clear because I just realized that it could be read as contents of a single transaction viewed as multi-splits when what I wanted to illustrate are single transactions. So with that let me try to answer your ques

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
The picture is getting clearer. Okay then, next question: Do ANY of the target expense accounts involve transactions with ANY other account than AccountA? Put another way, do you have even a single transaction between some other bank account in any of those same expense accounts? Regards, Ad

Re: [GNC] Help Find Feature

2020-03-08 Thread Gio Bacareza
I did that. Still blank :( On Mon, Mar 9, 2020 at 10:32 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Yes, it is blank, because you missed this step: > > >>-then change the “Search for items where” to “any criteria are > met” > > Thus, with ‘all criteria’ you’re asking

[GNC] New user

2020-03-08 Thread Barbara A. Allen
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? __

Re: [GNC] Help Find Feature

2020-03-08 Thread Adrien Monteleone
Try the search with just one expense account then. (that you can easily see in the register so you know it is there) Regards, Adrien > On Mar 8, 2020 w11d68, at 9:44 PM, Gio Bacareza wrote: > > I did that. Still blank :( ___ gnucash-user mailing lis

Re: [GNC] Find or search all expenses in a certain account

2020-03-08 Thread Gio Bacareza
Hi John, I also actually tried that Find > All Accounts > Choose Accounts = Expenses:(all children) and it's still blank. To be honest, I find this text in the documentation really hard to understand: "The Account option performs a search where the accounts selected in the Choose Accounts dialog

Re: [GNC] Find or search all expenses in a certain account

2020-03-08 Thread John Ralls
Gio, No surprise, that's not exactly lucid. I just tried again with a more realistic test book. The problem is that "matches all accounts" means what it says: if you give it ten accounts then any transaction must have splits in all 10 of them to match. Experimenting around a bit more, I find t

Re: [GNC] New user

2020-03-08 Thread David Carlson
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 runnin

Re: [GNC] Find or search all expenses in a certain account

2020-03-08 Thread Gio Bacareza
Hi John, I tried your recommendation. I actually tried to test all scenarios I can think of (I can't help myself). Unfortunately, it still does not produce the result I want. I'm sharing the results and details of what I did here. Google Docs here https://docs.google.com/document/d/16-4oAiKGfULuI0