Issue

Company wishes to combine Vendor A and B and all related history.


Vendor A (no. 10000) has a balance of $10


Vendor B (no. 20000) has a balance of $20


Company wishes to combine Vendor A and B and all related history.
Solution

Step 1: Decide on what the combined no. is to be.


In this example we will make the combined vendor as no. 20000


Step 2: Using code comment out the DELETE Trigger Code to allow the delete regarding of balances or delete via a utility using DELETE not DELETE(TRUE).


In this example vendor card no. 20000 is deleted orphaning all records.


Step 3: Rename the second vendor no. to be the first and pick up the other related transactions


In this example vendor card no. 10000 is renamed to 20000

Solution:


Vendor 20000 will now display as $30 and all previous related tables will have updated Vendor No. from 10000 to 20000