Remove duplicate transactions?

Maf. King maf at chilwell.net
Fri Nov 18 05:29:15 EST 2011


On Friday 18 Nov 2011 09:47:48 shokster wrote:
> Mistakes do happen. If one did by chance import a ton of duplicates, how
> would he then proceed to remove the duplicates?
> 
> Deleting one by one is incredibly time consuming and needs to be deleted
> from 2 places! And even after the deleting is over, the proper way to test
> would be to search for duplicates. Is there a function to do this?
> 

Hi,

Well, you could roll back to an old backup file from before the import 
(assuming that you aren't using MySQL/Postgres backends, of course)

Not sure what you mean when you say each txn has to be deleted from 2 places? 
If a transaction has several splits (and all txns have at least 2), then 
deleting that txn from any of the split accounts should delete the whole 
transaction.

Surely you will catch duplicates (if they still exist) when you reconcile?

HTH,
Maf.


More information about the gnucash-user mailing list