Baq

system · November 18, 2009, 3:28pm

Try some parentheses:

(Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost )* PartBin.OnhandQty

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Smith
Sent: Wednesday, November 18, 2009 4:27 PM
To: Vantage
Subject: [Vantage] BAQ

I am trying to create a BAQ that adds all the cost of a part and then
multiplies that total by the on hand qty. The formula below is not
working,
what am I doing wrong, thanks in advance.

Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost * PartBin.OnhandQty
Paul Smith
Inventory Management
233 Ballston Ave
Saratoga Springs NY, 12866
518-245-4358

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

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

system · November 18, 2009, 3:29pm

Is it not working or giving you the wrong number?

If the wrong number try adding parenthesis

(Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost) * PartBin.OnhandQty

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Smith
Sent: Wednesday, November 18, 2009 2:27 PM
To: Vantage
Subject: [Vantage] BAQ

I am trying to create a BAQ that adds all the cost of a part and then
multiplies that total by the on hand qty. The formula below is not
working,
what am I doing wrong, thanks in advance.

Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost * PartBin.OnhandQty
Paul Smith
Inventory Management
233 Ballston Ave
Saratoga Springs NY, 12866
518-245-4358

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

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

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

system · November 18, 2009, 3:58pm

Worked....thanks....

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Dale Schuerman
Sent: Wednesday, November 18, 2009 3:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ

Is it not working or giving you the wrong number?

If the wrong number try adding parenthesis

(Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost) * PartBin.OnhandQty

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul Smith
Sent: Wednesday, November 18, 2009 2:27 PM
To: Vantage
Subject: [Vantage] BAQ

I am trying to create a BAQ that adds all the cost of a part and then
multiplies that total by the on hand qty. The formula below is not
working,
what am I doing wrong, thanks in advance.

Part.AvgMaterialCost + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost * PartBin.OnhandQty
Paul Smith
Inventory Management
233 Ballston Ave
Saratoga Springs NY, 12866
518-245-4358

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

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

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

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

system · November 19, 2009, 8:11am

Â Use parantheses as shown:
Â
( Part.AvgMaterialCos t + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost ) Â * PartBin.OnhandQty

--- On Wed, 11/18/09, Paul Smith <psmith@...> wrote:

From: Paul Smith <psmith@...>
Subject: [Vantage] BAQ
To: "Vantage" <vantage@yahoogroups.com>
Date: Wednesday, November 18, 2009, 3:26 PM

Â

I am trying to create a BAQ that adds all the cost of a part and then
multiplies that total by the on hand qty. The formula below is not working,
what am I doing wrong, thanks in advance.

Part.AvgMaterialCos t + Part.AvgLaborCost + Part.AvgBurdenCost +
Part.AvgSubContCost + Part.AvgMtlBurCost * PartBin.OnhandQty
Paul Smith
Inventory Management
233 Ballston Ave
Saratoga Springs NY, 12866
518-245-4358

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

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

system · January 14, 2013, 6:52pm

Hi Group,
Â
Looking for some advice on BAQ.
Can you and if so how do you get a summary by part number of all open quantities on order.
Can a BAQ summarize the data in PORel by part number similar to a group by in Access.
Â
MarkB

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

system · January 15, 2013, 8:18am

Sure just add the PORel table and check the Summary CheckBox thne use one
of the Aggregate functions in a BAQ Calc Field.

*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/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*

On Mon, Jan 14, 2013 at 6:52 PM, Mark Betts <mbetts1953@...> wrote:

> **
>
>
> Hi Group,
>
> Looking for some advice on BAQ.
> Can you and if so how do you get a summary by part number of all open
> quantities on order.
> Can a BAQ summarize the data in PORel by part number similar to a group by
> in Access.
>
> MarkB
>
> [Non-text portions of this message have been removed]
>
>
>

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

system · January 15, 2013, 9:14am

MarkB

My first try:

Since the OrderRel table doesn't have the PART field you have to link
OrderREL to OrderDtl to get it.

Since the OrderDtl Table could have multiple lines of the same part or
other orders with line items of the same part you can only summary for
each OrderDtl record for that part.

I linked: Part to OrderDtl to OrderREL then Aggregate TOTAL .

This is as far as my logic takes me, If you can get it another way I
would like to here.

My Second Try:

If you don't have the "Keep Line Quantity Constant" field checked in
Company Config - Orders.

The line quantity will reflect to total releases which gives you release
but I don't know how to subtract off shipments.

Note the OrderDtl.LockQty field reflects the setting from the company
Config - Orders - Keep Line Quantity Constant.

Not sure if this was any help but misery loves company.

Patrick Winter

Information Technology Manager

Specialty Screw Corporation

2801 Huffman Boulevard, Rockford IL 61103

815.969.4147

Vantage 6.10.514, Progress 9.1D

Testing: Epicor 9.05.700c, Progress Database, Windows Server 2008 R2
Standard

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Betts
Sent: Monday, January 14, 2013 17:52
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ

Hi Group,

Looking for some advice on BAQ.
Can you and if so how do you get a summary by part number of all open
quantities on order.
Can a BAQ summarize the data in PORel by part number similar to a group
by in Access.

MarkB

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

system · January 15, 2013, 11:46am

I am trying to create an updatable BAQ to update the PartWhse.Number01
field. However when I look in the Update Processing tab and in the
Column Mapping section, I do not see an expression for the ttPartWhse
for the Plant field. I could not find the Plant field under the
PartWhse table so does that mean I need to bring in the PlantWhse table
into the phrase builder query too?

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

system · April 17, 2014, 11:51am

Can too many BAQs drag down the processing speed of our EPICOR Live environment? If so, at what point might this begin to become noticeable? Thanks

system · April 17, 2014, 11:56am

