On Tue, 10 Mar 2020 at 03:08, Gio Bacareza wrote:
> PS The root of all this was the issue with gnucash importing multicurrency
> transactions with CSV. Would you have any idea if other imports eg QIF can
> handle multi-currency?
>
There's old code to handle multicurrency/stock QIF imports but no
No worries. You;ve been a great help. Thanks!
On Tue, Mar 10, 2020 at 11:19 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:
>
> > On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza
> wrote:
> >
> > Hi Adrien,
> >
> > Yes I'm afraid that is the only solution I find. It is not a viable
> On Mar 9, 2020 w11d69, at 10:00 PM, Gio Bacareza wrote:
>
> Hi Adrien,
>
> Yes I'm afraid that is the only solution I find. It is not a viable option
> right now because I'm looking at hundreds of lines.
>
> I'm very grateful for the time and attention you have given me in trying to
> solv
Hi Adrien,
Yes I'm afraid that is the only solution I find. It is not a viable option
right now because I'm looking at hundreds of lines.
I'm very grateful for the time and attention you have given me in trying to
solve this problem as well. Thanks very much.
Gio
PS The root of all this was the
Let’s say you want to delete transactions between AccountA and Expense:E,
Are there any transactions in Expense:E between it and some other account
besides AccountA?
If no, then just delete the entire account Expense:E, GnuCash will offer to
move the transactions, but in this case you want to d
Hi Adrien,
"Do ANY of the target expense accounts involve transactions with ANY other
account than AccountA?"
Yes.
My objective is to be able to select ALL expense accounts. Because they are
expense accounts it is very very likely that they will have transactions
with other accounts besides Acco
Hi Adrien, i'll answer this first because it's much faster for me since
i've done it. I have tried with 1 expense account or several specific
accounts. It works.
But when you try with select ALL expense accounts that's when it's blank.
So I think that when you ID the specific expense accounts and
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
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
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
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
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
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
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
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?
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.
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
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
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
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
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
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
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>
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
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
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
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
relo
First, I would ask, “Why do you want to delete these transactions?” and second,
“Do you want to delete some or *all* of the transactions in that expense
account?"
You don’t need to ‘find’ transactions from an expense account to delete them.
Just open the expense account if you want to delete ce
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 an
Thanks Maf, I tried that but it doesn't let me do what I ultimately want to
do. The goal is to be able to delete all transactions to expense account
and all it's children.
So example consider accountA. In it you would have transactions to/from:
AccountB
AccountC
Expense:E
Expense:F
I want to be a
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.
>
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 repor
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.
--
cheers,
Gio
___
gnucash-user mailing list
gnucash
33 matches
Mail list logo
