Opportunity / Quote - Line - Worksheet Calculations Modification

Yahoo Archive
1
Can't seem to find the intermediate fields as well, this implies need to work at the form customization level.

--- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
>
> It looks like PriceTotalProfit is a calculated field so you cannot directly
> call it out in a BPM. You will have to calculate it within your BPM using
> the available fields.
>
>
> On Thu, Apr 18, 2013 at 5:13 PM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Scott I am tring to use QuoteQty.PriceTotalProfit and multiplying it to
> > another customized field,which is, QuoteQty.Number01 and need to assign the
> > result to the QuoteQty.Number02.
> >
> > Also tried to use data-directive for QuoteQty but it looks like
> > 'PriceTotalprofit' is not exposed field at the data-directive level.
> >
> > --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@> wrote:
> > >
> > > Where is the data coming from? To populate QuoteQty.Number02?
> > >
> > > I am taking data from the QuoteMtl table and populating the QuoteQty
> > table.
> > > So I use a standard data directive on the QuoteMtl table and a in-trans
> > > data directive on the QuoteQty table. Both using ABL code.
> > >
> > > Let me know if you need a code example.
> > >
> > >
> > > On Thu, Apr 18, 2013 at 4:36 PM, noor.fazli@
> > > <noor.fazli@>wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi Scott,
> > > > I'm trying to assign the calculated value to QuoteQty.number02 on
> > > > Post-processing of Quote.RecalcWorksheet but the binded field does not
> > seem
> > > > to populate. Can you give some example of what you have done in your
> > bpm.
> > > >
> > > > Thanks
> > > >
> > > > --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@> wrote:
> > > > >
> > > > > We've tried several times to interact with the calculations on the
> > Quote
> > > > > worksheet with no success. The fields are calculated and I don't
> > believe
> > > > > you can change the calculations without the SDK.
> > > > > We ended up adding a couple UD fields on the QuoteQty table that a
> > BPM
> > > > > fills. Another BPM grabs these values and adds them together on the
> > Misc.
> > > > > Line which affects the unit price in the worksheet.
> > > > >
> > > > > Scott
> > > > >
> > > > >
> > > > > On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@
> > > > > <noor.fazli@>wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Hi Epicor Gurus,
> > > > > >
> > > > > > We have a requirement to add another numeric field on to the
> > > > > > Quote/opportunity Worksheet,which needs to be editable, that is
> > going
> > > > to
> > > > > > impact the Total Price. Which in turn is going to impact the bottom
> > > > > > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit
> > Price
> > > > w/o
> > > > > > Comm'.
> > > > > >
> > > > > > What would be the best way to capture these values and show the
> > > > changes in
> > > > > > any field, including the new customized field, and show the results
> > > > based
> > > > > > on newly added field value along with already existing calculation
> > > > thats
> > > > > > being done by the system.
> > > > > >
> > > > > > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but
> > not
> > > > sure
> > > > > > is it better to use it or do customizations in the form itslef, to
> > > > reflect
> > > > > > the changes in the bottom fields.
> > > > > >
> > > > > > Any help will be deeply appreciated .
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
2
Hi Epicor Gurus,

We have a requirement to add another numeric field on to the Quote/opportunity Worksheet,which needs to be editable, that is going to impact the Total Price. Which in turn is going to impact the bottom calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price w/o Comm'.

What would be the best way to capture these values and show the changes in any field, including the new customized field, and show the results based on newly added field value along with already existing calculation thats being done by the system.

P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not sure is it better to use it or do customizations in the form itslef, to reflect the changes in the bottom fields.

Any help will be deeply appreciated .

Thanks
3
We've tried several times to interact with the calculations on the Quote
worksheet with no success. The fields are calculated and I don't believe
you can change the calculations without the SDK.
We ended up adding a couple UD fields on the QuoteQty table that a BPM
fills. Another BPM grabs these values and adds them together on the Misc.
Line which affects the unit price in the worksheet.

Scott


On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
<noor.fazli@...>wrote:

> **
>
>
> Hi Epicor Gurus,
>
> We have a requirement to add another numeric field on to the
> Quote/opportunity Worksheet,which needs to be editable, that is going to
> impact the Total Price. Which in turn is going to impact the bottom
> calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price w/o
> Comm'.
>
> What would be the best way to capture these values and show the changes in
> any field, including the new customized field, and show the results based
> on newly added field value along with already existing calculation thats
> being done by the system.
>
> P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not sure
> is it better to use it or do customizations in the form itslef, to reflect
> the changes in the bottom fields.
>
> Any help will be deeply appreciated .
>
> Thanks
>
>
>


