- modified the IAS 3, add field of brand and sub brand, add tables needed to left join and add it on filter on the query also added additional query for MK for their request of additional tables and fixing the error in all sell thru report.