logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
judy at Web2Market  
#1 Posted : Monday, November 15, 2021 7:07:01 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
We have a B6432 site asking this and I've looked a little in the source code and can't answer it. For them, for October, they had one cancelled order for 4,500 (they show their currency as points instead of dollars). Their monthly sales and sales over time match, but annual sales is 4,500 more for October.
September is really weird- they have one cancelled order for 1,125 but the discrepancy is 4000.
I checked a 9.0.4 site and they are showing a similar discrepancy for October-annual sales includes cancelled orders.
Shouldn't all three totals for October match.
See attached document. SalesDiscrepancy.doc (340kb) downloaded 5 time(s).

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

shaharyar  
#2 Posted : Tuesday, November 16, 2021 5:50:49 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
I have tried on my test database but I am unable to reproduce the issue.


Quote:
Their monthly sales and sales overtime match, but annual sales are 4,500 more for October.


For October, the difference is 3000, not 4500. This means that it is not because of the cancelled order amount.
judy at Web2Market  
#3 Posted : Tuesday, November 16, 2021 6:23:13 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Well, I guess I can't subtract, I just took her word for the 4500. I just checked a third site and they are seeing discrepancies also.
shaharyar  
#4 Posted : Tuesday, November 16, 2021 6:36:26 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
I think the issue is related to the difference in the timestamp. I have reported the issue to see this in details

Thanks
judy at Web2Market  
#5 Posted : Wednesday, November 17, 2021 6:17:12 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Thanks. If you come up with fix please post it.
Also, when looking at date discrepancies and trying to tie them to specific orders, I noticed that on 9.0.4 and previous sites, on the manage orders screen, if you want to include orders for the last day of the month, you have to select the first day of the next month as the end date. For example, October 31 orders didn't show until I set Nov 1 as the end date.
shaharyar  
#6 Posted : Wednesday, November 17, 2021 6:29:30 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Quote:
Also, when looking at date discrepancies and trying to tie them to specific orders, I noticed that on 9.0.4 and previous sites, on the manage orders screen, if you want to include orders for the last day of the month, you have to select the first day of the next month as the end date. For example, October 31 orders didn't show until I set Nov 1 as the end date.


This very issue was fixed in 905.

I will share the code fix for the issue.
Thanks
Users browsing this topic
Guest (2)
Similar Topics
Discrepancy in sales reports-edge case (AbleCommerce 9 Bug Reports)
by judy at Web2Market 4/10/2023 7:23:52 AM(UTC)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.