Arvin asked me to analyze and check the problem on the generated report of IAS Sell Thru for Superdry. Based on my checking on JDA the seasonal code has 3 letter codes already but as per your advice via hangouts, you reuploaded the Masterfile that's why I already got 3 letter codes on the season code.
I also checked on the on hand on the inventory side, the total on hand is  35119, but there are some which have zero values. At first, I got  22385 as the total result then I asked you why we didn't have the same result when you checked my query I used the wrong field for the ibdept, I used the istore instead. So when I tried querying it using the ibdept we got the same result.  As per Advised by Arvin, we also need to checked it on the other reports like inventory report. 