ttQSalesRP email address is empty 9.05.701

Yahoo Archive
1
Thanks for your reply Greg. The answer was to look at the Post processing directive and the data was there.

Cheers
Simon Hall
--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> use the QSalesRP.SalesRepCode to link to SalesRep.SalesRepCode
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of s1mhall
> Sent: Tuesday, June 04, 2013 12:24 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] ttQSalesRP email address is empty 9.05.701
>
>
>
> Hello,
> I am attempting to create a BPM to send an email to the salesperson that is listed on a quote once the quote has been quoted (approved).
>
> When I attempt to create and email or informational message based on the information in the TTQSalesRP table the Global Alert log gives me an error stating no email address. The Message with included field data indicates that there is nothing in the ttQSalesRP.emailaddress field.
>
> When I look at the actual table in SQL the QSalesRP table does not have an email address field.
>
> The data dictionary indicate that there is no email address field on that table.
>
> Field help on the form for the Sales Person email address indicates that the Epibinding field is QSalesRP.emailaddress, but the DB field is blank
>
> In the past where there is nothing in the DB Field, I have been able to find the information in the PatchFld table, but not this time.
>
> Does anyone know where/how the system derives the data for the ttQSalesRP.emailaddress field?
>
> Is there some complex logic in Quoting that determines where the email address is obtained and if so how could we possibly dumb it down a bit so it actually does use the email address field on the Salesperson tab on the quote form?
>
> Cheers
> Simon Hall
>
>
> ________________________________
> 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-6280 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]
>
2
Hello,
I am attempting to create a BPM to send an email to the salesperson that is listed on a quote once the quote has been quoted (approved).

When I attempt to create and email or informational message based on the information in the TTQSalesRP table the Global Alert log gives me an error stating no email address. The Message with included field data indicates that there is nothing in the ttQSalesRP.emailaddress field.

When I look at the actual table in SQL the QSalesRP table does not have an email address field.

The data dictionary indicate that there is no email address field on that table.

Field help on the form for the Sales Person email address indicates that the Epibinding field is QSalesRP.emailaddress, but the DB field is blank

In the past where there is nothing in the DB Field, I have been able to find the information in the PatchFld table, but not this time.

Does anyone know where/how the system derives the data for the ttQSalesRP.emailaddress field?

Is there some complex logic in Quoting that determines where the email address is obtained and if so how could we possibly dumb it down a bit so it actually does use the email address field on the Salesperson tab on the quote form?


Cheers
Simon Hall
3
use the QSalesRP.SalesRepCode to link to SalesRep.SalesRepCode

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of s1mhall
Sent: Tuesday, June 04, 2013 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ttQSalesRP email address is empty 9.05.701



Hello,
I am attempting to create a BPM to send an email to the salesperson that is listed on a quote once the quote has been quoted (approved).

When I attempt to create and email or informational message based on the information in the TTQSalesRP table the Global Alert log gives me an error stating no email address. The Message with included field data indicates that there is nothing in the ttQSalesRP.emailaddress field.

When I look at the actual table in SQL the QSalesRP table does not have an email address field.

The data dictionary indicate that there is no email address field on that table.

Field help on the form for the Sales Person email address indicates that the Epibinding field is QSalesRP.emailaddress, but the DB field is blank

In the past where there is nothing in the DB Field, I have been able to find the information in the PatchFld table, but not this time.

Does anyone know where/how the system derives the data for the ttQSalesRP.emailaddress field?

Is there some complex logic in Quoting that determines where the email address is obtained and if so how could we possibly dumb it down a bit so it actually does use the email address field on the Salesperson tab on the quote form?

Cheers
Simon Hall


________________________________
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-6280 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]