- modified the query of these report " Ferragamo snap shot report per season/style , top ten sales report all styles , top ten sales report all class , top ten sales report all sub class , top ten sales report all sub dept , Merchandise Information Sheet by sku, Price Event per location by sku , 15/30 Monthly Report by Season and style,  Transfer list report" of IAS 3 for new heirarchy and additional table for MK.