Business Activity Query

system · May 12, 2011, 4:25pm

Thank you,

It's much easier in excel...I appreciate the example.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Brown
Sent: Thursday, May 12, 2011 3:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: Business Activity Query

Here is an example of an If statement formula that would work in a Baq.
IF Sum ({jobmtl.requiredqty}, {joboper.shortchar01})<> 0 THEN (Sum
({jobmtl.requiredqty}, {joboper.shortchar01})- Sum ({@Actual Used},
{joboper.shortchar01}))/Sum ({jobmtl.requiredqty},
{joboper.shortchar01})*100
ELSE 0
Mike
mbrown@... <mailto:mbrown%40dsmfg.com>

________________________________
From: Karen Schoenung <kschoenung@...
<mailto:kschoenung%40fisher-barton.com> >
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> "
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Thu, May 12, 2011 3:15:23 PM
Subject: [Vantage] RE: Business Activity Query

In a calculated field - yes

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ellen Lensing
Sent: Thursday, May 12, 2011 3:12 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Business Activity Query

Can a if statement formula be put in a BAQ??

Middle West Manufacturing Corp.

Ellen Lensing

Accounting Manager

Phone 262-251-8760

Fax 262-251-8769

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

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

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

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

system · August 23, 2004, 12:44pm

I recently acquired the conversion tool and I am trying to export the part tables to excel using the BAQ. I'm trying to export the part table, but I'm getting an error flash on the screen when I analyze the statement. It is telling me, "there are more than 1024 items in a single statement. Use the -tok parameter."

What is this parameter and where do I set it?

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

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

system · August 23, 2004, 1:39pm

To anyone interested, the -tok parameter is located in the eipcor\mfgsys60\db folder in a file called mfgsys.pf. I added the parameter "-tok 2048" and it took care of the problem.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

-----Original Message-----
From: Tyira Eric
Sent: Monday, August 23, 2004 12:44 PM
To: Vantage User Group (E-mail)
Subject: [Vantage] Business Activity Query

I recently acquired the conversion tool and I am trying to export the part tables to excel using the BAQ. I'm trying to export the part table, but I'm getting an error flash on the screen when I analyze the statement. It is telling me, "there are more than 1024 items in a single statement. Use the -tok parameter."

What is this parameter and where do I set it?

Thanks.

Eric L. Tyira
Tamglass Tempering Systems

P: (856) 786-1200
F: (856) 786-7606

eric.tyira@...

