E9: ABL to display Contact Name from Quote on Part Advisor

That worked. The PA.GetQuoteDtlPARows gave me the same tables, so I create the BPM PP on the BO. I also needed to change the code on the PartAdvisor XML. I needed to point to the TT tables.

public static void InitializeCustomCode()
{

// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **
// Begin Wizard Added Custom Method Calls
SetExtendedProperties();
// End Wizard Added Custom Method Calls
}

private static void SetExtendedProperties()
{
// Begin Wizard Added EpiDataView Initialization
EpiDataView edvQuoteView = ((EpiDataView)(Script.oTrans.EpiDataViews["QuoteView"]));
// End Wizard Added EpiDataView Initialization

// Begin Wizard Added Conditional Block
if (edvQuoteView.dataView.Table.Columns.Contains("ShortChar01"))
{
// Begin Wizard Added ExtendedProperty Settings: edvQuoteView-ShortChar01
edvQuoteView.dataView.Table.Columns["ShortChar01"].ExtendedProperties["ReadOnly"] = true;
edvQuoteView.dataView.Table.Columns["ShortChar01"].ExtendedProperties["Like"] = "ttQuoteDtlPA.ShortChar01";
// End Wizard Added ExtendedProperty Settings: edvQuoteView-ShortChar01
}
// End Wizard Added Conditional Block
}

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, March 26, 2013 11:05 AM
To: Vantage
Subject: Re: [Vantage] E9: ABL to display Contact Name from Quote on Part Advisor

Miguel do it in this Method
PartAdvisor.GetQuoteDtlPARows. and see if the tables tehre have what you
need. Since PartAdvisor is read only uou should be ale to set the values
with no problem.




*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Mar 25, 2013 at 5:51 PM, Miguel Santillan <msantillan@...>wrote:

> **
>
>
> I was trying to display the Contact Name from a Quote when you hit
> RETRIEVE on the Quote it? Tab on part advisor.
>
> I see some sample code in ABL ( already have the Part Advisor set up using
> the wizard) but I cannot understand how I can edit the BPM for my instance.
>
> When I hit retrieve on Part Advisor, the following BO trigger.
> PartAdvisor.GetByID
> PartAdvisor.GetPartBinRows
> PartAdvisor.GetQuoteDtlPARows.
>
> On the sample ABL that I am looking at there is a BPM Post Process on
> CashDtl.GetByID, so I am doing the same Post Process on PA.GetByID.
>
> The Part Advisor Quoted It? Grid is using an EPIBinding of QuoteView.
> There is no table for that. For me to get the Contact Name (QuoteCnt.Name)
> the QuoteNum is required.
>
> So somehow, QuoteView.ShortChar01 = QuoteCnt.Name.
>
> /* */
>
> for each ttQuoteDtlPA exclusive-lock :
>
> find first QuoteCnt where QuoteCnt.Company = ttQuoteDtlPA.Company
> and QuoteCnt.QuoteNum = ttQuoteDtlPA.QuoteNum
> no-lock no-error.
>
> ttQuoteDtlPA.ShortChar01 = if avail( QuoteCnt) then QuoteCnt.Name else
> ttQuoteDtlPA.ShortChar01.
> end.
>
> Hopefully someone can point me in the right direction.
>
> [Non-text portions of this message have been removed]
>
>
>


[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/linksYahoo! Groups Links
I was trying to display the Contact Name from a Quote when you hit RETRIEVE on the Quote it? Tab on part advisor.

I see some sample code in ABL ( already have the Part Advisor set up using the wizard) but I cannot understand how I can edit the BPM for my instance.

When I hit retrieve on Part Advisor, the following BO trigger.
PartAdvisor.GetByID
PartAdvisor.GetPartBinRows
PartAdvisor.GetQuoteDtlPARows.

On the sample ABL that I am looking at there is a BPM Post Process on CashDtl.GetByID, so I am doing the same Post Process on PA.GetByID.


The Part Advisor Quoted It? Grid is using an EPIBinding of QuoteView. There is no table for that. For me to get the Contact Name (QuoteCnt.Name) the QuoteNum is required.

So somehow, QuoteView.ShortChar01 = QuoteCnt.Name.


/* */

for each ttQuoteDtlPA exclusive-lock :

find first QuoteCnt where QuoteCnt.Company = ttQuoteDtlPA.Company
and QuoteCnt.QuoteNum = ttQuoteDtlPA.QuoteNum
no-lock no-error.

ttQuoteDtlPA.ShortChar01 = if avail( QuoteCnt) then QuoteCnt.Name else ttQuoteDtlPA.ShortChar01.
end.



Hopefully someone can point me in the right direction.


[Non-text portions of this message have been removed]
Miguel do it in this Method
PartAdvisor.GetQuoteDtlPARows. and see if the tables tehre have what you
need. Since PartAdvisor is read only uou should be ale to set the values
with no problem.




*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Mar 25, 2013 at 5:51 PM, Miguel Santillan <msantillan@...>wrote:

> **
>
>
> I was trying to display the Contact Name from a Quote when you hit
> RETRIEVE on the Quote it? Tab on part advisor.
>
> I see some sample code in ABL ( already have the Part Advisor set up using
> the wizard) but I cannot understand how I can edit the BPM for my instance.
>
> When I hit retrieve on Part Advisor, the following BO trigger.
> PartAdvisor.GetByID
> PartAdvisor.GetPartBinRows
> PartAdvisor.GetQuoteDtlPARows.
>
> On the sample ABL that I am looking at there is a BPM Post Process on
> CashDtl.GetByID, so I am doing the same Post Process on PA.GetByID.
>
> The Part Advisor Quoted It? Grid is using an EPIBinding of QuoteView.
> There is no table for that. For me to get the Contact Name (QuoteCnt.Name)
> the QuoteNum is required.
>
> So somehow, QuoteView.ShortChar01 = QuoteCnt.Name.
>
> /* */
>
> for each ttQuoteDtlPA exclusive-lock :
>
> find first QuoteCnt where QuoteCnt.Company = ttQuoteDtlPA.Company
> and QuoteCnt.QuoteNum = ttQuoteDtlPA.QuoteNum
> no-lock no-error.
>
> ttQuoteDtlPA.ShortChar01 = if avail( QuoteCnt) then QuoteCnt.Name else
> ttQuoteDtlPA.ShortChar01.
> end.
>
> Hopefully someone can point me in the right direction.
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]