Continued to check the data of the mall sending, for checking the extraction of data with and without E for the filter, this might be the reason why the data for date 20220224 has a discrepancy, discussed with Sir Law for checking on his side as well, as per checking, the data has a serial E (EOD) but in the XML it is S (Sales), as discussed with sir Ian this will be checked with Pentaho first. This was fixed by the Pentaho team, and as per checking with the mall sending, the data is now tally, confirmed as well by sir Ian that it is now OK.