Thanks Greg. I hadn't tested that scenario of simply saving a CustCnt contact once the PhoneNum and FaxNum were blanked. I had written a SQL routine to go back and clear them thinking that would solve the data import issue. This finding in itself forces my hand. I guess without being able to disable the code internally, I will have to back populate whatever Epicor does into our CRM environment and move on. Bummer.
--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> When I had DMT training, I was told the best way to troubleshoot DMT was to attempt the same operation manually, since DMT uses the same objects. I tried to clear the phone number and fax from a contact and when saved they came back,
>
> The CustCnt table has this entry on PhoneNum
> The contact's business telephone number. When displaying phone numbers of contacts the system will use the phone number found in the Customer or Shipto file if the contacts number is blank.
>
> You can try a BPM to set them to all 9's on pre and then clear the 9s on post
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tim Vonderhaar
> Sent: Tuesday, November 22, 2011 9:42 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: DMT Customer Contacts adding unwanted FaxNum and PhoneNum
>
>
>
> Yes, I tried that. First pass I have just the Add New checked, second pass I have just the Update, but the numbers still were that of the customer record.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "bw2868bond" <bwalker@<mailto:bwalker@>> wrote:
> >
> > sounds like that is a function of the BO or a Db trigger.
> > Have you tried a second pass to Update the records and blank out those fields?
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > >
> > > Anyone?
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > > >
> > > > We are DMTing contacts into customers and have found that if the PhoneNum \ FaxNum of the contact being imported is blank, the system will insert the PhoneNum \ FaxNum from the Customer in it's place. Given we are trying to synchronize between two systems, having this type of data change is undesirable. Anyone know how to prevent this during the DMT process?
> > > >
> > > > Thanks,
> > > > Tim
> > > >
> > >
> >
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at (727) 578-6258 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>