[MOD] Custom Invoice Numbers

[Shaun]

I was looking for a way to emulate the way sequential invoices allows a customer invoice numbering scheme eg XXX-{Number}.

 

Reason being i run this and myob and i wanted to know where to go when a customer inquired about invoice XYZ

 

I first looked for a action hook for new invoices and it wasn't there.

So the way to do it is to hook the db insert using a trigger.

 

Installation:

Connect to you phpMyAdmin.

Open you WMHCS DB and goto the SQL tab

Copy paste and inster the below row

Rember to chane ##PREFIX## to your desired prefix

delimiter ;;

create trigger kdo_SetInvoiceNumber BEFORE INSERT on tblinvoices FOR EACH ROW BEGIN
set new.invoicenum = concat('##PREFIX##',(SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE
TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'tblinvoices'));

END
;;

 

Removal:

Connect to you phpMyAdmin.

Open you WMHCS DB and goto the SQL tab

Copy paste and inster the below row

Drop trigger kdo_SetInvoiceNumber ;

 

This is the first hack i'm doing.

I am going to take the time to build this into a full admin mod that allows you to add and remove the trigger and update it from inside the WHMC's panel.

 

Matt:

You could make it easier by adding a hook for invoice_Create

 

Small Print: All care, no responsibility.

[nivlek78]

This does not work. It says syntax error....

[Shaun]

This does not work. It says syntax error....

 

i may have typed the code wrong.

Ill look into it some more for you soon

[Blitz]

Anytime soon?

[jozeph]

V4 have a invoice_Create actionhook.

[Shaun]

V4 have a invoice_Create actionhook.

 

This action hooks is called after the invoice email is sent.

This means that when the invoice is sent its sent with the wrong number.

I am going to look at this codee today for you guys.

Its been running in my WHMCS for a while and i havn't touched it, i will just have to understand it again.

[LemonBarley]

i'm waiting for it

[Shaun]

I have just run the above code on mysql 5 and it runs.

[UltraUnix]

I'm looking to import invoices from another billing system which might have duplicate invoice number. Looking at your mod, seems to be able to fit into what I'm looking for.

 

Base on your SQL query, it basically tells to append prefix on every new transaction. I tried manually change the ID in tblinvoice to XYZ{number} but later turned into 0. May I know hows the entry would look like after your mods?

[UltraUnix]

nevermind, got it figure. basically using append XYZ-{number} into invoicenum field.

[weba]

nice thinking shaun!

[suksuk.lee]

Would this still work in WHMCS 4.5? I'm just wanting to add a simple word like HOST-### in front of the number.

 

I tried editing the lang file as follows:

 

$_LANG["invoicenumber"] = "Invoice #: HOST-";

$_LANG["invoicestitle"] = "Invoice #: HOST-";

This works but the email attachment sent out is still just ###.pdf - would be great if the PDF file name can be renamed too.

Edited May 30, 2011 by suksuk.lee

[equipc]

I think this could be done with the EU VAT addon but I'm not sure

[suksuk.lee]

Thanks, the mod has this feature:

the ability to assign custom invoice number formats when invoices are generated

 

I'll give it a go...

[suksuk.lee]

I think this could be done with the EU VAT addon but I'm not sure

 

Thanks, I think that addon did the trick!

[newgenservices]

Would this still work in WHMCS 4.5? I'm just wanting to add a simple word like HOST-### in front of the number.

 

I tried editing the lang file as follows:

 

 

This works but the email attachment sent out is still just ###.pdf - would be great if the PDF file name can be renamed too.

You can just set the Sequential Invoice Number Format setting to

HOST-{NUMBER}

in WHMCS Admin General Settings \ Invoices

 

More Info @ http://docs.whmcs.com/Invoicing#Proforma_Invoicing.2FSequential_Invoice_Numbering