Testing ABL and running queries

Ok so thats working. The only thing remaining would be that when a new line is added and hold is checked the created row is unfirmed and when hold is unchecked a firm release is created. Tried adding another condition for changed row but that didn't seem to work? Any other way I can just get it to default. All I see run in my tracelog is the MasterUpdate method

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> If you go to conditions you can set it to only fire when 'the value of
> <field> has changed from <something> to <something else>' you can use this
> to ensure your BPM only fires when the field is changed. However, that won't
> stop it from firming/unfirming all releases. If you only want to change a
> subset of the releases, you're going to need to come up with
> some criteria that you can implement.
>
> On Tue, Sep 13, 2011 at 2:13 PM, jgiese1988
> <jgiese@...>wrote:
>
> > **
> >
> >
> > Hmm.... actually this won't work. So how would I go about making this be
> > controlled at the time the hold checkbox is checked? The issue is if we
> > actually want the order off hold and one of the releases unfirm while the
> > other is firm at the time i save it will firm the unfirm release. Can I add
> > a condition at the BPM that only runs the action if the value of orderHeld
> > changes?
> >
> >
> > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > >
> > > As far as your issue with the order holds, try this:
> > >
> > > FOR EACH ttOrderHed,
> > > EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
> > > OrderRel.OrderNum = ttOrderHed.OrderNum.
> > > IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
> > > ELSE OrderRel.Firm = TRUE.
> > > END.
> > >
> > > Double check the field names, as I'm just pulling them off the top of my
> > > head here.
> > >
> > > Essentially what you're doing is finding all the Order Headers (there
> > should
> > > only be one). Generally speaking, if your accessing tables that Epicor is
> > > using for the current operation, you'll need to work with the temp ('tt')
> > > table instead of the actual DB table. This ensures that you're working
> > with
> > > the current data even though it may not be committed yet.
> > >
> > > After we find the header, we're looking up the Order Releases. Epicor
> > does
> > > not always load all the child records into the tt dataset if they haven't
> > > been changed; this is why we're not accessing them via ttOrderRel. We
> > want
> > > to make sure we get ALL the releases. The IF statement should be pretty
> > > straight forward.
> > >
> > > In regards to what customization method to use at a given time it's not
> > > always a black and white thing and everyone has their own opinions.
> > Here's a
> > > rough overview of my views:
> > >
> > > BPM - If you want to change the way Epicor acts in all occurrences of a
> > > situation, use a BPM. If you attach a directive to a method (i.e.
> > > SalesOrder.Update) it will fire EVERY TIME that method is called,
> > regardless
> > > of where it is called from. This includes calls from Service Connect,
> > custom
> > > code, 3rd part addons, etc. Generally speaking, if the changes you wish
> > to
> > > make are purely 'business process' issues, you should try to use a BPM if
> > at
> > > all possible. BPM is generally my preferred place to customize when it's
> > > available. If you change something via BPM, you can be pretty confident
> > that
> > > it will work across the board, for all users, in all screens. The code is
> > > generally simpler and more quickly written. All you need to write is your
> > > logic, no UI code, no wiring up adapters/BOs etc.
> > >
> > > Screen Customization - There are best used for 'User Experience' issues.
> > If
> > > your users need to see more data, less data, a different UI, this is the
> > > tool. Want to create new buttons that implement user directed logic, this
> > is
> > > the place. As a rule of thumb, avoid implementing Business Logic here
> > > whenever possible.
> > >
> > > BAQ - These are just queries. If you need fetch data for dashboards or
> > > reports, these are the tool. In some scenarios you'll use them as part of
> > a
> > > screen customization, but that's a bit much to get into right now.
> > >
> > >
> > > On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@>wrote:
> >
> > >
> > > > **
> > > >
> > > >
> > > > > I'll second the answer below.
> > > > Me too, I've been trying to improve my ABL.
> > > > BPMs ended up being the best place I found, even though they can
> > consume
> > > > quite a bit of time to set up and test.
> > > >
> > > > Also, you can check out the .p programs examples here
> > > > \\servername\epicor_directory\server\ud\Test
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > > > >
> > > > > I'll second the answer below... I'm a couple months into learning ABL
> > &
> > > > > BPMs, and most of my time is spent figuring out what to do and how to
> > > > > hook into Epicor to do it. The technical ABL command to actually do
> > it
> > > > > is easy by comparison.
> > > > >
> > > > > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > > > > business logic (= business objects, often abbreviated "BO"). Its on
> > > > > your Epicor server, under Utilities I think.
> > > > >
> > > > > It is possible to hook up the AppBuilder to your test database (add
> > the
> > > > > bits below to your shortcut) but its not that useful... do it in a
> > BPM
> > > > > instead.
> > > > > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > > > > -ininame "C:\Program Files\Epicor
> > Software\Epicor905\config\Test905.ini"
> > > > >
> > > > > Brian.
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> > Behalf
> > > > > Of Waffqle
> > > > > Sent: Monday, September 12, 2011 8:57 PM
> > > > > To: vantage@yahoogroups.com
> > > > > Subject: Re: [Vantage] Re: Testing ABL and running queries
> > > > >
> > > > > Easiest way to learn is just wait till you need to do something via
> > BPM.
> > > > > Then crack the manual and figure it out. Almost all of your ABL is
> > going
> > > > > to
> > > > > be written for BPMs. Getting used to what data you have available and
> > > > > when
> > > > > to run your directives is going to be trickier than actually learning
> > > > > ABL.
> > > > > --Not to say that either is a particularly daunting task.
> > > > >
> > > > > When you get rolling and run into a specific issue, come back to the
> > > > > list
> > > > > and we'll help you work through it.
> > > > >
> > > > > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > > > > <jgiese@>wrote:
> > > >
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > I do have the manual downloaded, printed, and in a binder.
> > > > > Unfortunately
> > > > > > 'doing' is the way I learn, so the guide really only helps as
> > > > > reference.
> > > > > >
> > > > > > ABL tester what is that?
> > > > > >
> > > > > > I'm hoping to use some of the examples in the guide to play around
> > > > > with the
> > > > > > training DB and see what I can all do with ABL. That's the primary
> > > > > goal. I
> > > > > > will check out the posted video next.
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > > > > wrote:
> > > > > > >
> > > > > > > Do you have the ABL manual?
> > > > > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > > > > >
> > > > > > > And the BL Tester?
> > > > > > >
> > > > > > > Also, I found this video interesting:
> > > > > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > > > > >
> > > > > > > > What is the best way to go about learning ABL? I was looking
> > for a
> > > > > way
> > > > > > to maybe run queries and see the results. I believe I can do this
> > > > > through
> > > > > > app builder but I can't figure out how to use it? Any other
> > > > > recommendations
> > > > > > for learning ABL?
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > *Waffqle Driggers*
> > > > > *High End Dev, System Design, Profit Drinking
> > > > > *
> > > > > *:: 904.962.2887*
> > > > > *:: waffqle@*
> > > >
> > > > > *:: NO FAXES*
> > > > >
> > > > > *
> > > > >
> > > > > *
> > > > >
> > > > >
> > > > > [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
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
What is the best way to go about learning ABL? I was looking for a way to maybe run queries and see the results. I believe I can do this through app builder but I can't figure out how to use it? Any other recommendations for learning ABL?
Do you have the ABL manual?
http://communities.progress.com/pcom/docs/DOC-16296

And the BL Tester?

Also, I found this video interesting:
http://www.youtube.com/watch?v=4Dv295qg3FY



--- In vantage@yahoogroups.com, "jgiese1988" <jgiese@...> wrote:
>
> What is the best way to go about learning ABL? I was looking for a way to maybe run queries and see the results. I believe I can do this through app builder but I can't figure out how to use it? Any other recommendations for learning ABL?
>
I do have the manual downloaded, printed, and in a binder. Unfortunately 'doing' is the way I learn, so the guide really only helps as reference.

ABL tester what is that?

I'm hoping to use some of the examples in the guide to play around with the training DB and see what I can all do with ABL. That's the primary goal. I will check out the posted video next.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Do you have the ABL manual?
> http://communities.progress.com/pcom/docs/DOC-16296
>
> And the BL Tester?
>
> Also, I found this video interesting:
> http://www.youtube.com/watch?v=4Dv295qg3FY
>
>
>
> --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> >
> > What is the best way to go about learning ABL? I was looking for a way to maybe run queries and see the results. I believe I can do this through app builder but I can't figure out how to use it? Any other recommendations for learning ABL?
> >
>
Easiest way to learn is just wait till you need to do something via BPM.
Then crack the manual and figure it out. Almost all of your ABL is going to
be written for BPMs. Getting used to what data you have available and when
to run your directives is going to be trickier than actually learning ABL.
--Not to say that either is a particularly daunting task.

When you get rolling and run into a specific issue, come back to the list
and we'll help you work through it.

On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
<jgiese@...>wrote:

> **
>
>
> I do have the manual downloaded, printed, and in a binder. Unfortunately
> 'doing' is the way I learn, so the guide really only helps as reference.
>
> ABL tester what is that?
>
> I'm hoping to use some of the examples in the guide to play around with the
> training DB and see what I can all do with ABL. That's the primary goal. I
> will check out the posted video next.
>
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
> >
> > Do you have the ABL manual?
> > http://communities.progress.com/pcom/docs/DOC-16296
> >
> > And the BL Tester?
> >
> > Also, I found this video interesting:
> > http://www.youtube.com/watch?v=4Dv295qg3FY
> >
> >
> >
> > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > >
> > > What is the best way to go about learning ABL? I was looking for a way
> to maybe run queries and see the results. I believe I can do this through
> app builder but I can't figure out how to use it? Any other recommendations
> for learning ABL?
> > >
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
I was hoping to not ask to many trivial questions simply because of my ignorance to ABL but here it goes.

I am trying to build a BPM that when the orderHeld checkbox is checked and it's object is run it unfirms all of the releases for the current order. Also in reverse when the hold is false that it firms all of the releases. I have the orderHeld checkbox checking by default from my BPM but don't even know where to begin to get the releases for X order and do on. I am a developer so I understand logic in general, but Epicor poses some particular challenge for me because I never know when I should use a BPM vs a regular customization and some scripting vs what I should use ABL for over a BAQ etc.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> Easiest way to learn is just wait till you need to do something via BPM.
> Then crack the manual and figure it out. Almost all of your ABL is going to
> be written for BPMs. Getting used to what data you have available and when
> to run your directives is going to be trickier than actually learning ABL.
> --Not to say that either is a particularly daunting task.
>
> When you get rolling and run into a specific issue, come back to the list
> and we'll help you work through it.
>
> On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> <jgiese@...>wrote:
>
> > **
> >
> >
> > I do have the manual downloaded, printed, and in a binder. Unfortunately
> > 'doing' is the way I learn, so the guide really only helps as reference.
> >
> > ABL tester what is that?
> >
> > I'm hoping to use some of the examples in the guide to play around with the
> > training DB and see what I can all do with ABL. That's the primary goal. I
> > will check out the posted video next.
> >
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > Do you have the ABL manual?
> > > http://communities.progress.com/pcom/docs/DOC-16296
> > >
> > > And the BL Tester?
> > >
> > > Also, I found this video interesting:
> > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > >
> > > > What is the best way to go about learning ABL? I was looking for a way
> > to maybe run queries and see the results. I believe I can do this through
> > app builder but I can't figure out how to use it? Any other recommendations
> > for learning ABL?
> > > >
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
I'll second the answer below... I'm a couple months into learning ABL &
BPMs, and most of my time is spent figuring out what to do and how to
hook into Epicor to do it. The technical ABL command to actually do it
is easy by comparison.

And the BL tester (not ABL tester) is an Epicor tool for testing the
business logic (= business objects, often abbreviated "BO"). Its on
your Epicor server, under Utilities I think.

It is possible to hook up the AppBuilder to your test database (add the
bits below to your shortcut) but its not that useful... do it in a BPM
instead.
-pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
-ininame "C:\Program Files\Epicor Software\Epicor905\config\Test905.ini"

Brian.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Waffqle
Sent: Monday, September 12, 2011 8:57 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Testing ABL and running queries

Easiest way to learn is just wait till you need to do something via BPM.
Then crack the manual and figure it out. Almost all of your ABL is going
to
be written for BPMs. Getting used to what data you have available and
when
to run your directives is going to be trickier than actually learning
ABL.
--Not to say that either is a particularly daunting task.

When you get rolling and run into a specific issue, come back to the
list
and we'll help you work through it.

On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
<jgiese@...>wrote:

> **
>
>
> I do have the manual downloaded, printed, and in a binder.
Unfortunately
> 'doing' is the way I learn, so the guide really only helps as
reference.
>
> ABL tester what is that?
>
> I'm hoping to use some of the examples in the guide to play around
with the
> training DB and see what I can all do with ABL. That's the primary
goal. I
> will check out the posted video next.
>
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...>
wrote:
> >
> > Do you have the ABL manual?
> > http://communities.progress.com/pcom/docs/DOC-16296
> >
> > And the BL Tester?
> >
> > Also, I found this video interesting:
> > http://www.youtube.com/watch?v=4Dv295qg3FY
> >
> >
> >
> > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > >
> > > What is the best way to go about learning ABL? I was looking for a
way
> to maybe run queries and see the results. I believe I can do this
through
> app builder but I can't figure out how to use it? Any other
recommendations
> for learning ABL?
> > >
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[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'll second the answer below.
Me too, I've been trying to improve my ABL.
BPMs ended up being the best place I found, even though they can consume quite a bit of time to set up and test.

Also, you can check out the .p programs examples here
\\servername\epicor_directory\server\ud\Test





--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> I'll second the answer below... I'm a couple months into learning ABL &
> BPMs, and most of my time is spent figuring out what to do and how to
> hook into Epicor to do it. The technical ABL command to actually do it
> is easy by comparison.
>
> And the BL tester (not ABL tester) is an Epicor tool for testing the
> business logic (= business objects, often abbreviated "BO"). Its on
> your Epicor server, under Utilities I think.
>
> It is possible to hook up the AppBuilder to your test database (add the
> bits below to your shortcut) but its not that useful... do it in a BPM
> instead.
> -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> -ininame "C:\Program Files\Epicor Software\Epicor905\config\Test905.ini"
>
> Brian.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Waffqle
> Sent: Monday, September 12, 2011 8:57 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Re: Testing ABL and running queries
>
> Easiest way to learn is just wait till you need to do something via BPM.
> Then crack the manual and figure it out. Almost all of your ABL is going
> to
> be written for BPMs. Getting used to what data you have available and
> when
> to run your directives is going to be trickier than actually learning
> ABL.
> --Not to say that either is a particularly daunting task.
>
> When you get rolling and run into a specific issue, come back to the
> list
> and we'll help you work through it.
>
> On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> <jgiese@...>wrote:
>
> > **
> >
> >
> > I do have the manual downloaded, printed, and in a binder.
> Unfortunately
> > 'doing' is the way I learn, so the guide really only helps as
> reference.
> >
> > ABL tester what is that?
> >
> > I'm hoping to use some of the examples in the guide to play around
> with the
> > training DB and see what I can all do with ABL. That's the primary
> goal. I
> > will check out the posted video next.
> >
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> wrote:
> > >
> > > Do you have the ABL manual?
> > > http://communities.progress.com/pcom/docs/DOC-16296
> > >
> > > And the BL Tester?
> > >
> > > Also, I found this video interesting:
> > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > >
> > > > What is the best way to go about learning ABL? I was looking for a
> way
> > to maybe run queries and see the results. I believe I can do this
> through
> > app builder but I can't figure out how to use it? Any other
> recommendations
> > for learning ABL?
> > > >
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [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
>
>the orderHeld checkbox
>unfirms all of the releases
Not sure if this is the same for Sales Orders but...
I was working on something similar with PO releases a while back.
I could not get it to work.

I never would have figured it out without the help in this thread...
http://tech.groups.yahoo.com/group/vantage/message/96522

--- In vantage@yahoogroups.com, "jgiese1988" <jgiese@...> wrote:
>
> I was hoping to not ask to many trivial questions simply because of my ignorance to ABL but here it goes.
>
> I am trying to build a BPM that when the orderHeld checkbox is checked and it's object is run it unfirms all of the releases for the current order. Also in reverse when the hold is false that it firms all of the releases. I have the orderHeld checkbox checking by default from my BPM but don't even know where to begin to get the releases for X order and do on. I am a developer so I understand logic in general, but Epicor poses some particular challenge for me because I never know when I should use a BPM vs a regular customization and some scripting vs what I should use ABL for over a BAQ etc.
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> >
> > Easiest way to learn is just wait till you need to do something via BPM.
> > Then crack the manual and figure it out. Almost all of your ABL is going to
> > be written for BPMs. Getting used to what data you have available and when
> > to run your directives is going to be trickier than actually learning ABL.
> > --Not to say that either is a particularly daunting task.
> >
> > When you get rolling and run into a specific issue, come back to the list
> > and we'll help you work through it.
> >
> > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > <jgiese@>wrote:
> >
> > > **
> > >
> > >
> > > I do have the manual downloaded, printed, and in a binder. Unfortunately
> > > 'doing' is the way I learn, so the guide really only helps as reference.
> > >
> > > ABL tester what is that?
> > >
> > > I'm hoping to use some of the examples in the guide to play around with the
> > > training DB and see what I can all do with ABL. That's the primary goal. I
> > > will check out the posted video next.
> > >
> > >
> > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > > >
> > > > Do you have the ABL manual?
> > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > >
> > > > And the BL Tester?
> > > >
> > > > Also, I found this video interesting:
> > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > >
> > > > > What is the best way to go about learning ABL? I was looking for a way
> > > to maybe run queries and see the results. I believe I can do this through
> > > app builder but I can't figure out how to use it? Any other recommendations
> > > for learning ABL?
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
As far as your issue with the order holds, try this:

FOR EACH ttOrderHed,
EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
OrderRel.OrderNum = ttOrderHed.OrderNum.
IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
ELSE OrderRel.Firm = TRUE.
END.

Double check the field names, as I'm just pulling them off the top of my
head here.

Essentially what you're doing is finding all the Order Headers (there should
only be one). Generally speaking, if your accessing tables that Epicor is
using for the current operation, you'll need to work with the temp ('tt')
table instead of the actual DB table. This ensures that you're working with
the current data even though it may not be committed yet.

After we find the header, we're looking up the Order Releases. Epicor does
not always load all the child records into the tt dataset if they haven't
been changed; this is why we're not accessing them via ttOrderRel. We want
to make sure we get ALL the releases. The IF statement should be pretty
straight forward.

In regards to what customization method to use at a given time it's not
always a black and white thing and everyone has their own opinions. Here's a
rough overview of my views:

BPM - If you want to change the way Epicor acts in all occurrences of a
situation, use a BPM. If you attach a directive to a method (i.e.
SalesOrder.Update) it will fire EVERY TIME that method is called, regardless
of where it is called from. This includes calls from Service Connect, custom
code, 3rd part addons, etc. Generally speaking, if the changes you wish to
make are purely 'business process' issues, you should try to use a BPM if at
all possible. BPM is generally my preferred place to customize when it's
available. If you change something via BPM, you can be pretty confident that
it will work across the board, for all users, in all screens. The code is
generally simpler and more quickly written. All you need to write is your
logic, no UI code, no wiring up adapters/BOs etc.

Screen Customization - There are best used for 'User Experience' issues. If
your users need to see more data, less data, a different UI, this is the
tool. Want to create new buttons that implement user directed logic, this is
the place. As a rule of thumb, avoid implementing Business Logic here
whenever possible.

BAQ - These are just queries. If you need fetch data for dashboards or
reports, these are the tool. In some scenarios you'll use them as part of a
screen customization, but that's a bit much to get into right now.


On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@...>wrote:

> **
>
>
> > I'll second the answer below.
> Me too, I've been trying to improve my ABL.
> BPMs ended up being the best place I found, even though they can consume
> quite a bit of time to set up and test.
>
> Also, you can check out the .p programs examples here
> \\servername\epicor_directory\server\ud\Test
>
>
> --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
> >
> > I'll second the answer below... I'm a couple months into learning ABL &
> > BPMs, and most of my time is spent figuring out what to do and how to
> > hook into Epicor to do it. The technical ABL command to actually do it
> > is easy by comparison.
> >
> > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > business logic (= business objects, often abbreviated "BO"). Its on
> > your Epicor server, under Utilities I think.
> >
> > It is possible to hook up the AppBuilder to your test database (add the
> > bits below to your shortcut) but its not that useful... do it in a BPM
> > instead.
> > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > -ininame "C:\Program Files\Epicor Software\Epicor905\config\Test905.ini"
> >
> > Brian.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of Waffqle
> > Sent: Monday, September 12, 2011 8:57 PM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Re: Testing ABL and running queries
> >
> > Easiest way to learn is just wait till you need to do something via BPM.
> > Then crack the manual and figure it out. Almost all of your ABL is going
> > to
> > be written for BPMs. Getting used to what data you have available and
> > when
> > to run your directives is going to be trickier than actually learning
> > ABL.
> > --Not to say that either is a particularly daunting task.
> >
> > When you get rolling and run into a specific issue, come back to the
> > list
> > and we'll help you work through it.
> >
> > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > <jgiese@...>wrote:
>
> >
> > > **
> > >
> > >
> > > I do have the manual downloaded, printed, and in a binder.
> > Unfortunately
> > > 'doing' is the way I learn, so the guide really only helps as
> > reference.
> > >
> > > ABL tester what is that?
> > >
> > > I'm hoping to use some of the examples in the guide to play around
> > with the
> > > training DB and see what I can all do with ABL. That's the primary
> > goal. I
> > > will check out the posted video next.
> > >
> > >
> > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > wrote:
> > > >
> > > > Do you have the ABL manual?
> > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > >
> > > > And the BL Tester?
> > > >
> > > > Also, I found this video interesting:
> > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > >
> > > > > What is the best way to go about learning ABL? I was looking for a
> > way
> > > to maybe run queries and see the results. I believe I can do this
> > through
> > > app builder but I can't figure out how to use it? Any other
> > recommendations
> > > for learning ABL?
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@...*
>
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [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
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
So I don't even have to provide a condition then I see. I did not realize that I could be using conditions within the ABL action. I have it working though, it was very close. So is ABL a sort of combo between logic language and DB query language?


--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> As far as your issue with the order holds, try this:
>
> FOR EACH ttOrderHed,
> EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
> OrderRel.OrderNum = ttOrderHed.OrderNum.
> IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
> ELSE OrderRel.Firm = TRUE.
> END.
>
> Double check the field names, as I'm just pulling them off the top of my
> head here.
>
> Essentially what you're doing is finding all the Order Headers (there should
> only be one). Generally speaking, if your accessing tables that Epicor is
> using for the current operation, you'll need to work with the temp ('tt')
> table instead of the actual DB table. This ensures that you're working with
> the current data even though it may not be committed yet.
>
> After we find the header, we're looking up the Order Releases. Epicor does
> not always load all the child records into the tt dataset if they haven't
> been changed; this is why we're not accessing them via ttOrderRel. We want
> to make sure we get ALL the releases. The IF statement should be pretty
> straight forward.
>
> In regards to what customization method to use at a given time it's not
> always a black and white thing and everyone has their own opinions. Here's a
> rough overview of my views:
>
> BPM - If you want to change the way Epicor acts in all occurrences of a
> situation, use a BPM. If you attach a directive to a method (i.e.
> SalesOrder.Update) it will fire EVERY TIME that method is called, regardless
> of where it is called from. This includes calls from Service Connect, custom
> code, 3rd part addons, etc. Generally speaking, if the changes you wish to
> make are purely 'business process' issues, you should try to use a BPM if at
> all possible. BPM is generally my preferred place to customize when it's
> available. If you change something via BPM, you can be pretty confident that
> it will work across the board, for all users, in all screens. The code is
> generally simpler and more quickly written. All you need to write is your
> logic, no UI code, no wiring up adapters/BOs etc.
>
> Screen Customization - There are best used for 'User Experience' issues. If
> your users need to see more data, less data, a different UI, this is the
> tool. Want to create new buttons that implement user directed logic, this is
> the place. As a rule of thumb, avoid implementing Business Logic here
> whenever possible.
>
> BAQ - These are just queries. If you need fetch data for dashboards or
> reports, these are the tool. In some scenarios you'll use them as part of a
> screen customization, but that's a bit much to get into right now.
>
>
> On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@...>wrote:
>
> > **
> >
> >
> > > I'll second the answer below.
> > Me too, I've been trying to improve my ABL.
> > BPMs ended up being the best place I found, even though they can consume
> > quite a bit of time to set up and test.
> >
> > Also, you can check out the .p programs examples here
> > \\servername\epicor_directory\server\ud\Test
> >
> >
> > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > >
> > > I'll second the answer below... I'm a couple months into learning ABL &
> > > BPMs, and most of my time is spent figuring out what to do and how to
> > > hook into Epicor to do it. The technical ABL command to actually do it
> > > is easy by comparison.
> > >
> > > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > > business logic (= business objects, often abbreviated "BO"). Its on
> > > your Epicor server, under Utilities I think.
> > >
> > > It is possible to hook up the AppBuilder to your test database (add the
> > > bits below to your shortcut) but its not that useful... do it in a BPM
> > > instead.
> > > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > > -ininame "C:\Program Files\Epicor Software\Epicor905\config\Test905.ini"
> > >
> > > Brian.
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of Waffqle
> > > Sent: Monday, September 12, 2011 8:57 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] Re: Testing ABL and running queries
> > >
> > > Easiest way to learn is just wait till you need to do something via BPM.
> > > Then crack the manual and figure it out. Almost all of your ABL is going
> > > to
> > > be written for BPMs. Getting used to what data you have available and
> > > when
> > > to run your directives is going to be trickier than actually learning
> > > ABL.
> > > --Not to say that either is a particularly daunting task.
> > >
> > > When you get rolling and run into a specific issue, come back to the
> > > list
> > > and we'll help you work through it.
> > >
> > > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > > <jgiese@>wrote:
> >
> > >
> > > > **
> > > >
> > > >
> > > > I do have the manual downloaded, printed, and in a binder.
> > > Unfortunately
> > > > 'doing' is the way I learn, so the guide really only helps as
> > > reference.
> > > >
> > > > ABL tester what is that?
> > > >
> > > > I'm hoping to use some of the examples in the guide to play around
> > > with the
> > > > training DB and see what I can all do with ABL. That's the primary
> > > goal. I
> > > > will check out the posted video next.
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > > wrote:
> > > > >
> > > > > Do you have the ABL manual?
> > > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > > >
> > > > > And the BL Tester?
> > > > >
> > > > > Also, I found this video interesting:
> > > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > > >
> > > > > > What is the best way to go about learning ABL? I was looking for a
> > > way
> > > > to maybe run queries and see the results. I believe I can do this
> > > through
> > > > app builder but I can't figure out how to use it? Any other
> > > recommendations
> > > > for learning ABL?
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
> >
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [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
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
I suppose you could call it that. Progress likes to refer to it as a 'Fourth
Generation Language'.

You can put your conditions in either side. I've heard that its faster to
set them up separately, but honestly I've never tested it. I tend to just do
whatever will be quicker for me in a given instance. Regardless, it should
function the same either way.

On Tue, Sep 13, 2011 at 1:17 PM, jgiese1988
<jgiese@...>wrote:

> **
>
>
> So I don't even have to provide a condition then I see. I did not realize
> that I could be using conditions within the ABL action. I have it working
> though, it was very close. So is ABL a sort of combo between logic language
> and DB query language?
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > As far as your issue with the order holds, try this:
> >
> > FOR EACH ttOrderHed,
> > EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
> > OrderRel.OrderNum = ttOrderHed.OrderNum.
> > IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
> > ELSE OrderRel.Firm = TRUE.
> > END.
> >
> > Double check the field names, as I'm just pulling them off the top of my
> > head here.
> >
> > Essentially what you're doing is finding all the Order Headers (there
> should
> > only be one). Generally speaking, if your accessing tables that Epicor is
> > using for the current operation, you'll need to work with the temp ('tt')
> > table instead of the actual DB table. This ensures that you're working
> with
> > the current data even though it may not be committed yet.
> >
> > After we find the header, we're looking up the Order Releases. Epicor
> does
> > not always load all the child records into the tt dataset if they haven't
> > been changed; this is why we're not accessing them via ttOrderRel. We
> want
> > to make sure we get ALL the releases. The IF statement should be pretty
> > straight forward.
> >
> > In regards to what customization method to use at a given time it's not
> > always a black and white thing and everyone has their own opinions.
> Here's a
> > rough overview of my views:
> >
> > BPM - If you want to change the way Epicor acts in all occurrences of a
> > situation, use a BPM. If you attach a directive to a method (i.e.
> > SalesOrder.Update) it will fire EVERY TIME that method is called,
> regardless
> > of where it is called from. This includes calls from Service Connect,
> custom
> > code, 3rd part addons, etc. Generally speaking, if the changes you wish
> to
> > make are purely 'business process' issues, you should try to use a BPM if
> at
> > all possible. BPM is generally my preferred place to customize when it's
> > available. If you change something via BPM, you can be pretty confident
> that
> > it will work across the board, for all users, in all screens. The code is
> > generally simpler and more quickly written. All you need to write is your
> > logic, no UI code, no wiring up adapters/BOs etc.
> >
> > Screen Customization - There are best used for 'User Experience' issues.
> If
> > your users need to see more data, less data, a different UI, this is the
> > tool. Want to create new buttons that implement user directed logic, this
> is
> > the place. As a rule of thumb, avoid implementing Business Logic here
> > whenever possible.
> >
> > BAQ - These are just queries. If you need fetch data for dashboards or
> > reports, these are the tool. In some scenarios you'll use them as part of
> a
> > screen customization, but that's a bit much to get into right now.
> >
> >
> > On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@...>wrote:
>
> >
> > > **
> > >
> > >
> > > > I'll second the answer below.
> > > Me too, I've been trying to improve my ABL.
> > > BPMs ended up being the best place I found, even though they can
> consume
> > > quite a bit of time to set up and test.
> > >
> > > Also, you can check out the .p programs examples here
> > > \\servername\epicor_directory\server\ud\Test
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > > >
> > > > I'll second the answer below... I'm a couple months into learning ABL
> &
> > > > BPMs, and most of my time is spent figuring out what to do and how to
> > > > hook into Epicor to do it. The technical ABL command to actually do
> it
> > > > is easy by comparison.
> > > >
> > > > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > > > business logic (= business objects, often abbreviated "BO"). Its on
> > > > your Epicor server, under Utilities I think.
> > > >
> > > > It is possible to hook up the AppBuilder to your test database (add
> the
> > > > bits below to your shortcut) but its not that useful... do it in a
> BPM
> > > > instead.
> > > > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > > > -ininame "C:\Program Files\Epicor
> Software\Epicor905\config\Test905.ini"
> > > >
> > > > Brian.
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > > > Of Waffqle
> > > > Sent: Monday, September 12, 2011 8:57 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] Re: Testing ABL and running queries
> > > >
> > > > Easiest way to learn is just wait till you need to do something via
> BPM.
> > > > Then crack the manual and figure it out. Almost all of your ABL is
> going
> > > > to
> > > > be written for BPMs. Getting used to what data you have available and
> > > > when
> > > > to run your directives is going to be trickier than actually learning
> > > > ABL.
> > > > --Not to say that either is a particularly daunting task.
> > > >
> > > > When you get rolling and run into a specific issue, come back to the
> > > > list
> > > > and we'll help you work through it.
> > > >
> > > > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > > > <jgiese@>wrote:
> > >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > I do have the manual downloaded, printed, and in a binder.
> > > > Unfortunately
> > > > > 'doing' is the way I learn, so the guide really only helps as
> > > > reference.
> > > > >
> > > > > ABL tester what is that?
> > > > >
> > > > > I'm hoping to use some of the examples in the guide to play around
> > > > with the
> > > > > training DB and see what I can all do with ABL. That's the primary
> > > > goal. I
> > > > > will check out the posted video next.
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > > > wrote:
> > > > > >
> > > > > > Do you have the ABL manual?
> > > > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > > > >
> > > > > > And the BL Tester?
> > > > > >
> > > > > > Also, I found this video interesting:
> > > > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > > > >
> > > > > > > What is the best way to go about learning ABL? I was looking
> for a
> > > > way
> > > > > to maybe run queries and see the results. I believe I can do this
> > > > through
> > > > > app builder but I can't figure out how to use it? Any other
> > > > recommendations
> > > > > for learning ABL?
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> > >
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [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
> > > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@...*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Hmm.... actually this won't work. So how would I go about making this be controlled at the time the hold checkbox is checked? The issue is if we actually want the order off hold and one of the releases unfirm while the other is firm at the time i save it will firm the unfirm release. Can I add a condition at the BPM that only runs the action if the value of orderHeld changes?

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> As far as your issue with the order holds, try this:
>
> FOR EACH ttOrderHed,
> EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
> OrderRel.OrderNum = ttOrderHed.OrderNum.
> IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
> ELSE OrderRel.Firm = TRUE.
> END.
>
> Double check the field names, as I'm just pulling them off the top of my
> head here.
>
> Essentially what you're doing is finding all the Order Headers (there should
> only be one). Generally speaking, if your accessing tables that Epicor is
> using for the current operation, you'll need to work with the temp ('tt')
> table instead of the actual DB table. This ensures that you're working with
> the current data even though it may not be committed yet.
>
> After we find the header, we're looking up the Order Releases. Epicor does
> not always load all the child records into the tt dataset if they haven't
> been changed; this is why we're not accessing them via ttOrderRel. We want
> to make sure we get ALL the releases. The IF statement should be pretty
> straight forward.
>
> In regards to what customization method to use at a given time it's not
> always a black and white thing and everyone has their own opinions. Here's a
> rough overview of my views:
>
> BPM - If you want to change the way Epicor acts in all occurrences of a
> situation, use a BPM. If you attach a directive to a method (i.e.
> SalesOrder.Update) it will fire EVERY TIME that method is called, regardless
> of where it is called from. This includes calls from Service Connect, custom
> code, 3rd part addons, etc. Generally speaking, if the changes you wish to
> make are purely 'business process' issues, you should try to use a BPM if at
> all possible. BPM is generally my preferred place to customize when it's
> available. If you change something via BPM, you can be pretty confident that
> it will work across the board, for all users, in all screens. The code is
> generally simpler and more quickly written. All you need to write is your
> logic, no UI code, no wiring up adapters/BOs etc.
>
> Screen Customization - There are best used for 'User Experience' issues. If
> your users need to see more data, less data, a different UI, this is the
> tool. Want to create new buttons that implement user directed logic, this is
> the place. As a rule of thumb, avoid implementing Business Logic here
> whenever possible.
>
> BAQ - These are just queries. If you need fetch data for dashboards or
> reports, these are the tool. In some scenarios you'll use them as part of a
> screen customization, but that's a bit much to get into right now.
>
>
> On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@...>wrote:
>
> > **
> >
> >
> > > I'll second the answer below.
> > Me too, I've been trying to improve my ABL.
> > BPMs ended up being the best place I found, even though they can consume
> > quite a bit of time to set up and test.
> >
> > Also, you can check out the .p programs examples here
> > \\servername\epicor_directory\server\ud\Test
> >
> >
> > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > >
> > > I'll second the answer below... I'm a couple months into learning ABL &
> > > BPMs, and most of my time is spent figuring out what to do and how to
> > > hook into Epicor to do it. The technical ABL command to actually do it
> > > is easy by comparison.
> > >
> > > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > > business logic (= business objects, often abbreviated "BO"). Its on
> > > your Epicor server, under Utilities I think.
> > >
> > > It is possible to hook up the AppBuilder to your test database (add the
> > > bits below to your shortcut) but its not that useful... do it in a BPM
> > > instead.
> > > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > > -ininame "C:\Program Files\Epicor Software\Epicor905\config\Test905.ini"
> > >
> > > Brian.
> > >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of Waffqle
> > > Sent: Monday, September 12, 2011 8:57 PM
> > > To: vantage@yahoogroups.com
> > > Subject: Re: [Vantage] Re: Testing ABL and running queries
> > >
> > > Easiest way to learn is just wait till you need to do something via BPM.
> > > Then crack the manual and figure it out. Almost all of your ABL is going
> > > to
> > > be written for BPMs. Getting used to what data you have available and
> > > when
> > > to run your directives is going to be trickier than actually learning
> > > ABL.
> > > --Not to say that either is a particularly daunting task.
> > >
> > > When you get rolling and run into a specific issue, come back to the
> > > list
> > > and we'll help you work through it.
> > >
> > > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > > <jgiese@>wrote:
> >
> > >
> > > > **
> > > >
> > > >
> > > > I do have the manual downloaded, printed, and in a binder.
> > > Unfortunately
> > > > 'doing' is the way I learn, so the guide really only helps as
> > > reference.
> > > >
> > > > ABL tester what is that?
> > > >
> > > > I'm hoping to use some of the examples in the guide to play around
> > > with the
> > > > training DB and see what I can all do with ABL. That's the primary
> > > goal. I
> > > > will check out the posted video next.
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > > wrote:
> > > > >
> > > > > Do you have the ABL manual?
> > > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > > >
> > > > > And the BL Tester?
> > > > >
> > > > > Also, I found this video interesting:
> > > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > > >
> > > > > > What is the best way to go about learning ABL? I was looking for a
> > > way
> > > > to maybe run queries and see the results. I believe I can do this
> > > through
> > > > app builder but I can't figure out how to use it? Any other
> > > recommendations
> > > > for learning ABL?
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
> >
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [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
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
If you go to conditions you can set it to only fire when 'the value of
<field> has changed from <something> to <something else>' you can use this
to ensure your BPM only fires when the field is changed. However, that won't
stop it from firming/unfirming all releases. If you only want to change a
subset of the releases, you're going to need to come up with
some criteria that you can implement.

On Tue, Sep 13, 2011 at 2:13 PM, jgiese1988
<jgiese@...>wrote:

> **
>
>
> Hmm.... actually this won't work. So how would I go about making this be
> controlled at the time the hold checkbox is checked? The issue is if we
> actually want the order off hold and one of the releases unfirm while the
> other is firm at the time i save it will firm the unfirm release. Can I add
> a condition at the BPM that only runs the action if the value of orderHeld
> changes?
>
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
> >
> > As far as your issue with the order holds, try this:
> >
> > FOR EACH ttOrderHed,
> > EACH OrderRel WHERE OrderRel.Company = ttOrderHed.Company AND
> > OrderRel.OrderNum = ttOrderHed.OrderNum.
> > IF ttOrderHed.OrderHeld = TRUE THEN OrderRel.Firm = False.
> > ELSE OrderRel.Firm = TRUE.
> > END.
> >
> > Double check the field names, as I'm just pulling them off the top of my
> > head here.
> >
> > Essentially what you're doing is finding all the Order Headers (there
> should
> > only be one). Generally speaking, if your accessing tables that Epicor is
> > using for the current operation, you'll need to work with the temp ('tt')
> > table instead of the actual DB table. This ensures that you're working
> with
> > the current data even though it may not be committed yet.
> >
> > After we find the header, we're looking up the Order Releases. Epicor
> does
> > not always load all the child records into the tt dataset if they haven't
> > been changed; this is why we're not accessing them via ttOrderRel. We
> want
> > to make sure we get ALL the releases. The IF statement should be pretty
> > straight forward.
> >
> > In regards to what customization method to use at a given time it's not
> > always a black and white thing and everyone has their own opinions.
> Here's a
> > rough overview of my views:
> >
> > BPM - If you want to change the way Epicor acts in all occurrences of a
> > situation, use a BPM. If you attach a directive to a method (i.e.
> > SalesOrder.Update) it will fire EVERY TIME that method is called,
> regardless
> > of where it is called from. This includes calls from Service Connect,
> custom
> > code, 3rd part addons, etc. Generally speaking, if the changes you wish
> to
> > make are purely 'business process' issues, you should try to use a BPM if
> at
> > all possible. BPM is generally my preferred place to customize when it's
> > available. If you change something via BPM, you can be pretty confident
> that
> > it will work across the board, for all users, in all screens. The code is
> > generally simpler and more quickly written. All you need to write is your
> > logic, no UI code, no wiring up adapters/BOs etc.
> >
> > Screen Customization - There are best used for 'User Experience' issues.
> If
> > your users need to see more data, less data, a different UI, this is the
> > tool. Want to create new buttons that implement user directed logic, this
> is
> > the place. As a rule of thumb, avoid implementing Business Logic here
> > whenever possible.
> >
> > BAQ - These are just queries. If you need fetch data for dashboards or
> > reports, these are the tool. In some scenarios you'll use them as part of
> a
> > screen customization, but that's a bit much to get into right now.
> >
> >
> > On Tue, Sep 13, 2011 at 10:36 AM, cooner_55421 <cooner_55421@...>wrote:
>
> >
> > > **
> > >
> > >
> > > > I'll second the answer below.
> > > Me too, I've been trying to improve my ABL.
> > > BPMs ended up being the best place I found, even though they can
> consume
> > > quite a bit of time to set up and test.
> > >
> > > Also, you can check out the .p programs examples here
> > > \\servername\epicor_directory\server\ud\Test
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Brian Roberts" <broberts@> wrote:
> > > >
> > > > I'll second the answer below... I'm a couple months into learning ABL
> &
> > > > BPMs, and most of my time is spent figuring out what to do and how to
> > > > hook into Epicor to do it. The technical ABL command to actually do
> it
> > > > is easy by comparison.
> > > >
> > > > And the BL tester (not ABL tester) is an Epicor tool for testing the
> > > > business logic (= business objects, often abbreviated "BO"). Its on
> > > > your Epicor server, under Utilities I think.
> > > >
> > > > It is possible to hook up the AppBuilder to your test database (add
> the
> > > > bits below to your shortcut) but its not that useful... do it in a
> BPM
> > > > instead.
> > > > -pf "C:\Program Files\Epicor Software\Epicor905\config\mfgtest.pf"
> > > > -ininame "C:\Program Files\Epicor
> Software\Epicor905\config\Test905.ini"
> > > >
> > > > Brian.
> > > >
> > > > -----Original Message-----
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > > > Of Waffqle
> > > > Sent: Monday, September 12, 2011 8:57 PM
> > > > To: vantage@yahoogroups.com
> > > > Subject: Re: [Vantage] Re: Testing ABL and running queries
> > > >
> > > > Easiest way to learn is just wait till you need to do something via
> BPM.
> > > > Then crack the manual and figure it out. Almost all of your ABL is
> going
> > > > to
> > > > be written for BPMs. Getting used to what data you have available and
> > > > when
> > > > to run your directives is going to be trickier than actually learning
> > > > ABL.
> > > > --Not to say that either is a particularly daunting task.
> > > >
> > > > When you get rolling and run into a specific issue, come back to the
> > > > list
> > > > and we'll help you work through it.
> > > >
> > > > On Mon, Sep 12, 2011 at 7:18 PM, jgiese1988
> > > > <jgiese@>wrote:
> > >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > I do have the manual downloaded, printed, and in a binder.
> > > > Unfortunately
> > > > > 'doing' is the way I learn, so the guide really only helps as
> > > > reference.
> > > > >
> > > > > ABL tester what is that?
> > > > >
> > > > > I'm hoping to use some of the examples in the guide to play around
> > > > with the
> > > > > training DB and see what I can all do with ABL. That's the primary
> > > > goal. I
> > > > > will check out the posted video next.
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@>
> > > > wrote:
> > > > > >
> > > > > > Do you have the ABL manual?
> > > > > > http://communities.progress.com/pcom/docs/DOC-16296
> > > > > >
> > > > > > And the BL Tester?
> > > > > >
> > > > > > Also, I found this video interesting:
> > > > > > http://www.youtube.com/watch?v=4Dv295qg3FY
> > > > > >
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com, "jgiese1988" <jgiese@> wrote:
> > > > > > >
> > > > > > > What is the best way to go about learning ABL? I was looking
> for a
> > > > way
> > > > > to maybe run queries and see the results. I believe I can do this
> > > > through
> > > > > app builder but I can't figure out how to use it? Any other
> > > > recommendations
> > > > > for learning ABL?
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> > >
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [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
> > > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@...*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


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