Cannot delete a customer - referenced in another record

you should look for CustomerID too, that being said Equipment Record in the error indicates FSEquipment table

 If I do a select on that table for the customerID 4899 which is Ace Bartender, it comes up with no records.  I even checked that there weren’t any CustomerLocationID’s for Ace in that table (checking for all the LocationID records for Ace).

Just to make sure I wasn’t chasing a ghost, I just truncated the FSEquipment table and I was able to delete the customer record.

I’m going restore the DB and try to find out some relationship the FSEquipment table has that is causing the issue.  If there are no customerid records for that customer in that table, maybe it is something linked to the FSEquipment table.

I found the records in the FSEquipment table causing the issue.  The value in the error message is actually the RefNbr field.  

There is probably some FK value in those records causing the issue even though the customerId and customerlocationId fields are not Ace Bartender.

You’ve probably figured out what I am doing here by now.  I’m trying to change the customer account to a different customer account.  I know this is not supported by Acumatica, but my customer is begging for this, so please withhold your chastisements.  I’m just seeing what I can do in my testing environment.  If I am not comfortable with my solution, don’t worry.  I won’t use the application and corrupt the database.

Thanks all for you inputs.  Just for kicks, in 10 hours or so, after I finally figure it out, I’ll post an update.

I found it.  The OwnerID field is a customerid based field.  That was the problem.

Thanks all for jumping in so quickly.