 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003593 post PendingInvicesDO 2 QSM-101003562 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003562 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='01d9f33a-1cf7-4245-b788-4a69d95268dd' LIMIT 1 Date : 2024-10-31T09:51:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T09:51:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003594 post PendingInvicesDO 2 QSM-101003563 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003563 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d17f04c5-6212-4e01-967d-d18227ef624d' LIMIT 1 Date : 2024-10-31T10:09:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T10:09:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003595 post PendingInvicesDO 2 QSM-101003564 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003564 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eea5cd62-51d2-4ff7-8ac2-20c5b6c96def' LIMIT 1 Date : 2024-10-31T10:23:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T10:23:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003596 post PendingInvicesDO 2 QSM-101003565 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003565 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='052d75e6-ee22-4217-8ab4-082bdc4179f8' LIMIT 1 Date : 2024-10-31T10:45:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T10:45:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003597 post PendingInvicesDO 2 QSM-101003566 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003566 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='063493ca-9dda-4550-a03f-ba83e7ba289a' LIMIT 1 Date : 2024-10-31T11:21:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T11:21:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003598 post PendingInvicesDO 2 QSM-101003567 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003567 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3512b58f-c4d4-4fc5-9b8a-ca696a6daba4' LIMIT 1 Date : 2024-10-31T11:43:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-10-31T11:43:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003599 post PendingInvicesDO 2 QSM-101003546 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003546 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-101003546' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003546' OR OrderId='QSM-101003546' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-10-31T15:31:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003600 post PendingInvicesDO 2 QSM-101003568 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003568 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1daaaa6f-36eb-4362-8c17-98ae4266fe7f' LIMIT 1 Date : 2024-11-02T09:45:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T09:45:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003601 post PendingInvicesDO 2 QSM-101003569 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003569 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3e20e5c3-f7ff-48a6-92a2-78384a7b2c90' LIMIT 1 Date : 2024-11-02T10:20:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T10:20:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003602 post PendingInvicesDO 2 QSM-101003570 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003570 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fae71145-4911-4578-84b6-e4effab2325a' LIMIT 1 Date : 2024-11-02T10:39:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-02T10:39:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003603 post PendingInvicesDO 2 QSM-101003571 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003571 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='36cb6c64-aa8e-4bf7-83de-bf88a373d8fc' LIMIT 1 Date : 2024-11-03T09:24:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:24:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003604 post PendingInvicesDO 2 QSM-101003572 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003572 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1d368b4e-8659-45f7-8264-d4b5fac10056' LIMIT 1 Date : 2024-11-03T09:46:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:46:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003605 post PendingInvicesDO 2 QSM-101003573 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003573 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='90b9e3ad-9655-40c7-b107-a80bae387880' LIMIT 1 Date : 2024-11-03T09:57:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-03T09:57:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003606 post PendingInvicesDO 2 QSM-101003575 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003575 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d3aaa583-d229-4214-8c77-68280e3d0128' LIMIT 1 Date : 2024-11-04T09:49:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T09:49:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003607 post PendingInvicesDO 2 QSM-101003576 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003576 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5730828d-352c-4643-a399-e3c1820fd7f4' LIMIT 1 Date : 2024-11-04T10:26:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T10:26:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003608 post PendingInvicesDO 2 QSM-101003577 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003577 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c52f57ac-a4e8-46e7-aa3b-413ccc001edc' LIMIT 1 Date : 2024-11-04T10:48:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-04T10:48:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003609 post PendingInvicesDO 2 QSM-101003578 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003578 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-101003578' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003578' OR OrderId='QSM-101003578' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-05T11:06:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003610 post PendingInvicesDO 2 QSM-101003579 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003579 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4c827c94-d747-4af0-9141-46822b615b4d' LIMIT 1 Date : 2024-11-05T11:07:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T11:07:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003611 post PendingInvicesDO 2 QSM-101003580 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003580 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e08d2868-d142-4202-a79e-24ff157f8be9' LIMIT 1 Date : 2024-11-05T11:26:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T11:26:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003612 post PendingInvicesDO 2 QSM-101003581 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003581 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ce6714f5-c5a1-41cf-a5e4-0c1074d839ce' LIMIT 1 Date : 2024-11-05T11:57:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T11:57:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003613 post PendingInvicesDO 2 QSM-101003574 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003574 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-101003574' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003574' OR OrderId='QSM-101003574' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-05T12:08:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003614 post PendingInvicesDO 2 QSM-101003582 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003582 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='74495b2f-18f2-4d00-8a40-eed42a5d08a9' LIMIT 1 Date : 2024-11-05T12:18:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-05T12:18:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003615 post PendingInvicesDO 2 QSM-101003583 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003583 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2afeecda-fc29-4867-ae0f-b4afee8f2a18' LIMIT 1 Date : 2024-11-06T09:57:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T09:57:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003617 post PendingInvicesDO 2 QSM-101003585 post PendingInvicesDO 2 QSM-101003584 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003616 post PendingInvicesDO 2 QSM-101003585 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003584 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003585 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-101003585' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003585' OR OrderId='QSM-101003585' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101003585' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003585' OR OrderId='QSM-101003585' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-06T10:31:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003618 post PendingInvicesDO 2 QSM-101003586 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003586 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7e82f51a-4cc0-4a94-8624-23fc81eb8094' LIMIT 1 Date : 2024-11-06T10:52:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-06T10:52:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003619 post PendingInvicesDO 2 QSM-101003587 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003587 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-101003587' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003587' OR OrderId='QSM-101003587' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-06T13:18:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003620 post PendingInvicesDO 2 QSM-101003588 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003588 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='468c2e1b-6d33-499f-945c-b38760b9b852' LIMIT 1 Date : 2024-11-07T09:50:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T09:50:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003621 post PendingInvicesDO 2 QSM-101003589 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003589 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d5b6f670-8bb9-44d9-9f73-249dba6038db' LIMIT 1 Date : 2024-11-07T10:03:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T10:03:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003622 post PendingInvicesDO 2 QSM-101003590 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003590 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c0018a07-e175-403e-b4ca-15a9742d75a3' LIMIT 1 Date : 2024-11-07T10:18:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T10:18:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003623 post PendingInvicesDO 2 QSM-101003591 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003591 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d7217663-4ccb-4f4d-aa05-e14f426dc35e' LIMIT 1 Date : 2024-11-07T10:42:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T10:42:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003624 post PendingInvicesDO 2 QSM-101003592 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003592 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='47aea593-d285-4acf-bee5-3cc818bbae47' LIMIT 1 Date : 2024-11-07T11:25:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-07T11:25:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003625 post PendingInvicesDO 2 QSM-101003593 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003593 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='afe1f96d-e7d1-47fc-83f1-d5adbc5fb784' LIMIT 1 Date : 2024-11-09T09:55:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T09:55:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003626 post PendingInvicesDO 2 QSM-101003594 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003594 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9a382ded-3b74-4e66-8c07-35d0d6049b9e' LIMIT 1 Date : 2024-11-09T10:08:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T10:08:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003627 post PendingInvicesDO 2 QSM-101003595 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003595 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ca9db493-54c5-4bf9-80d0-987e4f1ec8ca' LIMIT 1 Date : 2024-11-09T10:44:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T10:44:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003628 post PendingInvicesDO 2 QSM-101003596 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003596 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31f57131-9605-47d2-ab4c-50226ae74ae2' LIMIT 1 Date : 2024-11-09T11:24:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T11:24:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003629 post PendingInvicesDO 2 QSM-101003597 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003597 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cbe0b724-2775-41d9-9acf-07349827e211' LIMIT 1 Date : 2024-11-09T11:50:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T11:50:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003630 post PendingInvicesDO 2 QSM-101003598 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003598 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d5a446c5-6078-4e54-8ba5-effa1b0d735f' LIMIT 1 Date : 2024-11-09T12:30:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-09T12:30:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003631 post PendingInvicesDO 2 QSM-101003599 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003599 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1da1cb0b-1092-461c-9187-0d5f8869d051' LIMIT 1 Date : 2024-11-10T09:34:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T09:34:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003632 post PendingInvicesDO 2 QSM-101003600 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003600 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bc2f8eea-0337-4723-b2a0-57e39269f564' LIMIT 1 Date : 2024-11-10T10:05:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:05:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003633 post PendingInvicesDO 2 QSM-101003601 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003601 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d46f91e7-122d-40fd-9fed-b1e507fcd08f' LIMIT 1 Date : 2024-11-10T10:31:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:31:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003634 post PendingInvicesDO 2 QSM-101003602 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003602 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f9da2ed6-ab1d-4dbc-9483-5c05572d61a9' LIMIT 1 Date : 2024-11-10T10:55:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T10:55:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003635 post PendingInvicesDO 2 QSM-101003603 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003603 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b82f025-5702-493e-b918-55690fcb0027' LIMIT 1 Date : 2024-11-10T11:26:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T11:26:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003636 post PendingInvicesDO 2 QSM-101003604 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003604 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='57c2bfd1-8811-4870-bfd5-46bd4d1e9475' LIMIT 1 Date : 2024-11-10T13:21:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-10T13:21:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003637 post PendingInvicesDO 2 QSM-101003605 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003605 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e8915e52-36e7-4173-822a-a174f2d6c28f' LIMIT 1 Date : 2024-11-11T09:39:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T09:39:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003638 post PendingInvicesDO 2 QSM-101003606 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003606 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6c21fded-df22-4d4c-8891-5a1bc73a33a3' LIMIT 1 Date : 2024-11-11T09:55:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T09:55:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003639 post PendingInvicesDO 2 QSM-101003607 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003607 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='51844d14-6679-4e5e-aa65-2be34a56f9bf' LIMIT 1 Date : 2024-11-11T10:17:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T10:17:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003640 post PendingInvicesDO 2 QSM-101003608 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003608 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ed250df1-64ab-472f-bf60-99836e5f9abe' LIMIT 1 Date : 2024-11-11T10:43:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T10:43:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003641 post PendingInvicesDO 2 QSM-101003609 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003609 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c0e3c3d1-f6dd-4d15-b06f-341a3c99e996' LIMIT 1 Date : 2024-11-11T11:16:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-11T11:16:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003642 post PendingInvicesDO 2 QSM-101003610 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003610 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='af59c33e-54bb-4481-8633-570cfa56810e' LIMIT 1 Date : 2024-11-12T09:57:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T09:57:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003643 post PendingInvicesDO 2 QSM-101003611 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003611 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a1dc65af-bfff-4af4-b6bf-18ba0a2dd890' LIMIT 1 Date : 2024-11-12T10:15:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T10:15:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003644 post PendingInvicesDO 2 QSM-101003612 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003612 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e45b36d0-4afa-4a72-bc22-27b4bac6f2fd' LIMIT 1 Date : 2024-11-12T10:41:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T10:41:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003645 post PendingInvicesDO 2 QSM-101003613 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003613 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='15327aa0-af14-4ef7-b566-686898ec70dd' LIMIT 1 Date : 2024-11-12T11:08:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T11:08:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003646 post PendingInvicesDO 2 QSM-101003614 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003614 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='64852e5b-6f75-4d54-88b9-df8dbb1c294e' LIMIT 1 Date : 2024-11-12T11:30:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T11:30:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003647 post PendingInvicesDO 2 QSM-101003615 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003615 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c3f4ccda-d3b1-47f5-bad5-5bb800017c5d' LIMIT 1 Date : 2024-11-12T12:36:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-12T12:36:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003648 post PendingInvicesDO 2 QSM-101003616 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003616 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cc0c5f75-05de-4c91-a071-2281d9986e31' LIMIT 1 Date : 2024-11-13T10:38:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T10:38:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003649 post PendingInvicesDO 2 QSM-101003617 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003617 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07be57f9-452e-45eb-be6c-d4f1a02fe32a' LIMIT 1 Date : 2024-11-13T10:52:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T10:52:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003650 post PendingInvicesDO 2 QSM-101003618 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003618 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='123c2acd-597f-4940-9bdf-587d25fbd7a8' LIMIT 1 Date : 2024-11-13T11:04:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T11:04:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003651 post PendingInvicesDO 2 QSM-101003619 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003619 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7fa38e37-304f-411f-9075-c62b2cae033a' LIMIT 1 Date : 2024-11-13T11:25:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T11:25:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003652 post PendingInvicesDO 2 QSM-101003620 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003620 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79d8481a-184c-4fbf-9791-c5b272176556' LIMIT 1 Date : 2024-11-13T12:25:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-13T12:25:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003653 post PendingInvicesDO 2 QSM-101003621 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003621 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3853d4b3-0a6f-40a7-bd0d-768591671524' LIMIT 1 Date : 2024-11-14T09:53:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-14T09:53:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003654 post PendingInvicesDO 2 QSM-101003622 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003622 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8dcd806f-c5dc-451a-979c-172241409f81' LIMIT 1 Date : 2024-11-14T10:17:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-14T10:17:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003655 post PendingInvicesDO 2 QSM-101003624 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003624 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='958d509e-f3a0-4bf4-9e4f-d67016a3eb4f' LIMIT 1 Date : 2024-11-14T11:35:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-14T11:35:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003656 post PendingInvicesDO 2 QSM-101003625 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003625 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2ca80fd1-df41-4d4d-a495-262f31b6db19' LIMIT 1 Date : 2024-11-16T10:10:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T10:10:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003657 post PendingInvicesDO 2 QSM-101003626 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003626 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b147e80c-2030-43ab-a17c-f3ad51fc49d0' LIMIT 1 Date : 2024-11-16T10:27:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T10:27:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003658 post PendingInvicesDO 2 QSM-101003627 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003627 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='95bd91f6-559d-44d1-9991-0e8f5b424ce7' LIMIT 1 Date : 2024-11-16T10:45:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T10:45:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003659 post PendingInvicesDO 2 QSM-101003628 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003628 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3c6bc0df-f307-47b5-ad25-831e45ddace8' LIMIT 1 Date : 2024-11-16T10:54:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T10:54:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003660 post PendingInvicesDO 2 QSM-101003629 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003629 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='858f24b1-ab4f-42f7-842b-8b5d86484f30' LIMIT 1 Date : 2024-11-16T11:21:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T11:21:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003661 post PendingInvicesDO 2 QSM-101003630 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003630 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='11b1e099-6abf-4d7f-9b09-3f14c9431df6' LIMIT 1 Date : 2024-11-16T13:22:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-16T13:22:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003662 post PendingInvicesDO 2 QSM-101003631 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003631 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1c5a1059-cc14-4070-936f-7caacfd1a0dd' LIMIT 1 Date : 2024-11-17T10:16:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-17T10:16:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003663 post PendingInvicesDO 2 QSM-101003633 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003633 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eeb60e09-daa9-4a01-8a0b-84776ae78b4d' LIMIT 1 Date : 2024-11-17T13:26:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-17T13:26:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003664 post PendingInvicesDO 2 QSM-101003634 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003634 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ad7c5673-b3e8-45e2-ba07-0f87f04f1cb8' LIMIT 1 Date : 2024-11-20T09:52:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T09:52:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003665 post PendingInvicesDO 2 QSM-101003635 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003635 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='59291498-23ed-4edd-8aa2-07d26bcef89d' LIMIT 1 Date : 2024-11-20T10:20:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T10:20:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003666 post PendingInvicesDO 2 QSM-101003636 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003636 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='943cd2cb-c244-4f5c-8f38-a262c5573957' LIMIT 1 Date : 2024-11-20T10:43:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T10:43:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003667 post PendingInvicesDO 2 QSM-101003637 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003637 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ef271c2e-86ae-4728-8cc3-9ab0afbff1c5' LIMIT 1 Date : 2024-11-20T11:12:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T11:12:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003668 post PendingInvicesDO 2 QSM-101003638 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003638 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b097cad6-6bfc-459a-9b48-4e6516542bfd' LIMIT 1 Date : 2024-11-20T12:23:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T12:23:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003669 post PendingInvicesDO 2 QSM-101003639 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003639 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cf62fc9d-53b9-4ac5-bc16-0244a4fb9e21' LIMIT 1 Date : 2024-11-20T12:47:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-20T12:47:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003670 post PendingInvicesDO 2 QSM-101003632 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003632 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-101003632' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003632' OR OrderId='QSM-101003632' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-20T15:54:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003671 post PendingInvicesDO 2 QSM-101003640 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003640 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1366ad43-1077-434f-a3eb-9d95d179c8d7' LIMIT 1 Date : 2024-11-21T09:43:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T09:43:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003672 post PendingInvicesDO 2 QSM-101003641 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003641 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='45eb742f-5c43-447c-9d53-5ca362d5461f' LIMIT 1 Date : 2024-11-21T09:57:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T09:57:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003673 post PendingInvicesDO 2 QSM-101003642 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003642 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='30d309bc-3cea-4e60-bddd-9531d23f19a0' LIMIT 1 Date : 2024-11-21T10:26:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T10:26:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003674 post PendingInvicesDO 2 QSM-101003643 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003643 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='23d2f396-9778-4968-9aa9-7cabbc461b87' LIMIT 1 Date : 2024-11-21T10:57:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T10:57:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003675 post PendingInvicesDO 2 QSM-101003644 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003644 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5fda9fba-94c7-4936-b4be-aa9f237bf89b' LIMIT 1 Date : 2024-11-21T11:23:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T11:23:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003676 post PendingInvicesDO 2 QSM-101003645 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003645 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='984549da-7f12-4ecc-bb5a-8914ec792017' LIMIT 1 Date : 2024-11-21T12:33:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T12:33:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003677 post PendingInvicesDO 2 QSM-101003646 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003646 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f1e8654-d00b-4295-8ac7-ac09051e757c' LIMIT 1 Date : 2024-11-21T14:18:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-21T14:18:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003678 post PendingInvicesDO 2 QSM-101003647 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003647 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1522a03b-66be-4d83-91d9-34886b089bb1' LIMIT 1 Date : 2024-11-23T10:16:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-23T10:16:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003679 post PendingInvicesDO 2 QSM-101003648 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003648 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9da5ea76-226d-4600-8efe-491bd0395c78' LIMIT 1 Date : 2024-11-23T10:55:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-23T10:55:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003680 post PendingInvicesDO 2 QSM-101003649 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003649 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a6baa66e-20bd-42cd-bdf9-1e6dd383300b' LIMIT 1 Date : 2024-11-23T11:12:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-23T11:12:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003681 post PendingInvicesDO 2 QSM-101003650 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003650 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-101003650' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003650' OR OrderId='QSM-101003650' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-23T11:50:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003682 post PendingInvicesDO 2 QSM-101003651 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003651 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6d7b6851-6d8b-453c-a764-bb1ac59b99a0' LIMIT 1 Date : 2024-11-23T12:09:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-23T12:09:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003684 post PendingInvicesDO 2 QSM-101003653 post PendingInvicesDO 2 QSM-101003652 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003683 post PendingInvicesDO 2 QSM-101003653 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003652 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003653 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-101003653' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003653' OR OrderId='QSM-101003653' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101003653' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003653' OR OrderId='QSM-101003653' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-23T13:00:05 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003685 post PendingInvicesDO 2 QSM-101003623 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003623 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-101003623' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003623' OR OrderId='QSM-101003623' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-23T15:32:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003686 post PendingInvicesDO 2 QSM-101003654 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003654 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='89b78c38-0740-49d7-badd-37afa02e2d2e' LIMIT 1 Date : 2024-11-24T09:26:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-24T09:26:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003687 post PendingInvicesDO 2 QSM-101003655 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003655 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20b6d22b-03ab-4dd7-9c09-02d91fd834d8' LIMIT 1 Date : 2024-11-24T09:55:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-24T09:55:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003688 post PendingInvicesDO 2 QSM-101003656 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003656 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ff1607e6-0749-4b2d-8504-44b5ee4f2101' LIMIT 1 Date : 2024-11-24T10:15:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-24T10:15:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003689 post PendingInvicesDO 2 QSM-101003657 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003657 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e68235ca-abec-48e6-947e-908c498973d9' LIMIT 1 Date : 2024-11-24T10:52:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-24T10:52:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003690 post PendingInvicesDO 2 QSM-101003658 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003658 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9db2329d-b253-4df5-afcb-84d7a5550db5' LIMIT 1 Date : 2024-11-24T14:01:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-24T14:01:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003691 post PendingInvicesDO 2 QSM-101003659 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003659 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='df692023-05f7-44d4-9ec8-6b282d37bf44' LIMIT 1 Date : 2024-11-25T09:44:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T09:44:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003692 post PendingInvicesDO 2 QSM-101003660 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003660 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ec29f211-8283-4ee6-a471-af81f00347bb' LIMIT 1 Date : 2024-11-25T10:23:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T10:23:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003693 post PendingInvicesDO 2 QSM-101003661 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003661 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b05262d4-37a0-4261-a8ab-d52e53e1662b' LIMIT 1 Date : 2024-11-25T10:40:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T10:40:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003694 post PendingInvicesDO 2 QSM-101003662 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003662 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6f072de6-dea8-489d-a5b8-96de5a989af7' LIMIT 1 Date : 2024-11-25T10:58:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T10:58:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003695 post PendingInvicesDO 2 QSM-101003663 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003663 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-101003663' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003663' OR OrderId='QSM-101003663' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-25T12:44:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003696 post PendingInvicesDO 2 QSM-101003664 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003664 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6504570b-aaba-4c7c-b23b-b110e04e100d' LIMIT 1 Date : 2024-11-25T13:07:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T13:07:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003697 post PendingInvicesDO 2 QSM-101003665 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003665 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0e947862-3094-44ab-9689-def417a98399' LIMIT 1 Date : 2024-11-25T13:24:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-25T13:24:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003698 post PendingInvicesDO 2 QSM-101003667 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003667 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3908db6d-6cd8-4518-862a-bd9001497f74' LIMIT 1 Date : 2024-11-26T10:08:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-26T10:08:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003699 post PendingInvicesDO 2 QSM-101003668 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003668 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f05a5624-7a16-4263-a06a-c79a6bb6237b' LIMIT 1 Date : 2024-11-26T10:58:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-26T10:58:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003700 post PendingInvicesDO 2 QSM-101003669 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003669 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d647c70a-2961-416f-a248-511474789ffe' LIMIT 1 Date : 2024-11-26T12:47:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-26T12:47:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003701 post PendingInvicesDO 2 QSM-101003670 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003670 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bc18df5-2172-44de-890b-282f9a6248d2' LIMIT 1 Date : 2024-11-26T15:30:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-26T15:30:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003702 post PendingInvicesDO 2 QSM-101003666 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003666 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-101003666' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003666' OR OrderId='QSM-101003666' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-26T15:32:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003703 post PendingInvicesDO 2 QSM-101003671 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003671 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='140ab4c3-7165-406e-bc20-7037a86ab939' LIMIT 1 Date : 2024-11-27T10:22:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T10:22:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003704 post PendingInvicesDO 2 QSM-101003672 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003672 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d00c99f-b662-4ab8-a8f6-146b853033c8' LIMIT 1 Date : 2024-11-27T10:53:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T10:53:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003705 post PendingInvicesDO 2 QSM-101003673 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003673 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0a702fa0-c7f9-4a05-b89d-84b4c1c43933' LIMIT 1 Date : 2024-11-27T11:07:18   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T11:07:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003706 post PendingInvicesDO 2 QSM-101003674 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003674 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='edc52e08-cd64-4d56-a2a3-443f917698fb' LIMIT 1 Date : 2024-11-27T12:36:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T12:36:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003707 post PendingInvicesDO 2 QSM-101003675 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003675 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='92ac6b8a-5a06-4cad-afcd-74c26df920aa' LIMIT 1 Date : 2024-11-27T13:10:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T13:10:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003708 post PendingInvicesDO 2 QSM-101003676 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003676 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3a3d0177-9972-4ef1-b48c-353d97f38c4e' LIMIT 1 Date : 2024-11-27T15:13:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-27T15:13:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003709 post PendingInvicesDO 2 QSM-101003677 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003677 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='afdac7cd-b8cd-4393-9108-0defae9ca633' LIMIT 1 Date : 2024-11-28T09:41:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T09:41:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003710 post PendingInvicesDO 2 QSM-101003678 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003678 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b44486f9-f410-4259-bb8a-7b99bfe4ee4b' LIMIT 1 Date : 2024-11-28T09:55:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T09:55:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003711 post PendingInvicesDO 2 QSM-101003680 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003680 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ccaf34f5-e20d-4829-9e20-6d6afdb475a9' LIMIT 1 Date : 2024-11-28T11:14:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T11:14:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003712 post PendingInvicesDO 2 QSM-101003681 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003681 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b96ad934-912b-433a-b4f1-703d11147fc7' LIMIT 1 Date : 2024-11-28T12:07:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T12:07:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003713 post PendingInvicesDO 2 QSM-101003682 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003682 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8757f4a8-9c6b-4263-a981-e4dc03d1e08d' LIMIT 1 Date : 2024-11-28T12:30:00   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T12:30:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003714 post PendingInvicesDO 2 QSM-101003683 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003683 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='df42c854-9492-43a1-b5ac-eb6951158943' LIMIT 1 Date : 2024-11-28T12:58:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-28T12:58:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003715 post PendingInvicesDO 2 QSM-101003679 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003679 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-101003679' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003679' OR OrderId='QSM-101003679' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-11-28T15:28:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003716 post PendingInvicesDO 2 QSM-101003684 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003684 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7e6b710a-cf87-4aff-adba-142532e7f73e' LIMIT 1 Date : 2024-11-30T09:54:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-30T09:54:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003717 post PendingInvicesDO 2 QSM-101003685 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003685 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='88588936-72d1-402f-8abb-d0ebe42347c6' LIMIT 1 Date : 2024-11-30T10:08:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-30T10:08:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003718 post PendingInvicesDO 2 QSM-101003686 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003686 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0a250662-026d-4c1b-b628-56a547be9929' LIMIT 1 Date : 2024-11-30T10:24:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-30T10:24:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003719 post PendingInvicesDO 2 QSM-101003687 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003687 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7b503910-8ad4-45eb-93c4-1cb27bf2e943' LIMIT 1 Date : 2024-11-30T10:52:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-30T10:52:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003720 post PendingInvicesDO 2 QSM-101003688 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003688 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='004c691f-710d-4de2-9208-33583e880988' LIMIT 1 Date : 2024-11-30T11:13:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-11-30T11:13:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003721 post PendingInvicesDO 2 QSM-101003689 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003689 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8ea13836-9ee9-40ad-9da6-8a8b3398a3c8' LIMIT 1 Date : 2024-12-01T10:15:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-01T10:15:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003722 post PendingInvicesDO 2 QSM-101003690 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003690 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f3b25286-9095-499c-bc63-1b72462a3734' LIMIT 1 Date : 2024-12-01T10:51:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-01T10:51:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003723 post PendingInvicesDO 2 QSM-101003691 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003691 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14483f1f-7eee-4039-a7af-07d4a266374e' LIMIT 1 Date : 2024-12-01T13:31:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-01T13:31:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003724 post PendingInvicesDO 2 QSM-101003692 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003692 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fec8a49f-ec41-457f-9ed9-b6ff86c31846' LIMIT 1 Date : 2024-12-02T10:39:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-02T10:39:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003725 post PendingInvicesDO 2 QSM-101003693 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003693 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a77e4461-7576-4ce0-922f-987b407e6831' LIMIT 1 Date : 2024-12-02T11:01:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-02T11:01:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003727 post PendingInvicesDO 2 QSM-101003695 post PendingInvicesDO 2 QSM-101003694 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003726 post PendingInvicesDO 2 QSM-101003695 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003694 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003695 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-101003695' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003695' OR OrderId='QSM-101003695' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101003695' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003695' OR OrderId='QSM-101003695' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-12-03T10:18:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003728 post PendingInvicesDO 2 QSM-101003698 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003698 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d3ee03f9-d45e-4598-aec3-1a3587c5f777' LIMIT 1 Date : 2024-12-03T10:50:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-03T10:50:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003729 post PendingInvicesDO 2 QSM-101003699 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003699 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='503b89cd-622b-44e3-8127-0ecd30c0b3ea' LIMIT 1 Date : 2024-12-04T10:03:04   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-04T10:03:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003730 post PendingInvicesDO 2 QSM-101003700 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003700 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='77c3c40b-ac22-47b7-a064-331daae92ea1' LIMIT 1 Date : 2024-12-04T10:23:28   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-04T10:23:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003731 post PendingInvicesDO 2 QSM-101003701 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003701 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7d8a85ae-6942-4058-b618-59ccd40d833b' LIMIT 1 Date : 2024-12-05T09:51:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-05T09:51:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003732 post PendingInvicesDO 2 QSM-101003702 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003702 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9c3c0871-c6fb-45ee-b283-91f5123e6b62' LIMIT 1 Date : 2024-12-05T10:17:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-05T10:17:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003733 post PendingInvicesDO 2 QSM-101003703 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003703 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0e2856f4-45f2-4aa1-9649-0c4ddd0e0c5b' LIMIT 1 Date : 2024-12-07T10:00:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-07T10:00:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003734 post PendingInvicesDO 2 QSM-101003704 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003704 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='64307e38-394d-4827-b52f-bc095782082f' LIMIT 1 Date : 2024-12-07T10:43:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-07T10:43:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003735 post PendingInvicesDO 2 QSM-101003705 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003705 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='df4cdbca-72af-4591-bc46-964d50b7b339' LIMIT 1 Date : 2024-12-07T11:26:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-07T11:26:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003736 post PendingInvicesDO 2 QSM-101003706 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003706 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a4727fe5-a225-4cbb-8ebe-a99988c62b07' LIMIT 1 Date : 2024-12-07T12:52:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-07T12:53:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003737 post PendingInvicesDO 2 QSM-101003708 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003708 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='835d95f3-117b-49bb-9da6-6c526b5218bd' LIMIT 1 Date : 2024-12-07T13:52:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-07T13:52:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003739 post PendingInvicesDO 2 QSM-101003697 post PendingInvicesDO 2 QSM-101003696 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003738 post PendingInvicesDO 2 QSM-101003697 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003696 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003697 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-101003697' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003697' OR OrderId='QSM-101003697' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101003697' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003697' OR OrderId='QSM-101003697' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-12-07T15:37:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003740 post PendingInvicesDO 2 QSM-101003709 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003709 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='20b1ea2d-448a-49d4-a5a9-8aa15d87b2c1' LIMIT 1 Date : 2024-12-08T09:43:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-08T09:43:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003741 post PendingInvicesDO 2 QSM-101003710 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003710 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='13ac96e7-e22a-4b40-92fe-4a4997d30106' LIMIT 1 Date : 2024-12-08T10:37:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-08T10:37:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003742 post PendingInvicesDO 2 QSM-101003711 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003711 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e780dc11-0795-4acc-a9b6-cc42e2f97c28' LIMIT 1 Date : 2024-12-08T11:19:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-08T11:19:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003744 post PendingInvicesDO 2 QSM-101003713 post PendingInvicesDO 2 QSM-101003712 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003743 post PendingInvicesDO 2 QSM-101003713 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003712 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003713 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79ce3fb6-fab0-4c02-b99a-65c19068e14f' LIMIT 1 Date : 2024-12-08T13:19:46  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='23baaf1c-d123-477d-a8dc-53ec2fbf4bd9' LIMIT 1 Date : 2024-12-08T13:19:47  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79ce3fb6-fab0-4c02-b99a-65c19068e14f' LIMIT 1 Date : 2024-12-08T13:19:47  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='23baaf1c-d123-477d-a8dc-53ec2fbf4bd9' LIMIT 1 Date : 2024-12-08T13:19:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2024-12-08T13:19:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003745 post PendingInvicesDO 2 QSM-101003714 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003714 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='41f2edca-931e-4bb2-b7f3-8124f65828a9' LIMIT 1 Date : 2024-12-09T10:00:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-09T10:00:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003746 post PendingInvicesDO 2 QSM-101003716 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003716 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9b2c827b-efde-4535-a27f-a5d829fa386f' LIMIT 1 Date : 2024-12-09T14:19:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-09T14:19:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003747 post PendingInvicesDO 2 QSM-101003717 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003717 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4ff3dc42-9333-4177-b491-16b94f1637fc' LIMIT 1 Date : 2024-12-10T10:35:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-10T10:35:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003748 post PendingInvicesDO 2 QSM-101003718 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003718 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b4bb1a6e-c071-4094-86e5-606527020bd1' LIMIT 1 Date : 2024-12-10T11:01:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-10T11:01:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003749 post PendingInvicesDO 2 QSM-101003719 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003719 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c996a43f-6120-49b6-a035-845995e8647d' LIMIT 1 Date : 2024-12-10T11:21:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-10T11:21:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003751 post PendingInvicesDO 2 QSM-101003721 post PendingInvicesDO 2 QSM-101003720 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003750 post PendingInvicesDO 2 QSM-101003721 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003720 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003721 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-101003721' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003721' OR OrderId='QSM-101003721' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'QSM-101003721' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003721' OR OrderId='QSM-101003721' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-12-10T12:36:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003752 post PendingInvicesDO 2 QSM-101003722 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003722 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c1e530aa-292c-467d-9200-515931d3f8da' LIMIT 1 Date : 2024-12-10T14:22:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-10T14:22:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003753 post PendingInvicesDO 2 QSM-101003723 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003723 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='83e1396c-e7b0-465d-99a9-225fc5ee3e80' LIMIT 1 Date : 2024-12-10T14:27:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-10T14:27:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003754 post PendingInvicesDO 2 QSM-101003715 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003715 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-101003715' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003715' OR OrderId='QSM-101003715' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-12-10T16:12:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003755 post PendingInvicesDO 2 QSM-101003724 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003724 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5e8ae1d3-a45e-4193-84e0-fbcea23c5d5a' LIMIT 1 Date : 2024-12-11T10:13:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-11T10:13:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003756 post PendingInvicesDO 2 QSM-101003725 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003725 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8afe422f-dc1c-49d4-83a8-1004c21cd44b' LIMIT 1 Date : 2024-12-11T10:42:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-11T10:42:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003757 post PendingInvicesDO 2 QSM-101003726 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003726 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='30af002c-e4e5-4c35-9ebb-e29850506ead' LIMIT 1 Date : 2024-12-11T11:01:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-11T11:01:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003758 post PendingInvicesDO 2 QSM-101003727 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003727 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2f662aac-1459-4fb1-985f-24eae96753c2' LIMIT 1 Date : 2024-12-11T11:41:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-11T11:41:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003759 post PendingInvicesDO 2 QSM-101003728 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003728 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d986c4f8-0c10-415c-8ba8-125b0e1a7a38' LIMIT 1 Date : 2024-12-12T09:23:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-12T09:23:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003760 post PendingInvicesDO 2 QSM-101003729 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003729 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79b36a36-fa87-4d8d-95d5-ef43afe589bd' LIMIT 1 Date : 2024-12-12T11:33:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-12T11:33:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003761 post PendingInvicesDO 2 QSM-101003730 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003730 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='24bb30ad-6d4a-46da-a898-58bd33f7a662' LIMIT 1 Date : 2024-12-12T14:23:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-12T14:23:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003762 post PendingInvicesDO 2 QSM-101003731 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003731 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d0e5d419-38ea-4cc9-9596-c80b5e794ce6' LIMIT 1 Date : 2024-12-12T16:31:42   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-12T16:31:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003763 post PendingInvicesDO 2 QSM-101003732 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003732 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='502a6649-ff3e-406b-b11a-40ad4c702f3c' LIMIT 1 Date : 2024-12-14T10:35:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-14T10:35:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003764 post PendingInvicesDO 2 QSM-101003733 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003733 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='73779d5d-1c06-428a-aed4-2fd605d30dc9' LIMIT 1 Date : 2024-12-14T10:51:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-14T10:51:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003765 post PendingInvicesDO 2 QSM-101003734 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003734 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ca2fc6d5-73a5-48af-ba46-793e8cd419af' LIMIT 1 Date : 2024-12-14T11:12:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-14T11:12:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003766 post PendingInvicesDO 2 QSM-101003735 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003735 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8bc47ed2-727c-46a1-9380-fc6349fae8fa' LIMIT 1 Date : 2024-12-15T10:35:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-15T10:35:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003767 post PendingInvicesDO 2 QSM-101003736 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003736 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9bc8da04-e1fb-4e97-8034-333e9e2db220' LIMIT 1 Date : 2024-12-16T11:22:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-16T11:22:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003768 post PendingInvicesDO 2 QSM-101003707 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003707 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-101003707' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003707' OR OrderId='QSM-101003707' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2024-12-16T15:39:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003769 post PendingInvicesDO 2 QSM-101003737 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003737 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c3e8f338-dd04-4c25-90db-81e992ffd928' LIMIT 1 Date : 2024-12-17T10:28:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-17T10:29:00 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003770 post PendingInvicesDO 2 QSM-101003738 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003738 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6754bfa3-ed6a-4d70-9619-bf77dbc0712e' LIMIT 1 Date : 2024-12-18T10:09:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-18T10:09:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003771 post PendingInvicesDO 2 QSM-101003739 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003739 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='70010797-f1b4-4416-853b-ef5df220067f' LIMIT 1 Date : 2024-12-19T10:40:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-19T10:40:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003772 post PendingInvicesDO 2 QSM-101003740 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003740 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d99cb46c-b0a8-49fa-8b76-f36fe9251d53' LIMIT 1 Date : 2024-12-19T11:18:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-19T11:18:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003773 post PendingInvicesDO 2 QSM-101003741 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003741 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7356903e-e7cd-49c8-9aa0-ae3c68e2ba79' LIMIT 1 Date : 2024-12-19T12:36:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-19T12:36:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003774 post PendingInvicesDO 2 QSM-101003742 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003742 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3312889c-98ab-4bc0-a35a-7a6e243d38e6' LIMIT 1 Date : 2024-12-21T10:07:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-21T10:07:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003775 post PendingInvicesDO 2 QSM-101003743 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003743 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='37a0cdee-e84e-4bf1-8129-1f462677ad00' LIMIT 1 Date : 2024-12-21T13:02:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-21T13:02:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003776 post PendingInvicesDO 2 QSM-101003744 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003744 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5b195ded-f0d9-4f21-b6ef-86fdc53260aa' LIMIT 1 Date : 2024-12-21T13:41:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-21T13:41:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003777 post PendingInvicesDO 2 QSM-101003745 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003745 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ad0941a4-9f50-4701-b496-e6cd0d556951' LIMIT 1 Date : 2024-12-22T10:02:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-22T10:02:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003778 post PendingInvicesDO 2 QSM-101003746 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003746 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9d6f7f3d-254d-4cb4-9918-67444e6734ad' LIMIT 1 Date : 2024-12-23T09:48:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-23T09:48:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003779 post PendingInvicesDO 2 QSM-101003747 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003747 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dc0b48ff-24bc-4bb8-b191-dd854405dfeb' LIMIT 1 Date : 2024-12-24T10:22:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-24T10:22:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003780 post PendingInvicesDO 2 QSM-101003748 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003748 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='27d8a35d-d025-43d2-9d53-4b7894d6a0e0' LIMIT 1 Date : 2024-12-24T10:39:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-24T10:39:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003781 post PendingInvicesDO 2 QSM-101003749 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003749 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2e33985d-8f3c-4f66-85c5-f192cbb551da' LIMIT 1 Date : 2024-12-24T10:53:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-24T10:53:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003782 post PendingInvicesDO 2 QSM-101003750 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003750 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2f8f182e-96de-438e-8fe5-e89699509759' LIMIT 1 Date : 2024-12-24T11:01:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-24T11:01:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003783 post PendingInvicesDO 2 QSM-101003751 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003751 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='21f6dde6-0de9-496f-94fd-ef25a2cc957f' LIMIT 1 Date : 2024-12-26T10:38:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-26T10:38:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003784 post PendingInvicesDO 2 QSM-101003752 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003752 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='534687a8-794a-461d-a44d-8700fa7c871c' LIMIT 1 Date : 2024-12-26T11:12:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-26T11:12:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003785 post PendingInvicesDO 2 QSM-101003753 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003753 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c0c3b69a-50d3-43d7-af41-4d648b1af3ca' LIMIT 1 Date : 2024-12-26T11:26:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-26T11:26:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003786 post PendingInvicesDO 2 QSM-101003754 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003754 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='09397fd2-da46-4765-a025-831ca8c697c1' LIMIT 1 Date : 2024-12-26T11:51:38   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-26T11:51:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003787 post PendingInvicesDO 2 QSM-101003755 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003755 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='449cb1ca-bda9-4950-97ac-0809688e3848' LIMIT 1 Date : 2024-12-26T12:07:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2024-12-26T12:07:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003788 post PendingInvicesDO 2 QSM-101003756 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003756 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-101003756' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003756' OR OrderId='QSM-101003756' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-18T09:51:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003789 post PendingInvicesDO 2 QSM-101003757 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003757 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7e2d785a-84d6-4dca-826d-cab527a88fea' LIMIT 1 Date : 2025-03-18T10:41:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T10:41:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003791 post PendingInvicesDO 2 QSM-101003760 post PendingInvicesDO 2 QSM-101003759 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 QSM-104003790 post PendingInvicesDO 2 QSM-101003760 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : QSM-101003759 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003760 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ebf12f22-33c1-4333-9e9e-b30848bf97c8' LIMIT 1 Date : 2025-03-18T11:38:30  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f26b5b77-7b0a-4b36-9ac8-1348cbeff509' LIMIT 1 Date : 2025-03-18T11:38:30  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ebf12f22-33c1-4333-9e9e-b30848bf97c8' LIMIT 1 Date : 2025-03-18T11:38:30  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f26b5b77-7b0a-4b36-9ac8-1348cbeff509' LIMIT 1 Date : 2025-03-18T11:38:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-03-18T11:38:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003792 post PendingInvicesDO 2 QSM-101003761 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003761 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-101003761' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003761' OR OrderId='QSM-101003761' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-18T12:40:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003793 post PendingInvicesDO 2 QSM-101003762 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003762 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a20f7687-b791-4132-8b8d-c18437762171' LIMIT 1 Date : 2025-03-18T13:20:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T13:20:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003794 post PendingInvicesDO 2 QSM-101003763 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003763 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fe7ab97b-1f66-41c4-b708-445a67115bde' LIMIT 1 Date : 2025-03-18T14:10:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T14:10:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003795 post PendingInvicesDO 2 QSM-101003764 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003764 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d1a7346-a13e-4667-a8f5-03fae5af3fe6' LIMIT 1 Date : 2025-03-18T14:33:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T14:33:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003796 post PendingInvicesDO 2 QSM-101003766 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003766 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-101003766' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003766' OR OrderId='QSM-101003766' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-18T16:26:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003797 post PendingInvicesDO 2 QSM-101003767 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003767 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='aec6ae5b-15be-4731-ac53-ed9a5af4b1d1' LIMIT 1 Date : 2025-03-18T16:30:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T16:30:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003798 post PendingInvicesDO 2 QSM-101003768 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003768 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f246d9c-bf19-4429-9a6a-badd33846e5f' LIMIT 1 Date : 2025-03-18T16:38:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-18T16:38:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003799 post PendingInvicesDO 2 QSM-101003769 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003769 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3429c346-0239-4a07-9729-4ba332fee295' LIMIT 1 Date : 2025-03-19T10:07:23   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-19T10:07:24 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003800 post PendingInvicesDO 2 QSM-101003770 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003770 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3429c346-0239-4a07-9729-4ba332fee295' LIMIT 1 Date : 2025-03-19T10:08:56 QSM-101003769  performInsertPayment totalCNVal 0.0 duplicate happened  performInsertPayment duplicate 2025-03-19T10:08:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003800 post PendingInvicesDO 2 QSM-101003770 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003770 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9b4c97d0-9318-4ba3-9659-1319c51c5d12' LIMIT 1 Date : 2025-03-19T10:40:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-19T10:40:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003801 post PendingInvicesDO 2 QSM-101003758 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003758 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-101003758' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003758' OR OrderId='QSM-101003758' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-19T10:50:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003802 post PendingInvicesDO 2 QSM-101003771 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003771 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3660ec19-4933-4cb1-94d7-6532ac32acb0' LIMIT 1 Date : 2025-03-19T11:25:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-19T11:25:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003803 post PendingInvicesDO 2 QSM-101003772 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003772 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e5c736da-8298-4ebd-a521-07d1adc50441' LIMIT 1 Date : 2025-03-19T13:03:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-19T13:03:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003804 post PendingInvicesDO 2 QSM-101003773 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003773 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-101003773' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='QSM-101003773' OR OrderId='QSM-101003773' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-03-19T13:44:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003805 post PendingInvicesDO 2 QSM-101003774 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003774 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3e628204-2e75-4733-95ad-94243d5875b1' LIMIT 1 Date : 2025-03-19T14:44:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-19T14:44:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003806 post PendingInvicesDO 2 QSM-101003775 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003775 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='db12875f-91bf-4b5a-8eb0-c4102cbec6bf' LIMIT 1 Date : 2025-03-20T12:49:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-20T12:49:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 QSM-104003807 post PendingInvicesDO 2 QSM-101003776 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : QSM-101003776 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5fde64eb-5298-43b9-8a1b-cc32596f456f' LIMIT 1 Date : 2025-03-20T13:31:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-03-20T13:31:41 payment end 
