Jump to content
malin

The tblinvoices  records do not have the invoicenum. 

Recommended Posts

 

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)

 

Share this post


Link to post
Share on other sites
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.

8uxEXUD.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated