[Skip to main content](#vessel-content) # inconsistencies in reports ## - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Topic Author - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 10 months ago [\#139620](#139620) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#139620 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* was created by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* -- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: [ ![h4a6513f.png](/forum/attachment/14661) ](/forum/attachment/14661 "h4a6513f.png") When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: [ ![h92e5f70.png](/forum/attachment/14662) ](/forum/attachment/14662 "h92e5f70.png") I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment. - [ ![h4a6513f.png](/forum/attachment/14661) ](/forum/attachment/14661 "h4a6513f.png") [ ](/forum/attachment/14661?download=1 "h4a6513f.png") - [ ![h92e5f70.png](/forum/attachment/14662) ](/forum/attachment/14662 "h92e5f70.png") [ ](/forum/attachment/14662?download=1 "h92e5f70.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 12 years 9 months ago [\#139756](#139756) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#139756 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* Hi, Are you sure you are using the same filters for the orders ? Because you shouldn't include the orders "created" or "cancelled". Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Topic Author - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 9 months ago [\#139778](#139778) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Replied by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* on topic *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#139778 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* Hi Jerome, glad you are helping out. My clients want to finish their administration over 2013 and this is a serious problem. I have now exported the CSV and made an overview but this also gives completely different totals.... To answer your question: No I only select CONFIRMED items, this year, incl VAT and nothing else. I get a crazy number, not sticking to the dates but it seems to take all orders in the system. [ ![h2458b39.png](/forum/attachment/14682) ](/forum/attachment/14682 "h2458b39.png") - [ ![h2458b39.png](/forum/attachment/14682) ](/forum/attachment/14682 "h2458b39.png") [ ](/forum/attachment/14682?download=1 "h2458b39.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 12 years 9 months ago [\#139941](#139941) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#139941 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* Hi, There is no option to display the calculations from the beginning of the current year. The option "This year" is actually the 365 previous days including the current one. If you want to see the results from the beginning of the year, you should set a start date as January 1st of the current year and no end date in your widget. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")** - [![zebrafilm's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Topic Author - [ Offline](/forum/user/6308-zebrafilm) Less More - Posts: 187 - Thank you received: 10 - - 12 years 9 months ago - 12 years 9 months ago [\#139958](#139958) by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Replied by *[zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile")* on topic *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#139958 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* Ah that explains part of the issue. I suggest to rename "This year" to "Last 365 days" to avoid confusion. What about 'last year' is it the real last year? What about sale "this month" = last 30 days or really this month? Bottom line seems: use the date setting rather than the preset? Last edit: 12 years 9 months ago by [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#140003](#140003) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[inconsistencies in reports](/forum/36-reports-statistics/864969-inconsistencies-in-reports#140003 "-- HikaShop version -- : latest -- Joomla version -- : latest -- PHP version -- : 5.4 -- Browser(s) name and version -- : n/a I am trying to get some reports done for my client and run into strange issues when it comes to total calculations in reports. There are only a few products and the 'default' widget shows: When I create a new widget with the YEAR TOTAL, it should be the same as the current month but I get: I have create the table pretty standard, set the dropdown to this year, added with VAT and only confirmed orders and clicked OK. It seems it takes 2013 with it. Than I tried a 'this year, versus this month, unless I lost count, we are still in January so it should be the same but the reports, display different values. Something like 23000 versus 17000, numbers I can't related too. If I just move the incl VAT to excluding VAT I suddenly get a total of >50.000 Is this a known bug or is it freaking out on some of our settings? Cant make any reliable reports at the moment.")* HI there, Last year is the same as "this year" but with one year less (so If you display this year and last year, you can see differences for the same dates). This month is also referring to last 30 days. We'll think about renaming it, it's indeed not especially relevant. Using date is however the best option if you want to display sales from January 1st to the current date. I guess it's what you're looking for ![:)](/media/kunena/emoticons/3.png ":)"). The following user(s) said Thank You: [zebrafilm](/forum/user/6308-zebrafilm "View zebrafilm's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NjQ5NjktaW5jb25zaXN0ZW5jaWVzLWluLXJlcG9ydHM/dG1wbD1tYXJrZG93bg==) 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.074 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)