Modified the web application again and changed the condition added, commented first on the added condition, and tested the extraction of sales for MOA and offsite locations, the MOA sales have been extracted successfully and correctly, but the offsite locations are not extracted, checked for the cause, and as per checking, the cause is that the query is extracting locations with Swarovski description only, removed this for now and tested it again, as per testing, the sales are successfully extracted. Checked with sir Mark the data, and as per checking, all is correct. Modified the sales module again and add the displaying of the offsite location sales under MOA, tested the changes, as per testing, the offsite location is not yet added and the offsite locations still displaying the offsite location code and not the official store code. Will continue the modification tomorrow.