[Non-text portions of this message have been removed]
4
Thanks Scott for your time and response.
So this means you suggest using BPM, as we don't have SDK.


--- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
>
> We've tried several times to interact with the calculations on the Quote
> worksheet with no success. The fields are calculated and I don't believe
> you can change the calculations without the SDK.
> We ended up adding a couple UD fields on the QuoteQty table that a BPM
> fills. Another BPM grabs these values and adds them together on the Misc.
> Line which affects the unit price in the worksheet.
>
> Scott
>
>
> On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Hi Epicor Gurus,
> >
> > We have a requirement to add another numeric field on to the
> > Quote/opportunity Worksheet,which needs to be editable, that is going to
> > impact the Total Price. Which in turn is going to impact the bottom
> > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price w/o
> > Comm'.
> >
> > What would be the best way to capture these values and show the changes in
> > any field, including the new customized field, and show the results based
> > on newly added field value along with already existing calculation thats
> > being done by the system.
> >
> > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not sure
> > is it better to use it or do customizations in the form itslef, to reflect
> > the changes in the bottom fields.
> >
> > Any help will be deeply appreciated .
> >
> > Thanks
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
5
We use the configurator. Our pricing worksheet is a page of the PC. The quoters can manipulate a zillion different options. I have had some success w/ calculating our own prices / price breaks and then adding those lines from the configurator. Took a lot of data manipulation and watching how things are affected and we are still fine tuning, but it looks way promising so far.

Brenda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scotty K.
Sent: Wednesday, April 17, 2013 11:01 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Opportunity / Quote - Line - Worksheet Calculations Modification

We've tried several times to interact with the calculations on the Quote worksheet with no success. The fields are calculated and I don't believe you can change the calculations without the SDK.
We ended up adding a couple UD fields on the QuoteQty table that a BPM fills. Another BPM grabs these values and adds them together on the Misc.
Line which affects the unit price in the worksheet.

Scott


On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
<noor.fazli@...>wrote:

> **
>
>
> Hi Epicor Gurus,
>
> We have a requirement to add another numeric field on to the
> Quote/opportunity Worksheet,which needs to be editable, that is going
> to impact the Total Price. Which in turn is going to impact the bottom
> calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price
> w/o Comm'.
>
> What would be the best way to capture these values and show the
> changes in any field, including the new customized field, and show the
> results based on newly added field value along with already existing
> calculation thats being done by the system.
>
> P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> sure is it better to use it or do customizations in the form itslef,
> to reflect the changes in the bottom fields.
>
> Any help will be deeply appreciated .
>
> Thanks
>
>
>


