 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001759 post PendingInvicesDO 2 BSH-061001768 post PendingInvicesDO 2 BSH-061001767 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001758 post PendingInvicesDO 2 BSH-061001768 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001767 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001768 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f854f846-bf61-4a57-a31f-b57dfd5a0a97' LIMIT 1 Date : 2025-10-13T18:39:35  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2ff423c5-e62e-4409-aaab-86f78c7882b7' LIMIT 1 Date : 2025-10-13T18:39:35  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f854f846-bf61-4a57-a31f-b57dfd5a0a97' LIMIT 1 Date : 2025-10-13T18:39:35  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2ff423c5-e62e-4409-aaab-86f78c7882b7' LIMIT 1 Date : 2025-10-13T18:39:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-13T18:39:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001761 post PendingInvicesDO 2 BSH-061001770 post PendingInvicesDO 2 BSH-061001769 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001760 post PendingInvicesDO 2 BSH-061001770 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001769 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001770 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d6f7c9e-a0f1-40ae-97ee-9bae244e0f1d' LIMIT 1 Date : 2025-10-14T11:15:49  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9309ef51-4ed6-4eaa-bbe5-afbaf885b51a' LIMIT 1 Date : 2025-10-14T11:15:49  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d6f7c9e-a0f1-40ae-97ee-9bae244e0f1d' LIMIT 1 Date : 2025-10-14T11:15:49  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9309ef51-4ed6-4eaa-bbe5-afbaf885b51a' LIMIT 1 Date : 2025-10-14T11:15:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-14T11:15:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001762 post PendingInvicesDO 2 BSH-061001771 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001771 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='12ab115a-e142-4e60-b19e-73fce926a1f8' LIMIT 1 Date : 2025-10-14T11:57:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T11:57:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001763 post PendingInvicesDO 2 BSH-061001772 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001772 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='aa74ba0a-85fd-4977-b254-124b906d83da' LIMIT 1 Date : 2025-10-14T12:26:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T12:26:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001764 post PendingInvicesDO 2 BSH-061001773 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001773 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ace89b23-67d1-4abe-a5b8-52b89cf5cb14' LIMIT 1 Date : 2025-10-14T12:40:48   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T12:40:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001765 post PendingInvicesDO 2 BSH-061001774 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001774 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bf7f2f0-d16d-4e8a-9869-3f14ecae3be9' LIMIT 1 Date : 2025-10-14T13:07:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:07:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001766 post PendingInvicesDO 2 BSH-061001775 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001775 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8f449f6d-4149-4e71-8f22-1945c70d1a68' LIMIT 1 Date : 2025-10-14T13:33:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:33:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001767 post PendingInvicesDO 2 BSH-061001776 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001776 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8d10d3d5-2acb-4d9f-9188-bdb8caee93e3' LIMIT 1 Date : 2025-10-14T13:53:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T13:53:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001768 post PendingInvicesDO 2 BSH-061001777 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001777 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='73b57e22-4209-49a8-a5c9-7b7f135fe487' LIMIT 1 Date : 2025-10-14T14:17:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T14:17:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001769 post PendingInvicesDO 2 BSH-061001778 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001778 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eec1265f-a29e-4f0a-a2e8-c5076fa9c09c' LIMIT 1 Date : 2025-10-14T14:52:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-14T14:52:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001771 post PendingInvicesDO 2 BSH-061001783 post PendingInvicesDO 2 BSH-061001782 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001770 post PendingInvicesDO 2 BSH-061001783 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001782 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001783 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07383dd6-ee75-44a7-8f73-7b807574e026' LIMIT 1 Date : 2025-10-14T20:51:52  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31e974cd-1525-471f-b6b9-40e7838f0de9' LIMIT 1 Date : 2025-10-14T20:51:52  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='07383dd6-ee75-44a7-8f73-7b807574e026' LIMIT 1 Date : 2025-10-14T20:51:52  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='31e974cd-1525-471f-b6b9-40e7838f0de9' LIMIT 1 Date : 2025-10-14T20:51:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-14T20:51:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001772 post PendingInvicesDO 2 BSH-061001642 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001642 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 = 'BSH-061001642' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001642' OR OrderId='BSH-061001642' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T09:15:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001773 post PendingInvicesDO 2 BSH-061001647 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001647 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 = 'BSH-061001647' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001647' OR OrderId='BSH-061001647' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T09:15:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001774 post PendingInvicesDO 2 BSH-061001784 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001784 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='00b30d9a-c734-42e5-9cb2-332861d57a4f' LIMIT 1 Date : 2025-10-15T13:20:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T13:20:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001775 post PendingInvicesDO 2 BSH-061001785 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001785 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e79ca506-a41c-482b-9a87-376c5062bdf3' LIMIT 1 Date : 2025-10-15T13:41:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T13:41:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001776 post PendingInvicesDO 2 BSH-061001788 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001788 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8cac5b21-18bf-4da6-8a8e-e88af20d4bcd' LIMIT 1 Date : 2025-10-15T15:43:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T15:43:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001777 post PendingInvicesDO 2 BSH-061001789 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001789 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3fdcd7a7-eeeb-421b-8b41-f408fae25f57' LIMIT 1 Date : 2025-10-15T16:16:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T16:16:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001778 post PendingInvicesDO 2 BSH-061001790 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001790 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b9eb6294-ce96-4ec7-b506-b6d5797a65ac' LIMIT 1 Date : 2025-10-15T16:35:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T16:35:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001779 post PendingInvicesDO 2 BSH-061001791 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001791 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b16121c6-5d45-474c-b762-a6fd03ba410e' LIMIT 1 Date : 2025-10-15T17:09:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T17:09:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001780 post PendingInvicesDO 2 BSH-061001792 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001792 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ffb24c79-8053-464d-b523-5482ba0867c2' LIMIT 1 Date : 2025-10-15T18:34:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T18:34:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001781 post PendingInvicesDO 2 BSH-061001793 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001793 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cb05e0a2-37bd-4791-b650-8cd986cf6044' LIMIT 1 Date : 2025-10-15T19:03:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T19:03:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001782 post PendingInvicesDO 2 BSH-061001794 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001794 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c6326d99-441a-4f85-9573-8ef134a4c6f0' LIMIT 1 Date : 2025-10-15T20:04:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:04:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001783 post PendingInvicesDO 2 BSH-061001795 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001795 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d855a723-b46d-4dcd-944f-d8c41215ca7f' LIMIT 1 Date : 2025-10-15T20:30:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:30:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001784 post PendingInvicesDO 2 BSH-061001780 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001780 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 = 'BSH-061001780' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001780' OR OrderId='BSH-061001780' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T20:52:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001785 post PendingInvicesDO 2 BSH-061001796 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001796 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bd4407f9-4704-4047-a2dd-b99765898d13' LIMIT 1 Date : 2025-10-15T20:54:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-15T20:54:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001786 post PendingInvicesDO 2 BSH-061001667 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001667 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 = 'BSH-061001667' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001667' OR OrderId='BSH-061001667' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-15T23:58:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001787 post PendingInvicesDO 2 BSH-061001687 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001687 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 = 'BSH-061001687' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001687' OR OrderId='BSH-061001687' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T10:08:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001788 post PendingInvicesDO 2 BSH-061001713 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001713 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 = 'BSH-061001713' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001713' OR OrderId='BSH-061001713' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T11:46:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001789 post PendingInvicesDO 2 BSH-061001801 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001801 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b1ceb46e-a95f-47bd-84ef-ba09da9b9f08' LIMIT 1 Date : 2025-10-16T13:02:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T13:02:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001790 post PendingInvicesDO 2 BSH-061001718 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001718 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 = 'BSH-061001718' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001718' OR OrderId='BSH-061001718' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T13:37:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001791 post PendingInvicesDO 2 BSH-061001803 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001803 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='75224583-57a1-43a6-b2c1-3b37a75dcb50' LIMIT 1 Date : 2025-10-16T16:03:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:03:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001792 post PendingInvicesDO 2 BSH-061001804 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001804 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='107e5a8b-281e-4d8e-a8be-382b70154f03' LIMIT 1 Date : 2025-10-16T16:13:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:13:23 payment end 
 performInsertPayment 1 post payment 2 performInsertPayment 3 mode performInsertPayment 10 BSH-064001793 post PendingInvicesDO 2 BSH-061001805 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001805 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5c5b801d-24a4-4628-9f51-63a1c1830ac7' LIMIT 1 Date : 2025-10-16T16:35:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:35:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001794 post PendingInvicesDO 2 BSH-061001806 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001806 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0502d307-cce8-4928-b89d-0612e7af66b9' LIMIT 1 Date : 2025-10-16T16:58:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T16:58:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001795 post PendingInvicesDO 2 BSH-061001740 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001740 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 = 'BSH-061001740' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001740' OR OrderId='BSH-061001740' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-16T17:24:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001796 post PendingInvicesDO 2 BSH-061001808 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001808 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f958d27d-64a4-4d75-8713-5a8b5e7739b0' LIMIT 1 Date : 2025-10-16T18:11:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T18:11:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001797 post PendingInvicesDO 2 BSH-061001809 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001809 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6cc8401c-a961-4282-a726-d25b0f99e962' LIMIT 1 Date : 2025-10-16T19:04:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T19:04:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001798 post PendingInvicesDO 2 BSH-061001810 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001810 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8e60296c-d5a0-4a39-9fc5-85def17cc0cf' LIMIT 1 Date : 2025-10-16T19:58:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T19:58:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001799 post PendingInvicesDO 2 BSH-061001811 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001811 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d10e282f-be3d-43c6-b2a3-97a3044265c2' LIMIT 1 Date : 2025-10-16T20:54:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-16T20:54:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001800 post PendingInvicesDO 2 BSH-061001812 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001812 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d18676bd-f973-4d55-a5f0-7dd873279486' LIMIT 1 Date : 2025-10-18T10:02:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:02:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001801 post PendingInvicesDO 2 BSH-061001813 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001813 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c752cbec-5438-47f5-8d0b-ddaccb4d9418' LIMIT 1 Date : 2025-10-18T10:35:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:35:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001802 post PendingInvicesDO 2 BSH-061001814 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001814 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='45c6f683-de65-4b3a-a7b9-3e3e57ad9be4' LIMIT 1 Date : 2025-10-18T10:51:31   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T10:51:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001803 post PendingInvicesDO 2 BSH-061001815 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001815 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e440c7bf-8ccb-4085-8c3f-ed27c440e15c' LIMIT 1 Date : 2025-10-18T11:05:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:05:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001804 post PendingInvicesDO 2 BSH-061001816 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001816 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8aec90a4-a42f-465e-b885-57cbf183c8b6' LIMIT 1 Date : 2025-10-18T11:27:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:27:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001805 post PendingInvicesDO 2 BSH-061001817 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001817 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4eeacecc-2878-4e73-b873-4ed3e1d79db8' LIMIT 1 Date : 2025-10-18T11:45:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T11:45:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001806 post PendingInvicesDO 2 BSH-061001818 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001818 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a5634a8d-8d8e-459a-ba33-0c07f6ab80d6' LIMIT 1 Date : 2025-10-18T12:25:50   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:25:51 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001807 post PendingInvicesDO 2 BSH-061001819 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001819 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='84d9719a-8a9b-4b7b-84be-0465261a5aca' LIMIT 1 Date : 2025-10-18T12:45:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T12:45:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001808 post PendingInvicesDO 2 BSH-061001820 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001820 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='978660db-a59a-4da8-98f1-f5a40aa74843' LIMIT 1 Date : 2025-10-18T13:01:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T13:01:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001809 post PendingInvicesDO 2 BSH-061001695 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001695 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 = 'BSH-061001695' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001695' OR OrderId='BSH-061001695' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-18T13:29:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001810 post PendingInvicesDO 2 BSH-061001823 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001823 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='982d300a-9031-432f-a2a0-9bd6955ea0d9' LIMIT 1 Date : 2025-10-18T14:50:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T14:50:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001811 post PendingInvicesDO 2 BSH-061001824 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001824 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='389855d6-fe97-485d-b596-5e5db00ab3ea' LIMIT 1 Date : 2025-10-18T15:12:08   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T15:12:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001812 post PendingInvicesDO 2 BSH-061001825 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001825 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a1dadf4b-eecd-48b4-b599-a53570285d9c' LIMIT 1 Date : 2025-10-18T17:08:14   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T17:08:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001813 post PendingInvicesDO 2 BSH-061001826 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001826 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4f000698-6fe3-4ef9-9ec1-e3e8fd30ca1e' LIMIT 1 Date : 2025-10-18T17:47:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T17:47:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001815 post PendingInvicesDO 2 BSH-061001828 post PendingInvicesDO 2 BSH-061001827 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001814 post PendingInvicesDO 2 BSH-061001828 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001827 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001828 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='44bcec4a-8c05-4fe3-9a09-23dab868e293' LIMIT 1 Date : 2025-10-18T18:17:12  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ee15125c-8ed3-44ba-8abe-9d889f9ab158' LIMIT 1 Date : 2025-10-18T18:17:12  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='44bcec4a-8c05-4fe3-9a09-23dab868e293' LIMIT 1 Date : 2025-10-18T18:17:12  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ee15125c-8ed3-44ba-8abe-9d889f9ab158' LIMIT 1 Date : 2025-10-18T18:17:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-18T18:17:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001816 post PendingInvicesDO 2 BSH-061001829 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001829 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14d3b719-d72d-40c4-8b8c-1bdfc32c070d' LIMIT 1 Date : 2025-10-18T18:35:24   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-18T18:35:25 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001817 post PendingInvicesDO 2 BSH-061001830 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001830 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bd1976d-29fb-40cc-b221-8017a0794353' LIMIT 1 Date : 2025-10-19T13:05:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T13:05:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001818 post PendingInvicesDO 2 BSH-061001832 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001832 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3c27f1ac-f3a0-45bc-8940-3c2a6507f0c1' LIMIT 1 Date : 2025-10-19T13:55:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T13:55:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001819 post PendingInvicesDO 2 BSH-061001833 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001833 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='09f15cf2-dbbd-4c7a-b174-cb739f1d070d' LIMIT 1 Date : 2025-10-19T14:32:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T14:32:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001820 post PendingInvicesDO 2 BSH-061001834 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001834 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6071b8e0-9859-40c4-91be-5a92cffb70f2' LIMIT 1 Date : 2025-10-19T15:08:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T15:08:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001821 post PendingInvicesDO 2 BSH-061001835 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001835 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='957d88a8-5137-4ffe-bb54-91e9ddc386a0' LIMIT 1 Date : 2025-10-19T16:17:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T16:17:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001822 post PendingInvicesDO 2 BSH-061001836 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001836 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ac2bdce0-d68f-4e51-b288-3b176ae02d55' LIMIT 1 Date : 2025-10-19T17:05:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T17:05:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001823 post PendingInvicesDO 2 BSH-061001837 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001837 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fd9d6a91-3a61-4ce7-9009-9de7a936a909' LIMIT 1 Date : 2025-10-19T17:45:33   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T17:45:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001824 post PendingInvicesDO 2 BSH-061001838 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001838 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2d41d427-bf27-4224-afbb-e5aa7dde55fd' LIMIT 1 Date : 2025-10-19T18:50:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-19T18:50:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001825 post PendingInvicesDO 2 BSH-061001839 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001839 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e14188ae-a0a2-41dd-9689-41a6e49d27c2' LIMIT 1 Date : 2025-10-20T09:47:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T09:47:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001826 post PendingInvicesDO 2 BSH-061001840 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001840 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3abd84c1-aa40-4a0e-bb28-4a0531fc62fc' LIMIT 1 Date : 2025-10-20T10:05:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:05:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001827 post PendingInvicesDO 2 BSH-061001841 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001841 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9bfaa199-26ef-4e3c-84e8-b3147104a557' LIMIT 1 Date : 2025-10-20T10:44:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T10:44:01 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001828 post PendingInvicesDO 2 BSH-061001842 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001842 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='40ed4848-84dc-457b-afb5-45a750511dca' LIMIT 1 Date : 2025-10-20T11:14:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:14:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001829 post PendingInvicesDO 2 BSH-061001843 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001843 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1f688abb-d1aa-4c20-984d-035cd7bbbeed' LIMIT 1 Date : 2025-10-20T11:30:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:30:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001831 post PendingInvicesDO 2 BSH-061001845 post PendingInvicesDO 2 BSH-061001844 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001830 post PendingInvicesDO 2 BSH-061001845 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001844 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001845 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4320b72-b634-4bae-a71b-c053b57cbc5d' LIMIT 1 Date : 2025-10-20T11:36:09  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4725bb9a-5143-458a-b155-a9af4d835f08' LIMIT 1 Date : 2025-10-20T11:36:09  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f4320b72-b634-4bae-a71b-c053b57cbc5d' LIMIT 1 Date : 2025-10-20T11:36:09  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4725bb9a-5143-458a-b155-a9af4d835f08' LIMIT 1 Date : 2025-10-20T11:36:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-20T11:36:10 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001832 post PendingInvicesDO 2 BSH-061001846 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001846 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7e9ef98d-ba20-488a-be1b-93c2640be727' LIMIT 1 Date : 2025-10-20T11:50:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-20T11:50:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001833 post PendingInvicesDO 2 BSH-061001849 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001849 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='cd1aa757-d47a-419a-97ce-852b15438d04' LIMIT 1 Date : 2025-10-21T11:02:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T11:02:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001834 post PendingInvicesDO 2 BSH-061001850 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001850 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9ff9f983-ae2c-4bb8-b897-4af447aa9ae2' LIMIT 1 Date : 2025-10-21T12:05:39   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T12:05:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001835 post PendingInvicesDO 2 BSH-061001851 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001851 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='344b4c0a-01d7-4777-953f-73d28756f612' LIMIT 1 Date : 2025-10-21T12:48:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T12:48:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001836 post PendingInvicesDO 2 BSH-061001852 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001852 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='49cc5178-4412-4ee0-96f4-0bdad6174ce3' LIMIT 1 Date : 2025-10-21T13:20:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T13:20:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001837 post PendingInvicesDO 2 BSH-061001853 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001853 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='bb12c495-d495-4b6d-beb0-2696c380230f' LIMIT 1 Date : 2025-10-21T14:13:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T14:13:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001838 post PendingInvicesDO 2 BSH-061001854 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001854 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76f7367d-b766-4f91-bf87-fb638985d322' LIMIT 1 Date : 2025-10-21T14:40:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T14:40:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001839 post PendingInvicesDO 2 BSH-061001855 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001855 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4dff6711-2d7c-44d3-9e0d-9c3025af96a5' LIMIT 1 Date : 2025-10-21T16:42:53   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T16:42:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001840 post PendingInvicesDO 2 BSH-061001856 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001856 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='adeeb4e1-31a5-4a8f-8298-e2fd59ee0db0' LIMIT 1 Date : 2025-10-21T17:10:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T17:10:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001841 post PendingInvicesDO 2 BSH-061001857 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001857 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='83de1c74-eda2-46d6-9cf7-c599922ce226' LIMIT 1 Date : 2025-10-21T17:54:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-21T17:54:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001842 post PendingInvicesDO 2 BSH-061001715 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001715 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 = 'BSH-061001715' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001715' OR OrderId='BSH-061001715' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T09:29:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001843 post PendingInvicesDO 2 BSH-061001800 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001800 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 = 'BSH-061001800' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001800' OR OrderId='BSH-061001800' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T09:30:49 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001844 post PendingInvicesDO 2 BSH-061001694 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001694 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 = 'BSH-061001694' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001694' OR OrderId='BSH-061001694' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T09:33:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001845 post PendingInvicesDO 2 BSH-061001859 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001859 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='baf0504c-7cfe-4382-a1c0-3a5b69e72988' LIMIT 1 Date : 2025-10-22T13:21:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T13:21:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001846 post PendingInvicesDO 2 BSH-061001860 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001860 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='eb26b412-7229-4afc-80aa-88c701f60289' LIMIT 1 Date : 2025-10-22T13:37:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T13:37:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001847 post PendingInvicesDO 2 BSH-061001786 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001786 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 = 'BSH-061001786' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001786' OR OrderId='BSH-061001786' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T14:09:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001848 post PendingInvicesDO 2 BSH-061001862 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001862 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1b579aa7-2521-4157-ac8f-272bd1333633' LIMIT 1 Date : 2025-10-22T14:32:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T14:32:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001849 post PendingInvicesDO 2 BSH-061001863 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001863 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7f9cfb5f-40d7-4af3-8edd-2a0b14447dbf' LIMIT 1 Date : 2025-10-22T14:49:05   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T14:49:06 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001850 post PendingInvicesDO 2 BSH-061001864 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001864 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e5fa9f47-a6e5-4326-bd88-5ab2d3e46ea7' LIMIT 1 Date : 2025-10-22T14:58:34   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T14:58:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001851 post PendingInvicesDO 2 BSH-061001787 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001787 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 = 'BSH-061001787' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001787' OR OrderId='BSH-061001787' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T15:19:30 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001852 post PendingInvicesDO 2 BSH-061001749 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001749 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 = 'BSH-061001749' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001749' OR OrderId='BSH-061001749' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-22T16:00:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001853 post PendingInvicesDO 2 BSH-061001868 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001868 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2eb76d77-57ff-48d7-929c-05b348858370' LIMIT 1 Date : 2025-10-22T16:27:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T16:27:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001854 post PendingInvicesDO 2 BSH-061001869 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001869 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='642225c6-3aa5-48b6-973a-401ac7f5411a' LIMIT 1 Date : 2025-10-22T16:30:20   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T16:30:21 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001855 post PendingInvicesDO 2 BSH-061001870 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001870 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a6e28061-1a22-40b7-bbfb-6d9c63591599' LIMIT 1 Date : 2025-10-22T16:38:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T16:38:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001856 post PendingInvicesDO 2 BSH-061001871 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001871 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76b0b748-abe9-4514-badc-6d602a077231' LIMIT 1 Date : 2025-10-22T16:44:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T16:44:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001857 post PendingInvicesDO 2 BSH-061001872 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001872 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3d2afe76-2803-41bb-9538-ef28d41cebb9' LIMIT 1 Date : 2025-10-22T16:50:41   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T16:50:42 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001858 post PendingInvicesDO 2 BSH-061001874 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001874 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='575cea62-cb0c-428b-a76c-2ddef658a207' LIMIT 1 Date : 2025-10-22T18:15:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T18:15:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001859 post PendingInvicesDO 2 BSH-061001875 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001875 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='33a3cd04-5f79-4644-b378-51473b0c5790' LIMIT 1 Date : 2025-10-22T18:26:10   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T18:26:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001860 post PendingInvicesDO 2 BSH-061001876 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001876 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f3c92a7c-23b0-4ba1-9ca3-f7821097364c' LIMIT 1 Date : 2025-10-22T18:49:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-22T18:49:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001861 post PendingInvicesDO 2 BSH-061001831 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001831 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 = 'BSH-061001831' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001831' OR OrderId='BSH-061001831' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T11:06:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001862 post PendingInvicesDO 2 BSH-061001877 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001877 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b5c6dfc8-65b6-4891-af65-34850d2a17e9' LIMIT 1 Date : 2025-10-23T11:16:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T11:16:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001863 post PendingInvicesDO 2 BSH-061001878 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001878 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='51588b66-7ffb-4726-adb7-567e8b2e7dcf' LIMIT 1 Date : 2025-10-23T11:37:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T11:37:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001864 post PendingInvicesDO 2 BSH-061001879 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001879 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f43b91c1-b462-46e3-b818-e29f49498b07' LIMIT 1 Date : 2025-10-23T11:52:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T11:52:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001865 post PendingInvicesDO 2 BSH-061001802 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001802 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 = 'BSH-061001802' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001802' OR OrderId='BSH-061001802' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T12:10:45 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001866 post PendingInvicesDO 2 BSH-061001881 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001881 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='86504d7f-146f-4de1-92b9-f1c4e9b70f80' LIMIT 1 Date : 2025-10-23T12:35:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T12:35:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001867 post PendingInvicesDO 2 BSH-061001882 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001882 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='736daf49-b6cb-4083-9012-f1a9e1de4033' LIMIT 1 Date : 2025-10-23T12:47:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T12:47:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001868 post PendingInvicesDO 2 BSH-061001883 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001883 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='80b6cb82-9225-4a48-a1be-f7d6820a74e0' LIMIT 1 Date : 2025-10-23T13:02:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T13:02:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001869 post PendingInvicesDO 2 BSH-061001884 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001884 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f80e6842-31e9-4cbc-8803-ba87966d8550' LIMIT 1 Date : 2025-10-23T13:17:54   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T13:17:54 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001870 post PendingInvicesDO 2 BSH-061001885 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001885 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='86792906-4b05-4591-92b4-c47c2ad9c475' LIMIT 1 Date : 2025-10-23T15:47:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T15:47:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001871 post PendingInvicesDO 2 BSH-061001886 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001886 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8a9f95f0-176c-4283-9175-768c220db0c2' LIMIT 1 Date : 2025-10-23T16:00:03   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T16:00:04 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001872 post PendingInvicesDO 2 BSH-061001887 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001887 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='76ddc7e6-deee-49fa-ae72-36b7d08462ef' LIMIT 1 Date : 2025-10-23T16:23:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T16:23:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001873 post PendingInvicesDO 2 BSH-061001888 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001888 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8db4b73a-973a-494b-b9f7-160c2651ed10' LIMIT 1 Date : 2025-10-23T16:51:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T16:51:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001874 post PendingInvicesDO 2 BSH-061001889 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001889 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='37a106dd-10e1-48e1-8e13-60e7b928c312' LIMIT 1 Date : 2025-10-23T16:57:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T16:57:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001875 post PendingInvicesDO 2 BSH-061001807 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001807 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 = 'BSH-061001807' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001807' OR OrderId='BSH-061001807' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T17:09:35 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001876 post PendingInvicesDO 2 BSH-061001891 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001891 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='df1b6499-8242-4307-a85c-951e9cfe5aee' LIMIT 1 Date : 2025-10-23T17:45:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T17:45:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001877 post PendingInvicesDO 2 BSH-061001723 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001723 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 = 'BSH-061001723' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001723' OR OrderId='BSH-061001723' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-23T17:49:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001878 post PendingInvicesDO 2 BSH-061001893 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001893 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fbbc104f-d243-47a1-b7b4-9e6879a436d3' LIMIT 1 Date : 2025-10-23T18:00:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-23T18:00:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001879 post PendingInvicesDO 2 BSH-061001894 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001894 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d252549f-ca77-4bd6-9244-7ff6b451e541' LIMIT 1 Date : 2025-10-25T10:12:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T10:12:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001880 post PendingInvicesDO 2 BSH-061001895 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001895 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d2cebbd1-4b0e-40d4-ab52-74ea9497bb3c' LIMIT 1 Date : 2025-10-25T10:30:47   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T10:30:48 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001881 post PendingInvicesDO 2 BSH-061001896 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001896 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='901e624b-e8f5-4814-8246-67a5d9281b6d' LIMIT 1 Date : 2025-10-25T10:49:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T10:49:11 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001882 post PendingInvicesDO 2 BSH-061001897 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001897 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='d0e0758f-1a08-41b2-83fb-e0641e1491e8' LIMIT 1 Date : 2025-10-25T11:19:35   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T11:19:36 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001883 post PendingInvicesDO 2 BSH-061001898 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001898 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a9e18c37-40d7-46c8-902f-0607883c7447' LIMIT 1 Date : 2025-10-25T11:42:19   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T11:42:20 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001884 post PendingInvicesDO 2 BSH-061001899 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001899 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='3e33a366-61c9-4191-9612-da659dbfc49a' LIMIT 1 Date : 2025-10-25T11:51:26   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T11:51:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001885 post PendingInvicesDO 2 BSH-061001901 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001901 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fa8db18c-913e-4a64-bff0-0540e4bf2608' LIMIT 1 Date : 2025-10-25T12:59:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T12:59:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001886 post PendingInvicesDO 2 BSH-061001821 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001821 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 = 'BSH-061001821' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001821' OR OrderId='BSH-061001821' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-25T13:31:32 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001887 post PendingInvicesDO 2 BSH-061001903 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001903 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='63985869-5efb-47e3-9669-0be9b2ac2515' LIMIT 1 Date : 2025-10-25T13:52:09   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T13:52:09 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001888 post PendingInvicesDO 2 BSH-061001822 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001822 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 = 'BSH-061001822' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001822' OR OrderId='BSH-061001822' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-25T13:58:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001889 post PendingInvicesDO 2 BSH-061001905 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001905 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ac6f0b7f-b9bd-4cb4-97cb-59c06ab062bd' LIMIT 1 Date : 2025-10-25T16:53:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T16:53:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001890 post PendingInvicesDO 2 BSH-061001906 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001906 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='32091df9-058f-486f-ab8b-1a454e7435d9' LIMIT 1 Date : 2025-10-25T17:15:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-25T17:15:17 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001891 post PendingInvicesDO 2 BSH-061001907 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001907 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fbdc77ad-239d-4868-9e0f-e364a7c00bee' LIMIT 1 Date : 2025-10-26T12:00:11   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T12:00:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001892 post PendingInvicesDO 2 BSH-061001798 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001798 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 = 'BSH-061001798' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001798' OR OrderId='BSH-061001798' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-26T12:19:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001894 post PendingInvicesDO 2 BSH-061001910 post PendingInvicesDO 2 BSH-061001909 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001893 post PendingInvicesDO 2 BSH-061001910 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001909 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001910 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4423eace-3127-438e-a0ba-aa71d9fcd6e0' LIMIT 1 Date : 2025-10-26T13:03:22  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5e18719a-e220-4156-b854-3e7f99857eb2' LIMIT 1 Date : 2025-10-26T13:03:22  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4423eace-3127-438e-a0ba-aa71d9fcd6e0' LIMIT 1 Date : 2025-10-26T13:03:22  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5e18719a-e220-4156-b854-3e7f99857eb2' LIMIT 1 Date : 2025-10-26T13:03:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-26T13:03:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001895 post PendingInvicesDO 2 BSH-061001911 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001911 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='c07302db-4bac-4fda-a99e-db4cd93c41cf' LIMIT 1 Date : 2025-10-26T13:45:01   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T13:45:02 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001896 post PendingInvicesDO 2 BSH-061001912 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001912 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5272df12-fdd5-40ba-a245-3b4e68b0f1f2' LIMIT 1 Date : 2025-10-26T14:09:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T14:09:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001897 post PendingInvicesDO 2 BSH-061001913 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001913 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='71caa96e-1f6e-464d-ab6b-be7f443beee8' LIMIT 1 Date : 2025-10-26T14:26:15   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T14:26:15 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001898 post PendingInvicesDO 2 BSH-061001914 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001914 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0d595e92-726b-4ea3-a29f-9aa907e65fd5' LIMIT 1 Date : 2025-10-26T15:58:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T15:58:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001899 post PendingInvicesDO 2 BSH-061001915 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001915 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2999880c-97e8-43e3-9a19-a882acd1b069' LIMIT 1 Date : 2025-10-26T16:53:36   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T16:53:37 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001900 post PendingInvicesDO 2 BSH-061001916 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001916 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='34386cdd-4a30-483f-acfe-66e3b7a09493' LIMIT 1 Date : 2025-10-26T17:28:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T17:28:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001901 post PendingInvicesDO 2 BSH-061001918 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001918 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0f357a88-1498-46a8-80da-edef0138c9ef' LIMIT 1 Date : 2025-10-26T18:25:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-26T18:25:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001902 post PendingInvicesDO 2 BSH-061001919 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001919 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='4e41130c-48ab-445c-a672-070f37bbab2a' LIMIT 1 Date : 2025-10-27T11:28:30   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T11:28:31 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001903 post PendingInvicesDO 2 BSH-061001920 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001920 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fc4d2f8d-c814-4f3b-b5e4-fd92e9bb0de0' LIMIT 1 Date : 2025-10-27T13:31:06   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T13:31:07 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001905 post PendingInvicesDO 2 BSH-061001922 post PendingInvicesDO 2 BSH-061001921 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001904 post PendingInvicesDO 2 BSH-061001922 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001921 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001922 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e3ca1d17-f292-499e-98ea-dda1eea6dfef' LIMIT 1 Date : 2025-10-27T14:10:54  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7642a022-e154-4dda-b2d7-e5037743bff7' LIMIT 1 Date : 2025-10-27T14:10:54  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='e3ca1d17-f292-499e-98ea-dda1eea6dfef' LIMIT 1 Date : 2025-10-27T14:10:54  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7642a022-e154-4dda-b2d7-e5037743bff7' LIMIT 1 Date : 2025-10-27T14:10:55   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-27T14:10:55 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001906 post PendingInvicesDO 2 BSH-061001923 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001923 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f7e00d34-b631-402b-aa1d-d5558d8de6fe' LIMIT 1 Date : 2025-10-27T14:42:46   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T14:42:47 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001907 post PendingInvicesDO 2 BSH-061001924 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001924 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='dd14417b-6e65-4fe0-87a5-64872fa2dcee' LIMIT 1 Date : 2025-10-27T16:34:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T16:34:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001908 post PendingInvicesDO 2 BSH-061001925 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001925 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='0b30a435-406f-48c2-b0fd-a0664256a0a0' LIMIT 1 Date : 2025-10-27T17:07:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T17:07:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001909 post PendingInvicesDO 2 BSH-061001926 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001926 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='40d75bdc-a317-4c00-8d25-22734695762c' LIMIT 1 Date : 2025-10-27T18:19:32   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T18:19:33 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001910 post PendingInvicesDO 2 BSH-061001927 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001927 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='06c56c3a-ae4f-46a5-a643-eced09ec16fb' LIMIT 1 Date : 2025-10-27T19:01:02   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-27T19:01:03 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001911 post PendingInvicesDO 2 BSH-061001848 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001848 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 = 'BSH-061001848' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001848' OR OrderId='BSH-061001848' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-27T20:19:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001912 post PendingInvicesDO 2 BSH-061001779 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001779 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 = 'BSH-061001779' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001779' OR OrderId='BSH-061001779' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T10:08:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001913 post PendingInvicesDO 2 BSH-061001880 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001880 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 = 'BSH-061001880' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001880' OR OrderId='BSH-061001880' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T10:10:14 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001915 post PendingInvicesDO 2 BSH-061001738 post PendingInvicesDO 2 BSH-061001737 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001914 post PendingInvicesDO 2 BSH-061001738 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001737 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001738 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 = 'BSH-061001738' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001738' OR OrderId='BSH-061001738' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'BSH-061001738' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001738' OR OrderId='BSH-061001738' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T10:13:34 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001917 post PendingInvicesDO 2 BSH-061001930 post PendingInvicesDO 2 BSH-061001929 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001916 post PendingInvicesDO 2 BSH-061001930 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001929 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001930 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='19d4ebfb-4435-4ef5-a7b2-5b6516311e59' LIMIT 1 Date : 2025-10-28T11:31:17  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='42fca1ae-1ceb-4699-a1bc-70ad85287b03' LIMIT 1 Date : 2025-10-28T11:31:17  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='19d4ebfb-4435-4ef5-a7b2-5b6516311e59' LIMIT 1 Date : 2025-10-28T11:31:17  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='42fca1ae-1ceb-4699-a1bc-70ad85287b03' LIMIT 1 Date : 2025-10-28T11:31:17   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-28T11:31:18 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001918 post PendingInvicesDO 2 BSH-061001799 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001799 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 = 'BSH-061001799' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001799' OR OrderId='BSH-061001799' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-28T12:32:19 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001919 post PendingInvicesDO 2 BSH-061001932 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001932 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5083a304-97b3-4484-a943-c28ce9d44ec2' LIMIT 1 Date : 2025-10-28T13:53:43   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T13:53:43 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001920 post PendingInvicesDO 2 BSH-061001933 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001933 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='71a6650b-1c80-4197-b740-e42434c1be6b' LIMIT 1 Date : 2025-10-28T13:57:25   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T13:57:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001921 post PendingInvicesDO 2 BSH-061001934 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001934 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='5a64bb27-f3b6-412c-acb9-2005ee56ff69' LIMIT 1 Date : 2025-10-28T14:06:16   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T14:06:16 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001922 post PendingInvicesDO 2 BSH-061001935 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001935 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='fd6b4bf9-2b55-415d-8b1d-e6d843dc5568' LIMIT 1 Date : 2025-10-28T14:15:29   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T14:15:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001923 post PendingInvicesDO 2 BSH-061001936 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001936 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8e7fa178-4c9c-481b-8781-ce16a4d09343' LIMIT 1 Date : 2025-10-28T14:25:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T14:25:57 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001924 post PendingInvicesDO 2 BSH-061001937 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001937 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='a0e16ff4-9f05-483f-912f-1d616f948ee6' LIMIT 1 Date : 2025-10-28T16:08:49   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T16:08:50 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001925 post PendingInvicesDO 2 BSH-061001938 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001938 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='49162bf3-535e-46fc-8a4c-3153982b5bed' LIMIT 1 Date : 2025-10-28T16:24:37   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T16:24:38 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001926 post PendingInvicesDO 2 BSH-061001939 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001939 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='68ff4ec7-6261-4cd4-87bd-1259626a337e' LIMIT 1 Date : 2025-10-28T16:28:12   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T16:28:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001927 post PendingInvicesDO 2 BSH-061001940 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001940 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='7672368a-4525-4896-a527-c46ce032bd58' LIMIT 1 Date : 2025-10-28T16:39:57   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T16:39:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001928 post PendingInvicesDO 2 BSH-061001941 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001941 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='1a409fa2-5dd8-4b56-ab7f-9bf4734a3ade' LIMIT 1 Date : 2025-10-28T16:57:51   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T16:57:52 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001929 post PendingInvicesDO 2 BSH-061001942 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001942 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f96cc095-cc07-4c82-8f9c-8671f3dd622e' LIMIT 1 Date : 2025-10-28T17:20:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T17:20:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001930 post PendingInvicesDO 2 BSH-061001943 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001943 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2a6ef220-a615-4022-9978-11a068a2c5ef' LIMIT 1 Date : 2025-10-28T18:02:40   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-28T18:02:41 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001931 post PendingInvicesDO 2 BSH-061001944 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001944 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8d4621b9-bd56-4933-8821-9c89065162f9' LIMIT 1 Date : 2025-10-29T11:26:13   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T11:26:13 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001932 post PendingInvicesDO 2 BSH-061001945 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001945 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='79c5af5c-d4e3-4516-99fc-824f5a8abfc2' LIMIT 1 Date : 2025-10-29T11:46:58   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T11:46:58 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001933 post PendingInvicesDO 2 BSH-061001946 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001946 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='41be0f51-8741-4cc5-b2f0-034efdb16616' LIMIT 1 Date : 2025-10-29T11:54:44   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T11:54:44 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001935 post PendingInvicesDO 2 BSH-061001866 post PendingInvicesDO 2 BSH-061001865 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001934 post PendingInvicesDO 2 BSH-061001866 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001865 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001866 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 = 'BSH-061001866' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001866' OR OrderId='BSH-061001866' 
