[GNC] How to Delete a Runaway Invoice?

[Jediator]

Not sure if the title is too "violent" that prevents it from being 
accepted by the list.  Resending...

On 9/27/23 6:24 PM, Jediator wrote:
> Thanks Adrien!  I am using the latest version 5.4 of GC, running on 
> Mac with a Postgresql in the back-end.  Please see answers to your 
> questions below.  Additional questions to this mailing list:
>
>   * Has this bug been reported or should I take the initiative to
>     report (this is the first major headache I encountered in GC).
>   * I was wondering if an SQL-delete to remove that record from the
>     database would solve this problem.  However, the old invoice (now
>     it turned into a credit note) is nowhere to find in the invoices
>     table.  Where is it recorded?  Any damage it may cause if I just
>     delete that record?
>
> Thanks in advance!  -- JC
>
> On 9/27/23 12:13 AM, Adrien Monteleone wrote:
>> I think this was a bug in early 5.x, but should be fixed as of 5.4
>>
>> That said, you can't delete invoices.
>>
>> If you changed the Customer assigned to the invoice, it wouldn't show 
>> up on the original Customer Report. (did you change it back?)
>>
>> How are you searching for the invoice you can't seem to find?
>>
>> Do they both show up in the AR register?
>>
>> You can right-click that transaction to 'Jump to Invoice'
>>
>> Once you are viewing the invoice, click the Edit Invoice button on 
>> the *toolbar*. (not the Edit link within the invoice!)
>>
>> Now you can change Customer, ID, etc.
>>
>> I change my errant invoices to "USE NEXT" as the ID so I can spot 
>> them easily for re-use.
>>
>> Note, you can't change the type. So if it was a Credit Note, you have 
>> to wait to use it for your next Credit Note. (for any customer, as 
>> you can re-assign it)
>>
>> Regards,
>> Adrien
>>
>> On 9/26/23 9:36 PM, Jediator wrote:
>>> I was trying to reuse/repurpose an invoice ID for a customer (e.g. 
>>> change the amount and date), but made a mistake of changing the 
>>> customer name in between (not sure if was the cause).  Now I ended 
>>> up with two invoices with the same ID on the customer report, with 
>>> the old entry labeled as a Refund (with the amount still listed 
>>> under Debits to AR) . I tried multiple ways to kill that refund 
>>> invoice, but couldn't succeed.  Looks like the Invoice ID in GC 
>>> isn't unique, so I ended up with two invoices and the old one just 
>>> no where to find and noway to unpost.  Any suggestions how to kill 
>>> that invoice (i.e., remove the corresponding entry in Accounts 
>>> Receivable)?
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>