Question:
Change There is a agent A already resign, all his transactions want to transfer to agent B. I need a script which can update all transaction from Agent A to Agent B. Users has created Agent B and key-in so many transactions. agent A to Agent B for all transactions
Answer:
update ARDN set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update CASHSALES set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update DEBTOR set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update DELIVERYORDER set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update INVOICE set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update QUOTATION set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESPERSONCOMMBYCOLLPERIOD set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESPERSONCOMMISSION set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESPERSONCOMMISSIONDETAIL set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESDN set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESINVOICE set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESORDER set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update ARRECEIPT set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESPERSON set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESCN set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update ARCN set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
update SALESDEPOSIT set SALESPERSONCODE = 'B'
where SALESPERSONCODE = 'A'
---
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article