Rank: Member
Joined: 11/20/2008(UTC)
Posts: 4
|
Hi
I was hoping to get some help on a problem that just cropped up. I am currently setting up a new BVC5 website so it's not public yet. I've been testing the order process all along and haven't had a problem until now. But just yesterday, all of the orders I place are given the order number of 0 (it seems to be ignoring the OrderNumberSeed settings all of a sudden). I now have a dozen Orders with an order number of 0. I'm not sure what I would have done to cause this to happen however I have been importing sales order from our accounting software so customers can look at their previous orders and get tracking info. But I made sure none of the order numbers would overlap.
I'm really scratching my head on this.
Any insight into what might be happening, would be appreciated.
Steve
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
Steve -- does anything show up in your event log when you generate one of those orders?
Is the "Assign Order Number" in place in your Process New Order workflow? Perhaps that got taken out somehow. |
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
Also make sure your settings are correct under Options --> Site Settings --> Orders.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 11/20/2008(UTC)
Posts: 4
|
I didn't even think to check the event log. Thanks
This is the error that I get:
Conversion from string "R9999 " to type 'Integer' is not valid.[ at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(Object Value) at BVSoftware.Bvc5.Core.Orders.Order.Mapper.FindMaxOrderNumber() at BVSoftware.Bvc5.Core.Orders.OrderNumberGenerator.GenerateNewOrderNumber() ]
I know that our accounting software creates return orders with an order number of R#### and that I have been importing those return orders into the BV website. So I'm guessing that because these order numbers have a char in them, the FindMaxOrderNumber function is returning an error and all the new order numbers are coming up 0.
Am I correct in assuming that I need to either:
* modify the FindMaxOrderNumber function so that it ignores the orders with an R in them or
* Remove all of the return orders from the database
Is there a third option?
Thanks for the help.
Steve
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
A third option is to edit the bvc_Order_MaxOrderNumber_s stored procedure in the database to strip off the "R". I think that is the way I would go because stored procedure changes are pretty easy to re-apply after installing a service pack. |
|
|
|
|
|
|
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.