[Skip to main content](#vessel-content) # Invoice number not reset at beginning of the year ## - **[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")** - [![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile") Topic Author - [ Offline](/forum/user/31616-jaystore) Less More - Posts: 8 - Thank you received: 0 - - 9 years 7 months ago [\#265765](#265765) by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265765 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* was created by *[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")* The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate 00160/3/2017 and last invoice in 2016 was 00159/12/2016. Now we have updated last order to invoice id 14 and invoice number "00014/3/2017" but next oorder will generate again 00160/3/2017. What we have to update to get the system generate the right invoce number? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 7 months ago [\#265781](#265781) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265781 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Hello, Can you please provide us some details about your HikaShop configuration ? How your "order" settings are set ? How your order statuses are configured ? Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")** - [![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile") Topic Author - [ Offline](/forum/user/31616-jaystore) Less More - Posts: 8 - Thank you received: 0 - - 9 years 7 months ago [\#265901](#265901) by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") Replied by *[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265901 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Please check configuration in attachment [ ![HikaShopConf.jpg](/forum/attachment/37259) ](/forum/attachment/37259 "HikaShopConf.jpg") - [ ![HikaShopConf.jpg](/forum/attachment/37259) ](/forum/attachment/37259 "HikaShopConf.jpg") [ ](/forum/attachment/37259?download=1 "HikaShopConf.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 9 years 7 months ago [\#265907](#265907) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265907 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Hi, As far as I can see it looks good. Are you sure that you're looking at the invoice number and not the order number ? Because only the invoice number is reset with that setting. The order number keeps on incrementing no matter what. Also, the invoice number is only generated when the order is confirmed. If the order stays created, or if the payment plugin you're using doesn't properly change the status of the order via the standard functions of HikaShop it's possible that the invoice number is not generated and you're actually looking at the invoice number. On our end I did some tests just to make sure and it works properly. Could you do a screenshot of all the details of an order with the problem when you edit it via the backend orders manager ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")** - [![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile") Topic Author - [ Offline](/forum/user/31616-jaystore) Less More - Posts: 8 - Thank you received: 0 - - 9 years 7 months ago [\#265945](#265945) by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") Replied by *[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265945 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* We are using HikaShop since 2014 and we had no problems with invoices until 2017 and after different version updates. We know orders are not reset, just tell us the SQL statement to run to reset this number. Again, there is an invoice 159/12/2016 and we updated manually all 2017 invoices, we are sure next invoice will be 160/3/2017 . Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")** - [![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile") Topic Author - [ Offline](/forum/user/31616-jaystore) Less More - Posts: 8 - Thank you received: 0 - - 9 years 7 months ago [\#265968](#265968) by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") Replied by *[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265968 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Last order, this is data base data, the last order is 00160/3/2017 and the previous was updated to 014/3/2017 [ ![hikashopinvoice.png](/forum/attachment/37280) ](/forum/attachment/37280 "...hopinvoice.png") - [ ![hikashopinvoice.png](/forum/attachment/37280) ](/forum/attachment/37280 "...hopinvoice.png") [ ](/forum/attachment/37280?download=1 "...hopinvoice.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")** - [![jaystore's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31616-jaystore "View jaystore's Profile") Topic Author - [ Offline](/forum/user/31616-jaystore) Less More - Posts: 8 - Thank you received: 0 - - 9 years 7 months ago [\#265973](#265973) by [jaystore](/forum/user/31616-jaystore "View jaystore's Profile") Replied by *[jaystore](/forum/user/31616-jaystore "View jaystore's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#265973 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Another problem we found was the invoice date equal to order date. If the order is paid by bank transfer then is confirmed manually when we receive the money and print the invoice. But if we receive new orders then we have an invoice with a recent date and invoice number, when we confirm an outstanding order the date is old and invoice number new. This is not accepted by italian fiscal rules. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 9 years 6 months ago [\#266106](#266106) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Invoice number not reset at beginning of the year](/forum/35-orders-management/889516-invoice-number-not-reset-at-beginning-of-the-year#266106 "The invoice number was not reset at the beginning of the year as we have configured in Syste/Configutration/Order tab. We have to update manually the invoice number because it continues to calculate...")* Hi, Well, I don't see how that's possible and I can't reproduce. Please provide a backend access, a FTP access and a PHPMyAdmin access (ideally of a copy of your website) so that we could debug the situation because I'm out of ideas here. You can use our contact form to provide that along with a link to this thread: [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4OTUxNi1pbnZvaWNlLW51bWJlci1ub3QtcmVzZXQtYXQtYmVnaW5uaW5nLW9mLXRoZS15ZWFyP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.214 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)