How to get last invoice ID?

[Remitur]

Hello.

 

Any easy and elegant way to get last generated invoice ID?

 

The one I'm guessing (create a fake invoice, get its ID, decrement by one and so you get the previous last ID number) is not so elegant... )

[sentq]

this will get you the last invoice ID in database table:

SELECT `id` FROM `tblinvoices` ORDER BY `id` DESC LIMIT 0,1;