Checked the reported variance in the Consolidated Sales Report and analyzed the issue. Coordinated with JDA team on where to check the referenced values in the report. Created SQL Script and tested against the generated data. Advised Mark to update the report script based on my designed selection script. Generated the Report, review, and coordinated with Merch for Checking. Merch confirmed that the report is now correct.