BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Orders Put On Hold or basically any status included in Daily Sales report?
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
We use the Daily Sales and Search by Date reports as a means to tell us the sales we had for that date range. The thing is orders that are placed On Hold or A Custom Status we created called Canceled are showing up in this report?
I don't think its logical to include these types of orders into the Sales by Date, Date Reports if they are not actual sales. They are more or less still pending and we have not received the funds for them.
I would think that any orders that are mark completed should be the ONLY status that be included in the sales reports.
Is this by design? I hope not. |
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Yes, it's by design. I've found items in this sales report that are marked 'phone for quote'... can't be ordered on-line. I'm pretty sure the list includes items placed in a wish-list too. It's a useless report in SP2.
Has this been fixed in SP3.1, 3.2, 3.2A? |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
I actually fixed this just now in on my store by making a change to the .vb code. It only now displays the completed orders and leaves the rest off the list.
I wish I didn't have to do this because now I have to remember that change for service packs...but, oh well. =) |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
We will put this in the list. We will probably have to implement it so that store owners can choose what status they want to display. The issue is that some people may consider an order to be a valid order before it is marked "completed", others may not. If people put in custom statuses that they want included, we have no way of knowing (at this point) whether they want them in the report or not. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
For those wanting to know what I did here is the code I added to the Daily Sales report and Sale by Date report. You need to edit the view.aspx.vb files for each respective report Daily Sales report is located in /BVModules/Reports/Daily Sales Sales By Date is located in /BVModules/Reports/Sales By Date Open up the View.aspx.vb file and look for this bit of code Code:
Dim c As New Orders.OrderSearchCriteria
c.StartDate = Me.DatePicker.SelectedDate
c.EndDate = Me.DatePicker.SelectedDate.AddDays(1)
And add this line Code:
Dim c As New Orders.OrderSearchCriteria
c.StatusCode = "09D7305D-BD95-48d2-A025-16ADC827582A"
c.StartDate = Me.DatePicker.SelectedDate
c.EndDate = Me.DatePicker.SelectedDate.AddDays(1)
Now that long bit of alphanumeric is the BVIN field. I don't know if that is going to be the same in everyone's DB so this is how I found it. You open up your SQL Management program and look for the table bvc_OrderStatusCode. Once you have the table open look for the Status Name "Complete" Use that BVIN value as the one up above. If its the same don't worry about it. Good luck...and hopefully backup those pages before you apply this. =) |
|
|
|
|
|
|
Rank: Member
Joined: 3/24/2005(UTC)
Posts: 311
|
That would be great Justin thanks for the quick response! |
|
|
|
|
|
|
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.