Follow the steps on the script attached
Step 1 - Enter the client/s reference number - if batch_id is null this shows that the amount is visible in DMS, if this is 'Zero Bal' then it will not show.
Step 2 - Identify which transactions need to be updated and set back to 'Null'.
Step 3 - Enter the hold debt id's found in step 2 into the script and then follow the process for getting a script run into live.