Created a new  subquery to get the correct discount date from, date to and discount percentage then update the query of Consolidated Sales Report then validate the data if still have variance in the Total Net Sales vs total in JDA