The tblinvoices records do not have the invoicenum.

[malin]

 

The tblinvoices  records do not have the invoicenum. 

 

mysql> select * from  tblinvoices limit 3; 

+----+--------+------------+------------+------------+---------------------+----------------------+----------+--------+------+------+--------+---------+----------+--------+---------------+-------+

| id | userid | invoicenum | date       | duedate    | datepaid            | last_capture_attempt | subtotal | credit | tax  | tax2 | total  | taxrate | taxrate2 | status | paymentmethod | notes |

+----+--------+------------+------------+------------+---------------------+----------------------+----------+--------+------+------+--------+---------+----------+--------+---------------+-------+

| 23 |      5 |            | 2018-08-10 | 2018-08-10 | 2018-08-10 02:54:51 | 0000-00-00 00:00:00  |   235.00 |   0.00 | 0.00 | 0.00 | 235.00 |    0.00 |     0.00 | Paid   | hanteddosing  |       |

| 25 |      6 |            | 2018-08-14 | 2018-08-14 | 2018-08-22 07:13:23 | 0000-00-00 00:00:00  |    87.00 |   0.00 | 0.00 | 0.00 |  87.00 |    0.00 |     0.00 | Paid   | hanteddosing  |       |

| 26 |      6 |            | 2018-08-18 | 2018-08-18 | 2018-08-22 07:13:18 | 0000-00-00 00:00:00  |    87.00 |   0.00 | 0.00 | 0.00 |  87.00 |    0.00 |     0.00 | Paid   | hanteddosing  |       |

+----+--------+------------+------------+------------+---------------------+----------------------+----------+--------+------+------+--------+---------+----------+--------+---------------+-------+

3 rows in set (0.00 sec)

 

[brian!]

8 hours ago, malin said:

The tblinvoices  records do not have the invoicenum. 

that's normal - invoicenum is only used if you define a custom invoice number format - either through general settings->invoices (sequential), or by coding.