Billing System Status
SIP Servers
| SIP Server |
Unprocessed CDR Count |
Failed Bills
Failed to charge bill costs
| Account |
Bill Start Date |
Bill End Date |
| 01202109-3236 |
2026-08-01 06:00:00 |
2026-09-01 06:00:00 |
| 02201803-4961 |
2026-08-02 06:00:00 |
2026-09-02 06:00:00 |
| 20201903-9953 |
2026-08-20 13:46:28 |
2026-09-20 13:46:28 |
| 27201803-4936 |
2026-08-27 09:53:52 |
2026-09-27 09:53:52 |
| 01202109-3236 |
2026-09-01 06:00:00 |
2026-10-01 06:00:00 |
| 02201803-4961 |
2026-09-02 06:00:00 |
2026-10-02 06:00:00 |
| 20201903-9953 |
2026-09-20 13:46:28 |
2026-10-20 13:46:28 |
| 27201803-4936 |
2026-09-27 09:53:52 |
2026-10-27 09:53:52 |
Monthly pay-in-full card charge failure
| Customer ID |
Bill Date |
Amount |
Status |
| 08201712-7660 |
2026-09-02 |
$12.00 |
Unprocessed |
| 28201803-1978 |
2026-09-13 |
$16.00 |
Unprocessed |
| 08201712-7660 |
2026-10-02 |
$12.00 |
Unprocessed |
| 28201803-1978 |
2026-10-13 |
$16.00 |
Unprocessed |
10-29-2026 01:00:22 SQL Statement: SELECT serverID, server_name FROM sipServers WHERE active = '1' ORDER BY server_name
10-29-2026 01:00:22 SQL Statement: SELECT id, customer_id, monthly_bill_id, bill_amount, bill_creation_date, bill_payment_date, status FROM customer_bill WHERE bill_creation_date >= '2026-09-01' AND status = '-1' ORDER BY bill_creation_date
10-29-2026 01:00:22 SQL Statement: SELECT id, customer_id, monthly_bill_id, bill_amount, bill_creation_date, bill_payment_date, status FROM customer_bill WHERE status = '0' AND bill_creation_date >= '2026-09-01' AND bill_creation_date <= '2026-10-26' ORDER BY bill_creation_date
10-29-2026 01:00:22 SQL Statement: SELECT customer_bill.id, customer_bill.customer_id, customer_bill.monthly_bill_id, customer_bill.bill_amount, customer_bill.bill_creation_date, customer_bill.bill_payment_date, customer_bill.status, customer.account_number FROM customer_bill, customer WHERE customer.id = customer_bill.customer_id AND customer_bill.id = '178'
10-29-2026 01:00:22 SQL Statement: SELECT customer_bill.id, customer_bill.customer_id, customer_bill.monthly_bill_id, customer_bill.bill_amount, customer_bill.bill_creation_date, customer_bill.bill_payment_date, customer_bill.status, customer.account_number FROM customer_bill, customer WHERE customer.id = customer_bill.customer_id AND customer_bill.id = '179'
10-29-2026 01:00:22 SQL Statement: SELECT customer_bill.id, customer_bill.customer_id, customer_bill.monthly_bill_id, customer_bill.bill_amount, customer_bill.bill_creation_date, customer_bill.bill_payment_date, customer_bill.status, customer.account_number FROM customer_bill, customer WHERE customer.id = customer_bill.customer_id AND customer_bill.id = '180'
10-29-2026 01:00:22 SQL Statement: SELECT customer_bill.id, customer_bill.customer_id, customer_bill.monthly_bill_id, customer_bill.bill_amount, customer_bill.bill_creation_date, customer_bill.bill_payment_date, customer_bill.status, customer.account_number FROM customer_bill, customer WHERE customer.id = customer_bill.customer_id AND customer_bill.id = '181'
10-29-2026 01:00:22 SQL Statement: SELECT id, api_key, from_domain, from_name FROM mailgun_settings WHERE id = '1'
10-29-2026 01:00:22 SQL Statement: SELECT t.account_number, t.bill_start, t.bill_end FROM (SELECT monthly_bill_costs.bill_start AS bill_start, monthly_bill_costs.bill_end AS bill_end, monthly_bill_costs.cdr_taxed AS cdr_taxed, customer.account_number AS account_number FROM monthly_bill_costs monthly_bill_costs LEFT JOIN customer customer ON monthly_bill_costs.customer_id = customer.id) AS t WHERE bill_end >= '2026-09-01' AND cdr_taxed = '1' ORDER BY bill_end
10-29-2026 01:00:22 SQL Statement: SELECT t.account_number, t.bill_start, t.bill_end FROM (SELECT monthly_bill_costs.bill_start AS bill_start, monthly_bill_costs.bill_end AS bill_end, monthly_bill_costs.invoiced AS invoiced, customer.account_number AS account_number FROM monthly_bill_costs monthly_bill_costs LEFT JOIN customer customer ON monthly_bill_costs.customer_id = customer.id) AS t WHERE bill_end >= '2026-09-01' AND invoiced = '2' ORDER BY bill_end
10-29-2026 01:00:22 SQL Statement: SELECT t.account_number, t.bill_start, t.bill_end FROM (SELECT monthly_bill_costs.bill_start AS bill_start, monthly_bill_costs.bill_end AS bill_end, monthly_bill_costs.billed AS billed, customer.account_number AS account_number FROM monthly_bill_costs monthly_bill_costs LEFT JOIN customer customer ON monthly_bill_costs.customer_id = customer.id) AS t WHERE bill_end >= '2026-09-01' AND billed = '1' ORDER BY bill_end
