How to delete all transaction related to one specific customer

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

Reply to
Mario
Loading thread data ...

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

Reply to
Afshin Alikhani

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.

Reply to
Mario

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.