Validated the Stock on-hand report provided by Mark for Furla. Checked the SKU randomly then sum the total quantity if it is the same on the SQL. Asked Jimmy why on the query I only had 4524 total while on the report I have 4780 in total. He advised that this is because on the report the on-hand and in transit are already added on the total quantity. Will advised the merch regarding this.