Duplicate invoices help needed

[Brenda Reed]

I found a work around which is to "Void" the duplicated invoice. This
worked but not sure if it causes any other issues. The A/R Aging is correct
and the amount in the A/R Register was wiped out. What is voiding an
invoice intended purpose? Voiding in 1 step was certainly easier than doing
a search which involves finding the invoice, unposting it and then editing
the amount to be 0.

*Brenda*


On Tue, Feb 4, 2014 at 7:57 AM, Brenda Reed <brendareed123 at gmail.com> wrote:

> Not able to just delete the Type of ? since the transaction would need to
> be unposted 1st, and the search does not turn up the transaction. It sounds
> like you are right that the read only transaction in the A/R register may
> have been duplicated (for the record I did not use the "Duplicate"
> function). I was able to create this issue 2 times and have only been using
> GnuCash for 2 weeks. Can I go into the XML file and find the records and
> remove them? If so, what should I search on, invoice # maybe? Yes, I will
> file a bug report. Sad to be in no man's land where a problem cannot be
> fixed. Wonder if this happens much?
>
> *Brenda*
>
>
> On Tue, Feb 4, 2014 at 5:08 AM, Derek Atkins <derek at ihtfp.com> wrote:
>
>> Hi,
>>
>> On Mon, February 3, 2014 11:29 pm, Brenda Reed wrote:
>> > Thank you for reminder to reply to list. I'm not able to "find" the
>> > duplicated invoice doing a search on either the invoice # or the
>> customer
>> > apparently because both records have the exact same invoice #. Only one
>> > invoice shows up in the search results! In the A/R reg one of the
>> invoices
>> > has a ? mark in the Type column and the other has an "I". I was able to
>> > unpost the credit note which is now $0 and does not show up on the aging
>> > report nor the A/R register, so it appears that those worked.  What is
>> the
>> > ? in the register and how can I find the record to unpost it? Also, is
>> the
>> > program supposed to be able to create invoices using the same invoice #?
>> > Thank you, Brenda
>> >
>> > *Brenda*
>>
>> It sounds like you do NOT duplicate an invoice, but instead duplicated the
>> invoice's posted transaction.  So you have a duplicate transaction in your
>> A/R account.  But I suspect that, even though the "type" is "?", if you
>> just try to delete it from A/R you may not be able to.  But try, just for
>> kicks.  If you can, great.
>>
>> If not, I'm afraid you've no-man's land... You did something the
>> developers didn't expect and got yourself into a state that unfortunately
>> you wont be able to get out of.  So, assuming you cannot just delete it
>> from A/R, please file a bug report so the developers remember to handle
>> this corner case (namely, you shouldn't be able to duplicate a read-only
>> transaction).
>>
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>        Derek Atkins                 617-623-3745
>>        derek at ihtfp.com             www.ihtfp.com
>>        Computer and Internet Security Consultant
>>
>>
>