Todd,
You're on the right track. I know of at least one other Vantage customer I had worked with many moons ago who had the same situation you're describing. A product with one billing address and a gazillion retail shipping points. They created a Ship to for each location. The leading zeros helped in this situation as well.
Unless there is some new functionality on 8 I think you've already figured out the best way to handle.
HTH,
Mike
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Wednesday, July 20, 2005 2:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Customer Ship To - Retail Drop Ship Means Thousands of Them
For a metal stamping job shop we have gotten ourselves into an odd situation where a new subsidiary sells a consumer product. Mostly through distributors who have us send the product (electric mirror defoggers for bathrooms and fogfree mirrors for showers) direct to the customer. We have one distributor who now has about 2,000 ship to addresses and another which will have many times that if the relationship takes off. This one deals with showrooms that builders send people to to spend their accessories allowances on their new house. Could be many thousands of new houses the products go into (we certainly hope anyway). So I am looking to see how other people doing retail sales handle this where we bill the distributor but ship to the end consumer (or their builder anyway).
Do you create a new shipto for each receiving location? Or is there another way to ship and forget? I might try making a dummy shipto and having them change it for each order but we might have a dozen in process at a given time and I also would not want to lose the trail of where it went. When we invoice the distributor they like to see the receiving address and sometimes their customer number for the end customer.
One big issue for our people is numbering each shipto record. Unless I missed it it looks like there is no autonumbering (next) capability. Best advice for them so far has been to number with lots of leading zeros because it is an alphanum field and does not do a numeric sort. This way they can at least search for the last number and add one themselves.
Any tips and tricks would be much appreciated.
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Technical <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg> support Vantage <http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw> Database <http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>
Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-u9MWSh0_-hA> management software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT26M5TzRGQlg> database software Church <http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6ys_yZxg> database software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
You're on the right track. I know of at least one other Vantage customer I had worked with many moons ago who had the same situation you're describing. A product with one billing address and a gazillion retail shipping points. They created a Ship to for each location. The leading zeros helped in this situation as well.
Unless there is some new functionality on 8 I think you've already figured out the best way to handle.
HTH,
Mike
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Todd Caughey
Sent: Wednesday, July 20, 2005 2:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Customer Ship To - Retail Drop Ship Means Thousands of Them
For a metal stamping job shop we have gotten ourselves into an odd situation where a new subsidiary sells a consumer product. Mostly through distributors who have us send the product (electric mirror defoggers for bathrooms and fogfree mirrors for showers) direct to the customer. We have one distributor who now has about 2,000 ship to addresses and another which will have many times that if the relationship takes off. This one deals with showrooms that builders send people to to spend their accessories allowances on their new house. Could be many thousands of new houses the products go into (we certainly hope anyway). So I am looking to see how other people doing retail sales handle this where we bill the distributor but ship to the end consumer (or their builder anyway).
Do you create a new shipto for each receiving location? Or is there another way to ship and forget? I might try making a dummy shipto and having them change it for each order but we might have a dozen in process at a given time and I also would not want to lose the trail of where it went. When we invoice the distributor they like to see the receiving address and sometimes their customer number for the end customer.
One big issue for our people is numbering each shipto record. Unless I missed it it looks like there is no autonumbering (next) capability. Best advice for them so far has been to number with lots of leading zeros because it is an alphanum field and does not do a numeric sort. This way they can at least search for the last number and add one themselves.
Any tips and tricks would be much appreciated.
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
SPONSORED LINKS
Technical <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg> support Vantage <http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw> Database <http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>
Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-u9MWSh0_-hA> management software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT26M5TzRGQlg> database software Church <http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6ys_yZxg> database software
_____
YAHOO! GROUPS LINKS
* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]