BAQ question Blank Title 96147

Yahoo Archive
1
It may be the "and JobHead.PartNum = JobOper.PartNum" in the first join,
try removing it.



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of melissa hietala
Sent: Tuesday, April 03, 2012 5:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ question





I am trying to create a BAQ that shows me any open jobs where a
operation is complete but any material lines(tools) related to that op
are not issued complete. Here is my Phrase Builder information:

for each JobHead no-lock where JobHead.JobClosed = False , each
JobOper no-lock where (JobHead.Company = JobOper.Company and
JobHead.JobNum = JobOper.JobNum and JobHead.PartNum = JobOper.PartNum )
and JobOper.OpComplete = True , each JobMtl no-lock where
(JobOper.Company = JobMtl.Company and JobOper.JobNum = JobMtl.JobNum and
JobOper.OprSeq = JobMtl.RelatedOperation ) and JobMtl.IssuedComplete =
False .

I get no records, yet when I use all the same tables, fields, criteria,
joins, I get 10 pages in Crystal. What am I missing?

If I do not have the criteria on for only open jobs and let it run wide
open or for closed jobs I get records back. Am I missing a join or
something on the tables? Do I need to add another table in between
somewhere?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@... <mailto:melissah%40ultramc.com>

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





[Non-text portions of this message have been removed]
2
I am running version 8 and am working on a BAQ. Right now my BAQ pulls each PO line item and calculates its total. I am trying to get this data down to a unique list of suppliers along with the totals of their PO lines within a date range. Does anyone know where to start?
3
I would do the totals in Crystal. Basically the BAQ just pulls from
PODetail, POHeader, and Vendor, and your BAQ report definition can
include a begin and end date option.

Then group by VendorID in the report, and add a summary at the end of
the group. If you're not interested in the PODetail, then suppress the
detail section and just show the GroupFooter section with your
summaries.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of deferr86
Sent: Monday, December 13, 2010 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ question

I am running version 8 and am working on a BAQ. Right now my BAQ pulls
each PO line item and calculates its total. I am trying to get this
data down to a unique list of suppliers along with the totals of their
PO lines within a date range. Does anyone know where to start?



------------------------------------

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
4
The Executive Query would sum based on the Supplier.
you can then write a query with the MfgCube table included that would be filtered for the PO data only.

I just did something like that with job receipts to stock totals.


Bruce Larson
Senior Solution Architect
alternative Technology Partners

Web Site: www.alttechpartners.com

Cell: (763) 486-0030
Fax: (763) 447-3571
Email: bruce.larson@...



--- In vantage@yahoogroups.com, "deferr86" <d.e.ferrier@...> wrote:
>
> I am running version 8 and am working on a BAQ. Right now my BAQ pulls each PO line item and calculates its total. I am trying to get this data down to a unique list of suppliers along with the totals of their PO lines within a date range. Does anyone know where to start?
>
5
I want to return the last Order.Dtl that a particular Part shows up on.

My BAQ:

for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum) no-lock .

The query runs and returns data, but does not return what I would consider the LAST OrderDtl (highest OrderNumber, Highest Line)


What exactly does the LAST OrderDtl return.......?
6
You probably want to put a By OrderNum clause on that where statement and it
should work

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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:

