[GNC] How to Delete a Runaway Invoice?

[Adrien Monteleone]

On 9/27/23 7:28 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:

It seems your answers didn't come through for some reason.

>>
>>   * Has this bug been reported or should I take the initiative to
>>     report (this is the first major headache I encountered in GC).

What do you think is the bug? Duplicate ID's? I thought that was fixed 
for 5.4, but now I see it is not in the release notes. Can you still 
assign two invoices the same ID with 5.4? Then perhaps checkout bugzilla 
to see if it was reported and/or add a comment if so.

>>   * 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?

You *shouldn't* edit the data file with SQL, or at least do so at your 
own risk. Maybe ask on IRC about specifics.

And I"m still not sure how you managed to turn an invoice into a credit 
note. I thought the types were immutable.

-----

I'll wait for your answers to my below questions as they can help guide 
my follow-up suggestions on finding and editing the errant credit note.

Regards,
Adrien


>> 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)