Checked the screen scrape for checking if there are filter or condition that has been missed that might be the reason why the data is not allocated into Shipped status, as per checking, some of the transfer has W status in blue yonder but NULL in MySQL, changed the status into W and tag into Y in MySQL and executed the screen scrape again, checked the result after the execution, as per checking the transfer still not tag as received, checked the screen scrape again for checking, and modified it for adding a specific transfer to test if it will be tag as shipped.