>
>
> I want to return the last Order.Dtl that a particular Part shows up on.
>
> My BAQ:
>
> for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
> 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
> (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
> no-lock .
>
> The query runs and returns data, but does not return what I would consider
> the LAST OrderDtl (highest OrderNumber, Highest Line)
>
> What exactly does the LAST OrderDtl return.......?
>
>
>


[Non-text portions of this message have been removed]
7
I did try that and got the exact same results....

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, April 07, 2011 2:27 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ question

You probably want to put a By OrderNum clause on that where statement and it
should work

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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:

>
>
> I want to return the last Order.Dtl that a particular Part shows up on.
>
> My BAQ:
>
> for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
> 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
> (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
> no-lock .
>
> The query runs and returns data, but does not return what I would consider
> the LAST OrderDtl (highest OrderNumber, Highest Line)
>
> What exactly does the LAST OrderDtl return.......?
>
>
>


[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
8
What exactly did you try? Do you have BPM's running? Do you have external
processes? Do you have two people accessing the same PO at the same time?

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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:30 PM, Bernie Walker <bwalker@...>wrote:

>
>
> I did try that and got the exact same results....
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Thursday, April 07, 2011 2:27 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BAQ question
>
> You probably want to put a By OrderNum clause on that where statement and
> it
> should work
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:
>
> >
> >
> > I want to return the last Order.Dtl that a particular Part shows up on.
> >
> > My BAQ:
> >
> > for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
> > 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
> > (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
> > no-lock .
> >
> > The query runs and returns data, but does not return what I would
> consider
> > the LAST OrderDtl (highest OrderNumber, Highest Line)
> >
> > What exactly does the LAST OrderDtl return.......?
> >
> >
> >
>
> [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]
9
Never mind wrong email LoL

So you set your By Clause to OrderNum it should then sort by OrderNum and
Last, should be the last one that is returned


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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:31 PM, Jose Gomez <jose@...> wrote:

> What exactly did you try? Do you have BPM's running? Do you have external
> processes? Do you have two people accessing the same PO at the same time?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Apr 7, 2011 at 2:30 PM, Bernie Walker <bwalker@...>wrote:
>
>>
>>
>> I did try that and got the exact same results....
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of Jose Gomez
>> Sent: Thursday, April 07, 2011 2:27 PM
>> To: vantage@yahoogroups.com
>> Subject: Re: [Vantage] BAQ question
>>
>> You probably want to put a By OrderNum clause on that where statement and
>> it
>> should work
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez> <
>> http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
>> >
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>
>> *Quis custodiet ipsos custodes?*
>>
>>
>> On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:
>>
>> >
>> >
>> > I want to return the last Order.Dtl that a particular Part shows up on.
>> >
>> > My BAQ:
>> >
>> > for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
>> > 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
>> > (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
>> > no-lock .
>> >
>> > The query runs and returns data, but does not return what I would
>> consider
>> > the LAST OrderDtl (highest OrderNumber, Highest Line)
>> >
>> > What exactly does the LAST OrderDtl return.......?
>> >
>> >
>> >
>>
>> [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]
10
In case anyone should bump up against this in the future in 8.03.405a, The 'Part' index for the OderDtl table is built using OrderNum in descending order - so in this case use first in the BAQ to return the last OderNum

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bernie Walker
Sent: Thursday, April 07, 2011 2:30 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] BAQ question

I did try that and got the exact same results....

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Thursday, April 07, 2011 2:27 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ question

You probably want to put a By OrderNum clause on that where statement and it
should work

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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:

>
>
> I want to return the last Order.Dtl that a particular Part shows up on.
>
> My BAQ:
>
> for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
> 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
> (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
> no-lock .
>
> The query runs and returns data, but does not return what I would consider
> the LAST OrderDtl (highest OrderNumber, Highest Line)
>
> What exactly does the LAST OrderDtl return.......?
>
>
>


[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





------------------------------------

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
11
Hi

Have you tried applying a sort on the fields before viewing?

Ive had issues with FIRST and LAST too.

The only way I got it working was to export to crystal.

I find this quite useful ...

http://communities.progress.com/pcom/docs/DOC-48188
Â
Â



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Thu, 7 April, 2011 19:33:25
Subject: Re: [Vantage] BAQ question

Never mind wrong email LoL

So you set your By Clause to OrderNum it should then sort by OrderNum and
Last, should be the last one that is returned


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

*Quis custodiet ipsos custodes?*



On Thu, Apr 7, 2011 at 2:31 PM, Jose Gomez <jose@...> wrote:

> What exactly did you try? Do you have BPM's running? Do you have external
> processes? Do you have two people accessing the same PO at the same time?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
><http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Thu, Apr 7, 2011 at 2:30 PM, Bernie Walker <bwalker@...>wrote:
>
>>
>>
>> I did try that and got the exact same results....
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of Jose Gomez
>> Sent: Thursday, April 07, 2011 2:27 PM
>> To: vantage@yahoogroups.com
>> Subject: Re: [Vantage] BAQ question
>>
>> You probably want to put a By OrderNum clause on that where statement and
>> it
>> should work
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez> <
>> http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
>> >
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>
>> *Quis custodiet ipsos custodes?*
>>
>>
>> On Thu, Apr 7, 2011 at 2:22 PM, <bwalker@...> wrote:
>>
>> >
>> >
>> > I want to return the last Order.Dtl that a particular Part shows up on.
>> >
>> > My BAQ:
>> >
>> > for each Part where ( Part.PartNum BEGINS 'XYZ' OR Part.PartNum BEGINS
>> > 'ABC' OR Part.PartNum BEGINS 'LMO') no-lock , last OrderDtl where
>> > (Part.Company = OrderDtl.Company and Part.PartNum = OrderDtl.PartNum)
>> > no-lock .
>> >
>> > The query runs and returns data, but does not return what I would
>> consider
>> > the LAST OrderDtl (highest OrderNumber, Highest Line)
>> >
>> > What exactly does the LAST OrderDtl return.......?
>> >
>> >
>> >
>>
>> [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/.%c2%a0

(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]
12
This is a rough guess translating from SQL to Progress. Not in front of a computer so can't check syntax or field names but it my help

For each POdetail
Fetch last POdetail1 where podetail.company = podetail1.company and podetail.partnum = podetail1.partnum and podetail.ponum > podetail1.ponum



[Non-text portions of this message have been removed]
13
The field names are correct, my only problem at this point is to get
"Fetch Last" command thru BAQ Designer.



I copied the Query phrase from BAQ Designer:



for each PODetail no-lock where PODetail.OpenLine = yes , each
PODetail1 no-lock where (PODetail.Company = PODetail1.Company and
PODetail.PartNum = PODetail1.PartNum ) , each POHeader no-lock where
POHeader.OpenOrder = Yes And POHeader.ApprovalStatus = 'P' , each
PORel no-lock where PORel.TranType <> 'PUR-UKN' And PORel.TranType <>
'PUR-SUB' , each POHeader1 no-lock where POHeader1.PONum <>
POHeader.PONum , each PartRev no-lock , each PartRev1 no-lock ,
each PurAgent no-lock , each PartPlant no-lock where
(PartRev.Company = PartPlant.Company and PartRev.PartNum =
PartPlant.PartNum ) and (PODetail1.Company = PartRev1.Company and
PODetail1.PartNum = PartRev1.PartNum and PODetail1.RevisionNum =
PartRev1.RevisionNum ) and (PODetail.Company = PartRev.Company and
PODetail.PartNum = PartRev.PartNum and PODetail.RevisionNum =
PartRev.RevisionNum ) and (POHeader.Company = PODetail.Company and
POHeader.PONum = PODetail.PONUM ) and (PODetail1.Company =
POHeader1.Company and PODetail1.PONUM = POHeader1.PONum ) and
(PODetail.Company = PORel.Company and PODetail.PONum = PORel.PONUM and
PODetail.POLine = PORel.POLine ) and (POHeader.Company =
PurAgent.Company and POHeader.BuyerID = PurAgent.BuyerID ) by
POHeader.PONum by PODetail.POLine by POHeader1.OrderDate Desc.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Wayne Sheldon
Sent: Monday, August 29, 2011 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ question





This is a rough guess translating from SQL to Progress. Not in front of
a computer so can't check syntax or field names but it my help For each
POdetail Fetch last POdetail1 where podetail.company = podetail1.company
and podetail.partnum = podetail1.partnum and podetail.ponum >
podetail1.ponum

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




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
14
When you select a table in the designer you can choose if you want each,first,last.
So you have to choose last in order to get the last but this will cause to get the last PO that's basically the one receiving now so you will have to filter out that PO

HTH

Ephraim Feldman

-----Original Message-----
From: "Mike Tonoyan" <mtonoyan@...>
Sender: vantage@yahoogroups.com
Date: Mon, 29 Aug 2011 14:57:56
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: BAQ question

The field names are correct, my only problem at this point is to get
"Fetch Last" command thru BAQ Designer.



I copied the Query phrase from BAQ Designer:



for each PODetail no-lock where PODetail.OpenLine = yes , each
PODetail1 no-lock where (PODetail.Company = PODetail1.Company and
PODetail.PartNum = PODetail1.PartNum ) , each POHeader no-lock where
POHeader.OpenOrder = Yes And POHeader.ApprovalStatus = 'P' , each
PORel no-lock where PORel.TranType <> 'PUR-UKN' And PORel.TranType <>
'PUR-SUB' , each POHeader1 no-lock where POHeader1.PONum <>
POHeader.PONum , each PartRev no-lock , each PartRev1 no-lock ,
each PurAgent no-lock , each PartPlant no-lock where
(PartRev.Company = PartPlant.Company and PartRev.PartNum =
PartPlant.PartNum ) and (PODetail1.Company = PartRev1.Company and
PODetail1.PartNum = PartRev1.PartNum and PODetail1.RevisionNum =
PartRev1.RevisionNum ) and (PODetail.Company = PartRev.Company and
PODetail.PartNum = PartRev.PartNum and PODetail.RevisionNum =
PartRev.RevisionNum ) and (POHeader.Company = PODetail.Company and
POHeader.PONum = PODetail.PONUM ) and (PODetail1.Company =
POHeader1.Company and PODetail1.PONUM = POHeader1.PONum ) and
(PODetail.Company = PORel.Company and PODetail.PONum = PORel.PONUM and
PODetail.POLine = PORel.POLine ) and (POHeader.Company =
PurAgent.Company and POHeader.BuyerID = PurAgent.BuyerID ) by
POHeader.PONum by PODetail.POLine by POHeader1.OrderDate Desc.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Wayne Sheldon
Sent: Monday, August 29, 2011 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ question





This is a rough guess translating from SQL to Progress. Not in front of
a computer so can't check syntax or field names but it my help For each
POdetail Fetch last POdetail1 where podetail.company = podetail1.company
and podetail.partnum = podetail1.partnum and podetail.ponum >
podetail1.ponum

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




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

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




[Non-text portions of this message have been removed]
15
I am trying to create a BAQ that shows me any open jobs where a operation is complete but any material lines(tools) related to that op are not issued complete. Here is my Phrase Builder information:
Â
 for each JobHead no-lock where JobHead.JobClosed = False , each JobOper no-lock where (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum and JobHead.PartNum = JobOper.PartNum ) and JobOper.OpComplete = True , each JobMtl no-lock where (JobOper.Company = JobMtl.Company and JobOper.JobNum = JobMtl.JobNum and JobOper.OprSeq = JobMtl.RelatedOperation ) and JobMtl.IssuedComplete = False .

I get no records, yet when I use all the same tables, fields, criteria, joins, I get 10 pages in Crystal. What am I missing?

If I do not have the criteria on for only open jobs and let it run wide open or for closed jobs I get records back. Am I missing a join or something on the tables? Do I need to add another table in between somewhere?

Thanks,


Melissa Hietala
UMC, Inc.
melissah@...

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