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)
_______________________________________________
gnucash-user mailing list
gnucash-user@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.