BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Sales By Date Report - Custom Range - Not Accurate
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
If you generate a report 'sales by date' and set a custom date range you get the following results:
April 1 - April 30: Grand Total = $10500
May 1 - May 31: Grand Total = $10500
June 1 - June 30: Grand Total = $10500
April 1 - June 30: Grand Total = $31900
Notice $10500 + $10500 + $10500 = $31500, not $31900!
The numbers shown above are just examples, but the point is that the numbers for sub-total, shipping, grand total, etc. when looked at month by month do not add up to what is calculated on a multi-month range.
This would seem to imply that the calculation is failing to count the transactions that occur on the first/last date in the range, but more investigation is needed.
Could someone else confirm so that BV could address the issue. Thanks!
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Mark,
Do you have orders that are unpaid or not completed?
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Same here, $hundreds too high if I ask for Jan 1st - Mar 31st as opposed to adding J, F, M together.
Oddly, if I quiry for March 1-30 I get a total. If I ask for March 1-31 I get a different total. There was no sale posted for March 31, so the total shouldn't be different!!! Perhaps it's a calendar thing.
I'm getting the same thing happening for July.... 1-30/1-31 no sale on July 31 but I do get different totals.
Marcus, I checked, no abandoned carts or uncompleted orders for July 31.
If these are the figures going to Quickbooks (for those who use QB)....well..... I'd double check with the paper receipts for accuracy.
Interesting, but not likely to get much attention. BVC5 is out of the oven, we're all looking forward to BVC6. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 12/19/2006(UTC)
Posts: 153
|
Marcus, All orders are complete and paid.
Just for reference, we are talking about a $300 difference when looking at 3 months, vs month 1+2+3
We do have 1 order within the time period that was voided and the order total set to $0, but the original transaction was only $70 and does not correspond the the ~$300 discrepancy.
We also have may returns, that add up to well over the ~$300 discrepancy.
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
I've noticed this for some time. If you use custom date, say July 1 to July 31, it will not include the sales for July 31, only through July 30. However if you ask for last months sales it will include July 31.
I've been using a work around. For June sales I request June 1 to July 1, then it works fine. It just drops July 1.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
I think the fact that so little has come of this means nobody really uses this on-screen tool - can't even be printed.
If these numbers go to the outside world like this, it probably should be fixed. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 1/17/2007(UTC)
Posts: 69
|
it's still a bug whether it is a frequently used feature or not.
|
|
|
|
|
|
Rank: Member
Joined: 4/22/2004(UTC)
Posts: 280
|
Right - it is definitely a bug, definitely used and, IMO, definitely should be fixed.
Linette
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Does anyone know if the numbers that are exported to Quickbooks are correct? Perhaps showing the same error? |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
When you export the numbers to quick books, you export them by order number, not by date. However, I'm still not sure if they are exporting correctly.
We use the export paid orders only function and if the order is under or over paid it will not export. When it does export it records the payment date as the date the order was placed, not the actual payment date. So I can't reconcile the batches with our bank statement. In fact the connector doesn't provide any batch details.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Right now I suspect this has to do with translation of time zones from Universal to local time. One report is not doing the time conversion correctly giving you the difference. I'll dig into the details and try and provide a hot fixed report for the one that isn't accurate.
|
|
|
|
|
|
Rank: Member
Joined: 2/15/2007(UTC)
Posts: 37
|
To get accurate results, you must specify the 1st of one month to the 1st of the following.
For example:
July 1, 2008 - August 1, 2008 is correct
July 1, 2008 - July 31, 2008 is NOT
The query does not include the "end date's" sales. |
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Then I think the distinction is between - 'including' or 'up to' the date shown. By needing to quiry the 1st of the following month, it seems BVC is using 'up to'.
Anybody know which is in accordance with standard accounting practice? How does Quickbooks handle this type of quiry?
I know for reporting taxes for instance, sales figures are reported from the 1st to the 31st, not the 1st to the 1st.
I'm thinking about setting up QB for next year. I'd like to know I can trust the numbers that come over from the store. Does anyone know if their sales on the last day of each month are making it over to QB inf in fact QB quiries 1st to the 31st (as opposed to 1st to the 1st) for each month? |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
My experience with the QB Connector shows it imports data by order number, not date. You specify the first order number and the connector will import everything after that number (not that number). So if you pick a starting number of 1000 it will import 1001 and every subsequent order no matter what date or time zone it was placed in. The connector shows the last order number imported by default so that part works just fine.
The connector imports the date the order was placed, the date shown on the order. It doesn't stop on the end of the month or the last day of the month. It just stops after the last order placed at the time of the import. So it basically it imports everything available regardless of the date specified.
Bob Noble
Note: We are not using the 2008 beta version so I don't know what is happening there. We are 3.13.
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Thanks, Bob. That seems simple enough. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
There may be a bug in the date range for the Daily Sales Report At line 54 the code should read: Code:
Dim c As New Orders.OrderSearchCriteria
c.StartDate = New DateTime(Me.DatePicker.SelectedDate.Year, Me.DatePicker.SelectedDate.Month, Me.DatePicker.SelectedDate.Day, 0, 0, 0, 0)
c.EndDate = New DateTime(Me.DatePicker.SelectedDate.Year, Me.DatePicker.SelectedDate.Month, Me.DatePicker.SelectedDate.Day, 23, 59, 59, 999)
|
|
|
|
|
|
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.