[2026-03-29 14:38:26] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 14:38:26] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 14:38:26] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:17] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:09:17] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:17] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:20] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:09:20] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:20] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:23] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:09:23] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:23] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:26] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:09:26] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:09:26] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:10:09] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[1,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:10:09] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:10:09] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:17:16] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:17:16] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:17:16] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:17:20] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:17:20] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:17:20] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:18:16] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:18:16] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:18:16] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:23:23] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 20:23:23] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 20:23:23] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:13:42] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:13:42] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:13:42] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:46:30] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:46:30] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:46:30] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:48:30] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:48:30] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:48:30] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:52] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:58:52] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:52] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:55] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:58:55] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:55] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:57] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 21:58:57] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 21:58:57] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:38] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:04:38] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:38] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:41] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:04:41] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:41] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:41] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:04:41] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:04:41] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:05:30] live.INFO: Fetching tax rate for product ID: 674  
[2026-03-29 22:05:30] live.INFO: Product ID 674 has no tax assigned.  
[2026-03-29 22:05:55] live.INFO: mpesa_transaction_id value: NULL  
[2026-03-29 22:05:55] live.INFO: is_mpesa_sale value: true  
[2026-03-29 22:05:55] live.INFO: M-Pesa sale evaluation {"is_mpesa_sale_raw":true,"is_valid_mpesa_sale":false,"payment_method_input":"cash","mpesa_transaction_id":null,"transaction_id":3514} 
[2026-03-29 22:05:55] live.INFO: Journal Entry Case: FULL CASH PAYMENT {"transaction_id":3514,"final_total":2000.0,"amount_paid":2000.0,"balance_due":0} 
[2026-03-29 22:05:55] live.INFO: Journal Entries Inserted Successfully {"transaction_id":3514,"entries":[{"transaction_id":3514,"created_by_id":21,"transaction_number":"TRX-69c97813b668d7.30967403","payment_detail_id":275,"location_id":"9","currency_id":133,"transaction_type":"sell","date":"2026-03-29","month":3,"year":2026,"active":1,"reversed":0,"reversible":1,"manual_entry":1,"created_at":"2026-03-29 22:05:55","updated_at":"2026-03-29 22:05:55","chart_of_account_id":23,"debit":null,"credit":2000.0},{"transaction_id":3514,"created_by_id":21,"transaction_number":"TRX-69c97813b668d7.30967403","payment_detail_id":275,"location_id":"9","currency_id":133,"transaction_type":"sell","date":"2026-03-29","month":3,"year":2026,"active":1,"reversed":0,"reversible":1,"manual_entry":1,"created_at":"2026-03-29 22:05:55","updated_at":"2026-03-29 22:05:55","chart_of_account_id":27,"debit":2000.0,"credit":null}]} 
[2026-03-29 22:05:55] live.INFO: Inserted purchase sell mapping {"count":1,"data":[{"sell_line_id":4187,"purchase_line_id":932,"quantity":1.0,"created_at":"2026-03-29 22:05:55","updated_at":"2026-03-29 22:05:55"}]} 
[2026-03-29 22:05:55] live.INFO: Inserted Retained Earnings (profit) entries {"count":1,"total_profit":2000.0} 
[2026-03-29 22:05:55] live.INFO: ETIMS: Customer details retrieved {"transaction_id":3514,"contact_id":94,"customer_name":"Walk-In Customer","has_tin":false,"has_digitax_id":false} 
[2026-03-29 22:05:55] live.ERROR: ETIMS: Missing item_id for product {"product_id":674} 
[2026-03-29 22:05:55] live.ERROR: ETIMS: No valid items to submit after filtering  
[2026-03-29 22:05:55] live.INFO: eTIMS response: {"response":{"success":false,"message":"No valid items to submit to ETIMS"}} 
[2026-03-29 22:07:18] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:07:18] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:07:18] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:07:21] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:07:21] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:07:21] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:09:04] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:09:04] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:09:04] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:35:43] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:35:43] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:35:43] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:32] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:32] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:32] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:35] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:35] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:35] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:35] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:35] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:35] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:36] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:36] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:36] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:36] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:36] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:36] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:37] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:37] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:37] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:37] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:38] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:38] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:38] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:38] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:38] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:38] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:39] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:39] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:39] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:39] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:41] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:41] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:41] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:41] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:41] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:41] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:42] live.DEBUG: CREDIT PAYMENTS SQL (>1min) {"sql":"select `transactions`.`id` as `transaction_id`, `transactions`.`invoice_no`, `transactions`.`transaction_date` as `sell_date`, `transaction_payments`.`id` as `payment_id`, `transaction_payments`.`paid_on`, `transaction_payments`.`method`, `transaction_payments`.`amount`, `contacts`.`name` as `customer_name`, `contacts`.`supplier_business_name` from `transaction_payments` inner join `transactions` on `transaction_payments`.`transaction_id` = `transactions`.`id` left join `contacts` on `transactions`.`contact_id` = `contacts`.`id` where `transactions`.`business_id` = ? and `transactions`.`type` = ? and `transactions`.`status` = ? and `transaction_payments`.`is_return` = ? and `transaction_payments`.`paid_on` is not null and TIMESTAMPDIFF(SECOND, transactions.transaction_date, transaction_payments.paid_on) > 60 and date(`transactions`.`transaction_date`) = ?","bindings":[8,"sell","final",0,"2026-03-29"]} 
[2026-03-29 22:40:42] live.INFO: CREDIT PAYMENTS SUMMARY (>1min) {"total_records":0,"total_credit_amount":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}} 
[2026-03-29 22:40:42] live.INFO: CREDIT SALES SUMMARY {"total_records":0,"total_credit_sales":0,"total_paid":0,"total_due":0,"filters":{"locationFilter":null,"userFilter":null,"dateFilter":"today","startDate":null,"endDate":null}}