Discussed with Sir Law the fixing/workaround he can do for other transfer that I did not update the status and did not include when the transfer is executed. Discussed that if the problem is like what we encountered, the transfer in blue yonder is S and in MySQL it is C, this what he should do, change the trfsts status from C into S, the alloc_status into 2 and set the tag as null, then execute the transfer.php again, also advise that this is only for the problem with status as C in MySQL and S in the blue yonder. 