Mail Invoice number showing incorrectly

Post Reply

4 posts Page 1 of 1

Mail Invoice number showing incorrectly

CraDae

New member

Posts

Joined

Mon Aug 01, 2011 11:24 pm

Post by CraDae » Wed Sep 07, 2011 9:50 pm

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

Last edited by CraDae on Wed Sep 07, 2011 10:47 pm, edited 1 time in total.

CraDae

New member

Posts

Joined

Mon Aug 01, 2011 11:24 pm

Re: Mail Invoice number showing incorrectly

uksitebuilder

Guru Member

Posts

7606

Joined

Thu Jun 09, 2011 11:37 pm

Location

United Kindgom

Post by uksitebuilder » Wed Sep 07, 2011 11:54 pm

BACKUP first

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')) . "'");

replace with

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']) . "'");

find

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 . "'");

replace with

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 . "'");

it would be a good idea to upgrade to at least 1.5.0.5