Removing Customers in Bulk

SOLVED

A VI Job was created to import and update some data in a few fields on Customer Maintenance.

Something in the VI job was wrong that wasn't caught and it ended up creating a bunch of bogus customers. 

Is there any utility that can delete all of these bogus customers at one time instead of going into each record and manually deleting them? (It created a ton so manually deleting each customer will take some time and a route I would rather not have to go down)

Parents
  • 0

    While my esteemed colleague Kevin is correct, note that you can import a list of customers to be deleted into the utility.  Export the customer list to Excel, find the ones to be deleted and delete the rest and then import the resulting file into the Delete/Change Utility. Update.

  • 0 in reply to BigLouie

    Is this import done through Delete/Change Utility? Maybe I am just missing it but I don't see any options to import.

    While looking at this further in a backup company I was wondering if this approach would work...I run a VI Job to set the status all of these bogus customer accounts to Temporary and remove using the Remove Temporary Customers Utility. Since they haven't been used and have zero balances that should work right? We do not currently use the temp customer status for any customer accounts, just the active/inactive.

  • 0 in reply to tolden

    Use VI to import into the table, then run the utility.

  • 0 in reply to Kevin M

    Imported the records into the AR_DeleteChangeCustomers through VI. All looks good to me. Currently running the utlility.

    It was around 2500 records imported into the utility. Been running for about an hour now. Seems like a long time to me. Does that sound "normal" or no?

Reply
  • 0 in reply to Kevin M

    Imported the records into the AR_DeleteChangeCustomers through VI. All looks good to me. Currently running the utlility.

    It was around 2500 records imported into the utility. Been running for about an hour now. Seems like a long time to me. Does that sound "normal" or no?

Children