Good Day Tim:
With only 258 parts, I would make the new Part#'s.
In a year you will have history again, and in the
meantime you can use the old history.
You should also run the search often to stop new ones
from getting in; or, a BPM at PART-Entry to stop it there ( much better
solution).
Finally, the last time I migrated data, quotes in the
Description were a problem in the migration.
Len
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Vonderhaar
Sent: Friday, February 22, 2013 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9 - Quote symbol in PartNum not joining in
Report Data Definition
Thanks for the input Len. Unfortunately, we do have many part numbers
(258) like this and there is indeed history. These are not new part
numbers, they have been in our old system for years with much history
which we also brought in during our implementation DMTs. I am very
disappointed that Epicor would allow the creation of a part number that
included characters that would be problematic down stream. Our old
system didn't mind these characters, so we didn't even consider the
issue since the data imported correctly.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Len
Hartka" wrote:
Behalf
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.
[Non-text portions of this message have been removed]
With only 258 parts, I would make the new Part#'s.
In a year you will have history again, and in the
meantime you can use the old history.
You should also run the search often to stop new ones
from getting in; or, a BPM at PART-Entry to stop it there ( much better
solution).
Finally, the last time I migrated data, quotes in the
Description were a problem in the migration.
Len
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tim Vonderhaar
Sent: Friday, February 22, 2013 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E9 - Quote symbol in PartNum not joining in
Report Data Definition
Thanks for the input Len. Unfortunately, we do have many part numbers
(258) like this and there is indeed history. These are not new part
numbers, they have been in our old system for years with much history
which we also brought in during our implementation DMTs. I am very
disappointed that Epicor would allow the creation of a part number that
included characters that would be problematic down stream. Our old
system didn't mind these characters, so we didn't even consider the
issue since the data imported correctly.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Len
Hartka" wrote:
>You
> Good Day:
>
>
>
> Unless you have over a thousand PARTs with the problem,
> the right answer is to get rid of the " by replacing with new parts.
> can da BAQ search on >> Part:PartNum >> matches (constant = *"* ).-
>
>
>
> As noted, it will just keep popping up with problems.
> Even if you export or Paste data.
>
>
>
> Unfortunately, there are dominoes:
>
>
>
> A. Since it is a new part, it will not have a history. Trans, PO,
> Sales-Orders, etc. - all under old number.
>
> B. Probably want to make new a substitute for the old to prevent usage
> or make old inactive.[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
>
> C. New should have a note with old # so you can find it.
>
> D. Need to change in all BOM's
>
> E. Maybe a little customer confusion since they need to order the new
> number.
>
>
>
>
>
>
> Len
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Behalf
> Of brenda mohrOn
> Sent: Friday, February 22, 2013 6:49 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] E9 - Quote symbol in PartNum not joining in
> Report Data Definition
>
>
>
>
>
> We have found issues with all of the following in one form or another
> being in the PartNum And/Or PartDesc:
>
> " (Double Quote), ' (Single Quote), & (Ampersand), , (Comma), < (Less
> Than) , > (Greater Than)
>
> Needless to say, we just avoid them or it haunts you when you least
> expect it :(
>
> Brenda
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]
> Behalfcreated
> Of John Driggers
> Sent: Thursday, February 21, 2013 11:25 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: Re: [Vantage] E9 - Quote symbol in PartNum not joining in
> Report Data Definition
>
> Are they being escaped in the XML or do you just see the quote? I
> believe the escape format is " If it's not escaped in the XML it's
> likely a bug in Epicor. If they are escaped, the problem is likely in
> your report itself.
>
> *John Driggers*
> **
> *Chief Data Wrangler*
> *
> *
> *I have an Epicor blog http://usdoingstuff.com/>. How useful is that?*
> *
> *:: 904.404.9233
> :: waffqle@...
> :: http://www.usdoingstuff.com http://www.usdoingstuff.com/>
>
> *
>
> *
>
> On Thu, Feb 21, 2013 at 3:50 PM, Tim Vonderhaar <
> tvonderhaar@... >
> wrote:
>
> > **
> >
> >
> > We have several parts that have the quote (") symbol as part of the
> > part number. For example, a part number for shrink tube includes the
> > diameter as inches like this E6000-AUF-15/16"BLK. I have copied and
> > modified the BOM Listing RDD to include the PartCost table and
>I
> > a relationship between PartMtl and PartCost on the PartNum. Now when
>will
> > run the RDD, in the XML output, I will see the above part number in
> > PartMtl section, but I will not see it in the PartCost section. I
>)
> > see all other non quote character parts though, so I know the
> > relationship is working, just not for parts with a quote symbol.
> >
> > Any idea why?
> >
> >
> >
>
> [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<http://groups.yahoo.com/group/vantage/files/>
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> http://groups.yahoo.com/group/vantage/files/>confidential information. If you are not the intended recipient, please
> (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/linksYahoo! Groups Links
>
>
>
>
>
> This e-mail and any attachments may contain proprietary and/or
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.
>This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]