Hi everyone ---
I just thought I'd fill you in since I did eventually hear back from the
helpline. It is indeed broken and has a SCR, # 78693 --- It will be fixed in
9.04.508 (not released yet) or 9.05.602(? - I believe she said 6.02)
So much for that idea,....now back to the drawing board on this one -- since I'm
not moving to 9.05 till 2 quarter next year.
Thanks for your input!
Laurie
________________________________
From: "robertb_versa@..." <robertb_versa@...>
To: vantage@yahoogroups.com
Sent: Fri, December 10, 2010 5:53:50 PM
Subject: Re: [Vantage] Re: BAQ's and File Alias'
Â
Does it return data using those same joins as an effectively equivelent SQL
statement?
I didn't reread the thread but assume this must be a v9 install (which specific
one, can't tell) as your BAQ joins are allowing you to add 2 instances of the
Part table (eached joined in its own unique was to PartMtl to give you a query
capable of multilevel BOM dispaly with Part table stored data dispalyed at each
level)... That's a v9 introduced BAQ capability to my knowledge (which is
enabled by unleashing native Progress query capabilities that are apparently
purposely suppressed via added 'dumbed down' BAQ editor code in v8 and lower).
I ask if it works in SQL as I wonder if your joins aren't over simplified
(skipping partplant, part rev and perhaps even partasy).
I'd also do single table dumps to verify company is actually populated in each
table. (If it isn't, the BAQ criteria is doomedto return nothing and you don't
indicate how you loaded your versions db data... Maybe in a way that allowed biz
logic to be bypassed (not 4GL, not SC, not DMT and not manually entry) through
direct odbc/sql writes, etc. that can allow you to create imcomplete records
that come back and bite you later.
Not on 9 (and not in a nurry to be) - but I'd be very appreciative if you share
the eventual found cause and solution.
Good luck to you!
Rob Brown
--- Original Message ---
From:"stcsgirl" <stcsgirl@...>
Sent:Fri 12/10/10 10:00 am
To:vantage@yahoogroups.com
Subj:Re: [Vantage] Re: BAQ's and File Alias'
Hi Len,
Yes, I tried that --- I had another set of eyes look as well to make sure I
wasn't missing anything l and it matches your statement.Â
Very strange,...
________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thu, December 9, 2010 6:56:36 PM
Subject: RE: [Vantage] Re: BAQ's and File Alias'
Â
Good DAy Laurie:
See atached and below.
for each PartMtl no-lock , each Part no-lock where (PartMtl.Company
= Part.Company and PartMtl.PartNum = Part.PartNum ) , each Part1
no-lock where (PartMtl.Company = Part1.Company and PartMtl.MtlPartNum
= Part1.PartNum ).
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of stcsgirl
Sent: Thursday, December 09, 2010 5:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BAQ's and File Alias'
Hi Bruce,
I did that exactly, made sure my query statement matched yours,...the
only thing
different was the Rev table - I added that, but still nothing. Takes
forever to
run and then comes back blank.
I do have a helpline call in, but I can't seem to get alias' to work,
and I've
tried them on other files as well with no success.
Are you on the same version, by chance?
Laurie
________________________________
From: Bruce <epicor@... <mailto:epicor%40erpgeek.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, December 9, 2010 3:05:21 PM
Subject: [Vantage] Re: BAQ's and File Alias'
Take a look at the Table relations. The second Part table should be
relating to
MatlPartNum to capture the children parts.
Hope that helps.
Here's what the query is:
"MtlPart" is the alias of the PartNum table.
for each PartMtl no-lock , each Part no-lock where (PartMtl.Company =
Part.Company and PartMtl.PartNum = Part.PartNum ) , each MtlPart no-lock
, each
PartRev no-lock where (PartMtl.Company = MtlPart.Company and
PartMtl.MtlPartNum
= MtlPart.PartNum ) and (PartMtl.Company = PartRev.Company and
PartMtl.PartNum =
PartRev.PartNum and PartMtl.RevisionNum = PartRev.RevisionNum and
PartMtl.AltMethod = PartRev.AltMethod ).
Bruce Larson
Senior Solution Architect
alternative Technology Partners
Web Site: www.alttechpartners.com
Cell: (763) 486-0030
Fax: (763) 447-3571
Email: bruce.larson@...
<mailto:bruce.larson%40alttechpartners.com>
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
stcsgirl <stcsgirl@...> wrote:
I just thought I'd fill you in since I did eventually hear back from the
helpline. It is indeed broken and has a SCR, # 78693 --- It will be fixed in
9.04.508 (not released yet) or 9.05.602(? - I believe she said 6.02)
So much for that idea,....now back to the drawing board on this one -- since I'm
not moving to 9.05 till 2 quarter next year.
Thanks for your input!
Laurie
________________________________
From: "robertb_versa@..." <robertb_versa@...>
To: vantage@yahoogroups.com
Sent: Fri, December 10, 2010 5:53:50 PM
Subject: Re: [Vantage] Re: BAQ's and File Alias'
Â
Does it return data using those same joins as an effectively equivelent SQL
statement?
I didn't reread the thread but assume this must be a v9 install (which specific
one, can't tell) as your BAQ joins are allowing you to add 2 instances of the
Part table (eached joined in its own unique was to PartMtl to give you a query
capable of multilevel BOM dispaly with Part table stored data dispalyed at each
level)... That's a v9 introduced BAQ capability to my knowledge (which is
enabled by unleashing native Progress query capabilities that are apparently
purposely suppressed via added 'dumbed down' BAQ editor code in v8 and lower).
I ask if it works in SQL as I wonder if your joins aren't over simplified
(skipping partplant, part rev and perhaps even partasy).
I'd also do single table dumps to verify company is actually populated in each
table. (If it isn't, the BAQ criteria is doomedto return nothing and you don't
indicate how you loaded your versions db data... Maybe in a way that allowed biz
logic to be bypassed (not 4GL, not SC, not DMT and not manually entry) through
direct odbc/sql writes, etc. that can allow you to create imcomplete records
that come back and bite you later.
Not on 9 (and not in a nurry to be) - but I'd be very appreciative if you share
the eventual found cause and solution.
Good luck to you!
Rob Brown
--- Original Message ---
From:"stcsgirl" <stcsgirl@...>
Sent:Fri 12/10/10 10:00 am
To:vantage@yahoogroups.com
Subj:Re: [Vantage] Re: BAQ's and File Alias'
Hi Len,
Yes, I tried that --- I had another set of eyes look as well to make sure I
wasn't missing anything l and it matches your statement.Â
Very strange,...
________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thu, December 9, 2010 6:56:36 PM
Subject: RE: [Vantage] Re: BAQ's and File Alias'
Â
Good DAy Laurie:
See atached and below.
for each PartMtl no-lock , each Part no-lock where (PartMtl.Company
= Part.Company and PartMtl.PartNum = Part.PartNum ) , each Part1
no-lock where (PartMtl.Company = Part1.Company and PartMtl.MtlPartNum
= Part1.PartNum ).
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of stcsgirl
Sent: Thursday, December 09, 2010 5:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BAQ's and File Alias'
Hi Bruce,
I did that exactly, made sure my query statement matched yours,...the
only thing
different was the Rev table - I added that, but still nothing. Takes
forever to
run and then comes back blank.
I do have a helpline call in, but I can't seem to get alias' to work,
and I've
tried them on other files as well with no success.
Are you on the same version, by chance?
Laurie
________________________________
From: Bruce <epicor@... <mailto:epicor%40erpgeek.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, December 9, 2010 3:05:21 PM
Subject: [Vantage] Re: BAQ's and File Alias'
Take a look at the Table relations. The second Part table should be
relating to
MatlPartNum to capture the children parts.
Hope that helps.
Here's what the query is:
"MtlPart" is the alias of the PartNum table.
for each PartMtl no-lock , each Part no-lock where (PartMtl.Company =
Part.Company and PartMtl.PartNum = Part.PartNum ) , each MtlPart no-lock
, each
PartRev no-lock where (PartMtl.Company = MtlPart.Company and
PartMtl.MtlPartNum
= MtlPart.PartNum ) and (PartMtl.Company = PartRev.Company and
PartMtl.PartNum =
PartRev.PartNum and PartMtl.RevisionNum = PartRev.RevisionNum and
PartMtl.AltMethod = PartRev.AltMethod ).
Bruce Larson
Senior Solution Architect
alternative Technology Partners
Web Site: www.alttechpartners.com
Cell: (763) 486-0030
Fax: (763) 447-3571
Email: bruce.larson@...
<mailto:bruce.larson%40alttechpartners.com>
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
stcsgirl <stcsgirl@...> wrote:
>create a
> Hi there ---
> We are currently running Epicor 9.04.505A Progress and I'm trying to
> BAQ using the Part file --> PartMtl file --> the Part file again usingan alias
>at all
> keying off the Material Part.
>
>
> No matter what I do I can't get it to work, I don't get error messages
> and the syntax says everything is okay, but the fields from the 2ndpart file
> are blank.[Non-text portions of this message have been removed]
>
> Any suggestions?
>
> TIA,
> Laurie
>
>
>
>