I found where to write queries in the reports module. I toughest part about writing queries isn't so much the SQL but trying to find the fields required. So, does anyone know the table that the merchandize is stored. I am looking for the vendor and our cost in particular but other fields too. There is a sample report showing those fields but I can't find them in the tables in the list!!