Phoca Forum

I want to use this really good add-on with my online shop, however I'm concerned that the first invoice will be with number 0001. It doesn't look professional as customers could think that this is my first day of business. Is there a way to change this number in the database?
Thanks

Hi, the numbers are auto increment numbers, but you can change it e.g. in PDF so you will add before the number som your tags, search this forum, there should be a guide how to do.

Jan

Thanks for your help Jan,

For those interested and to give an idea of how it can be done, I've added 9 (for 2009) at the beginning of my invoice number.
I've added in the english.php file the following line : 'VM_DELIVERY_YEAR' => '9',
and replaced in phoca.tcpdf.php the following line :
$this->Cell(24,5,$hD['dbb']->f('bill_id'),0,0,'C');
by
$this->Cell(24,5,$VM_LANG->_('VM_DELIVERY_YEAR').$hD['dbb']->f('bill_id'),0,0,'C');
If you want to do the same for the delivery number replace in the same file the following line :
$this->Cell(28,5,$hD['d']['delivery_id'],0,0,'C');
by
$this->Cell(28,5,$VM_LANG->_('VM_DELIVERY_YEAR').$hD['d']['delivery_id'],0,0,'C');

Great, thank you for this information, I hope it will be usable for other users too.

Thank you, Jan

I changed the following last entries in the database e.g. first Invoiceno. 100:

Table jos_vm_bills
Field bill_id=99 and delivery_id=99

Table jos_vm_deliveries
Field delivery_id=99

So, the next auto increment no. is of course 100. Hope that helps.

Tobi

bluesoul wrote:Thanks for your help Jan,

For those interested and to give an idea of how it can be done, I've added 9 (for 2009) at the beginning of my invoice number.
I've added in the english.php file the following line : 'VM_DELIVERY_YEAR' => '9',
and replaced in phoca.tcpdf.php the following line :
$this->Cell(24,5,$hD['dbb']->f('bill_id'),0,0,'C');
by
$this->Cell(24,5,$VM_LANG->_('VM_DELIVERY_YEAR').$hD['dbb']->f('bill_id'),0,0,'C');
If you want to do the same for the delivery number replace in the same file the following line :
$this->Cell(28,5,$hD['d']['delivery_id'],0,0,'C');
by
$this->Cell(28,5,$VM_LANG->_('VM_DELIVERY_YEAR').$hD['d']['delivery_id'],0,0,'C');

Hi,
What is the path of the english.php file?

Thks.