Some of those you can delete if you remove them from the Vendors and Customers. It just depends on when and where you used that Vendor and Customer. This was one of those things identified at the Morroco road show and I did most of this editting right after installing 4.0 and was able to clean up the bad Country stuff.
-----Original Message-----
From: Wayne Cox [SMTP:wmc@...]
Sent: Monday, July 17, 2000 01:55 PM
To: vantage@egroups.com
Subject: [Vantage] Vtg 4 COuntry table
Just ran into a new one in Vantage 4.0 that I hadn't heard about. The
Country field on vendors, customers, etc is now coded from a Country
table, instead of being free-form text. Apparently this came with
the 3.2 "international" version?
This is a nice change (wish they'd do it for states too.) But - one of the
conversion routines loads up the new Country table with every single
country it can find in the old text field. Including obscure places like
AP check addresses.
Here's the annoying part... Early on in our Vantage implementation, we had
users putting all kinds of junk in the country field, like US, U.S.A., USA
and even "Attn: Joe Smith" We cleaned it out of the master files, but it's
permanently stuck in things like the AP Checks. And now, permanently
stuck in County as well. Arrgh! Would have been nice to have the option
to skip the junk, instead of proliferating it more. Guess I just need to
finally figure out ProVision or some way to blank out the old junk.
-Wayne Cox
------------------------------------------------------------------------
Still looking for the complete Application Server solution?
Find answers and a $75 gift certificate at the Intraware App Server
Webinar. Sign up at:
http://click.egroups.com/1/6756/13/_/411782/_/963860225/
------------------------------------------------------------------------
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]
-----Original Message-----
From: Wayne Cox [SMTP:wmc@...]
Sent: Monday, July 17, 2000 01:55 PM
To: vantage@egroups.com
Subject: [Vantage] Vtg 4 COuntry table
Just ran into a new one in Vantage 4.0 that I hadn't heard about. The
Country field on vendors, customers, etc is now coded from a Country
table, instead of being free-form text. Apparently this came with
the 3.2 "international" version?
This is a nice change (wish they'd do it for states too.) But - one of the
conversion routines loads up the new Country table with every single
country it can find in the old text field. Including obscure places like
AP check addresses.
Here's the annoying part... Early on in our Vantage implementation, we had
users putting all kinds of junk in the country field, like US, U.S.A., USA
and even "Attn: Joe Smith" We cleaned it out of the master files, but it's
permanently stuck in things like the AP Checks. And now, permanently
stuck in County as well. Arrgh! Would have been nice to have the option
to skip the junk, instead of proliferating it more. Guess I just need to
finally figure out ProVision or some way to blank out the old junk.
-Wayne Cox
------------------------------------------------------------------------
Still looking for the complete Application Server solution?
Find answers and a $75 gift certificate at the Intraware App Server
Webinar. Sign up at:
http://click.egroups.com/1/6756/13/_/411782/_/963860225/
------------------------------------------------------------------------
We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)
[Non-text portions of this message have been removed]