Merge Customer (and related invoice/payment etc) for wrongly created customer records

Merge Customer (and related invoice/payment etc) for wrongly created customer records

Hi all,

Some of my staffs created two (or more) customers, hence duplicate records and already associated invoice, and payment history (closed invoice). It made the sale figures very confusing and we need to tidy it up.

I search the forum and learn that I cannot just delete the customer as invoices and payment history are associated.

I tried to convert paid invoice to open (so that I delete and recreate them. But I cannot convert invoice because it is not DRAFT.

Anyway I can fix this? I am sure many users face the same problem. Thank you

Simon Li.