 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006535 post PendingInvicesDO 2 QSM-101006483 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006483 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dc7aab1d-f786-4213-bb34-9cba112ed738' LIMIT 1 Date : 2025-10-14T08:59:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T08:59:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006536 post PendingInvicesDO 2 QSM-101006484 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006484 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d9e0d6a-ab26-485c-b228-04c8e558a340' LIMIT 1 Date : 2025-10-14T09:31:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T09:31:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006537 post PendingInvicesDO 2 QSM-101006485 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006485 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='625573d7-27ef-4df7-84e0-0d6a4103751e' LIMIT 1 Date : 2025-10-14T10:06:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T10:06:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006538 post PendingInvicesDO 2 QSM-101006486 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006486 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1cef3e42-c504-40aa-84e6-3b143d2f4a24' LIMIT 1 Date : 2025-10-14T10:41:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T10:41:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006539 post PendingInvicesDO 2 QSM-101006276 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006276 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006276' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006276' OR OrderId='QSM-101006276' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-14T12:45:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006540 post PendingInvicesDO 2 QSM-101006487 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006487 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='067f29dd-877b-4b65-9869-105c2ee81029' LIMIT 1 Date : 2025-10-14T12:50:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T12:50:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006541 post PendingInvicesDO 2 QSM-101006303 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006303' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006303' OR OrderId='QSM-101006303' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-14T15:33:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006542 post PendingInvicesDO 2 QSM-101006488 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006488 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1515fc90-f928-4997-b844-ab75badb2a29' LIMIT 1 Date : 2025-10-15T07:45:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T07:45:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006543 post PendingInvicesDO 2 QSM-101006489 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006489 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='73d205a0-11d2-4e2e-8027-82cd38eb9ca0' LIMIT 1 Date : 2025-10-15T08:22:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T08:22:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006544 post PendingInvicesDO 2 QSM-101006490 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006490 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='65463395-1be4-421c-99c9-c9fd566e2d45' LIMIT 1 Date : 2025-10-15T09:22:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T09:22:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006545 post PendingInvicesDO 2 QSM-101006491 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006491 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='132d8701-0127-492a-86cb-42ddec13c4f4' LIMIT 1 Date : 2025-10-15T09:49:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T09:49:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006546 post PendingInvicesDO 2 QSM-101006492 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006492 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1c1040ee-c384-4015-8003-783081d1bd34' LIMIT 1 Date : 2025-10-15T10:18:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T10:18:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006547 post PendingInvicesDO 2 QSM-101006493 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006493 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a27e6f5e-47f6-44da-a48d-33427d7e5ccd' LIMIT 1 Date : 2025-10-15T10:50:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T10:50:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006548 post PendingInvicesDO 2 QSM-101006494 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006494 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5425b335-4f56-4e21-a372-505e19870080' LIMIT 1 Date : 2025-10-15T11:23:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T11:23:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006549 post PendingInvicesDO 2 QSM-101006495 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006495 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ba10feae-a4da-419a-a957-bcb9bf7abdff' LIMIT 1 Date : 2025-10-15T11:52:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T11:52:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006550 post PendingInvicesDO 2 QSM-101006496 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006496 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='47176643-d0e5-4a3a-817c-84aa45c993a3' LIMIT 1 Date : 2025-10-15T12:33:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T12:33:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006551 post PendingInvicesDO 2 QSM-101006497 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006497 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2426b9bb-db9e-4e67-9e26-df94a2ddba7a' LIMIT 1 Date : 2025-10-16T08:05:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T08:05:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006552 post PendingInvicesDO 2 QSM-101006425 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006425' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006425' OR OrderId='QSM-101006425' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T09:08:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006553 post PendingInvicesDO 2 QSM-101006498 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006498' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006498' OR OrderId='QSM-101006498' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T09:17:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006554 post PendingInvicesDO 2 QSM-101006499 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006499 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a738bb15-cff7-495d-a1c5-6d5bba27374e' LIMIT 1 Date : 2025-10-16T10:44:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T10:44:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006555 post PendingInvicesDO 2 QSM-101006500 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006500 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7ccfd7f8-b4fa-470f-8337-9fe09654f695' LIMIT 1 Date : 2025-10-16T12:17:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T12:17:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006557 post PendingInvicesDO 2 QSM-101006502 post PendingInvicesDO 2 QSM-101006501 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104006556 post PendingInvicesDO 2 QSM-101006502 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101006501 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006502 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3f43bd46-f55d-4005-b9dc-f392e7dfd726' LIMIT 1 Date : 2025-10-18T07:59:58  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c80b4a49-efe5-47b5-9719-485f65e58d97' LIMIT 1 Date : 2025-10-18T07:59:58  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3f43bd46-f55d-4005-b9dc-f392e7dfd726' LIMIT 1 Date : 2025-10-18T07:59:58  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c80b4a49-efe5-47b5-9719-485f65e58d97' LIMIT 1 Date : 2025-10-18T07:59:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-18T07:59:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006558 post PendingInvicesDO 2 QSM-101006503 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006503 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e1b9566a-c591-416b-9c1b-12b01d538128' LIMIT 1 Date : 2025-10-18T08:30:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T08:30:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006559 post PendingInvicesDO 2 QSM-101006504 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006504 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='90aa2b5d-c54f-49c5-9e0f-218268b0f810' LIMIT 1 Date : 2025-10-18T09:00:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T09:00:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006560 post PendingInvicesDO 2 QSM-101006505 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006505 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='09e6f258-1dcc-4f53-8ec6-f04bae2eeae0' LIMIT 1 Date : 2025-10-18T09:27:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T09:27:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006561 post PendingInvicesDO 2 QSM-101006506 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006506 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e67a08ae-ab03-4465-93ed-eee39837b07d' LIMIT 1 Date : 2025-10-18T10:07:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:07:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006562 post PendingInvicesDO 2 QSM-101006445 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006445 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006445' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006445' OR OrderId='QSM-101006445' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-18T11:32:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006563 post PendingInvicesDO 2 QSM-101006431 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006431' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006431' OR OrderId='QSM-101006431' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-18T11:44:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006564 post PendingInvicesDO 2 QSM-101006507 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006507 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='689d1bee-27a8-4e59-90f2-7adddad3cc58' LIMIT 1 Date : 2025-10-18T12:04:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:04:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006565 post PendingInvicesDO 2 QSM-101006508 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006508 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57e65858-913d-4020-b39f-fcd8755bfd61' LIMIT 1 Date : 2025-10-18T12:46:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:46:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006566 post PendingInvicesDO 2 QSM-101006509 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006509 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='98808fab-249e-464c-bb3b-d4c44698583f' LIMIT 1 Date : 2025-10-19T08:22:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T08:22:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006567 post PendingInvicesDO 2 QSM-101006510 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006510 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57940d5a-0528-4958-959a-74316c19f6cc' LIMIT 1 Date : 2025-10-19T09:08:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T09:08:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006568 post PendingInvicesDO 2 QSM-101006511 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006511' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006511' OR OrderId='QSM-101006511' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-19T11:25:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006569 post PendingInvicesDO 2 QSM-101006512 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006512 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2cd3e6b4-ca81-4226-aa56-0d23b67b9b81' LIMIT 1 Date : 2025-10-19T12:54:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T12:54:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006570 post PendingInvicesDO 2 QSM-101006408 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006408' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006408' OR OrderId='QSM-101006408' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-19T14:41:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006571 post PendingInvicesDO 2 QSM-101006466 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006466 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006466' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006466' OR OrderId='QSM-101006466' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-19T14:42:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006572 post PendingInvicesDO 2 QSM-101006514 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006514 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c130792b-6e2c-473d-a712-c478f4f1c046' LIMIT 1 Date : 2025-10-20T08:30:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T08:30:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006573 post PendingInvicesDO 2 QSM-101006422 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006422 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006422' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006422' OR OrderId='QSM-101006422' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-20T08:50:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006574 post PendingInvicesDO 2 QSM-101006515 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006515 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e0dc66b7-a5f2-40ff-8a49-4264b3610a22' LIMIT 1 Date : 2025-10-20T08:55:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T08:55:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006575 post PendingInvicesDO 2 QSM-101006516 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006516 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c2d0ac9a-eab2-41e5-bf85-ca73b62d3d52' LIMIT 1 Date : 2025-10-20T09:31:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T09:31:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006576 post PendingInvicesDO 2 QSM-101006517 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006517 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='177b1121-1f8b-4925-a931-4d93d96f1378' LIMIT 1 Date : 2025-10-20T10:00:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:00:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006577 post PendingInvicesDO 2 QSM-101006518 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006518 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='01dc0a3d-0457-432b-bf36-26621012df21' LIMIT 1 Date : 2025-10-20T10:53:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:54:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006578 post PendingInvicesDO 2 QSM-101006519 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006519 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='34f1d7be-79c9-48db-bc95-de09de79cf26' LIMIT 1 Date : 2025-10-20T11:18:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:18:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006579 post PendingInvicesDO 2 QSM-101006520 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006520 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dbb3c475-180e-480d-b48d-e9e1b08910a6' LIMIT 1 Date : 2025-10-21T08:34:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T08:34:50 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 QSM-104006580 post PendingInvicesDO 2 QSM-101006521 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006521 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c09b33a0-ffc9-4b14-8ef0-1ef41ee83639' LIMIT 1 Date : 2025-10-21T08:53:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T08:53:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006581 post PendingInvicesDO 2 QSM-101006522 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006522 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='044e78cf-a722-4234-b534-39cc5fc26fef' LIMIT 1 Date : 2025-10-21T09:28:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T09:28:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006582 post PendingInvicesDO 2 QSM-101006523 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006523 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='67bad9f8-f06e-4486-a1ed-37b29d8f0669' LIMIT 1 Date : 2025-10-21T10:17:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T10:17:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006583 post PendingInvicesDO 2 QSM-101006524 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006524 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0f7d4820-3dd6-417c-8e10-c48ea0c4a4bf' LIMIT 1 Date : 2025-10-21T10:31:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T10:31:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006584 post PendingInvicesDO 2 QSM-101006431 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006431' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006431' OR OrderId='QSM-101006431' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-21T10:41:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006585 post PendingInvicesDO 2 QSM-101006498 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006498' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006498' OR OrderId='QSM-101006498' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T07:59:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006586 post PendingInvicesDO 2 QSM-101006525 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006525' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006525' OR OrderId='QSM-101006525' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T08:08:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006587 post PendingInvicesDO 2 QSM-101006526 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006526 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c65345df-403f-4efd-b065-b995a2e22367' LIMIT 1 Date : 2025-10-22T08:35:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T08:35:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006588 post PendingInvicesDO 2 QSM-101006527 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006527 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5d6473a4-f5f4-410a-a115-cd12b7cc07b0' LIMIT 1 Date : 2025-10-22T09:11:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T09:11:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006589 post PendingInvicesDO 2 QSM-101006528 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006528 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b7ea219f-ce6d-43da-8e52-7606c20b10e1' LIMIT 1 Date : 2025-10-22T10:38:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T10:38:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006590 post PendingInvicesDO 2 QSM-101006529 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006529 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a6400fed-7ae0-40d5-8c2c-6819b1d0d906' LIMIT 1 Date : 2025-10-22T12:47:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T12:47:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006591 post PendingInvicesDO 2 QSM-101006393 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006393 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006393' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006393' OR OrderId='QSM-101006393' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T12:50:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006592 post PendingInvicesDO 2 QSM-101006513 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006513 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006513' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006513' OR OrderId='QSM-101006513' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T12:50:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006593 post PendingInvicesDO 2 QSM-101006511 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006511' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006511' OR OrderId='QSM-101006511' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T12:51:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006594 post PendingInvicesDO 2 QSM-101006530 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006530 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3eb8cd5d-63c8-4dda-ae11-5510d95b4340' LIMIT 1 Date : 2025-10-23T07:50:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T07:50:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006595 post PendingInvicesDO 2 QSM-101006531 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006531 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='732f8c1e-1e03-4c10-b2c1-8927227f170d' LIMIT 1 Date : 2025-10-23T08:24:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T08:24:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006596 post PendingInvicesDO 2 QSM-101006532 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006532' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006532' OR OrderId='QSM-101006532' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T09:31:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006597 post PendingInvicesDO 2 QSM-101006437 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006437 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006437' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006437' OR OrderId='QSM-101006437' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T09:33:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006598 post PendingInvicesDO 2 QSM-101006533 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006533 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006533' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006533' OR OrderId='QSM-101006533' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T09:57:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006599 post PendingInvicesDO 2 QSM-101006534 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006534 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='106752ce-8fad-4ac0-9f56-55cd4d549351' LIMIT 1 Date : 2025-10-23T10:06:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T10:06:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006600 post PendingInvicesDO 2 QSM-101006535 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006535 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='def90b3b-9aba-4c79-b7c7-681d9aa62b8f' LIMIT 1 Date : 2025-10-23T10:35:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T10:35:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006601 post PendingInvicesDO 2 QSM-101006536 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006536 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9879581c-7026-4497-9686-ee0418ec9288' LIMIT 1 Date : 2025-10-23T10:57:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T10:57:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006602 post PendingInvicesDO 2 QSM-101006537 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006537 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0550c1f2-7074-4591-b0ad-784c1a291c3d' LIMIT 1 Date : 2025-10-23T11:13:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T11:13:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006603 post PendingInvicesDO 2 QSM-101006538 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006538 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b9ea316-5077-4ad6-92b1-16ae1bcc7628' LIMIT 1 Date : 2025-10-23T11:33:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T11:33:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006604 post PendingInvicesDO 2 QSM-101006539 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006539 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cee1f346-d91a-453e-bb76-3015bea54cd4' LIMIT 1 Date : 2025-10-23T12:34:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T12:34:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006605 post PendingInvicesDO 2 QSM-101006540 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006540 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ccdad494-6178-4156-b409-9ce7b3db00bd' LIMIT 1 Date : 2025-10-23T13:42:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T13:42:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006606 post PendingInvicesDO 2 QSM-101006511 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006511' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006511' OR OrderId='QSM-101006511' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T14:24:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006607 post PendingInvicesDO 2 QSM-101006382 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006382 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006382' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006382' OR OrderId='QSM-101006382' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T15:09:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006608 post PendingInvicesDO 2 QSM-101006541 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006541 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a11ea239-1c9f-4f17-851a-b2289dfa7f0e' LIMIT 1 Date : 2025-10-25T07:54:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T07:54:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006609 post PendingInvicesDO 2 QSM-101006542 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006542 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='464af7dc-fc97-4c16-a31b-cd71abaee34f' LIMIT 1 Date : 2025-10-25T08:15:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T08:15:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006610 post PendingInvicesDO 2 QSM-101006543 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006543 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='98144fc7-8d03-4691-b15e-44b4afb81f58' LIMIT 1 Date : 2025-10-25T08:40:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T08:40:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006611 post PendingInvicesDO 2 QSM-101006544 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006544 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='58d5dd7f-4372-41ed-9770-2b7c1d549c91' LIMIT 1 Date : 2025-10-25T08:57:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T08:57:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006612 post PendingInvicesDO 2 QSM-101006545 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006545 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8c36ac22-6dae-4726-9c2d-c2a9e22659f0' LIMIT 1 Date : 2025-10-25T09:34:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T09:34:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006613 post PendingInvicesDO 2 QSM-101006546 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006546 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b35c0fbb-78d6-4ddc-b4a3-3f80d491199b' LIMIT 1 Date : 2025-10-25T10:15:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T10:15:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006614 post PendingInvicesDO 2 QSM-101006547 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006547 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='504034f1-0425-4365-ade3-b316a3c3af79' LIMIT 1 Date : 2025-10-25T10:36:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T10:36:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006615 post PendingInvicesDO 2 QSM-101006548 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006548 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fc547a32-1792-42f3-a5a3-43eda9e323ff' LIMIT 1 Date : 2025-10-25T11:09:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T11:09:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006616 post PendingInvicesDO 2 QSM-101006459 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006459 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006459' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006459' OR OrderId='QSM-101006459' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-25T11:24:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006617 post PendingInvicesDO 2 QSM-101006549 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006549 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='723eae92-ca14-416c-a640-0a5ff7642be1' LIMIT 1 Date : 2025-10-25T11:59:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T11:59:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006618 post PendingInvicesDO 2 QSM-101006550 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006550 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4e6e5076-8b6a-4f17-b092-81e14e6f88a5' LIMIT 1 Date : 2025-10-25T12:31:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T12:31:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006619 post PendingInvicesDO 2 QSM-101006525 post vecPaymentInvoices vecPaymentDetails 2SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006525' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006525' OR OrderId='QSM-101006525' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-25T12:42:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006620 post PendingInvicesDO 2 QSM-101006552 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006552 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4a1d7c6-e22b-4055-9d35-b27f06e8bcb6' LIMIT 1 Date : 2025-10-26T08:44:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T08:44:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006621 post PendingInvicesDO 2 QSM-101006553 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006553 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07a8b81c-3745-4f04-8025-ca0769161b65' LIMIT 1 Date : 2025-10-26T09:08:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T09:08:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006622 post PendingInvicesDO 2 QSM-101006554 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006554 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b151e11-104d-40f5-87d8-3db2c55e0b24' LIMIT 1 Date : 2025-10-26T09:56:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T09:56:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006623 post PendingInvicesDO 2 QSM-101006555 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006555 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e8c5245f-c1be-4a23-93b8-a8b82ca9fd2a' LIMIT 1 Date : 2025-10-26T10:32:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T10:32:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006624 post PendingInvicesDO 2 QSM-101006556 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006556 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dbba590e-888c-4e19-9e5c-9d25c882d17d' LIMIT 1 Date : 2025-10-26T11:25:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T11:25:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006625 post PendingInvicesDO 2 QSM-101006557 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006557 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d7b305e7-dac2-44e4-a256-f25ec7321b86' LIMIT 1 Date : 2025-10-26T12:54:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T12:54:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006626 post PendingInvicesDO 2 QSM-101006558 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006558 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='08cee4c6-5272-40a0-ad8b-d5ace3ea595a' LIMIT 1 Date : 2025-10-26T13:08:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T13:08:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006627 post PendingInvicesDO 2 QSM-101006559 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006559 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6d12140a-1f7f-40d0-ae0f-7e185b05c534' LIMIT 1 Date : 2025-10-26T13:10:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T13:10:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006628 post PendingInvicesDO 2 QSM-101006560 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006560 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='716d74b0-0b84-448c-a37a-3c16940c0cd5' LIMIT 1 Date : 2025-10-27T08:32:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T08:32:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006629 post PendingInvicesDO 2 QSM-101006561 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006561 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6ecb6c01-4bea-424d-9c8e-09fdaafd1a9b' LIMIT 1 Date : 2025-10-27T09:26:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T09:26:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006630 post PendingInvicesDO 2 QSM-101006562 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006562 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0f2601ec-735f-4d2f-8e55-f10348294a48' LIMIT 1 Date : 2025-10-27T10:11:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T10:11:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006631 post PendingInvicesDO 2 QSM-101006450 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006450 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006450' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006450' OR OrderId='QSM-101006450' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-27T10:25:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006632 post PendingInvicesDO 2 QSM-101006563 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006563 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6013649d-d2bc-4b9a-8f17-e6b338f70024' LIMIT 1 Date : 2025-10-27T10:49:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T10:49:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006633 post PendingInvicesDO 2 QSM-101006564 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006564 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='904720c1-d738-4bab-aa11-740454a73c65' LIMIT 1 Date : 2025-10-27T11:05:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T11:05:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006634 post PendingInvicesDO 2 QSM-101006565 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006565 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e58546cd-8c58-46d9-88f7-dc73f9c75e95' LIMIT 1 Date : 2025-10-27T11:44:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T11:44:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006635 post PendingInvicesDO 2 QSM-101006566 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006566 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95149cfb-fdeb-48f5-928b-3b491f06aa38' LIMIT 1 Date : 2025-10-27T12:17:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T12:17:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006636 post PendingInvicesDO 2 QSM-101006568 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006568 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cbe44100-bb49-4bfb-b4ea-3b814cd7f7a0' LIMIT 1 Date : 2025-10-28T08:23:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T08:23:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006637 post PendingInvicesDO 2 QSM-101006569 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006569 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6198729b-c186-4a9a-a116-6e00cf39a000' LIMIT 1 Date : 2025-10-28T09:08:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T09:08:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006638 post PendingInvicesDO 2 QSM-101006570 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006570 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b8c90b10-e394-4bc2-88e3-b1cd66842b4b' LIMIT 1 Date : 2025-10-28T09:45:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T09:45:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006639 post PendingInvicesDO 2 QSM-101006571 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006571 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='25feac9f-029b-4859-9968-000fea17de1d' LIMIT 1 Date : 2025-10-28T10:07:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T10:07:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006640 post PendingInvicesDO 2 QSM-101006572 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006572 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='36fde597-2d59-4b18-b201-96a8571c115c' LIMIT 1 Date : 2025-10-28T10:27:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T10:27:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006641 post PendingInvicesDO 2 QSM-101006573 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006573 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6390be73-17a4-4b6e-90a1-e83b39afd923' LIMIT 1 Date : 2025-10-28T11:01:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T11:01:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006642 post PendingInvicesDO 2 QSM-101006574 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006574 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7fd0fc40-cd80-4d0d-82a4-4e9d4316a930' LIMIT 1 Date : 2025-10-28T11:24:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T11:24:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006643 post PendingInvicesDO 2 QSM-101006575 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006575 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='04bea7b6-bf61-42ad-8f58-20883b67e8d1' LIMIT 1 Date : 2025-10-28T11:47:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T11:47:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006644 post PendingInvicesDO 2 QSM-101006567 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006567 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006567' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006567' OR OrderId='QSM-101006567' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T15:03:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006645 post PendingInvicesDO 2 QSM-101006410 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006410 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006410' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006410' OR OrderId='QSM-101006410' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T15:06:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006646 post PendingInvicesDO 2 QSM-101006576 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006576 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b7586aac-69a6-4541-8cbc-144d87eed740' LIMIT 1 Date : 2025-10-29T07:58:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T07:58:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006647 post PendingInvicesDO 2 QSM-101006577 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006577 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='69e3c6bd-dbb2-423a-b659-db039a5e5fe1' LIMIT 1 Date : 2025-10-29T08:28:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T08:28:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006648 post PendingInvicesDO 2 QSM-101006578 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006578 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b2c752ad-ab87-477e-9ae4-5bd1bfc2b05e' LIMIT 1 Date : 2025-10-29T09:03:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T09:03:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006649 post PendingInvicesDO 2 QSM-101006579 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006579 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0f286952-88a4-4801-950d-09bb4f00a836' LIMIT 1 Date : 2025-10-29T09:39:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T09:39:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006650 post PendingInvicesDO 2 QSM-101006580 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006580 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dddca314-24ed-4695-ad84-dd2c73ba4114' LIMIT 1 Date : 2025-10-29T11:25:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T11:25:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006651 post PendingInvicesDO 2 QSM-101006389 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006389 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : trueSELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101006389' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101006389' OR OrderId='QSM-101006389' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-30T07:17:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006652 post PendingInvicesDO 2 QSM-101006581 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006581 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='815b5337-c17b-4e4f-a6b2-780b80694d11' LIMIT 1 Date : 2025-10-30T08:17:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T08:17:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006653 post PendingInvicesDO 2 QSM-101006582 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006582 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='89347305-9894-4643-96b0-59b00d3536d1' LIMIT 1 Date : 2025-10-30T08:49:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T08:49:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006654 post PendingInvicesDO 2 QSM-101006583 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006583 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b2716f13-2c7e-4341-aa0a-6cdf67026bdf' LIMIT 1 Date : 2025-10-30T09:35:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T09:35:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006655 post PendingInvicesDO 2 QSM-101006584 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006584 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='62139a7c-9ba3-4660-836a-90eb869ef0af' LIMIT 1 Date : 2025-10-30T10:44:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T10:44:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006656 post PendingInvicesDO 2 QSM-101006585 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006585 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='df4aa8e5-5b66-4243-947d-cb021eaf67e0' LIMIT 1 Date : 2025-10-30T10:57:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T10:57:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006657 post PendingInvicesDO 2 QSM-101006586 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006586 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7d07d042-5c9d-4a9d-9a62-00e6f3a48485' LIMIT 1 Date : 2025-10-30T12:36:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T12:36:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006658 post PendingInvicesDO 2 QSM-101006587 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006587 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='064915c4-4005-470d-9507-2da727eb3d0c' LIMIT 1 Date : 2025-10-30T12:59:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T12:59:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104006659 post PendingInvicesDO 2 QSM-101006588 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101006588 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d0aab48b-138d-4aec-8d83-109e1023365e' LIMIT 1 Date : 2025-10-30T14:49:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T14:49:22 payment end 
