As per Gilbert, not all sales are uploaded in Pentaho Fused. Run the transaction refresh in Pentaho Fused after the refresh advise Gilbert to generate again the report but still the sales are still incomplete, I ask Gilbert for the expected sales figure for the Month of July (367,995.98). Generate the Consolidated sales report in Pentaho Fused as per checking, I got the same figure for validation I also query the month of July in JDA and got the same figure. Email the generated report to Gilbert for his validation.