Deleting customers

Geert Janssens geert.gnucash at kobaltwit.be
Sun Nov 16 12:34:27 EST 2014


On Sunday 16 November 2014 18:26:43 Christoph Holtermann wrote:
> Hello,
> 
> Am 15.11.2014 um 09:01 schrieb AC:
> > I was playing around with the business parts of GC just to see what
> > they did (no need for that particular part of the application, just
> > curiosity).  Is it possible to delete a customer from the database?
> > There's no obvious interface to do so.
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
> 
> That's a good question. I'd like to know that, too.
I don't think this was ever implemented.

I looked into deleting invoices once but eventually abandoned my effort. Without extreme 
precaution gnucash would crash each time. 

> 
> And I'd like to know how to decrement the new customer counter because
> accidentally it is about 4000 now.
> 
> Another question: Can I change the customer an invoice belongs to ?
> 
Sure you can: unpost the invoice, edit the invoice, choose another customer, repost.

There are some caveats though: the most straightforward one being that if you unpost a paid 
invoice it will become unpaid and the payment will be kept around as a pre-payment for the 
customer. After changing the invoice owner and reposting the payment will not be reassociated 
with the invoice. If the payment was meant for this new customer as well, you'll have to 
manually remove the old payment (and probably the accompanying lot link transaction if it 
exists) and redo the payment.

I have no idea what happens if the old and new customer have a different default currency. 
That may complicate things.

Geert


More information about the gnucash-user mailing list