if the agent A already resign, user will change the previous invoices to agent B. User needs to change the bills one by one ? got other methods to solve cos time consuming.
1. Use General Maintenance -> Change Code -> Change Agent Code
2. if they want to change agent code for range of document, it is advised to change one by one manually, if use sql code may cause problem