**********************************
 array : [64, 58, 58, 19-03-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='58' AND did='35' and tdate='2024-03-19' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-03-19','1','2024-03-19 10:37:59','Sale','1.0','284071','58','22-23-M1/58','35','58','17878','582.4','581.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='64' AND did='35' and tdate='2024-03-19' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('58','58','2024-03-19','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','64')

**********************************
 array : [65, 59, 59, 19-03-2024, 163, 1, 26.25, 25.0, 26.25, 25.0, 0.625, 0.625, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='59' AND did='35' and tdate='2024-03-19' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-03-19','1','2024-03-19 10:38:14','Sale','26.25','284071','59','22-23-M1/59','35','59','17878','581.4','555.15','1.25','25.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='65' AND did='35' and tdate='2024-03-19' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('59','59','2024-03-19','163','1','26.25','25.0','26.25','25.0','0.625','0.625','5.00','35','65')

**********************************
 array : [1, 1, 1, 16-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='1' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 10:55:58','Sale','5.0','284071','1','22-23-M1/1','35','1','17878','555.15','550.15','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='1' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('1','1','2024-05-16','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','1')

**********************************
 array : [2, 2, 2, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 3, 2, 2, 16-05-2024, 22, 1, 42.00, 40.0, 42.0, 40.0, 1.0, 1.0, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='2' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 10:56:22','Sale','43.0','284071','2','22-23-M1/2','35','2','17878','550.15','507.15','2.0','41.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='2' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('2','2','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','2')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='3' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('2','2','2024-05-16','22','1','42.00','40.0','42.0','40.0','1.0','1.0','5.00','35','3')

**********************************
 array : [4, 3, 3, 01-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='3' AND did='35' and tdate='2024-05-01' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-01','1','2024-05-01 11:14:12','Sale','1.0','284071','3','22-23-M1/3','35','3','17878','506.15','505.15','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='4' AND did='35' and tdate='2024-05-01' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('3','3','2024-05-01','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','4')

**********************************
 array : [5, 4, 4, 01-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='4' AND did='35' and tdate='2024-05-01' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-01','1','2024-05-01 11:16:01','Sale','5.0','284071','4','22-23-M1/4','35','4','17878','505.15','500.15','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='5' AND did='35' and tdate='2024-05-01' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('4','4','2024-05-01','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','5')

**********************************
 array : [6, 5, 5, 01-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 7, 5, 5, 01-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='5' AND did='35' and tdate='2024-05-01' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-01','1','2024-05-01 11:22:02','Sale','6.0','284071','5','22-23-M1/5','35','5','17878','500.15','494.15','0.24','5.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='6' AND did='35' and tdate='2024-05-01' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('5','5','2024-05-01','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','6')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='7' AND did='35' and tdate='2024-05-01' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('5','5','2024-05-01','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','7')

**********************************
 array : [8, 6, 6, 01-05-2024, 138, 1, 63.00, 60.0, 63.0, 60.0, 1.5, 1.5, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='6' AND did='35' and tdate='2024-05-01' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-01','1','2024-05-01 11:22:15','Sale','63.0','284071','6','22-23-M1/6','35','6','17878','494.15','431.15','3.0','60.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='8' AND did='35' and tdate='2024-05-01' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('6','6','2024-05-01','138','1','63.00','60.0','63.0','60.0','1.5','1.5','5.00','35','8')

**********************************
 array : [9, 7, 7, 28-04-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='7' AND did='35' and tdate='2024-04-28' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-28','1','2024-04-28 11:25:45','Sale','1.0','284071','7','22-23-M1/7','35','7','17878','431.15','430.15','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='9' AND did='35' and tdate='2024-04-28' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('7','7','2024-04-28','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','9')

**********************************
 array : [10, 8, 8, 28-04-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='8' AND did='35' and tdate='2024-04-28' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-28','1','2024-04-28 11:25:58','Sale','5.0','284071','8','22-23-M1/8','35','8','17878','430.15','425.15','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='10' AND did='35' and tdate='2024-04-28' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('8','8','2024-04-28','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','10')

**********************************
 array : [11, 9, 9, 29-04-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 12, 9, 9, 29-04-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='9' AND did='35' and tdate='2024-04-29' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-29','1','2024-04-29 11:27:00','Sale','6.0','284071','9','22-23-M1/9','35','9','17878','425.15','419.15','0.24','5.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='11' AND did='35' and tdate='2024-04-29' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('9','9','2024-04-29','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','11')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='12' AND did='35' and tdate='2024-04-29' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('9','9','2024-04-29','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','12')

**********************************
 array : [13, 10, 10, 29-04-2024, 59, 1, 89.25, 85.0, 89.25, 85.0, 2.125, 2.125, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='10' AND did='35' and tdate='2024-04-29' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-29','1','2024-04-29 11:27:13','Sale','89.25','284071','10','22-23-M1/10','35','10','17878','419.15','329.9','4.25','85.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='13' AND did='35' and tdate='2024-04-29' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('10','10','2024-04-29','59','1','89.25','85.0','89.25','85.0','2.125','2.125','5.00','35','13')

**********************************
 array : [14, 11, 11, 30-04-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='11' AND did='35' and tdate='2024-04-30' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-30','1','2024-04-30 11:28:01','Sale','1.0','284071','11','22-23-M1/11','35','11','17878','329.9','328.9','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='14' AND did='35' and tdate='2024-04-30' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('11','11','2024-04-30','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','14')

**********************************
 array : [15, 12, 12, 30-04-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='12' AND did='35' and tdate='2024-04-30' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-04-30','1','2024-04-30 11:28:08','Sale','5.0','284071','12','22-23-M1/12','35','12','17878','328.9','323.9','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='15' AND did='35' and tdate='2024-04-30' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('12','12','2024-04-30','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','15')

**********************************
 array : [16, 13, 13, 02-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 17, 13, 13, 02-05-2024, 36, 1, 52.50, 50.0, 52.5, 50.0, 1.25, 1.25, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='13' AND did='35' and tdate='2024-05-02' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-02','1','2024-05-02 11:29:13','Sale','53.5','284071','13','22-23-M1/13','35','13','17878','323.9','270.4','2.5','51.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='16' AND did='35' and tdate='2024-05-02' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('13','13','2024-05-02','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','16')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='17' AND did='35' and tdate='2024-05-02' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('13','13','2024-05-02','36','1','52.50','50.0','52.5','50.0','1.25','1.25','5.00','35','17')

**********************************
 array : [18, 14, 14, 08-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='14' AND did='35' and tdate='2024-05-08' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-08','1','2024-05-08 11:33:37','Sale','1.0','284071','14','22-23-M1/14','35','14','17878','270.4','269.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='18' AND did='35' and tdate='2024-05-08' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('14','14','2024-05-08','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','18')

**********************************
 array : [19, 15, 15, 08-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='15' AND did='35' and tdate='2024-05-08' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-08','1','2024-05-08 11:33:45','Sale','5.0','284071','15','22-23-M1/15','35','15','17878','269.4','264.4','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='19' AND did='35' and tdate='2024-05-08' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('15','15','2024-05-08','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','19')

**********************************
 array : [20, 16, 16, 09-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 21, 16, 16, 09-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='16' AND did='35' and tdate='2024-05-09' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-09','1','2024-05-09 11:34:30','Sale','6.0','284071','16','22-23-M1/16','35','16','17878','264.4','258.4','0.24','5.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='20' AND did='35' and tdate='2024-05-09' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('16','16','2024-05-09','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','20')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='21' AND did='35' and tdate='2024-05-09' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('16','16','2024-05-09','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','21')

**********************************
 array : [22, 17, 17, 09-05-2024, 22, 1, 42.00, 40.0, 42.0, 40.0, 1.0, 1.0, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='17' AND did='35' and tdate='2024-05-09' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-09','1','2024-05-09 11:34:39','Sale','42.0','284071','17','22-23-M1/17','35','17','17878','258.4','216.39999999999998','2.0','40.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='22' AND did='35' and tdate='2024-05-09' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('17','17','2024-05-09','22','1','42.00','40.0','42.0','40.0','1.0','1.0','5.00','35','22')

**********************************
 array : [23, 18, 18, 10-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='18' AND did='35' and tdate='2024-05-10' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-10','1','2024-05-10 11:35:28','Sale','1.0','284071','18','22-23-M1/18','35','18','17878','216.4','215.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='23' AND did='35' and tdate='2024-05-10' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('18','18','2024-05-10','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','23')

**********************************
 array : [24, 19, 19, 10-05-2024, 23, 1, 5.00, 4.76, 5.0, 4.76, 0.12, 0.12, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='19' AND did='35' and tdate='2024-05-10' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-10','1','2024-05-10 11:35:35','Sale','5.0','284071','19','22-23-M1/19','35','19','17878','215.4','210.4','0.24','4.76')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='24' AND did='35' and tdate='2024-05-10' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('19','19','2024-05-10','23','1','5.00','4.76','5.0','4.76','0.12','0.12','5.00','35','24')

**********************************
 array : [25, 20, 20, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='20' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 12:56:50','Sale','1.0','284071','20','22-23-M1/20','35','20','17878','210.4','209.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='25' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('20','20','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','25')

**********************************
 array : [26, 21, 21, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='21' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 12:58:12','Sale','1.0','284071','21','22-23-M1/21','35','21','17878','209.4','208.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='26' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('21','21','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','26')

**********************************
 array : [27, 22, 22, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='22' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 12:58:32','Sale','1.0','284071','22','22-23-M1/22','35','22','17878','208.4','207.4','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='27' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('22','22','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','27')

**********************************
 array : [28, 23, 23, 16-05-2024, 12, 1, 10.00, 9.52, 10.0, 9.52, 0.24, 0.24, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='23' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 13:15:57','Sale','10.0','284071','23','22-23-M1/23','35','23','17878','207.4','197.4','0.48','9.52')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='28' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('23','23','2024-05-16','12','1','10.00','9.52','10.0','9.52','0.24','0.24','5.00','35','28')

**********************************
 array : [29, 24, 24, 16-05-2024, 166, 1, 9.45, 9.0, 9.45, 9.0, 0.225, 0.225, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='24' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 13:21:20','Sale','9.45','284071','24','22-23-M1/24','35','24','17878','197.4','187.95000000000002','0.45','9.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='29' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('24','24','2024-05-16','166','1','9.45','9.0','9.45','9.0','0.225','0.225','5.00','35','29')

**********************************
 array : [30, 25, 25, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='25' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 16:32:11','Sale','1.0','284071','25','22-23-M1/25','35','25','17878','187.95','186.95','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='30' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('25','25','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','30')

**********************************
 array : [31, 26, 26, 16-05-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='26' AND did='35' and tdate='2024-05-16' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-05-16','1','2024-05-16 16:53:03','Sale','1.0','289754','26','22-23-M1/26','35','26','22807','48.5','47.5','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='31' AND did='35' and tdate='2024-05-16' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('26','26','2024-05-16','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','31')

**********************************
 array : [32, 27, 27, 03-07-2024, 19, 1, 52.50, 50.0, 52.5, 50.0, 1.25, 1.25, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='27' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 11:11:39','Sale','52.5','284071','27','22-23-M1/27','35','27','17878','186.95','134.45','2.5','50.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='32' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('27','27','2024-07-03','19','1','52.50','50.0','52.5','50.0','1.25','1.25','5.00','35','32')

**********************************
 array : [33, 28, 28, 03-07-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='28' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 11:22:16','Sale','1.0','284071','28','22-23-M1/28','35','28','17878','134.45','133.45','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='33' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('28','28','2024-07-03','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','33')

**********************************
 array : [34, 29, 29, 03-07-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='29' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 11:39:20','Sale','1.0','284071','29','22-23-M1/29','35','29','17878','133.45','132.45','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='34' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('29','29','2024-07-03','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','34')

**********************************
 array : [35, 30, 30, 03-07-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='30' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 12:20:40','Sale','1.0','284071','30','22-23-M1/30','35','30','17878','154.45','153.45','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='35' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('30','30','2024-07-03','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','35')

**********************************
 array : [36, 31, 31, 03-07-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='31' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 12:33:16','Sale','1.0','284071','31','22-23-M1/31','35','31','17878','253.45','252.45','0.0','1.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='36' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('31','31','2024-07-03','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','36')

**********************************
 array : [37, 32, 32, 03-07-2024, 166, 1, 9.45, 9.0, 9.45, 9.0, 0.225, 0.225, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='32' AND did='35' and tdate='2024-07-03' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-03','1','2024-07-03 16:29:19','Sale','9.45','284071','32','22-23-M1/32','35','32','17878','252.45','243.0','0.45','9.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='37' AND did='35' and tdate='2024-07-03' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('32','32','2024-07-03','166','1','9.45','9.0','9.45','9.0','0.225','0.225','5.00','35','37')

**********************************
 array : [38, 33, 33, 04-07-2024, 53, 1, 15.75, 15.0, 15.75, 15.0, 0.375, 0.375, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='33' AND did='35' and tdate='2024-07-04' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-04','1','2024-07-04 11:02:40','Sale','15.75','284071','33','22-23-M1/33','35','33','17878','4024.0','4008.25','0.75','15.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='38' AND did='35' and tdate='2024-07-04' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('33','33','2024-07-04','53','1','15.75','15.0','15.75','15.0','0.375','0.375','5.00','35','38')

**********************************
 array : [39, 34, 34, 04-07-2024, 53, 1, 15.75, 15.0, 15.75, 15.0, 0.375, 0.375, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='34' AND did='35' and tdate='2024-07-04' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-04','1','2024-07-04 11:05:15','Sale','15.75','284071','34','22-23-M1/34','35','34','17878','4008.25','3992.5','0.75','15.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='39' AND did='35' and tdate='2024-07-04' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('34','34','2024-07-04','53','1','15.75','15.0','15.75','15.0','0.375','0.375','5.00','35','39')

**********************************
 array : [40, 35, 35, 05-07-2024, 19, 1, 52.50, 50.0, 52.5, 50.0, 1.25, 1.25, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='35' AND did='35' and tdate='2024-07-05' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-05','1','2024-07-05 10:44:30','Sale','52.5','284071','35','22-23-M1/35','35','35','17878','4102.5','4050.0','2.5','50.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='40' AND did='35' and tdate='2024-07-05' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('35','35','2024-07-05','19','1','52.50','50.0','52.5','50.0','1.25','1.25','5.00','35','40')

**********************************
 array : [41, 36, 36, 05-07-2024, 100, 1, 15.00, 14.29, 15.0, 14.29, 0.355, 0.355, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='36' AND did='35' and tdate='2024-07-05' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-05','1','2024-07-05 10:44:45','Sale','15.0','284071','36','22-23-M1/36','35','36','17878','4050.0','4035.0','0.71','14.29')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='41' AND did='35' and tdate='2024-07-05' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('36','36','2024-07-05','100','1','15.00','14.29','15.0','14.29','0.355','0.355','5.00','35','41')

**********************************
 array : [42, 37, 37, 05-07-2024, 30, 1, 262.50, 250.0, 262.5, 250.0, 6.25, 6.25, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='37' AND did='35' and tdate='2024-07-05' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-05','1','2024-07-05 10:44:52','Sale','262.5','284071','37','22-23-M1/37','35','37','17878','4035.0','3772.5','12.5','250.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='42' AND did='35' and tdate='2024-07-05' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('37','37','2024-07-05','30','1','262.50','250.0','262.5','250.0','6.25','6.25','5.00','35','42')

**********************************
 array : [43, 38, 38, 05-07-2024, 63, 1, 125.00, 119.05, 125.0, 119.05, 2.975, 2.975, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='38' AND did='35' and tdate='2024-07-05' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-05','1','2024-07-05 10:45:11','Sale','125.0','284071','38','22-23-M1/38','35','38','17878','3772.5','3647.5','5.95','119.05')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='43' AND did='35' and tdate='2024-07-05' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('38','38','2024-07-05','63','1','125.00','119.05','125.0','119.05','2.975','2.975','5.00','35','43')

**********************************
 array : [44, 39, 39, 06-07-2024, 34, 1, 1.00, 1.0, 1.0, 1.0, 0.0, 0.0, 0.00, 35, :, 45, 39, 39, 06-07-2024, 91, 1, 50.00, 47.62, 50.0, 47.62, 1.19, 1.19, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='39' AND did='35' and tdate='2024-07-06' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-06','1','2024-07-06 10:14:28','Sale','51.0','284071','39','22-23-M1/39','35','39','17878','3494.5','3443.5','2.38','48.62')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='44' AND did='35' and tdate='2024-07-06' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('39','39','2024-07-06','34','1','1.00','1.0','1.0','1.0','0.0','0.0','0.00','35','44')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='45' AND did='35' and tdate='2024-07-06' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('39','39','2024-07-06','91','1','50.00','47.62','50.0','47.62','1.19','1.19','5.00','35','45')

**********************************
 array : [46, 40, 40, 06-07-2024, 53, 1, 15.75, 15.0, 15.75, 15.0, 0.375, 0.375, 5.00, 35, :, 47, 40, 40, 06-07-2024, 19, 3, 52.50, 50.0, 157.5, 150.0, 3.75, 3.75, 5.00, 35, :]


 transact : SELECT * FROM transact WHERE devicetno ='40' AND did='35' and tdate='2024-07-06' 

transact INSERT : INSERT INTO transact(tdate,loginid,dtime,vtype,amount,cid,billno,refno,did,devicetno,stid,rbal,wbal,tax,taxable)VALUES('2024-07-06','1','2024-07-06 10:17:33','Sale','173.25','284071','40','22-23-M1/40','35','40','17878','3443.5','3270.25','8.25','165.0')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='46' AND did='35' and tdate='2024-07-06' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('40','40','2024-07-06','53','1','15.75','15.0','15.75','15.0','0.375','0.375','5.00','35','46')


itemtran : SELECT * FROM itemtran WHERE ditrnid ='47' AND did='35' and tdate='2024-07-06' 


itemtran : INSERT INTO itemtran(tno,devicetno,tdate,ino,qty,rate,taxablerate,amount,taxableamt,sgst,cgst,pigst,did,ditrnid)VALUES('40','40','2024-07-06','19','3','52.50','50.0','157.5','150.0','3.75','3.75','5.00','35','47')