Phoca Forum

Hi,

Many companies restart the invoice count number at each New Year and I will sugest a way to solve your problems ( like it solve my ).

Imagine that at the start of 2011 Year you wish to have invoice numbered by the following
2011XXXXX
The first invoice will be 2011000001, the second 2011000002 and so on.

If you wish to have this to Invoice, Receipt and Delivery Notes you need to make some little changes in the database:

Change the AutoIncrement Start Counter:
ALTER TABLE jos_vm_bills AUTO_INCREMENT = 2011000001;
ALTER TABLE jos_vm_deliveries AUTO_INCREMENT = 2011000001;
ALTER TABLE jos_vm_orders AUTO_INCREMENT = 2011000001;

Change the index order :
jos_vm_deliveries - Change the order Primary Index (vendor_id, delivery_id) to Primary Index ( delivery_id, vendor_id)
jos_vm_bills - Change the order Primary Index (vendor_id, bill_id) to Primary Index (bill_id, vendor_id)

I check several other posts that require something like this. Hope this can help someone.

Bye

Hi, thank you for the guide.

Jan

hi how too this:


Change the index order :
jos_vm_deliveries - Change the order Primary Index (vendor_id, delivery_id) to Primary Index ( delivery_id, vendor_id)
jos_vm_bills - Change the order Primary Index (vendor_id, bill_id) to Primary Index (bill_id, vendor_id)

I check several other posts that require something like this. Hope this can help someone.

i novice

Howw too change?? any idea

Hi, no experiences with this

Jan

Dear ardose,

You can install something in joomla to help you manage the database, phpMyAdmin or Artadminer or via console.
Then you must run the following sql commands
Best Regards,
Miguel