update the new script for  Sales per counter per day  with new edi location reference table and modify the report template, communicate to sir jimmy for data cleanup of reports then advice sir michael try again the report.