[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
6
We started using Product Configurator and abandoned the project because of
time constraints. My understand of PC is that it is an easy way to
configure the MOM of a part, but it doesn't provide an extra functionality.
I can build a part the long way and have the same results in the end.

Does PC provide extra E9 functionality?


On Thu, Apr 18, 2013 at 8:44 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> We use the configurator. Our pricing worksheet is a page of the PC. The
> quoters can manipulate a zillion different options. I have had some success
> w/ calculating our own prices / price breaks and then adding those lines
> from the configurator. Took a lot of data manipulation and watching how
> things are affected and we are still fine tuning, but it looks way
> promising so far.
>
> Brenda
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Scotty K.
> Sent: Wednesday, April 17, 2013 11:01 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Opportunity / Quote - Line - Worksheet Calculations
> Modification
>
> We've tried several times to interact with the calculations on the Quote
> worksheet with no success. The fields are calculated and I don't believe
> you can change the calculations without the SDK.
> We ended up adding a couple UD fields on the QuoteQty table that a BPM
> fills. Another BPM grabs these values and adds them together on the Misc.
> Line which affects the unit price in the worksheet.
>
> Scott
>
> On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Hi Epicor Gurus,
> >
> > We have a requirement to add another numeric field on to the
> > Quote/opportunity Worksheet,which needs to be editable, that is going
> > to impact the Total Price. Which in turn is going to impact the bottom
> > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price
> > w/o Comm'.
> >
> > What would be the best way to capture these values and show the
> > changes in any field, including the new customized field, and show the
> > results based on newly added field value along with already existing
> > calculation thats being done by the system.
> >
> > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> > sure is it better to use it or do customizations in the form itslef,
> > to reflect the changes in the bottom fields.
> >
> > Any help will be deeply appreciated .
> >
> > Thanks
> >
> >
> >
>
> [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
>
>
>


[Non-text portions of this message have been removed]
7
We do not have the SDK either and are using BPMs to populate the Misc Line
on the Quote worksheet tab.


On Thu, Apr 18, 2013 at 7:52 AM, noor.fazli@...
<noor.fazli@...>wrote:

> **
>
>
> Thanks Scott for your time and response.
> So this means you suggest using BPM, as we don't have SDK.
>
> --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
> >
> > We've tried several times to interact with the calculations on the Quote
> > worksheet with no success. The fields are calculated and I don't believe
> > you can change the calculations without the SDK.
> > We ended up adding a couple UD fields on the QuoteQty table that a BPM
> > fills. Another BPM grabs these values and adds them together on the Misc.
> > Line which affects the unit price in the worksheet.
> >
> > Scott
> >
> >
> > On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> > <noor.fazli@...>wrote:
> >
> > > **
> > >
> > >
> > > Hi Epicor Gurus,
> > >
> > > We have a requirement to add another numeric field on to the
> > > Quote/opportunity Worksheet,which needs to be editable, that is going
> to
> > > impact the Total Price. Which in turn is going to impact the bottom
> > > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price
> w/o
> > > Comm'.
> > >
> > > What would be the best way to capture these values and show the
> changes in
> > > any field, including the new customized field, and show the results
> based
> > > on newly added field value along with already existing calculation
> thats
> > > being done by the system.
> > >
> > > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> sure
> > > is it better to use it or do customizations in the form itslef, to
> reflect
> > > the changes in the bottom fields.
> > >
> > > Any help will be deeply appreciated .
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
8
It just takes a little imagination. You can add an enormous amount of programming in it. Our jobs can be done using any number of machines and material types and can be assembled at several different times/locations. I created one big MOM took all the info asked a bunch of questions add some service connect functionality and its looking good. We are still developing, but it is pretty powerful w/ the right amount of determination.

Brenda


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scotty K.
Sent: Thursday, April 18, 2013 11:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Opportunity / Quote - Line - Worksheet Calculations Modification

We started using Product Configurator and abandoned the project because of time constraints. My understand of PC is that it is an easy way to configure the MOM of a part, but it doesn't provide an extra functionality.
I can build a part the long way and have the same results in the end.

Does PC provide extra E9 functionality?


On Thu, Apr 18, 2013 at 8:44 AM, brenda mohr <brenda@...> wrote:

> **
>
>
> We use the configurator. Our pricing worksheet is a page of the PC.
> The quoters can manipulate a zillion different options. I have had
> some success w/ calculating our own prices / price breaks and then
> adding those lines from the configurator. Took a lot of data
> manipulation and watching how things are affected and we are still
> fine tuning, but it looks way promising so far.
>
> Brenda
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of Scotty K.
> Sent: Wednesday, April 17, 2013 11:01 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Opportunity / Quote - Line - Worksheet
> Calculations Modification
>
> We've tried several times to interact with the calculations on the
> Quote worksheet with no success. The fields are calculated and I don't
> believe you can change the calculations without the SDK.
> We ended up adding a couple UD fields on the QuoteQty table that a BPM
> fills. Another BPM grabs these values and adds them together on the Misc.
> Line which affects the unit price in the worksheet.
>
> Scott
>
> On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Hi Epicor Gurus,
> >
> > We have a requirement to add another numeric field on to the
> > Quote/opportunity Worksheet,which needs to be editable, that is
> > going to impact the Total Price. Which in turn is going to impact
> > the bottom calculations like 'Profit',Unit Price ,'Quoted Unit
> > Price','Unit Price w/o Comm'.
> >
> > What would be the best way to capture these values and show the
> > changes in any field, including the new customized field, and show
> > the results based on newly added field value along with already
> > existing calculation thats being done by the system.
> >
> > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> > sure is it better to use it or do customizations in the form itslef,
> > to reflect the changes in the bottom fields.
> >
> > Any help will be deeply appreciated .
> >
> > Thanks
> >
> >
> >
>
> [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
>
>
>


[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
9
Hi Scott,
I'm trying to assign the calculated value to QuoteQty.number02 on Post-processing of Quote.RecalcWorksheet but the binded field does not seem to populate. Can you give some example of what you have done in your bpm.

Thanks

--- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
>
> We've tried several times to interact with the calculations on the Quote
> worksheet with no success. The fields are calculated and I don't believe
> you can change the calculations without the SDK.
> We ended up adding a couple UD fields on the QuoteQty table that a BPM
> fills. Another BPM grabs these values and adds them together on the Misc.
> Line which affects the unit price in the worksheet.
>
> Scott
>
>
> On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Hi Epicor Gurus,
> >
> > We have a requirement to add another numeric field on to the
> > Quote/opportunity Worksheet,which needs to be editable, that is going to
> > impact the Total Price. Which in turn is going to impact the bottom
> > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price w/o
> > Comm'.
> >
> > What would be the best way to capture these values and show the changes in
> > any field, including the new customized field, and show the results based
> > on newly added field value along with already existing calculation thats
> > being done by the system.
> >
> > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not sure
> > is it better to use it or do customizations in the form itslef, to reflect
> > the changes in the bottom fields.
> >
> > Any help will be deeply appreciated .
> >
> > Thanks
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
10
Where is the data coming from? To populate QuoteQty.Number02?

I am taking data from the QuoteMtl table and populating the QuoteQty table.
So I use a standard data directive on the QuoteMtl table and a in-trans
data directive on the QuoteQty table. Both using ABL code.

Let me know if you need a code example.


On Thu, Apr 18, 2013 at 4:36 PM, noor.fazli@...
<noor.fazli@...>wrote:

> **
>
>
> Hi Scott,
> I'm trying to assign the calculated value to QuoteQty.number02 on
> Post-processing of Quote.RecalcWorksheet but the binded field does not seem
> to populate. Can you give some example of what you have done in your bpm.
>
> Thanks
>
> --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
> >
> > We've tried several times to interact with the calculations on the Quote
> > worksheet with no success. The fields are calculated and I don't believe
> > you can change the calculations without the SDK.
> > We ended up adding a couple UD fields on the QuoteQty table that a BPM
> > fills. Another BPM grabs these values and adds them together on the Misc.
> > Line which affects the unit price in the worksheet.
> >
> > Scott
> >
> >
> > On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@...
> > <noor.fazli@...>wrote:
> >
> > > **
> > >
> > >
> > > Hi Epicor Gurus,
> > >
> > > We have a requirement to add another numeric field on to the
> > > Quote/opportunity Worksheet,which needs to be editable, that is going
> to
> > > impact the Total Price. Which in turn is going to impact the bottom
> > > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price
> w/o
> > > Comm'.
> > >
> > > What would be the best way to capture these values and show the
> changes in
> > > any field, including the new customized field, and show the results
> based
> > > on newly added field value along with already existing calculation
> thats
> > > being done by the system.
> > >
> > > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> sure
> > > is it better to use it or do customizations in the form itslef, to
> reflect
> > > the changes in the bottom fields.
> > >
> > > Any help will be deeply appreciated .
> > >
> > > Thanks
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
11
Scott I am tring to use QuoteQty.PriceTotalProfit and multiplying it to another customized field,which is, QuoteQty.Number01 and need to assign the result to the QuoteQty.Number02.

Also tried to use data-directive for QuoteQty but it looks like 'PriceTotalprofit' is not exposed field at the data-directive level.


--- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
>
> Where is the data coming from? To populate QuoteQty.Number02?
>
> I am taking data from the QuoteMtl table and populating the QuoteQty table.
> So I use a standard data directive on the QuoteMtl table and a in-trans
> data directive on the QuoteQty table. Both using ABL code.
>
> Let me know if you need a code example.
>
>
> On Thu, Apr 18, 2013 at 4:36 PM, noor.fazli@...
> <noor.fazli@...>wrote:
>
> > **
> >
> >
> > Hi Scott,
> > I'm trying to assign the calculated value to QuoteQty.number02 on
> > Post-processing of Quote.RecalcWorksheet but the binded field does not seem
> > to populate. Can you give some example of what you have done in your bpm.
> >
> > Thanks
> >
> > --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@> wrote:
> > >
> > > We've tried several times to interact with the calculations on the Quote
> > > worksheet with no success. The fields are calculated and I don't believe
> > > you can change the calculations without the SDK.
> > > We ended up adding a couple UD fields on the QuoteQty table that a BPM
> > > fills. Another BPM grabs these values and adds them together on the Misc.
> > > Line which affects the unit price in the worksheet.
> > >
> > > Scott
> > >
> > >
> > > On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@
> > > <noor.fazli@>wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi Epicor Gurus,
> > > >
> > > > We have a requirement to add another numeric field on to the
> > > > Quote/opportunity Worksheet,which needs to be editable, that is going
> > to
> > > > impact the Total Price. Which in turn is going to impact the bottom
> > > > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit Price
> > w/o
> > > > Comm'.
> > > >
> > > > What would be the best way to capture these values and show the
> > changes in
> > > > any field, including the new customized field, and show the results
> > based
> > > > on newly added field value along with already existing calculation
> > thats
> > > > being done by the system.
> > > >
> > > > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but not
> > sure
> > > > is it better to use it or do customizations in the form itslef, to
> > reflect
> > > > the changes in the bottom fields.
> > > >
> > > > Any help will be deeply appreciated .
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
12
It looks like PriceTotalProfit is a calculated field so you cannot directly
call it out in a BPM. You will have to calculate it within your BPM using
the available fields.


On Thu, Apr 18, 2013 at 5:13 PM, noor.fazli@...
<noor.fazli@...>wrote:

> **
>
>
> Scott I am tring to use QuoteQty.PriceTotalProfit and multiplying it to
> another customized field,which is, QuoteQty.Number01 and need to assign the
> result to the QuoteQty.Number02.
>
> Also tried to use data-directive for QuoteQty but it looks like
> 'PriceTotalprofit' is not exposed field at the data-directive level.
>
> --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@...> wrote:
> >
> > Where is the data coming from? To populate QuoteQty.Number02?
> >
> > I am taking data from the QuoteMtl table and populating the QuoteQty
> table.
> > So I use a standard data directive on the QuoteMtl table and a in-trans
> > data directive on the QuoteQty table. Both using ABL code.
> >
> > Let me know if you need a code example.
> >
> >
> > On Thu, Apr 18, 2013 at 4:36 PM, noor.fazli@...
> > <noor.fazli@...>wrote:
> >
> > > **
> > >
> > >
> > > Hi Scott,
> > > I'm trying to assign the calculated value to QuoteQty.number02 on
> > > Post-processing of Quote.RecalcWorksheet but the binded field does not
> seem
> > > to populate. Can you give some example of what you have done in your
> bpm.
> > >
> > > Thanks
> > >
> > > --- In vantage@yahoogroups.com, "Scotty K." <scottyk537@> wrote:
> > > >
> > > > We've tried several times to interact with the calculations on the
> Quote
> > > > worksheet with no success. The fields are calculated and I don't
> believe
> > > > you can change the calculations without the SDK.
> > > > We ended up adding a couple UD fields on the QuoteQty table that a
> BPM
> > > > fills. Another BPM grabs these values and adds them together on the
> Misc.
> > > > Line which affects the unit price in the worksheet.
> > > >
> > > > Scott
> > > >
> > > >
> > > > On Wed, Apr 17, 2013 at 7:49 AM, noor.fazli@
> > > > <noor.fazli@>wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > Hi Epicor Gurus,
> > > > >
> > > > > We have a requirement to add another numeric field on to the
> > > > > Quote/opportunity Worksheet,which needs to be editable, that is
> going
> > > to
> > > > > impact the Total Price. Which in turn is going to impact the bottom
> > > > > calculations like 'Profit',Unit Price ,'Quoted Unit Price','Unit
> Price
> > > w/o
> > > > > Comm'.
> > > > >
> > > > > What would be the best way to capture these values and show the
> > > changes in
> > > > > any field, including the new customized field, and show the results
> > > based
> > > > > on newly added field value along with already existing calculation
> > > thats
> > > > > being done by the system.
> > > > >
> > > > > P.S: One of the Bpm that got fired is Quote.RecalcWorksheet, but
> not
> > > sure
> > > > > is it better to use it or do customizations in the form itslef, to
> > > reflect
> > > > > the changes in the bottom fields.
> > > > >
> > > > > Any help will be deeply appreciated .
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


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