advance the invoice number

insegnalo
Topic Author
Offline

13 years 6 months ago #92045 by insegnalo

advance the invoice number was created by insegnalo

Hi
perhaps something has happened since the last update

does not advance the invoice number

See the attached image

thanks

Fabio

Configuration:
Joomla: 2.5.9
Hikashop: 2.1.1
Hikamarket: 1.1.2

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

13 years 6 months ago #92069 by Jerome

Replied by Jerome on topic advance the invoice number

Hi,

In the class order (administrator/components/com_hikashop/classes/order.php) there is two references to "$order->order_invoice_id".
Please update the file with these two new indicated lines:

Code:

					$order->order_invoice_id = $this->database->loadResult();
					$order->order_invoice_number = hikashop_encode($order, 'invoice');
					$order->order_invoice_created = time(); // Add this line

Code:

						$order->order_invoice_id = $order->order_id;
						$order->order_invoice_number = $order->order_number;
						$order->order_invoice_created = time(); // Add this line

It should fix your problem with the new option "invoice_reset_frequency".

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

insegnalo
Topic Author
Offline

13 years 6 months ago #93601 by insegnalo

Replied by insegnalo on topic advance the invoice number

Hi,

I did this change

if in the settings choose "Invoice number reset frequency" = "every years" the counter of the invoice does not feed (remains locked to a number lower than the last)

As if "Invoice number reset frequency" = no
counter order_invoice_id runs normally

Regards
Fabio

Configuration:
Joomla: 2.5.9
Hikashop: 2.1.1
Hikamarket: 1.1.2

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

13 years 6 months ago - 13 years 6 months ago #93718 by Jerome

Replied by Jerome on topic advance the invoice number

Hi,

It is because the last one does not have the right value in the column "order_invoice_created". So the algorithm does not use the value of this order because it does not see this order as an order generated this year.
You have to update your orders of this year by copying the value of "order_created" to "order_invoice_created".

You can use this SQL query (replace "#_" with you database prefix, like "jos")

Code:

UPDATE #__hikashop_order SET order_invoice_created = order_created WHERE order_invoice_id > 0 AND (order_invoice_created IS NULL OR order_invoice_created = 0);

Regards,

Last edit: 13 years 6 months ago by Jerome.

Please Log in or Create an account to join the conversation.

egel
Offline

13 years 6 months ago #93789 by egel

Replied by egel on topic advance the invoice number

i have set monthly reset and it is not working will this solution work for this?

Please Log in or Create an account to join the conversation.

Jerome
Offline
HikaShop core developer

13 years 6 months ago #93850 by Jerome

Replied by Jerome on topic advance the invoice number

Hi,

Yes, the two modifications are required.

Regards,

Please Log in or Create an account to join the conversation.

Time to create page: 0.210 seconds