Billing System Status
SIP Servers
| SIP Server |
Unprocessed CDR Count |
Failed Bills
Failed to create invoice
| Account |
Bill Start Date |
Bill End Date |
| 01202109-3236 |
2026-06-01 06:00:00 |
2026-07-01 06:00:00 |
| 04201801-9456 |
2026-06-02 01:00:00 |
2026-07-02 01:00:00 |
| 08201712-7660 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 04201801-6135 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 04201801-9118 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 04201801-8186 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 20201808-1332 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 06201802-3924 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 02201803-4961 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 31201810-5480 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 19201907-1925 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
| 13202004-4649 |
2026-06-02 06:00:00 |
2026-07-02 06:00:00 |
Failed to charge bill costs
| Account |
Bill Start Date |
Bill End Date |
| 20201903-9953 |
2026-06-20 13:46:28 |
2026-07-20 13:46:28 |
| 27201803-4936 |
2026-06-27 09:53:52 |
2026-07-27 09:53:52 |
| 01202109-3236 |
2026-07-01 06:00:00 |
2026-08-01 06:00:00 |
| 02201803-4961 |
2026-07-02 06:00:00 |
2026-08-02 06:00:00 |
| 20201903-9953 |
2026-07-20 13:46:28 |
2026-08-20 13:46:28 |
Monthly pay-in-full card charge failure
| Customer ID |
Bill Date |
Amount |
Status |
| 28201803-1978 |
2026-07-13 |
$16.00 |
Unprocessed |
| 08201712-7660 |
2026-08-02 |
$12.00 |
Unprocessed |
| 28201803-1978 |
2026-08-13 |
$16.00 |
Unprocessed |
08-25-2026 20:18:47 SQL Statement: SELECT serverID, server_name FROM sipServers WHERE active = '1' ORDER BY server_name
08-25-2026 20:18:47 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-07-01' AND status = '-1' ORDER BY bill_creation_date
08-25-2026 20:18:47 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-07-01' AND bill_creation_date <= '2026-08-22' ORDER BY bill_creation_date
08-25-2026 20:18:47 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 = '175'
08-25-2026 20:18:47 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 = '176'
08-25-2026 20:18:47 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 = '177'
08-25-2026 20:18:47 SQL Statement: SELECT id, api_key, from_domain, from_name FROM mailgun_settings WHERE id = '1'
08-25-2026 20:18:47 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-07-01' AND cdr_taxed = '1' ORDER BY bill_end
08-25-2026 20:18:47 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-07-01' AND invoiced = '2' ORDER BY bill_end
08-25-2026 20:18:47 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-07-01' AND billed = '1' ORDER BY bill_end