How to delete all transaction related to one specific customer

May 27, 2006 2 Replies

Hello Eveyone



We have few customers records where the account balance does not correspond to the total of transactions. And the balance can not be corrected just by doing an adjustment. The best way to resolve this is to delete all transaction related to these customers, create a new customer record and re-enter all transactions (Invoices, payments, tenders...) The question is how can I do that?



Any suggestions?



Thanks



contact me and will send you a sql script to correct this.

Thanks for your reply, I just sent an email to snipped-for-privacy@retailrealm.co.uk.

"Afsh> contact me and will send you a sql script to correct this.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required