Author Topic: invoice number not in in order anymore  (Read 3532 times)

DanielIIC

  • Beginner
  • *
  • Posts: 26
  • A beginner
invoice number not in in order anymore
« on: March 19, 2016, 11:16:56 am »
Hi,
I am using virtuemart now since more then a year and the invoice number was always in order:
160219Q3XV039
160219C2C7040
etc.

but for what ever reason it changed and it is sometimes jumping one number.  The order number is still in order so it is not that i am missing something.
If I had change anything in the meantime I would know where to search, but I am not aware of anything.

Any idea?

thanks
Daniel

Joomla! 3.4.7
VirtueMart 3.0.12
http://www.mementi-urnen.de

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10441
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: invoice number not in in order anymore
« Reply #1 on: March 20, 2016, 22:10:36 pm »
if u have sequential invoice numbers you must be using a plugin or hack as they are by standard installs random (I assume u mean Order numbers)
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

DanielIIC

  • Beginner
  • *
  • Posts: 26
  • A beginner
Re: invoice number not in in order anymore
« Reply #2 on: March 21, 2016, 23:22:27 pm »
Hi,
the order number (the one I can see in the left column in the order menu) is in a clear sequence:

A32T054
WC1Z055
NEG7056
N5XQ057
so that's fine.

but the invoice number I got on the pdf file (print options) next to the delivery notes, was in the previous described sequence.
It is also in the details under the IP adress "invoice"

Do I really need a plug-in to get this in sequence, was it just pure luck to be in sequence?

regards
Daniel

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10273
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: invoice number not in in order anymore
« Reply #3 on: March 22, 2016, 02:04:15 am »
The count of ordernumber and invoice counts the rows. So it works not perfect,
this plugin
http://extensions.virtuemart.net/vm-orders/automated-numbers-detail

uses an own table and own entry, just for the counter. The counter can be adjusted and works also per year, month, per country and so on.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

DanielIIC

  • Beginner
  • *
  • Posts: 26
  • A beginner
Re: invoice number not in in order anymore
« Reply #4 on: March 25, 2016, 11:42:52 am »
ok, thanks
I will try

DanielIIC

  • Beginner
  • *
  • Posts: 26
  • A beginner
Re: invoice number not in in order anymore
« Reply #5 on: March 31, 2016, 22:04:31 pm »
Hi,
It worked.

it took me a bit to get the syntax in the way I wanted it to have it, but it does what it should.

thanks for the help.

regards
Daniel