Progressive invoice number without "holes"

  • Posts: 272
  • Thank you received: 13
12 years 2 months ago #61837

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?

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 2 months ago #61951

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.

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 2 months ago #61980

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.

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 2 months ago #62055

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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 2 months ago #62113

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.

Please Log in or Create an account to join the conversation.

  • Posts: 107
  • Thank you received: 3
12 years 2 months ago #62199

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.

Last edit: 12 years 2 months ago by lanzanet.

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 2 months ago #62214

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.

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 2 months ago #62219

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

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 2 months ago #62222

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.

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 2 months ago #62224

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?

Please Log in or Create an account to join the conversation.

  • Posts: 107
  • Thank you received: 3
12 years 2 months ago #62316

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.

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 2 months ago #62431

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.

Please Log in or Create an account to join the conversation.

  • Posts: 107
  • Thank you received: 3
12 years 1 month ago #66707

Hi.

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

Thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 1 month ago #66974

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.

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 1 week ago #73174

October is ending... are you ready? :)

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 1 week ago #73218

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 1 week ago #73253

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

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 1 week ago #73309

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

Please Log in or Create an account to join the conversation.

  • Posts: 82760
  • Thank you received: 13346
  • MODERATOR
12 years 6 days ago #73599

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

Please Log in or Create an account to join the conversation.

  • Posts: 272
  • Thank you received: 13
12 years 5 days ago #73649

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.097 seconds
Powered by Kunena Forum