Numbering of billing documents (invoice & receipt) for Virtuemart3

Hi In [login to view URL] which is a Joomla 3.6.5 and Virtuemart 3.018 I have made some modifications on the following files in order for the customer to get a receipt or an invoice depending on his choice during checkout process: Under : /templates/shaper_varsita/html/com_virtuemart/orders : [login to view URL] That is where we decide if we will show a button for invoice "Τιμολόγιο" or receipt "Απόδειξη" depending on the customer's choice during the checkout process. Also here the button Προβολή / Εκτύπωση Απόδειξης for receipt and Προβολή / Εκτύπωση Τιμολογίου displays if and only if the order is confirmed. If the order is not confirmed the customer should not be able to get an invoice or a receipt! Under : /templates/shaper_varsita/html/com_virtuemart/invoice [login to view URL] (renamed it to [login to view URL]) Here there is some code to "translate" the amount into Greek words and the <?php echo $this->item->id ?> on line 136 takes the order ID for the invoice number. Under : /templates/shaper_varsita/html/com_virtuemart/receipt [login to view URL] (renamed it to [login to view URL]) Here there is some code to "translate" the amount into Greek words and the <?php echo $this->item->id ?> on line 137 takes the order ID for the receipt number. Of couree there is a field into the virtuemart_userinfos table called parastatiko which takes values "Απόδειξη" & "Τιμολόγιο" for receipt and invoice accordingly during the checkout process. NOW what needs to be done is: 1. If a customer chooses to have "Τιμολόγιο" (invoice) during the checkout process (OPC cart) to set, starting from 1, the invoice number on a different DB table for that specific order. 2. If a customer chooses to have "Απόδειξη" (receipt) during the checkout process (OPC cart) to set, starting from 1, the receipt number on the same DB table for that specific order. 3. Then depending on the order number when the [login to view URL] or [login to view URL] gets executed to get the value for that order for invoice or receipt number from the coresponding value of invoice or receipt from that DB table for the specific order. This DB table ie named billing with fields virtuemart_order_id (same as in virtuemart_orders), invoice_id and receipt_id would just increase the invoice_id and receipt_id by one when the customer chooses invoice or receipt. I am including my example that I posted on the forum below: Initially: invoice_number = 0 receipt_number = 0 if 1st Order --> Invoice invoice_number+1 (0+1=1) invoice_number = 1 if 2nd Order --> Invoice invoice_number+1 (1+1=2) invoice_number = 2 if 3rd Order --> Receipt receipt_number+1 (0+1=1) receipt_number = 1 if 4th Order --> Receipt receipt_number+1 (1+1=2) receipt_number = 2 if 5th Order --> Receipt receipt_number+1 (2+1=3) receipt_number = 3 if 6th Order --> Invoice invoice_number+1 (2+1=3) invoice_number = 3 if 7th Order --> Receipt receipt_number+1 (3+1=4) receipt_number = 4 Therefore after the 7th Order : invoice_number = 3 receipt_number = 4 If you have any questions and if you need FTP, DB and backend access please feel free to contact me.