you can have as many BAQ's as you want. They only have an effect when they are running ( at the time they are running) just having them on DB is "FREE"

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Thu, Apr 17, 2014 at 11:51 AM, <tom.sederquist@...> wrote:

Â

<div>
  
  
  <p>Can too many BAQs drag down the processing speed of our EPICOR Live environment?Â  If so, at what point might this begin to become noticeable?Â  Thanks</p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · April 17, 2014, 12:09pm

Certainly, as Jose said, only actually running the BAQ is really going to have an impact. We have seen, however, a BAQ (actually a builtin one, zCustomerShipments for the Sales Order Shipments Status Dashboard that ships with Epicor) that runs and runs forever, even after the client user just gives up and crashes MfgSys. This results in "bad things" happening a day or so later, when database locks start happening left and right, and snowball out of control.

system · April 17, 2014, 12:33pm

I'm having a similar performance issue when Retrieving Mfg Receipts in Job Tracker 9.05.702a pr.

Anyone happen to know what z BAQ is used for this?

Rob Brown
Versa Products
Sent from Yahoo Mail on Android

From: ygroups.adamleer@... <ygroups.adamleer@...>;
To: <vantage@yahoogroups.com>;
Subject: [Vantage] Re: BAQ
Sent: Thu, Apr 17, 2014 4:09:22 PM

Â

<div id="ygrps-yiv-1984994300ygrp-text">
  
  
  <p>Certainly, as Jose said, only actually running the BAQ is really going to have an impact. Â We have seen, however, a BAQ (actually a builtin one, zCustomerShipments for the Sales Order Shipments Status Dashboard that ships with Epicor) that runs and runs forever, even after the client user just gives up and crashes MfgSys. Â This results in &quot;bad things&quot; happening a day or so later, when database locks start happening left and right, and snowball out of control.</p><div><br clear="none"></div><div><br clear="none"></div>

</div>
 


<div style="color:#fff;height:0;"></div></div>

system · March 30, 2015, 1:12pm

How do you trim characters from the right side of a part number in a BAQ Epicor 9

system · March 30, 2015, 1:15pm

I'm assuming you mean in Progress, maybe:

RIGHT-TRIM function
Removes trailing white space, or other specified characters, from a CHARACTER or LONGCHAR expression.
Syntax

RIGHT-TRIM ( expression [ , trim-chars ] )

expression
An expression (a constant, field name, variable name, or expression) whose value is a CHARACTER or LONGCHAR. If expression is a case-sensitive variable, the AVM performs a case-sensitive trim. If expression is a LONGCHAR, the result is in the same code page.
trim-chars
A character expression that specifies the characters to trim from expression. If you do not specify trim-chars, the RIGHT-TRIM function removes spaces, tabs, line feeds, and carriage returns.

system · March 30, 2015, 1:44pm

The Right-Trim function is throwing an Error when (partnum,2)

system · March 30, 2015, 2:28pm

It may not be the right thing to use then, the second parameter in the function is a string ('what to remove'), not an integer.

Maybe you can use the Length function, then Substring to get back the original string , only 2 chars 'shorter'. :

Give me a new string, 2 chars shorter than the old one, starting at the beginning-

NewString = SUBSTRING(OldString,1,LENGTH(OldString) - 2)

system · November 13, 2015, 6:41pm

I am trying to create e custom report using vantage 8.03.

I have created the BAQ, with analyze and test I see that it displays what I want, but when I move to BAQ Report Designer, I am creating a new report definition, I enter all the data(use the BAQ that I have just created) and then I go to Actions->Test Report Form->Print Preview and all I get is a blank sheet, no information at all.

Am I missing something? I have used the book(epicor tools user guide) as well, and I could not find anything related to my problem.

Thanks!

system · November 13, 2015, 6:54pm

I'm using E10, which may be somewhat different, because we are using SSRS instead of Crystal Reports.

When I define a BAQ report, it sets up the SSRS (.rdl) report file with the query and fields lists, and a header. I have to design the report from there. I'm guessing it's something like that in Crystal Reports.

For what it's worth.

Joe

On Fri, Nov 13, 2015 at 5:41 PM, ionut.rus@... [vantage] <vantage@yahoogroups.com> wrote:

Â

<div>
  
  
  <p></p><p><span>I am trying to create e custom report using vantage 8.03.</span></p><p><span>I have created the BAQ, with analyze and test I see that it displays what I want, but when I move to BAQ Report Designer, I am creating a new report definition, I enter all the data(use the BAQ that I have just created) and then I go to Actions-&gt;Test Report Form-&gt;Print Preview and all I get is a blank sheet, no information at all.</span></p><p><span>Am I missing something?Â  I have used the book(epicor tools user guide) as well, and I could not find anything related to my problem.</span></p><p><span><br></span></p><p><span>Thanks!</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · November 14, 2015, 1:31pm

>> V8 BAQ Report
>> Actions->Test Report Form->Print Preview
>> all I get is a blank sheet

Yes, that just creates the blank report and generates the XML.
The report template is blank & only includes tables "Company" and "BAQReportParameter"

In Crystal designer you first need to edit the reports datasource
- select the "BAQReportResult" table (and add links)
Once this if done, you then can add the fields you want to the report body

Topic		Replies	Views
Business Activity Query Yahoo Archive	20	2459	May 12, 2011
BAQ Calculated Field Syntax Yahoo Archive	9	734	January 21, 2010
HELP! BAQ Calculated field sytax error Yahoo Archive	11	1008	July 16, 2009
BAQ Calculated Field Format to $.00 Question Yahoo Archive	6	4562	August 8, 2008
BAQ calculated field limitation? Yahoo Archive	14	905	April 19, 2012

Baq

Related Topics