SELECT IFNULL(SUM(TPI.Amount),0) FROM tblPaymentInvoice TPI
INNER JOIN tblPaymentHeader TPH ON TPI.ReceiptId=TPH.ReceiptId
WHERE TPI.TrxCode = 'BSH-061001866' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001866' OR OrderId='BSH-061001866' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T11:55:39 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001936 post PendingInvicesDO 2 BSH-061001947 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001947 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='6bb0714c-1532-4160-86fd-4f7221000be2' LIMIT 1 Date : 2025-10-29T11:56:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T11:56:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001937 post PendingInvicesDO 2 BSH-061001948 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001948 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='865b60f5-eeab-4e08-a6a5-de6d84509ea1' LIMIT 1 Date : 2025-10-29T12:08:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T12:08:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001938 post PendingInvicesDO 2 BSH-061001949 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001949 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f37c9435-c787-47e8-96d0-8b9e94028dd6' LIMIT 1 Date : 2025-10-29T12:11:56   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T12:11:56 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001939 post PendingInvicesDO 2 BSH-061001950 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001950 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='431ca712-2b16-488f-9c48-6946a341af3e' LIMIT 1 Date : 2025-10-29T12:14:52   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T12:14:53 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001940 post PendingInvicesDO 2 BSH-061001931 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001931 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 = 'BSH-061001931' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001931' OR OrderId='BSH-061001931' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T12:30:27 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001941 post PendingInvicesDO 2 BSH-061001867 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001867 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 = 'BSH-061001867' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001867' OR OrderId='BSH-061001867' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T12:31:40 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001942 post PendingInvicesDO 2 BSH-061001890 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001890 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 = 'BSH-061001890' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001890' OR OrderId='BSH-061001890' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T12:34:12 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001943 post PendingInvicesDO 2 BSH-061001861 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001861 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 = 'BSH-061001861' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001861' OR OrderId='BSH-061001861' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T13:14:29 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001944 post PendingInvicesDO 2 BSH-061001953 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001953 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='9782aac0-3b96-44c7-9eb7-de8ba64e344f' LIMIT 1 Date : 2025-10-29T13:40:59   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T13:40:59 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001945 post PendingInvicesDO 2 BSH-061001954 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001954 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='b7b19bba-eaeb-4884-aed3-0ba8a8b6e990' LIMIT 1 Date : 2025-10-29T14:41:22   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T14:41:23 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001947 post PendingInvicesDO 2 BSH-061001956 post PendingInvicesDO 2 BSH-061001955 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001946 post PendingInvicesDO 2 BSH-061001956 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001955 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001956 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8180d129-4854-4e99-bc22-6bbe539064f3' LIMIT 1 Date : 2025-10-29T15:42:26  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='30554d8a-015a-49f6-9aaa-5c478348b18a' LIMIT 1 Date : 2025-10-29T15:42:26  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='8180d129-4854-4e99-bc22-6bbe539064f3' LIMIT 1 Date : 2025-10-29T15:42:27  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='30554d8a-015a-49f6-9aaa-5c478348b18a' LIMIT 1 Date : 2025-10-29T15:42:27   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-29T15:42:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001948 post PendingInvicesDO 2 BSH-061001957 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001957 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='f6fad6b4-a946-4928-9e84-f77fa28517c9' LIMIT 1 Date : 2025-10-29T16:17:21   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-29T16:17:22 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001949 post PendingInvicesDO 2 BSH-061001797 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001797 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 = 'BSH-061001797' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001797' OR OrderId='BSH-061001797' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-29T16:43:28 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001950 post PendingInvicesDO 2 BSH-061001873 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001873 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 = 'BSH-061001873' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001873' OR OrderId='BSH-061001873' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-30T09:20:26 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001951 post PendingInvicesDO 2 BSH-061001962 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001962 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='2debfd86-ef12-4fa5-a2c3-0598412047be' LIMIT 1 Date : 2025-10-30T13:29:07   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 6 2025-10-30T13:29:08 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001953 post PendingInvicesDO 2 BSH-061001964 post PendingInvicesDO 2 BSH-061001963 post vecPaymentInvoices vecPaymentDetails 2 mode performInsertPayment 10 BSH-064001952 post PendingInvicesDO 2 BSH-061001964 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 performInsertPayment 14 trxHeaderDO.trxType : 4 trxHeaderDO.trxCode : BSH-061001963 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : false trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001964 isNewSettlement : true hmPendingInvoice.containsKey(trxHeaderDO.trxCode) : truearrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ecda57f9-64c5-462a-a438-3f766f804f89' LIMIT 1 Date : 2025-10-30T13:59:45  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14ef4646-435b-42b5-a4bc-df0affb21139' LIMIT 1 Date : 2025-10-30T13:59:45  arrTrxHeaderDOMultiSales.get(0).paymentTypeOrder1 arrTrxHeaderDOMultiSales.get(0).paymentType1 SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='ecda57f9-64c5-462a-a438-3f766f804f89' LIMIT 1 Date : 2025-10-30T13:59:45  SELECT TH.TrxCode FROM tblTrxHeader TH WHERE AppTrxId='14ef4646-435b-42b5-a4bc-df0affb21139' LIMIT 1 Date : 2025-10-30T13:59:45   performInsertPayment totalCNVal 0.0 performInsertPayment 4 Payment Type : 1  performInsertPayment 12 performInsertPayment 12 performInsertPayment 6 2025-10-30T13:59:46 payment end 
 performInsertPayment 1 performInsertPayment 3 mode performInsertPayment 10 BSH-064001954 post PendingInvicesDO 2 BSH-061001928 post vecPaymentInvoices vecPaymentDetails 2 performInsertPayment 14 trxHeaderDO.trxType : 1 trxHeaderDO.trxCode : BSH-061001928 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 = 'BSH-061001928' AND TPH.IsCancelled!='True' COLLATE NOCASE AND TPH.PaymentStatus!=4 AND TPI.TrxCode != 'ONACCOUNT' 
SELECT TotalAmount FROM tblPendingInvoices WHERE InvoiceNumber='BSH-061001928' OR OrderId='BSH-061001928' 
 performInsertPayment totalCNVal 0.0 performInsertPayment 4  performInsertPayment 6 2025-10-30T16:56:09 payment end 
