update transaction table when process transition day