As discussed with Sally Leria of the FSRI team rescanning the item didn't go as plan, what expect from rescanning the items is that it will correct the values and the letdown details and we will be able to view the items in detail. Talked to Sally Leria again and decided that we just try to manually update 300+ items with no TL number and hope that it will correct the issue. I also mentioned to her our findings with Jovie that the Batch Allocation and Letdown table should be in sync if one of two tables has different data it will not view the item in the letdown details. Donna Dordas of the warehouse provided us with TL and the corresponding SKU. What I did is to no manual query per SKU and match it to the corresponding SKU. After I was done with the update I did try to view the letdown details and now I was able to view the items via the web portal next is to manually submit the item and update the quantity. Advised Sally Leria that I was done with the update but Donna Dordas from the warehouse was already out of the office to confirm the issue is now ok. We will just wait for her feedback tomorrow. This happens when they proceed to scan the items in the warehouse and the connection is not stable this happens, as admitted by Sally Leria this is not an error with the system. She also mentioned there is an ongoing project that will enhance the connection from the warehouse that will prevent this kind of issue from happening.