Hello,
I trust you are all doing well.
I am having a bit of an issue with the invoice numbers.
When I "print invoice" in admin panel, it comes up correctly, e.g. Invoice No.: Inv000001
but when they get an email, the invoice number shows like this; Invoice No.: 1 .
Now I'm sure it wont be hard to fix, I just don't know how
Inv is part of my invoice number, and because of the company type I own in South Africa, I have to use it like this: Inv000001
TIA,
Craig
EDIT:
Anyone, please assist, you could also PM me
Version 1.5.0.1
I have not upgraded
BACKUP first
open: admin/model/sale/order.php
find
replace with
find
replace with
it would be a good idea to upgrade to at least 1.5.0.5
open: admin/model/sale/order.php
find
Code: Select all
$query = $this->db->query("SELECT MAX(invoice_no) AS invoice_no FROM `" . DB_PREFIX . "order` WHERE invoice_prefix = '" . $this->db->escape($this->config->get('config_invoice_prefix')) . "'");
Code: Select all
$query = $this->db->query("SELECT MAX(invoice_no) AS invoice_no FROM `" . DB_PREFIX . "order` WHERE invoice_prefix = '" . $this->db->escape($order_info['invoice_prefix']) . "'");
Code: Select all
$this->db->query("UPDATE `" . DB_PREFIX . "order` SET invoice_no = '" . (int)$invoice_no . "', invoice_prefix = '" . $this->db->escape($this->config->get('config_invoice_prefix')) . "' WHERE order_id = '" . (int)$order_id . "'");
Code: Select all
$this->db->query("UPDATE `" . DB_PREFIX . "order` SET invoice_no = '" . (int)$invoice_no . "', invoice_prefix = '" . $this->db->escape($order_info['invoice_prefix']) . "' WHERE order_id = '" . (int)$order_id . "'");
Who is online
Users browsing this forum: Baidu [Spider] and 279 guests