SELECT stv.`VendorReturnNo`, stv.`VendorID` SupplierID,sv.`Suppliername` ,stv.`LocationID`,sl.location,st.`ItemName`,st.`BatchNumber`,  DATE_FORMAT(st.`ExpiryDate`,'%d-%b-%Y') ExpiryDate,stv.`ReturnQty`,st.`MinorUnit`,st.`Rate`,st.`DiscountAmount`,st.taxamount,st.`UnitPrice`,  stv.Remark,stv.`UserName`,DATE_FORMAT(stv.EntryDateTime,'%d-%b-%Y')`ReturnDateTime`  FROM st_vendor_return stv  INNER JOIN `st_vendormaster` sv ON sv.`SupplierID`=stv.`VendorID`   INNER JOIN st_locationmaster sl ON sl.LocationID=stv.`LocationID`   INNER JOIN st_nmstock st ON st.`StockID`=stv.`StockID` AND st.`ItemID`=stv.`ItemID`  where stv.EntryDateTime>='2025-02-01 00:00:00'  and stv.EntryDateTime<='2025-02-24 23:59:59'  and stv.`LocationID` in ('24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','47') and stv.`LocationID` in (25,27,31,29,30,24,28,34,32,33,47) and stv.`VendorID` in (3,2,5,1,4,6,7,8,213,9,10,263,11,226,12,230,13,231,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,249,247,220,243,39,40,41,42,43,44,45,240,46,47,48,212,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,254,67,259,68,69,70,71,72,73,74,265,75,76,77,78,79,80,260,81,82,83,84,85,86,87,88,89,90,91,92,93,211,257,94,95,255,225,96,97,228,98,99,100,101,102,103,104,105,106,107,234,216,245,108,109,110,111,112,113,114,241,232,115,116,117,246,242,118,119,238,120,236,121,122,123,124,125,264,126,215,214,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,217,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,256,164,165,253,227,229,166,167,168,169,170,251,171,172,173,174,175,176,248,218,261,244,233,219,177,178,239,179,180,181,182,183,184,224,252,266,221,235,185,237,186,210,187,188,222,250,189,190,191,223,192,209,193,262,194,195,196,197,198,199,200,201,258,202,203,204,205,206,207,208) order BY VendorReturnNo,itemname