Wondering if I just create a bpm with the method I need to run and have it run after my code but its imbedded in other bpm method call or not sure if this is the best way
--- In vantage@yahoogroups.com, "gabelebron07" <gabe.lebron@...> wrote:
>
> Thank you for the explanation I understand what rowmod its doing now. You were absolutely right on the messages I saw the first one and not the second until I removed the Where clause. It seems to populate the field now but it populates that fields in all the lines each time -I don't seem to have an issue with that has of right now. There is a method that actually runs if you actually type a number in that field and tab out. Its not running when you auto fill. Is there a way to add a line in the code to run that method also? And I think it will work fine.
>
>
> This is the method
>
> <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> <methodName>GetWSUnitPrice</methodName>
>
>
> --- In vantage@yahoogroups.com, "Kevin Simon" <simstrak@> wrote:
> >
> > Gabe,
> >
> >
> >
> > What I've seen in the ABL code is this. Often times in the "pre-processing"
> > routines, you have a lot of "tt" records for each of the different records.
> > For example, if you have a PO with 5 lines, there will be 5 ttPODetail
> > records. Therefore, it's critical that you have the "where rowmod"
> > statement, so you ensure you're getting the one you need. (Actually,
> > there's often 6 records, as it will have the "unchanged" ttPODetail as well
> > as the changed one, with the changed one having a rowmod of "U", but that's
> > a different story.)
> >
> >
> >
> > On post-processing, often times there's only the one "tt" record available,
> > the one that was updated. In addition, it often clears the RowMod. This
> > actually makes sense, since that's record is now updated, the "tt" is being
> > sent back to the program, and you wouldn't want the program having that "tt"
> > records being marked with an "A" or "U" rowmod.
> >
> >
> >
> > So, I'd do the following. First, add informational messages within the ABL
> > code so you can ensure you know exactly what it's doing:
> >
> > {lib/PublishInfoMsg.i &InfoMsg = " 'inside the BPM ' "}
> > for each QuoteQty where (ttQuoteQty.RowMod = 'A' OR ttQuoteQty.RowMod = 'U')
> > exclusive-lock:
> > Assign ttQuoteQty.WQUnitPrice = ttQuoteQty.Calcupcommprofit.
> >
> > {lib/PublishInfoMsg.i &InfoMsg = " 'set value to ' +
> > string(ttQuoteQty.WQUnitPrice)"}
> > End.
> >
> >
> >
> > Next, I'll assume you'll see the first message (that's outside the "for"
> > loop), but not the second one (inside the loop). If that's the case, then
> > remove the "where" clauses on the "for each" statement, and see if that
> > helps.
> >
> >
> >
> > Of course, I'd ensure you do a test with a Quote line that has multiple
> > quantities set, so you can verify it's indeed only setting the WQUnitPrice
> > on the one you updated.
> >
> >
> >
> > Finally, I used words like "usually" and "often" in describing Epicor's
> > handling of "tt" records. That's because as soon as you think it's working
> > a certain way, you'll find some method out there that violates the rules.
> > Why would we expect consistency in behavior?
> >
> >
> >
> > Hope that helps,
> >
> >
> >
> > Kevin Simon
> >
> > SimsTrak Consulting, LLC
> >
> > Delivering Customized Epicor Solutions
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > gabelebron07
> > Sent: Wednesday, November 14, 2012 2:19 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BPM To Auto Fill a Field
> >
> >
> >
> >
> >
> >
> > I have tried some further testing and wondering if the fact that
> > CalUPCommProfit is a caulated field is the issue or that should not be a
> > problem
> >
> > it seems to me I picked a good method call and have the BPM setup right.
> > I dont think the code is doing the switch is there a way for me to check
> > out the code and see whats it doing?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "gabelebron07" <gabe.lebron@> wrote:
> > >
> > > Ok I had add tt infront of the QuoteQTY so no errors on code. I used
> > > <businessObject>Epicor.Mfg.BO.Quote</businessObject>
> > > <methodName>GetByID</methodName> as my methcode code call
> > > I know that pops up alot during quoting but its the very last thing
> > that happens after you get details. I will work on condition later.
> > >
> > > I added an informational message to make sure its working and it comes
> > up right after i get details. no issue there but the Price is still not
> > populating in WQUnitPrice from CalcUPCommProfit field Not sure what i am
> > missing
> > >
> > >
> > >
> > > for each QuoteQty where (ttQuoteQty.RowMod = 'A' OR ttQuoteQty.RowMod
> > = 'U')
> > > exclusive-lock.
> > >
> > > Assign ttQuoteQty.WQUnitPrice = ttQuoteQty.Calcupcommprofit.
> > >
> > > End.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
> > Drecchio" vic.drecchio@ wrote:
> > > >
> > > > Yep. Thanks.
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > > > Neil Buckman
> > > > Sent: Tuesday, November 13, 2012 9:19 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: RE: [Vantage] Re: BPM To Auto Fill a Field
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > where (QuoteQty.RowMod = 'A' or QuoteQty.RowMod = 'U')
> > > >
> > > > The Or is missing...
> > > >
> > > > - Neil
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ]
> > On
> > > > Behalf Of gabelebron07
> > > > Sent: Wednesday, 14 November 2012 1:07 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: BPM To Auto Fill a Field
> > > >
> > > > Ok so let me know if i am on the right track. instead of (field of
> > the
> > > > change row) I use Synchronously (execute ABL code.. record nothing.)
> > Action
> > > > Excute Code Below and enter your code? or Create a .p file add your
> > code to
> > > > that and link it to Forward to procedure?
> > > >
> > > > I did try adding your code to Excute code Below and got this error
> > > > ** Unable to understand after -- "QuoteQty where". (247)
> > > > **
> > > >
> > C:\Epicor\Epicor905\EpicorData\50012022362115144226206102202163104059180\
> > .p
> > > > Line 12 --Invalid FOR, DO, REPEAT, or EDITING statement.
> > > >
> > > > if i did it right i am asuming i still need to tweak the code. i
> > know
> > > > nothing about progress code I am new to epicor. I am getting the
> > basic
> > > > function of how things work its going to take me a bit to get the
> > code down
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>, "Vic Drecchio" <vic.drecchio@
> > <mailto:vic.drecchio@%0b>
> > > > <mailto:vic.drecchio@%3cmailto:vic.drecchio@>
> > > > <mailto:vic.drecchio@>> wrote:
> > > > >
> > > > > You're close. You'll need to execute 4GL code as the Action. It
> > should
> > > > > look close to this:
> > > > >
> > > > >
> > > > >
> > > > > for each QuoteQty where (QuoteQty.RowMod = 'A' QuoteQty.RowMod =
> > 'U')
> > > > > exclusive-lock.
> > > > >
> > > > > Assign QuoteQty.WQUnitPrice = QuoteQty.Calcupcommprofit.
> > > > >
> > > > > End.
> > > > >
> > > > >
> > > > >
> > > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
> > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>] On
> > > > Behalf Of
> > > > > gabelebron07
> > > > > Sent: Tuesday, November 13, 2012 3:10 PM
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > > > <mailto:vantage%40yahoogroups.com>
> > > > > Subject: [Vantage] BPM To Auto Fill a Field
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Wondering if anyone could help. I don't have an issue creating a
> > BPM to
> > > > auto
> > > > > fill a field with a certain static value
> > > > >
> > > > > I trying to create one using what I believe is a calculated field
> > from
> > > > > another field. To be more exact in the Quote Entry >Line
> > >Worksheet tab I
> > > > am
> > > > > trying to have the Quoted Unit Price (QuoteQty.WQunitPrice) field
> > auto
> > > > > populate with Unit Price w/Commission (QuoteQty.Calcupcommprofit)
> > field
> > > > > I created a BPM, Picked a method and added a Post Processing
> > Directive. I
> > > > > choose (set the QuoteQty.WQUnitPrice field of the change row to
> > the
> > > > > Specified Expression) Not sure how to build the expression to have
> > > > > QuoteQty.WQUnitPrice field = QuoteQty.Calcupcommprofit
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this message.
> > > > > Checked by AVG - www.avg.com<http://www.avg.com>
> > > > > Version: 2012.0.2221 / Virus Database: 2441/5392 - Release Date:
> > 11/13/12
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > -----
> > > > > No virus found in this message.
> > > > > Checked by AVG - www.avg.com<http://www.avg.com>
> > > > > Version: 2012.0.2221 / Virus Database: 2441/5392 - Release Date:
> > 11/13/12
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > > Notice:This e-mail and any attachments are confidential and are only
> > for the
> > > > use of the person to whom they are addressed. If you are not the
> > intended
> > > > recipient please advise the sender by return e-mail and delete the
> > message
> > > > and any attachments. Any use, interference with, disclosure or
> > copying of
> > > > this message or any attachments is unauthorised and prohibited. The
> > sender
> > > > does not warrant that the information is free of a virus or any
> > other defect
> > > > or error, and any views expressed herein, unless specifically
> > indicated
> > > > otherwise, are those of the individual sender.
> > > >
> > > > The DH Gibson Group of Companies -
> > http://www.gibsonshopfitters.com.au
> > > >
> > > > P Please consider our shared environment before printing this
> > communication.
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > No virus found in this message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 2012.0.2221 / Virus Database: 2441/5393 - Release Date:
> > 11/13/12
> > > >
> > > >
> > > >
> > > >
> > > > -----
> > > > No virus found in this message.
> > > > Checked by AVG - www.avg.com
> > > > Version: 2012.0.2221 / Virus Database: 2441/5393 - Release Date:
> > 11/13/12
> > > >
> > > > [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]
> >
>