[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/links

Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=1291ivqvs/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1093365892/A=2319501/R=0/SIG=11tq0u909/*http://www.netflix.com/Default?mqso=60185353&partid=5285298> click here

<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2319501/rand=379974126>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of <http://docs.yahoo.com/info/terms/> Service.

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

system · February 4, 2005, 9:23am

Ar the scripts that everybody writes for Business Activity Manager/Query just sql statements or are they something different?

Thanks,
Jasper

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

system · February 4, 2005, 12:02pm

they are progress routines. Jasper, I will help you along a bit. contact
me offline.
Aaron

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Friday, February 04, 2005 9:23 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Business Activity Query

Ar the scripts that everybody writes for Business Activity Manager/Query
just sql statements or are they something different?

Thanks,
Jasper

[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/links
Yahoo! Groups Links

system · July 22, 2005, 5:17pm

Is it possible to take a sql statement generated by report builder and copy it into a Business Activity Query? I would like to be able to see some reports I created in report builder on my dashboard.

Thanks,

Jasper

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

system · August 26, 2005, 1:49pm

I am trying to get a costed Stock Status Report through the Business
Activity Query. I have to combine the PART and the PART.BIN files
to get this report. The PART file has the standard costs and the
PARTBIN file has the quantity on hand. When I go to run the report
it is dropping all part numbers that have a zero quantity on hand.
What am I doing wrong? I am using the Query Wizard. How do I edit
the text below to get all items in the part master regardless of the
QOH? Below is the text in my query. Something is excluding the
parts with a zero QOH. HELP!
Query Text:

for each Part Where Part.Company = cur-comp no-lock,
each PartBin Where PartBin.Company = Part Company
and PartBin.PartNum = Part.PartNum no lock
BY Part.PpartNum:

Chris Layne
Amersham Corporation
clayne@...
Tel (727) 456-4756
Fax (818) 475-5057

system · August 26, 2005, 1:55pm

In report speak you need to an outer join on the part table but I do not
know how you do this in bam.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.

-----Original Message-----
From: tracer6782000 [mailto:tracer6782000@...]
Sent: Friday, August 26, 2005 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query

I am trying to get a costed Stock Status Report through the Business
Activity Query. I have to combine the PART and the PART.BIN files
to get this report. The PART file has the standard costs and the
PARTBIN file has the quantity on hand. When I go to run the report
it is dropping all part numbers that have a zero quantity on hand.
What am I doing wrong? I am using the Query Wizard. How do I edit
the text below to get all items in the part master regardless of the
QOH? Below is the text in my query. Something is excluding the
parts with a zero QOH. HELP!
Query Text:

for each Part Where Part.Company = cur-comp no-lock,
each PartBin Where PartBin.Company = Part Company
and PartBin.PartNum = Part.PartNum no lock
BY Part.PpartNum:

Chris Layne
Amersham Corporation
clayne@...
Tel (727) 456-4756
Fax (818) 475-5057

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/links
Yahoo! Groups Links

system · August 26, 2005, 2:02pm

I work in the BAQ frequently and sometime it is like pulling teeth. You
think you have written a good clean query then......well you get the point.
You can try adding, Part.AvgMaterialCost >= .0000 hope this helps.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
tracer6782000
Sent: Friday, August 26, 2005 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query

I am trying to get a costed Stock Status Report through the Business
Activity Query. I have to combine the PART and the PART.BIN files
to get this report. The PART file has the standard costs and the
PARTBIN file has the quantity on hand. When I go to run the report
it is dropping all part numbers that have a zero quantity on hand.
What am I doing wrong? I am using the Query Wizard. How do I edit
the text below to get all items in the part master regardless of the
QOH? Below is the text in my query. Something is excluding the
parts with a zero QOH. HELP!
Query Text:

for each Part Where Part.Company = cur-comp no-lock,
each PartBin Where PartBin.Company = Part Company
and PartBin.PartNum = Part.PartNum no lock
BY Part.PpartNum:

Chris Layne
Amersham Corporation
clayne@...
Tel (727) 456-4756
Fax (818) 475-5057

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/links

SPONSORED LINKS Technical support Vantage Database
Database management software Membership database software Church
database software

----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.

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

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

system · August 26, 2005, 3:36pm

Chris,

The problem is that if you have a zero onhand quantity in the Part file
you will not have a bin record for that part so you would need to do a
left outer join (all the records from the first file even if they have
no match in the second file). I don't know how you would do this in
BAQ.

Sandy Morse
BVR Technologies Company
815-874-2471 x112

system · August 26, 2005, 3:58pm

Sandy, Chris,
According to Progress help...

************************
[ LEFT ] OUTER-JOIN

Specifies a left outer join between record and the table (or join) specified
by the previous Record phrase(s) of an OPEN QUERY statement. A left outer
join combines and returns data from the specified tables in two ways. First,
the records selected for the table (or join) on the left side combine with
each record selected using the OF or WHERE options from the table on the
right (record). Second, the records selected for the table (or join) on the
left side combine with unknown values (?) for the fields from the table on
the right (record) for which no records are selected using the OF or WHERE
options. The join is ordered according to the given sort criteria starting
with the left-most table in the query.

NOTE: If you specify the OUTER-JOIN option, you must also specify the
OUTER-JOIN option in all succeeding Record phrases of the query to obtain a
left outer join. That is, for multiple Record phrases, all joins in the
query following your first left outer join must also be left outer joins.
Otherwise, the result is an inner join for all records up to the last inner
join in the query. For more information, see the Progress Programming
Handbook.

The OUTER-JOIN option is supported only in the OPEN QUERY statement and in
Record phrases specified after the first Record phrase in the OPEN QUERY
statement. The LEFT keyword is optional with OUTER-JOIN. If you specify
OUTER-JOIN, you must also specify the OF option, WHERE option, or any
combination of the OF and WHERE options. These options are required to
select record (the right-most table) for the specified left outer join.

OPEN QUERY q1 PRESELECT EACH customer,
FIRST order OUTER-JOIN OF customer WHERE order.order-num < 50
FIRST order-line OUTER-JOIN OF order WHERE order-line.item-num < 15.

*******************************
So...for your case...

for each Part Where Part.Company = cur-comp no-lock,
each PartBin OUTER-JOIN Where PartBin.Company = Part.Company
and PartBin.PartNum = Part.PartNum no-lock
BY Part.PartNum:

Should do the trick.
If not, I gave it a shot anyway.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Sandy Morse
Sent: Friday, August 26, 2005 3:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query

Chris,

The problem is that if you have a zero onhand quantity in the Part file
you will not have a bin record for that part so you would need to do a
left outer join (all the records from the first file even if they have
no match in the second file). I don't know how you would do this in
BAQ.

Sandy Morse
BVR Technologies Company
815-874-2471 x112

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/links
Yahoo! Groups Links

system · August 27, 2005, 1:58pm

Another table to look at is the PartWhse. It has an OnHandQty that
will sum the PartBin values and go to zero when none are on hand.
It was already stated, the PartBin table is deleted when OnHand goes
zero.

Mark Olson
TEAM Industries
763-691-2381

--- In vantage@yahoogroups.com, "tracer6782000" <tracer6782000@y...>
wrote:

> I am trying to get a costed Stock Status Report through the

Business

> Activity Query. I have to combine the PART and the PART.BIN files
> to get this report. The PART file has the standard costs and the
> PARTBIN file has the quantity on hand. When I go to run the

report

> it is dropping all part numbers that have a zero quantity on

hand.

> What am I doing wrong? I am using the Query Wizard. How do I

edit

> the text below to get all items in the part master regardless of

the

> QOH? Below is the text in my query. Something is excluding the
> parts with a zero QOH. HELP!
> Query Text:
>
> for each Part Where Part.Company = cur-comp no-lock,
> each PartBin Where PartBin.Company = Part Company
> and PartBin.PartNum = Part.PartNum no lock
> BY Part.PpartNum:
>
>
> Chris Layne
> Amersham Corporation
> clayne@a...
> Tel (727) 456-4756
> Fax (818) 475-5057

system · August 29, 2005, 9:08am

Thank you all very much for your knowledgeable assitance. This was my
first time using the user group for help. I only wish that some of
this expertise lied within the Epicor Support Group.
Chris Layne
Amersham Corporation
727-456-4756

--- In vantage@yahoogroups.com, "Sandy Morse" <smorse@b...> wrote:
> Chris,
>
> The problem is that if you have a zero onhand quantity in the Part
file
> you will not have a bin record for that part so you would need to do
a
> left outer join (all the records from the first file even if they
have
> no match in the second file). I don't know how you would do this in
> BAQ.
>
> Sandy Morse
> BVR Technologies Company
> 815-874-2471 x112

system · September 9, 2005, 3:09pm

I am trying to create a simple Business Activity Query shown below. The problem is, when I include the criteria (RcvDtl.JobSeqType = 'S'), it returns zero entries. I know for a fact that it should return some entries.

Why won't it accept this query?

for each RcvHead Where RcvHead.Company = cur-comp
and RcvHead.Company = 'Loc' and
RcvHead.ReceiptDate = 9/7/2005 and
RcvDtl.JobSeqType = 'S'
no-lock,
each RcvDtl Where RcvDtl.Company = RcvHead.Company
and RcvDtl.VendorNum = RcvHead.VendorNum
and RcvDtl.PackSlip = RcvHead.PackSlip no-lock
BY RcvHead.ShipViaCode:

Thanks,
Jasper

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

system · September 9, 2005, 3:29pm

Try moving the RcvDtl.JobSeqtype = logic under the "each RcvDtl Where"
clause.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, September 09, 2005 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Business Activity Query

I am trying to create a simple Business Activity Query shown below. The
problem is, when I include the criteria (RcvDtl.JobSeqType = 'S'), it
returns zero entries. I know for a fact that it should return some entries.

Why won't it accept this query?

for each RcvHead Where RcvHead.Company = cur-comp and RcvHead.Company =
'Loc' and RcvHead.ReceiptDate = 9/7/2005 and RcvDtl.JobSeqType = 'S'
no-lock,
each RcvDtl Where RcvDtl.Company = RcvHead.Company
and RcvDtl.VendorNum = RcvHead.VendorNum
and RcvDtl.PackSlip = RcvHead.PackSlip no-lock BY RcvHead.ShipViaCode:

Thanks,
Jasper

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

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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/links
Yahoo! Groups Links

system · September 9, 2005, 3:44pm

THANKS!!

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, September 09, 2005 3:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

Try moving the RcvDtl.JobSeqtype = logic under the "each RcvDtl Where"
clause.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, September 09, 2005 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Business Activity Query

I am trying to create a simple Business Activity Query shown below. The
problem is, when I include the criteria (RcvDtl.JobSeqType = 'S'), it
returns zero entries. I know for a fact that it should return some entries.

Why won't it accept this query?

for each RcvHead Where RcvHead.Company = cur-comp and RcvHead.Company =
'Loc' and RcvHead.ReceiptDate = 9/7/2005 and RcvDtl.JobSeqType = 'S'
no-lock,
each RcvDtl Where RcvDtl.Company = RcvHead.Company
and RcvDtl.VendorNum = RcvHead.VendorNum
and RcvDtl.PackSlip = RcvHead.PackSlip no-lock BY RcvHead.ShipViaCode:

Thanks,
Jasper

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

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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/links
Yahoo! 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/links
Yahoo! Groups Links

system · September 9, 2005, 4:23pm

I have another question on this,

I need to have this query filter using an OR statement from but from 2 different tables.

I want it to filter if RcvHead.ShipViaCode = 'DROP' OR if RcvDtl.JobSeqType = 'S'

How would I accomplish this if each the RcvHead.ShipViaCode criteria needs to be under the "each RcvHead Where" section and the RcvDtl.JobSeqType criteria needs to be under the "each RcvDtl Where" section?

Thanks,
Jasper

-----Original Message-----
From: Jasper Recto
Sent: Friday, September 09, 2005 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

THANKS!!

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, September 09, 2005 3:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

Try moving the RcvDtl.JobSeqtype = logic under the "each RcvDtl Where"
clause.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, September 09, 2005 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Business Activity Query

I am trying to create a simple Business Activity Query shown below. The
problem is, when I include the criteria (RcvDtl.JobSeqType = 'S'), it
returns zero entries. I know for a fact that it should return some entries.

Why won't it accept this query?

for each RcvHead Where RcvHead.Company = cur-comp and RcvHead.Company =
'Loc' and RcvHead.ReceiptDate = 9/7/2005 and RcvDtl.JobSeqType = 'S'
no-lock,
each RcvDtl Where RcvDtl.Company = RcvHead.Company
and RcvDtl.VendorNum = RcvHead.VendorNum
and RcvDtl.PackSlip = RcvHead.PackSlip no-lock BY RcvHead.ShipViaCode:

Thanks,
Jasper

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

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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/links
Yahoo! 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/links
Yahoo! 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/links
Yahoo! Groups Links

system · September 9, 2005, 4:37pm

I believe you can move them both under "each RcvDtl Where" section.
They don't have to be under the listed sections but you just have to read
the record before you select on it. Since RcvHead was selected above(before)
it should work if added in RcvDtl section below.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, September 09, 2005 3:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

I have another question on this,

I need to have this query filter using an OR statement from but from 2
different tables.

I want it to filter if RcvHead.ShipViaCode = 'DROP' OR if RcvDtl.JobSeqType
= 'S'

How would I accomplish this if each the RcvHead.ShipViaCode criteria needs
to be under the "each RcvHead Where" section and the RcvDtl.JobSeqType
criteria needs to be under the "each RcvDtl Where" section?

Thanks,
Jasper

-----Original Message-----
From: Jasper Recto
Sent: Friday, September 09, 2005 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

THANKS!!

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Friday, September 09, 2005 3:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Business Activity Query

Try moving the RcvDtl.JobSeqtype = logic under the "each RcvDtl Where"
clause.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Friday, September 09, 2005 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Business Activity Query

I am trying to create a simple Business Activity Query shown below. The
problem is, when I include the criteria (RcvDtl.JobSeqType = 'S'), it
returns zero entries. I know for a fact that it should return some entries.

Why won't it accept this query?

for each RcvHead Where RcvHead.Company = cur-comp and RcvHead.Company =
'Loc' and RcvHead.ReceiptDate = 9/7/2005 and RcvDtl.JobSeqType = 'S'
no-lock,
each RcvDtl Where RcvDtl.Company = RcvHead.Company
and RcvDtl.VendorNum = RcvHead.VendorNum
and RcvDtl.PackSlip = RcvHead.PackSlip no-lock BY RcvHead.ShipViaCode:

Thanks,
Jasper

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

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->

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/links
Yahoo! 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/links
Yahoo! 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/links
Yahoo! 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/links
Yahoo! Groups Links

system · May 12, 2011, 4:12pm

Can a if statement formula be put in a BAQ??

Middle West Manufacturing Corp.

Ellen Lensing

Accounting Manager

Phone 262-251-8760

Fax 262-251-8769

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

system · May 12, 2011, 4:15pm

In a calculated field - yes

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ellen Lensing
Sent: Thursday, May 12, 2011 3:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query

Can a if statement formula be put in a BAQ??

Middle West Manufacturing Corp.

Ellen Lensing

Accounting Manager

Phone 262-251-8760

Fax 262-251-8769

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

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

Topic		Replies	Views
Baq Yahoo Archive	38	1783	November 14, 2015
Calculation in BAQ and if statements Yahoo Archive	1	373	December 27, 2005
HELP! BAQ Calculated field sytax error Yahoo Archive	11	984	July 16, 2009
BAQ Calculated field Yahoo Archive	6	930	April 30, 2015
BAQ calculated field syntax Yahoo Archive	10	2418	December 10, 2008

Business Activity Query

Related Topics