Progressive invoice number without "holes"

I would like to know if Hikashop can generate invoices like Italian laws requires.

We need progressive invoice number starting at the beginning of every new year from number 1 and must be progressive 1,2,3,4,5,......1347 etc without "holes" in numeration; we cannot have 1,4,6,12, etc we must have 2,3,5,7,8,9,10,11 etc.. in this example.

My doubt is: if I delete an order I also generate an "hole" in the numeration? Example, I had generated invoices 1,2,3,4. Now for some reason the order with ID 5 is deleted or user do not confirm it. What happens to invoice sequence? It will go on with number 6? and what about number 5?

Also, think about that order with ID number 5 is generated but the payment not yet completed. In the meanwhile the order number 6 is placed and payed. What happens this case? I have the order number 5 with a date bigger that order 6??? I cannot have it this way. I should have a pro-forma invoice that will be converted with the subsequential order number when payment is completed so in that case the order with ID 5 will become invoice number 6 after real payment.

Last I would have a number invoice like this:

Fattura numero 1/01 del 14 Maggio 2012
Fattura numero 2/01 del 14 Maggio 2012
Fattura numero 3/01 del 16 Maggio 2012
Fattura numero 4/01 del 19 Maggio 2012
Fattura numero 5/01 del 25 Maggio 2012
and so on...

Is all that possible?

Thanks in advice?

For now the invoice number is simply the order number. We have a similar law in France and from what our accountant said, it is perfectly fine to do it like that.
Of course, you should not delete orders.

If you want that the invoice numbers get incremented only for confirmed orders, you will have to wait. We're working on that but it won't be available in HikaShop before September.

You can already personalize the order number to have the order id, the date and custom text in it. It will be possible to customize the order number in a similar way.

Ok, I hope you can implement those features as soon as possible.

Will you implement also a way to let me restart the invoice number from 1 every new year?

What about pro-forma invoice?

Thanks in advice.

The first version of that invoice numbering system won't handle invoice number reseting.

You can print the invoice via the "invoice" button of the order details page on the back end. Is that what you're talking about ?

I must restart the invoice number at value 1 every new 1 genuary of every year. Would you consider this in future releases?

With pro-forma invoice I mean a non legal invoice, just a "fac-simile" that can be' converted with real invoice number when payment is completed. That to be' sure I do not have holes in numbering sequence.
This is necessary in case described in previuous posts when someone pay online while someone else pay with Bank transfer for example.

Hi.

Please I need the same thing. Could it be done manually (or temporarily) by code subtracting the last Dec-31 autoincr value to the new year autoincr values in the invoices via views editting? I know maybe this is not the best solution, but it could be a temporarily one.

Please help. Thanks.

PD: Please, How can I be noticed when the 'invoice numbering system' will be available? I'm from Spain and I need this feature. Thanks.

Hi,

With pro-forma invoice I mean a non legal invoice, just a "fac-simile" that can be' converted with real invoice number when payment is completed.

That's what it will do with that decoupling of the order number and the invoice number.

The first version of the invoice numbering system won't cover the reseting of the numbering at specific dates.
That is planned for a later version and shouldn't be too complex to add after we have that decoupling between order number and invoice number.

If you want a temporary solution and if you're a developer, it's possible by creating a hikashop plugin implementing the onBeforeOrderCreate event as explained in our developer documentation.

nicolas wrote: Hi,
The first version of the invoice numbering system won't cover the reseting of the numbering at specific dates.
That is planned for a later version and shouldn't be too complex to add after we have that decoupling between order number and invoice number.

Any idea about when? Few months, next year? I start a new project and I would use Hikashop Business instead of VM but before start with Hikashop I need this feature and all other feature above. If I have to wait 1 ...2 months at least could be ok.

Thanks

I can't guarantee anything. The first version is already developed and should be available in September/October.
But the second version with the invoice numbering reset is not planned yet.

nicolas wrote: I can't guarantee anything. The first version is already developed and should be available in September/October.
But the second version with the invoice numbering reset is not planned yet.

Ok, I could start with Hikashop in september/october then would be fantastic to have the second version with reset solution before end of the year.

Otherway, if not will be available for the end of the year, how can I manually reset the order number an so the invoice number changing values directly into DB? Is that possible or could generate a disaster?

Hi Nicolas.

What about doing the invoice 'reset' procedure by code subtracting the last Dec-31 value to the new year autoincr values (while we wait for the next version of the invoice numbering system)? Maybe a field in the DB where we could put the last number of prior year and a variable in the numbering format so we could subtract that number to the current autoincr value (if we want) to make the order/invoice number. If this is not possible (to modify DB or core code) I think it would be subtracting that number in the order/invoice views manually.

Could be this a 'temporarily solution' while we wait for the next version of the invoice numbering system?

Please help, I need this procedure.

Thanks.

Hi,

I think that you will be able to change the invoice numbering with a MySQL query when you want to change the numbering.
We should be able to give that procedure once the release the next version which will include the invoice numbering.

Hi.

Do you know approximately when will be the invoice numbering system available? How will you notify it?

Thanks.

It will be in October.

You can follow us on twitter if you want to know when new releases are available on the same day.
Otherwise, we send a newsletter 1 or 2 weeks later, when all the quirks have been ironed out.

October is ending... are you ready?

A beta is already out since a few days:
www.hikashop.com/en/forum/2-general-talk...ikashop-20-beta.html

Thanks. I will do lot of tests and will report.

I cannot test the invoice function, I can do it only with commercial versions. Any commercial version available for beta test?

Invoices are available in the backend when you edit orders. The same invoices are displayed on both front and back end.

I've asked for a hikashop business 2.0 to test sendind a contact form request. Thanks.