[GNC] Deleting Multiple Transactions

pyz01 at cox.net pyz01 at cox.net
Tue Nov 19 01:16:15 EST 2019


Source of information was: 

 

https://money.stackexchange.com/questions/91861/how-to-delete-multiple-transaction-at-once-in-gnucash.  The user who gave the information was not named.

The only thing I changed was explaining where I used it compared to in the post where the user said he/she used it.  Either way – its use is for deleting multiple transactions quickly and efficiently in a single session.  Thanks to the user who gave this to me at the site. 

 

From: David Carlson <david.carlson.417 at gmail.com> 
Sent: Monday, November 18, 2019 9:35 PM
To: Ken Pyzik <pyz01 at cox.net>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: 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 <pyz01 at cox.net <mailto:pyz01 at cox.net> > 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
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction" "")

To:

(gtk_accel_path
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction"

"<Primary>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:

<Primary> is the same as "Command" on macs and "Ctrl" on Windows. Other
modifiers are <Shift> and <Alt> and they can be combined so to make it a bit
more difficult to do accidentally, my new line is:

(gtk_accel_path
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction"
"<Primary><Shift>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 at gnucash.org <mailto:gnucash-user at 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



More information about the gnucash-user mailing list