INSERT INTO `generalorderlistascdesc1` (`_id`, `date`, `time`, `user`, `billno`, `billdetails`, `sales`, `discountamount`, `paymentmethod`, `billtype`, `itemname`, `quan`, `tableid`, `individualprice`, `date1`, `datetimee`, `cardnumber`, `individualtotal`, `billcount`, `hsn_code`, `itemtax_name`, `itemtax_per`, `itemtax_rs`, `globaltax_rs`, `itemtax_name2`, `itemtax_rs2`, `itemtax_name3`, `itemtax_rs3`, `itemtax_name4`, `itemtax_rs4`, `itemtax_name5`, `itemtax_rs5`) VALUES (1,'01 Jul 2024','10:13:02 AM','Mani ','20240701-000011',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240701101302','','620.64','Shri Guru Traders _720','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(2,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240701101923','','1241.28','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(3,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Heritage FM Badam 200ml MRP 30','24','1','23.40',NULL,'20240701101923','','561.60','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(4,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Heritage FM Pista 200ml MRP 30 ','24','1','23.40',NULL,'20240701101923','','561.60','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(5,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Heritage FM Strawbery 200ml MRP 30 ','24.0','1','24.30',NULL,'20240701101923','','583.20','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(6,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Heritage FM Vanila 200ml MRP 30 ','24','1','24.30',NULL,'20240701101923','','583.20','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(7,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Paper Boat Guva MRP 20','16','1','17',NULL,'20240701101923','','272.00','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(8,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Paper Boat Orange MRP 20','13','1','17',NULL,'20240701101923','','221.00','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(9,'01 Jul 2024','10:19:23 AM','Mani ','20240701-000012',NULL,5008,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','48','1','20.50',NULL,'20240701101923','','984.00','Shri Guru Traders _721','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(10,'01 Jul 2024','10:28:47 AM','Mani ','20240701-000013',NULL,1461,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240701102847','','620.64','Shri Guru Traders _722','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(11,'01 Jul 2024','10:28:47 AM','Mani ','20240701-000013',NULL,1461,'0','  Cash','  General','Pran Doggy MRP 500','1.0','1','420.00',NULL,'20240701102847','','420.00','Shri Guru Traders _722','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(12,'01 Jul 2024','10:28:47 AM','Mani ','20240701-000013',NULL,1461,'0','  Cash','  General','Pran Feeder MRP 500','1.0','1','420.00',NULL,'20240701102847','','420.00','Shri Guru Traders _722','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(13,'01 Jul 2024','10:30:21 AM','Mani ','20240701-000014',NULL,2087,'0','  Cash','  General','Pran Litchi Drink MRP 10','144.0','1','8.66',NULL,'20240701103021','','1247.04','Shri Guru Traders _723','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(14,'01 Jul 2024','10:30:21 AM','Mani ','20240701-000014',NULL,2087,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','48','1','17.50',NULL,'20240701103021','','840.00','Shri Guru Traders _723','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(15,'01 Jul 2024','10:35:54 AM','Mani ','20240701-000015',NULL,1539,'0','  Cash','  General','Pran Litchi Drink MRP 10','36','1','8.62',NULL,'20240701103554','','310.32','Shri Guru Traders _724','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(16,'01 Jul 2024','10:35:54 AM','Mani ','20240701-000015',NULL,1539,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240701103554','','420.00','Shri Guru Traders _724','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(17,'01 Jul 2024','10:35:54 AM','Mani ','20240701-000015',NULL,1539,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','12','1','20.50',NULL,'20240701103554','','246.00','Shri Guru Traders _724','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(18,'01 Jul 2024','10:35:54 AM','Mani ','20240701-000015',NULL,1539,'0','  Cash','  General','Pran Potato Bis 75gm Cream and Onion MRP 25','12.0','1','21',NULL,'20240701103554','','252.00','Shri Guru Traders _724','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(19,'01 Jul 2024','10:35:54 AM','Mani ','20240701-000015',NULL,1539,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','36','1','8.62',NULL,'20240701103554','','310.32','Shri Guru Traders _724','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(20,'01 Jul 2024','10:43:17 AM','Mani ','20240701-000016',NULL,1461,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240701104317','','620.64','Shri Guru Traders _725','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(21,'01 Jul 2024','10:43:17 AM','Mani ','20240701-000016',NULL,1461,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','48','1','17.50',NULL,'20240701104317','','840.00','Shri Guru Traders _725','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(22,'01 Jul 2024','12:20:59 PM','Mani ','20240701-000017',NULL,1152,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17',NULL,'20240701122059','','408.00','Shri Guru Traders _726','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(23,'01 Jul 2024','12:20:59 PM','Mani ','20240701-000017',NULL,1152,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','31',NULL,'20240701122059','','744.00','Shri Guru Traders _726','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(24,'01 Jul 2024','12:31:56 PM','Mani ','20240701-000018',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240701123156','','620.64','Shri Guru Traders _727','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(25,'01 Jul 2024','12:31:56 PM','Mani ','20240701-000018',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240701123156','','420.00','Shri Guru Traders _727','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(26,'03 Jul 2024','09:47:50 AM','Mani ','20240703-000011',NULL,1241,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240703094750','','1241.28','Shri Guru Traders _728','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(27,'03 Jul 2024','09:53:30 AM','Mani ','20240703-000012',NULL,1862,'0','  Cash','  General','Pran Litchi Drink MRP 10','216','1','8.62',NULL,'20240703095330','','1861.92','Shri Guru Traders _729','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(28,'03 Jul 2024','09:58:33 AM','Mani ','20240703-000013',NULL,2519,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','24','1','33.00',NULL,'20240703095833','','792.00','Shri Guru Traders _730','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(29,'03 Jul 2024','09:58:33 AM','Mani ','20240703-000013',NULL,2519,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','33.00',NULL,'20240703095833','','792.00','Shri Guru Traders _730','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(30,'03 Jul 2024','09:58:33 AM','Mani ','20240703-000013',NULL,2519,'0','  Cash','  General','Paper Boat Apple MRP 10','54','1','8.66',NULL,'20240703095833','','467.64','Shri Guru Traders _730','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(31,'03 Jul 2024','09:58:33 AM','Mani ','20240703-000013',NULL,2519,'0','  Cash','  General','Paper Boat Mango MRP 10 ','54','1','8.66',NULL,'20240703095833','','467.64','Shri Guru Traders _730','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(32,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240703104103','','620.64','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(33,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','8.0','1','31',NULL,'20240703104103','','248.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(34,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','8.0','1','31',NULL,'20240703104103','','248.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(35,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','8.0','1','31',NULL,'20240703104103','','248.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(36,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Pran Litchi Drink 1 LTR MRP 80','12','1','68.00',NULL,'20240703104103','','816.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(37,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Heritage FM Strawbery 200ml MRP 30 ','10','1','24.30',NULL,'20240703104103','','243.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(38,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Heritage FM Rich Badam 180ml MRP 40 ','4.0','1','24',NULL,'20240703104103','','96.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(39,'03 Jul 2024','10:41:03 AM','Mani ','20240703-000014',NULL,2763,'0','  Cash','  General','Heritage FM Vanila 200ml MRP 30 ','10','1','24.30',NULL,'20240703104103','','243.00','Shri Guru Traders _731','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(40,'03 Jul 2024','11:13:04 AM','Mani ','20240703-000015',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240703111304','','620.64','Shri Guru Traders _732','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(41,'05 Jul 2024','09:55:37 AM','Mani ','20240705-000011',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240705095537','','620.64','Shri Guru Traders _733','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(42,'05 Jul 2024','10:01:59 AM','Mani ','20240705-000012',NULL,2205,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240705100159','','620.64','Shri Guru Traders _734','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(43,'05 Jul 2024','10:01:59 AM','Mani ','20240705-000012',NULL,2205,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','33.00',NULL,'20240705100159','','792.00','Shri Guru Traders _734','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(44,'05 Jul 2024','10:01:59 AM','Mani ','20240705-000012',NULL,2205,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','12','1','33.00',NULL,'20240705100159','','396.00','Shri Guru Traders _734','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(45,'05 Jul 2024','10:01:59 AM','Mani ','20240705-000012',NULL,2205,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','12','1','33.00',NULL,'20240705100159','','396.00','Shri Guru Traders _734','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(46,'05 Jul 2024','10:07:22 AM','Mani ','20240705-000013',NULL,2880,'0','  Cash','  General','Pran Litchi Drink MRP 10','360','1','8',NULL,'20240705100722','','2880.00','Shri Guru Traders _735','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(47,'05 Jul 2024','10:08:12 AM','Mani ','20240705-000014',NULL,408,'0','  Cash','  General','Pran Litchi Drink 1 LTR MRP 80','6','1','68.00',NULL,'20240705100812','','408.00','Shri Guru Traders _736','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(48,'05 Jul 2024','10:38:48 AM','Mani ','20240705-000015',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240705103848','','620.64','Shri Guru Traders _737','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(49,'05 Jul 2024','10:46:04 AM','Mani ','20240705-000016',NULL,1241,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240705104604','','1241.28','Shri Guru Traders _738','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(50,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Litchi Drink MRP 10','36','1','8.62',NULL,'20240705104813','','310.32','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(51,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','36','1','17.50',NULL,'20240705104813','','630.00','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(52,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','8','1','31',NULL,'20240705104813','','248.00','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(53,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','8','1','31',NULL,'20240705104813','','248.00','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(54,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','8.0','1','31',NULL,'20240705104813','','248.00','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(55,'05 Jul 2024','10:48:13 AM','Mani ','20240705-000017',NULL,2500,'0','  Cash','  General','Pran Litchi Drink 1 LTR MRP 80','12','1','68.00',NULL,'20240705104813','','816.00','Shri Guru Traders _739','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(56,'05 Jul 2024','10:53:42 AM','Mani ','20240705-000018',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240705105342','','620.64','Shri Guru Traders _740','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(57,'05 Jul 2024','10:59:10 AM','Mani ','20240705-000019',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240705105910','','620.64','Shri Guru Traders _741','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(58,'07 Jul 2024','07:33:44 PM','Mani ','20240707-000011',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240707193344','','620.64','Shri Guru Traders _742','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(59,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240708100914','','620.64','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(60,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','12','1','17.50',NULL,'20240708100914','','210.00','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(61,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Doggy MRP 500','1.0','1','420.00',NULL,'20240708100914','','420.00','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(62,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Feeder MRP 500','1.0','1','420.00',NULL,'20240708100914','','420.00','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(63,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Litchi Drink 1 LTR MRP 80','6','1','68.00',NULL,'20240708100914','','408.00','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(64,'08 Jul 2024','10:09:14 AM','Mani ','20240708-000011',NULL,2182,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','12','1','8.62',NULL,'20240708100914','','103.44','Shri Guru Traders _743','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(65,'08 Jul 2024','11:07:22 AM','Mani ','20240708-000012',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240708110722','','620.64','Shri Guru Traders _744','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(66,'08 Jul 2024','11:08:30 AM','Mani ','20240708-000013',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240708110830','','620.64','Shri Guru Traders _745','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(67,'08 Jul 2024','11:14:43 AM','Mani ','20240708-000014',NULL,1250,'0','  Cash','  General','Royal Napkin Silky MRP 65','50','1','25',NULL,'20240708111443','','1250.00','Shri Guru Traders _746','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(68,'08 Jul 2024','12:00:07 PM','Mani ','20240708-000015',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240708120007','','620.64','Shri Guru Traders _747','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(69,'08 Jul 2024','12:00:07 PM','Mani ','20240708-000015',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240708120007','','420.00','Shri Guru Traders _747','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(70,'11 Jul 2024','10:25:36 AM','Mani ','20240711-000011',NULL,811,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711102536','','620.64','Shri Guru Traders _748','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(71,'11 Jul 2024','10:25:36 AM','Mani ','20240711-000011',NULL,811,'0','  Cash','  General','Pran Lollipop Jar MRP 250','1.0','1','190.00',NULL,'20240711102536','','190.00','Shri Guru Traders _748','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(72,'11 Jul 2024','10:27:04 AM','Mani ','20240711-000012',NULL,612,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.5',NULL,'20240711102704','','612.00','Shri Guru Traders _749','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(73,'11 Jul 2024','10:28:28 AM','Mani ','20240711-000013',NULL,1121,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711102828','','620.64','Shri Guru Traders _750','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(74,'11 Jul 2024','10:28:28 AM','Mani ','20240711-000013',NULL,1121,'0','  Cash','  General','Pran Lollipop Jar MRP 250','1.0','1','190.00',NULL,'20240711102828','','190.00','Shri Guru Traders _750','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(75,'11 Jul 2024','10:28:28 AM','Mani ','20240711-000013',NULL,1121,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','36','1','8.62',NULL,'20240711102828','','310.32','Shri Guru Traders _750','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(76,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711103411','','620.64','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(77,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','24','1','33.00',NULL,'20240711103411','','792.00','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(78,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','33.00',NULL,'20240711103411','','792.00','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(79,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Lollipop Jar MRP 250','2.0','1','190.00',NULL,'20240711103411','','380.00','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(80,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Kulfi Candy MRP 165','1.0','1','135.00',NULL,'20240711103411','','135.00','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(81,'11 Jul 2024','10:34:11 AM','Mani ','20240711-000014',NULL,3248,'0','  Cash','  General','Pran Potato Bis 75gm Cream and Onion MRP 25','24','1','22.00',NULL,'20240711103411','','528.00','Shri Guru Traders _751','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(82,'11 Jul 2024','10:35:47 AM','Mani ','20240711-000015',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711103547','','620.64','Shri Guru Traders _752','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(83,'11 Jul 2024','10:52:51 AM','Mani ','20240711-000016',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711105251','','620.64','Shri Guru Traders _753','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(84,'11 Jul 2024','10:53:53 AM','Mani ','20240711-000017',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711105353','','620.64','Shri Guru Traders _754','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(85,'11 Jul 2024','11:11:30 AM','Mani ','20240711-000018',NULL,792,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','33.00',NULL,'20240711111130','','792.00','Shri Guru Traders _755','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(86,'11 Jul 2024','11:18:57 AM','Mani ','20240711-000019',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240711111857','','620.64','Shri Guru Traders _756','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(87,'12 Jul 2024','10:03:07 AM','Mani ','20240712-000011',NULL,2825,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240712100307','','1241.28','Shri Guru Traders _757','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(88,'12 Jul 2024','10:03:07 AM','Mani ','20240712-000011',NULL,2825,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','48','1','33.00',NULL,'20240712100307','','1584.00','Shri Guru Traders _757','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(89,'12 Jul 2024','10:05:56 AM','Mani ','20240712-000012',NULL,414,'0','  Cash','  General','Pran Litchi Drink MRP 10','36','1','8.62',NULL,'20240712100556','','310.32','Shri Guru Traders _758','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(90,'12 Jul 2024','10:05:56 AM','Mani ','20240712-000012',NULL,414,'0','  Cash','  General','Pran Curry Noodles MRP 10','12','1','8.60',NULL,'20240712100556','','103.20','Shri Guru Traders _758','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(91,'12 Jul 2024','10:09:02 AM','Mani ','20240712-000013',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240712100902','','620.64','Shri Guru Traders _759','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(92,'12 Jul 2024','10:11:20 AM','Mani ','20240712-000014',NULL,3239,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240712101120','','1241.28','Shri Guru Traders _760','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(93,'12 Jul 2024','10:11:20 AM','Mani ','20240712-000014',NULL,3239,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','48','1','33.00',NULL,'20240712101120','','1584.00','Shri Guru Traders _760','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(94,'12 Jul 2024','10:11:20 AM','Mani ','20240712-000014',NULL,3239,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','48','1','8.62',NULL,'20240712101120','','413.76','Shri Guru Traders _760','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(95,'18 Jul 2024','10:18:49 AM','Mani ','20240718-000011',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240718101849','','620.64','Shri Guru Traders _761','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(96,'18 Jul 2024','10:18:49 AM','Mani ','20240718-000011',NULL,1041,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240718101849','','420.00','Shri Guru Traders _761','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(97,'18 Jul 2024','10:21:12 AM','Mani ','20240718-000012',NULL,999,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','8','1','33.00',NULL,'20240718102112','','264.00','Shri Guru Traders _762','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(98,'18 Jul 2024','10:21:12 AM','Mani ','20240718-000012',NULL,999,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','8','1','33.00',NULL,'20240718102112','','264.00','Shri Guru Traders _762','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(99,'18 Jul 2024','10:21:12 AM','Mani ','20240718-000012',NULL,999,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','8','1','33.00',NULL,'20240718102112','','264.00','Shri Guru Traders _762','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(100,'18 Jul 2024','10:21:12 AM','Mani ','20240718-000012',NULL,999,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','24','1','8.62',NULL,'20240718102112','','206.88','Shri Guru Traders _762','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(101,'18 Jul 2024','10:21:39 AM','Mani ','20240718-000013',NULL,1241,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240718102139','','1241.28','Shri Guru Traders _763','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(102,'18 Jul 2024','10:23:50 AM','Mani ','20240718-000014',NULL,1629,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240718102350','','620.64','Shri Guru Traders _764','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(103,'18 Jul 2024','10:23:50 AM','Mani ','20240718-000014',NULL,1629,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','48.0','1','21',NULL,'20240718102350','','1008.00','Shri Guru Traders _764','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(104,'18 Jul 2024','10:27:31 AM','Mani ','20240718-000015',NULL,1632,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','33.00',NULL,'20240718102731','','792.00','Shri Guru Traders _765','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(105,'18 Jul 2024','10:27:31 AM','Mani ','20240718-000015',NULL,1632,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','48','1','17.50',NULL,'20240718102731','','840.00','Shri Guru Traders _765','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(106,'18 Jul 2024','10:29:59 AM','Mani ','20240718-000016',NULL,1738,'0','  Cash','  General','Pran Litchi Drink MRP 10','36','1','8.62',NULL,'20240718102959','','310.32','Shri Guru Traders _766','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(107,'18 Jul 2024','10:29:59 AM','Mani ','20240718-000016',NULL,1738,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240718102959','','420.00','Shri Guru Traders _766','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(108,'18 Jul 2024','10:29:59 AM','Mani ','20240718-000016',NULL,1738,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','48.0','1','21',NULL,'20240718102959','','1008.00','Shri Guru Traders _766','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(109,'18 Jul 2024','10:32:10 AM','Mani ','20240718-000017',NULL,1086,'0','  Cash','  General','Pran Litchi Drink MRP 10','48','1','8.62',NULL,'20240718103210','','413.76','Shri Guru Traders _767','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(110,'18 Jul 2024','10:32:10 AM','Mani ','20240718-000017',NULL,1086,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240718103210','','420.00','Shri Guru Traders _767','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(111,'18 Jul 2024','10:32:10 AM','Mani ','20240718-000017',NULL,1086,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','12.0','1','21',NULL,'20240718103210','','252.00','Shri Guru Traders _767','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(112,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Litchi Drink MRP 10','48','1','8.62',NULL,'20240718103743','','413.76','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(113,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','36','1','17.50',NULL,'20240718103743','','630.00','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(114,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','8','1','31',NULL,'20240718103743','','248.00','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(115,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','8','1','31',NULL,'20240718103743','','248.00','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(116,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','8','1','31',NULL,'20240718103743','','248.00','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(117,'18 Jul 2024','10:37:43 AM','Mani ','20240718-000018',NULL,2772,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','48','1','20.50',NULL,'20240718103743','','984.00','Shri Guru Traders _768','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(118,'18 Jul 2024','01:31:03 PM','Mani ','20240718-000019',NULL,1976,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240718133103','','620.64','Shri Guru Traders _769','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(119,'18 Jul 2024','01:31:03 PM','Mani ','20240718-000019',NULL,1976,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','24','1','17.50',NULL,'20240718133103','','420.00','Shri Guru Traders _769','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(120,'18 Jul 2024','01:31:03 PM','Mani ','20240718-000019',NULL,1976,'0','  Cash','  General','Paper Boat Orange MRP 10 ','54','1','8.66',NULL,'20240718133103','','467.64','Shri Guru Traders _769','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(121,'18 Jul 2024','01:31:03 PM','Mani ','20240718-000019',NULL,1976,'0','  Cash','  General','Paper Boat Lychee MRP 10 ','54','1','8.66',NULL,'20240718133103','','467.64','Shri Guru Traders _769','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(122,'23 Jul 2024','10:37:30 AM','Mani ','20240723-000011',NULL,1241,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240723103730','','1241.28','Shri Guru Traders _770','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(123,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240723122439','','1241.28','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(124,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Drinko Pineapple MRP 40','8','1','33.00',NULL,'20240723122439','','264.00','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(125,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','8','1','33.00',NULL,'20240723122439','','264.00','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(126,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Drinko Mango MRP 40 ','8','1','33.00',NULL,'20240723122439','','264.00','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(127,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','24','1','8.62',NULL,'20240723122439','','206.88','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(128,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','12.0','1','21',NULL,'20240723122439','','252.00','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(129,'23 Jul 2024','12:24:39 PM','Mani ','20240723-000012',NULL,2960,'0','  Cash','  General','Paper Boat Apple MRP 10','54','1','8.66',NULL,'20240723122439','','467.64','Shri Guru Traders _771','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(130,'25 Jul 2024','10:22:16 AM','Mani ','20240725-000011',NULL,4056,'0','  Cash','  General','Pran Litchi Drink MRP 10','360','1','8',NULL,'20240725102216','','2880.00','Shri Guru Traders _772','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(131,'25 Jul 2024','10:22:16 AM','Mani ','20240725-000011',NULL,4056,'0','  Cash','  General','Gems 5 RS MRP 120','12','1','98.00',NULL,'20240725102216','','1176.00','Shri Guru Traders _772','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(132,'25 Jul 2024','11:26:34 AM','Mani ','20240725-0000110',NULL,831,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','96','1','8.66',NULL,'20240725112634','','831.36','Shri Guru Traders _781','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(133,'25 Jul 2024','10:38:15 AM','Mani ','20240725-000012',NULL,869,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240725103815','','620.64','Shri Guru Traders _773','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(134,'25 Jul 2024','10:38:15 AM','Mani ','20240725-000012',NULL,869,'0','  Cash','  General','Gems 5 RS MRP 120','1.0','1','98.00',NULL,'20240725103815','','98.00','Shri Guru Traders _773','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(135,'25 Jul 2024','10:38:15 AM','Mani ','20240725-000012',NULL,869,'0','  Cash','  General','Pran Pudding Mango MRP 180','1.0','1','150.00',NULL,'20240725103815','','150.00','Shri Guru Traders _773','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(136,'25 Jul 2024','10:39:31 AM','Mani ','20240725-000013',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240725103931','','620.64','Shri Guru Traders _774','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(137,'25 Jul 2024','10:40:34 AM','Mani ','20240725-000014',NULL,300,'0','  Cash','  General','Pran Pudding Mango MRP 180','2.0','1','150.00',NULL,'20240725104034','','300.00','Shri Guru Traders _775','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(138,'25 Jul 2024','11:14:00 AM','Mani ','20240725-000015',NULL,1008,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','48.0','1','21',NULL,'20240725111400','','1008.00','Shri Guru Traders _776','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(139,'25 Jul 2024','11:15:24 AM','Mani ','20240725-000016',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240725111524','','620.64','Shri Guru Traders _777','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(140,'25 Jul 2024','11:17:38 AM','Mani ','20240725-000017',NULL,816,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','48','1','17',NULL,'20240725111738','','816.00','Shri Guru Traders _778','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(141,'25 Jul 2024','11:18:07 AM','Mani ','20240725-000018',NULL,420,'0','  Cash','  General','Pran Doggy MRP 500','1.0','1','420.00',NULL,'20240725111807','','420.00','Shri Guru Traders _779','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(142,'25 Jul 2024','11:18:55 AM','Mani ','20240725-000019',NULL,540,'0','  Cash','  General','Pran Potato Biscuit MRP 10 ','48','1','8.62',NULL,'20240725111855','','413.76','Shri Guru Traders _780','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(143,'25 Jul 2024','11:18:55 AM','Mani ','20240725-000019',NULL,540,'0','  Cash','  General','Pran Potato Biscuit Spicy MRP 25','6','1','21',NULL,'20240725111855','','126.00','Shri Guru Traders _780','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(144,'26 Jul 2024','09:58:30 AM','Mani ','20240726-000011',NULL,1155,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','18','1','17.50',NULL,'20240726095830','','315.00','Shri Guru Traders _782','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(145,'26 Jul 2024','09:58:30 AM','Mani ','20240726-000011',NULL,1155,'0','  Cash','  General','Pran Doggy MRP 500','1.0','1','420.00',NULL,'20240726095830','','420.00','Shri Guru Traders _782','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(146,'26 Jul 2024','09:58:30 AM','Mani ','20240726-000011',NULL,1155,'0','  Cash','  General','Pran Feeder MRP 500','1.0','1','420.00',NULL,'20240726095830','','420.00','Shri Guru Traders _782','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(147,'26 Jul 2024','10:22:25 AM','Mani ','20240726-000012',NULL,1241,'0','  Cash','  General','Pran Litchi Drink MRP 10','144','1','8.62',NULL,'20240726102225','','1241.28','Shri Guru Traders _783','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(148,'26 Jul 2024','11:16:32 AM','Mani ','20240726-000013',NULL,417,'0','  Cash','  General','Pran Litchi Drink MRP 10','24','1','8.62',NULL,'20240726111632','','206.88','Shri Guru Traders _784','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(149,'26 Jul 2024','11:16:32 AM','Mani ','20240726-000013',NULL,417,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','12','1','17.50',NULL,'20240726111632','','210.00','Shri Guru Traders _784','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(150,'26 Jul 2024','11:34:31 AM','Mani ','20240726-000014',NULL,300,'0','  Cash','  General','Pran Pudding Mango MRP 180','2.0','1','150.00',NULL,'20240726113431','','300.00','Shri Guru Traders _785','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(151,'26 Jul 2024','11:34:57 AM','Mani ','20240726-000015',NULL,621,'0','  Cash','  General','Pran Litchi Drink MRP 10','72','1','8.62',NULL,'20240726113457','','620.64','Shri Guru Traders _786','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(152,'28 Jul 2024','10:05:16 AM','Mani ','20240728-000011',NULL,849,'0','  Cash','  General','Pran Litchi Drink MRP 20 ','6','1','17.50',NULL,'20240728100516','','105.00','Shri Guru Traders _787','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0'),(153,'28 Jul 2024','10:05:16 AM','Mani ','20240728-000011',NULL,849,'0','  Cash','  General','Pran Drinko Litchi MRP 40 ','24','1','31',NULL,'20240728100516','','744.00','Shri Guru Traders _787','',NULL,NULL,'0','0',NULL,'0',NULL,'0',NULL,'0',NULL,'0');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'Paper Boat Lychee MRP 10 ',467),(2,'Paper Boat Orange MRP 10 ',467),(3,'Pran Curry Noodles MRP 10',1032),(4,'Pran Doggy MRP 500',1260),(5,'Pran Drinko Litchi MRP 40 ',5976),(6,'Pran Drinko Mango MRP 40 ',2856),(7,'Pran Drinko Pineapple MRP 40',2112),(8,'Pran Litchi Drink 1 LTR MRP 80',2040),(9,'Pran Litchi Drink MRP 10',27711),(10,'Pran Litchi Drink MRP 20 ',2100),(11,'Pran Lollipop Jar MRP 250',770),(12,'Pran Potato Bis 75gm Cream and Onion MRP 25',1512),(13,'Pran Potato Biscuit MRP 10 ',1036),(14,'Pran Potato Biscuit Spicy MRP 25',3282),(15,'Pran Pudding Mango MRP 180',2424);
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'1632','Paper Boat Lychee MRP 10 ',467,1,'54','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1631','Paper Boat Orange MRP 10 ',467,1,'54','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1618','Pran Curry Noodles MRP 10',1032,2,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1608','Pran Doggy MRP 500',1260,2,'3','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1638','Pran Drinko Litchi MRP 40 ',5976,11,'184','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1648','Pran Drinko Mango MRP 40 ',2856,5,'88','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1604','Pran Drinko Pineapple MRP 40',2112,4,'64','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1620','Pran Litchi Drink 1 LTR MRP 80',2040,4,'30','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1599','Pran Litchi Drink MRP 10',27711,50,'3256','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1600','Pran Litchi Drink MRP 20 ',2100,4,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1674','Pran Lollipop Jar MRP 250',770,1,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1601','Pran Potato Bis 75gm Cream and Onion MRP 25',1512,3,'72','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1607','Pran Potato Biscuit MRP 10 ',1036,2,'120','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1621','Pran Potato Biscuit Spicy MRP 25',3282,6,'156','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1606','Pran Pudding Mango MRP 180',2424,4,'17','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (144,'None',55045);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',55050);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'Mani ',55050,100);
