Duplicate payments of a single invoice

[Geert Janssens]

On Thursday 21 April 2016 14:01:01 John Whitling wrote:
> Somehow I got duplicate payments of a single invoice in my system. I
> tried to delete it, and it says that I need to edit the invoice which
> is says is protected, via posting. When I look at the invoice it does
> not show it to be posted for some reason.
> 
> Really I just want to delete one of the duplicate payments listed in
> my accounts receivable.
> 
> So far I have not found a way to list out all invoices in the system.
> Is there a way? That would be useful for me.

Hi,

Are you sure you're looking at duplicate invoice payments and not duplicate posted invoices ?

A payment is just an ordinary transaction as far as gnucash is concerned and is normally not 
protected (unless it is reconciled).

Transactions generated as the result of posting an invoice are special and protected. Trying to 
delete those will pop up a message suggesting you should alter the invoice directly instead.

Due to a recently discovered (but probably already very old bug) [1] it is possible to post an 
invoice more than once from the search results window. That would create multiple transactions 
for one single invoice, which sounds very familiar to the issue you are experiencing.

The good news is this bug has been fixed in gnucash 2.6.12, together with some code to help 
fix this issue.

What you can do is this:
- upgrade to gnucash 2.6.12 if you haven't done so already
- run Check & Repair on your AR/AP accounts (the one with the duplicate invoice transactions)
- when Check & Repair completes nothing seems to have changed, however the duplicate 
transactions are now no longer protected, so you can go in your AR/AP account and delete 
them.

Let us know how it went.

Regards,

Geert


[1] https://bugzilla.gnome.org/show_bug.cgi?id=754209