9.05.702 BAQ issues w/summary tables

system · October 2, 2014, 9:11am

<!-- #ygrps-yiv-1093338573 _filtered #ygrps-yiv-1093338573 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1093338573 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1093338573 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1093338573 {font-family:"Century Gothic"; panose-1:2 11 5 2 2 2 2 2 2 4;} _filtered #ygrps-yiv-1093338573 {font-family:"Lucida Fax"; panose-1:2 6 6 2 5 5 5 2 2 4;} _filtered #ygrps-yiv-1093338573 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1093338573 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1093338573 #ygrps-yiv-1093338573 p.ygrps-yiv-1093338573MsoNormal, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573MsoNormal, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1093338573 a:link, #ygrps-yiv-1093338573 span.ygrps-yiv-1093338573MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1093338573 a:visited, #ygrps-yiv-1093338573 span.ygrps-yiv-1093338573MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1093338573 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 code
{
font-family:“Courier New”;}
#ygrps-yiv-1093338573 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1093338573 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573cat
{}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573ct
{}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573attach, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573attach, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573bold, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573bold, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573green, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573green, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573replbq, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573replbq, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573ad, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573ad, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573underline, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573underline, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573yshortcuts
{}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573ad1, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573ad1, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573ad2, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573ad2, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1093338573 p.ygrps-yiv-1093338573underline1, #ygrps-yiv-1093338573 li.ygrps-yiv-1093338573underline1, #ygrps-yiv-1093338573 div.ygrps-yiv-1093338573underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1093338573 span.ygrps-yiv-1093338573EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1093338573 .ygrps-yiv-1093338573MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1093338573 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1093338573 div.ygrps-yiv-1093338573WordSection1
{}
#ygrps-yiv-1093338573
_filtered #ygrps-yiv-1093338573 {
}
_filtered #ygrps-yiv-1093338573 {

font-family:Symbol;}
_filtered #ygrps-yiv-1093338573 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1093338573 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1093338573 {

font-family:Wingdings;}
#ygrps-yiv-1093338573 ol
{margin-bottom:0in;}
#ygrps-yiv-1093338573 ul
{margin-bottom:0in;}
–>

I hadnâ€™t even tried that yet, but that will be another issue for us, thanks for sharing!

Sarah Vareschi â–ª Systems Manager â–ª NyproMold â–ª 978-368-4718

system · June 13, 2013, 9:08am

I've ran across 2 problems with 9.05.702 BAQs that use summary tables. I'm working with support on them but thought the group might want a heads up, I'll add an update when I receive one. Background info: Data needed to calculate pension. We need employee ID, name, age (EOY), anniversary years (EOY), hours and pay, current rate of pay. This is used to project EOY wages that are used to calculate pension amounts. Not all hours are included so I need to pull hours from PRChkDtl so I can filter by pay type. (PREmpMas>PRCheck>PRChkDtl w/PRCheck and PRChkDtl both marked as summary tables.) This BAQ is working in Vantage 8.03.409A. If this doesn't get fixed I'll have to completely revamp some critical dashboards.

First problem is that cross-company BAQs returns no data if the BAQ includes a summary table. This won't affect anyone that isn't multi-company. This works in Vantage and it worked in 9.05.701.

Second problem is that no data is returned for summary tables unless they are the highest level summary table. I no longer get total hours from PRCHkDtl. This works in Vantage and it worked in 9.05.701.

I had a third problem that was new to me, but don't think it's new to the software. In Vantage I had set up Company UD fields to hold our current and prior fiscal years. In Epicor 9 I've eliminated that and used the Constants.FiscalYear field. I found I can't use that in a BAQ calculated field such as Constants.FiscalYear Â– Year(PREmpMas.HireDate); Year(Today) Â– Year(PREMpMas.HireDate) does work as a workaround.

Sue

system · June 14, 2013, 2:40pm

SCR 116608 has been issued for "BAQ IsSummary doesn't calculate total correctly when multiple tables are summarized that have a 1 to many relations and are on different levels or nodes in the Phase Builder", no target yet.

No word on cross-company BAQs w/summary tables yet (unless internally a cross company BAQ is actually on different levels/nodes?). I'm pretty disappointed, I need BAQs to work cross-company and to summarize multiple tables. I'm hoping that's fixed before we set our final Epicor 9 conversion date, it's important to management that we don't lose any functionality when we convert. It scares me that they'll now quit working on Epicor 9 just like their focus moved from Vantage to Epicor 9 right after we went to Vantage 8.03.4xx...

Sue

--- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@...> wrote:
>
> I've ran across 2 problems with 9.05.702 BAQs that use summary tables. I'm working with support on them but thought the group might want a heads up, I'll add an update when I receive one. Background info: Data needed to calculate pension. We need employee ID, name, age (EOY), anniversary years (EOY), hours and pay, current rate of pay. This is used to project EOY wages that are used to calculate pension amounts. Not all hours are included so I need to pull hours from PRChkDtl so I can filter by pay type. (PREmpMas>PRCheck>PRChkDtl w/PRCheck and PRChkDtl both marked as summary tables.) This BAQ is working in Vantage 8.03.409A. If this doesn't get fixed I'll have to completely revamp some critical dashboards.
>
> First problem is that cross-company BAQs returns no data if the BAQ includes a summary table. This won't affect anyone that isn't multi-company. This works in Vantage and it worked in 9.05.701.
>
> Second problem is that no data is returned for summary tables unless they are the highest level summary table. I no longer get total hours from PRCHkDtl. This works in Vantage and it worked in 9.05.701.
>
> I had a third problem that was new to me, but don't think it's new to the software. In Vantage I had set up Company UD fields to hold our current and prior fiscal years. In Epicor 9 I've eliminated that and used the Constants.FiscalYear field. I found I can't use that in a BAQ calculated field such as Constants.FiscalYear Â– Year(PREmpMas.HireDate); Year(Today) Â– Year(PREMpMas.HireDate) does work as a workaround.
>
> Sue
>

system · October 1, 2014, 12:35pm

Hi Sue - I realize this is a very old post - but I just ran into this same problem on cross-company BAQ using summary table. It took me a while to realize I wasn't doing something wrong and then a search found your post. Did you ever get an answer/resolution from epicor? I am about to submit a call to them.

system · October 1, 2014, 2:34pm

<!-- #ygrps-yiv-169114856 _filtered #ygrps-yiv-169114856 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-169114856 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-169114856 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-169114856 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-169114856 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-169114856 #ygrps-yiv-169114856 p.ygrps-yiv-169114856MsoNormal, #ygrps-yiv-169114856 li.ygrps-yiv-169114856MsoNormal, #ygrps-yiv-169114856 div.ygrps-yiv-169114856MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-169114856 a:link, #ygrps-yiv-169114856 span.ygrps-yiv-169114856MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-169114856 a:visited, #ygrps-yiv-169114856 span.ygrps-yiv-169114856MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-169114856 p.ygrps-yiv-169114856MsoPlainText, #ygrps-yiv-169114856 li.ygrps-yiv-169114856MsoPlainText, #ygrps-yiv-169114856 div.ygrps-yiv-169114856MsoPlainText {

margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:“Calibri”, “sans-serif”;}
#ygrps-yiv-169114856 p
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 code
{
font-family:“Courier New”;}
#ygrps-yiv-169114856 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-169114856 tt
{
font-family:“Courier New”;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856cat
{}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856ct
{}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856attach, #ygrps-yiv-169114856 li.ygrps-yiv-169114856attach, #ygrps-yiv-169114856 div.ygrps-yiv-169114856attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856bold, #ygrps-yiv-169114856 li.ygrps-yiv-169114856bold, #ygrps-yiv-169114856 div.ygrps-yiv-169114856bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856green, #ygrps-yiv-169114856 li.ygrps-yiv-169114856green, #ygrps-yiv-169114856 div.ygrps-yiv-169114856green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856replbq, #ygrps-yiv-169114856 li.ygrps-yiv-169114856replbq, #ygrps-yiv-169114856 div.ygrps-yiv-169114856replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856ad, #ygrps-yiv-169114856 li.ygrps-yiv-169114856ad, #ygrps-yiv-169114856 div.ygrps-yiv-169114856ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856underline, #ygrps-yiv-169114856 li.ygrps-yiv-169114856underline, #ygrps-yiv-169114856 div.ygrps-yiv-169114856underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856yshortcuts
{}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856ad1, #ygrps-yiv-169114856 li.ygrps-yiv-169114856ad1, #ygrps-yiv-169114856 div.ygrps-yiv-169114856ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856ad2, #ygrps-yiv-169114856 li.ygrps-yiv-169114856ad2, #ygrps-yiv-169114856 div.ygrps-yiv-169114856ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-169114856 p.ygrps-yiv-169114856underline1, #ygrps-yiv-169114856 li.ygrps-yiv-169114856underline1, #ygrps-yiv-169114856 div.ygrps-yiv-169114856underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-169114856 span.ygrps-yiv-169114856PlainTextChar
{

font-family:“Calibri”, “sans-serif”;}
#ygrps-yiv-169114856 .ygrps-yiv-169114856MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-169114856 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-169114856 div.ygrps-yiv-169114856WordSection1
{}
#ygrps-yiv-169114856
_filtered #ygrps-yiv-169114856 {
}
_filtered #ygrps-yiv-169114856 {

font-family:Symbol;}
_filtered #ygrps-yiv-169114856 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-169114856 {

font-family:Wingdings;}
_filtered #ygrps-yiv-169114856 {

font-family:Wingdings;}
#ygrps-yiv-169114856 ol
{margin-bottom:0in;}
#ygrps-yiv-169114856 ul
{margin-bottom:0in;}
–>

FYI to anyone interested â€“ response form Epicor support:

SCR 124711 - Cross-company BAQ fails to return data when child table is summarized Has been fixed on Epicor 10.01.000, it is tentatively scheduled for release on 3/15/2015.Â There will be no one off fixes released for Epicor 9 due to the fact that changes in the tool set were needed to fix this issue.

system · October 1, 2014, 4:11pm

I see you got the answer from support. This bug was the main reason we won't upgrade past 9.05.701 (before the BAQs were broken). You may be able to get some info you need by using a dashboard report which can combine data from multiple BAQs in a Crystal Report. You can do some manipulations with summaries and sub-reports in the Crystal report and produce a bare bones report that can be exported to Excel. We rely heavily on cross-company BAQs for payroll and 401k processing; the users that need that data are very "low tech". I can give them the info they need easily when the BAQs work. Since it only affects cross-company BAQs I suspect it was a low priority for Epicor.

system · October 1, 2014, 4:44pm

On a side note. I realized you can have only one summarized table in a query in 9.05.701

If you have more than one, it breaks the query.

From: "snielsen.hipco@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Wednesday, October 1, 2014 4:11 PM
Subject: [Vantage] Re: 9.05.702 BAQ issues w/summary tables

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320 --

#ygrps-yiv-1867530353yiv4733490320 .ygrps-yiv-1867530353yiv4733490320ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320photo-title
a,
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320photo-title a:active,
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320photo-title a:hover,
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320attach-table div.ygrps-yiv-1867530353yiv4733490320attach-row {
clear:both;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320attach-table div.ygrps-yiv-1867530353yiv4733490320attach-row div {
float:left;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320ygrp-file {
width:30px;}
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320attach-table div.ygrps-yiv-1867530353yiv4733490320attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320attach-table div.ygrps-yiv-1867530353yiv4733490320attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 div.ygrps-yiv-1867530353yiv4733490320ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1867530353
#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320 –
#ygrps-yiv-1867530353yiv4733490320ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp #ygrps-yiv-1867530353yiv4733490320hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp #ygrps-yiv-1867530353yiv4733490320ads {
margin-bottom:10px;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp .ygrps-yiv-1867530353yiv4733490320ad {
padding:0 0;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp .ygrps-yiv-1867530353yiv4733490320ad p {
margin:0;}

#ygrps-yiv-1867530353 #ygrps-yiv-1867530353yiv4733490320 #ygrps-yiv-1867530353yiv4733490320ygrp-mkp .ygrps-yiv-1867530353yiv4733490320ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1867530353

I see you got the answer from support. This bug was the main reason we won't upgrade past 9.05.701 (before the BAQs were broken). You may be able to get some info you need by using a dashboard report which can combine data from multiple BAQs in a Crystal Report. You can do some manipulations with summaries and sub-reports in the Crystal report and produce a bare bones report that can be exported to Excel. We rely heavily on cross-company BAQs for payroll and 401k processing; the users that need that data are very "low tech". I can give them the info they need easily when the BAQs work. Since it only affects cross-company BAQs I suspect it was a low priority for Epicor.

system · October 1, 2014, 5:23pm

I didn't realize that Ted...I just tried it and it blew up. You can't branch off to more than one summary table, but you can "stack" them. For example, PREmpMas>PRCheck>PRChkTax displaying TOTAL(PRChkTax.TaxableAmt) with both PRCheck and PRChkTax being summary tables. You get a nice one line per employee result. I think that was another BAQ feature that broke after 9.05.701. Thanks for the side note on multiple summary tables...I'll file it away so I don't waste time and energy trying to get it to work!

Sue

system · October 2, 2014, 9:10am

<!-- #ygrps-yiv-371842094 _filtered #ygrps-yiv-371842094 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-371842094 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-371842094 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-371842094 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-371842094 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-371842094 #ygrps-yiv-371842094 p.ygrps-yiv-371842094MsoNormal, #ygrps-yiv-371842094 li.ygrps-yiv-371842094MsoNormal, #ygrps-yiv-371842094 div.ygrps-yiv-371842094MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-371842094 a:link, #ygrps-yiv-371842094 span.ygrps-yiv-371842094MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-371842094 a:visited, #ygrps-yiv-371842094 span.ygrps-yiv-371842094MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-371842094 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 code
{
font-family:“Courier New”;}
#ygrps-yiv-371842094 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-371842094 tt
{
font-family:“Courier New”;}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094cat
{}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094ct
{}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094attach, #ygrps-yiv-371842094 li.ygrps-yiv-371842094attach, #ygrps-yiv-371842094 div.ygrps-yiv-371842094attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094bold, #ygrps-yiv-371842094 li.ygrps-yiv-371842094bold, #ygrps-yiv-371842094 div.ygrps-yiv-371842094bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094green, #ygrps-yiv-371842094 li.ygrps-yiv-371842094green, #ygrps-yiv-371842094 div.ygrps-yiv-371842094green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094replbq, #ygrps-yiv-371842094 li.ygrps-yiv-371842094replbq, #ygrps-yiv-371842094 div.ygrps-yiv-371842094replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094ad, #ygrps-yiv-371842094 li.ygrps-yiv-371842094ad, #ygrps-yiv-371842094 div.ygrps-yiv-371842094ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094underline, #ygrps-yiv-371842094 li.ygrps-yiv-371842094underline, #ygrps-yiv-371842094 div.ygrps-yiv-371842094underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094yshortcuts
{}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094ad1, #ygrps-yiv-371842094 li.ygrps-yiv-371842094ad1, #ygrps-yiv-371842094 div.ygrps-yiv-371842094ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094ad2, #ygrps-yiv-371842094 li.ygrps-yiv-371842094ad2, #ygrps-yiv-371842094 div.ygrps-yiv-371842094ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-371842094 p.ygrps-yiv-371842094underline1, #ygrps-yiv-371842094 li.ygrps-yiv-371842094underline1, #ygrps-yiv-371842094 div.ygrps-yiv-371842094underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-371842094 span.ygrps-yiv-371842094EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-371842094 .ygrps-yiv-371842094MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-371842094 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-371842094 div.ygrps-yiv-371842094WordSection1
{}
#ygrps-yiv-371842094
_filtered #ygrps-yiv-371842094 {
}
_filtered #ygrps-yiv-371842094 {

font-family:Symbol;}
_filtered #ygrps-yiv-371842094 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-371842094 {

font-family:Wingdings;}
_filtered #ygrps-yiv-371842094 {

font-family:Wingdings;}
#ygrps-yiv-371842094 ol
{margin-bottom:0in;}
#ygrps-yiv-371842094 ul
{margin-bottom:0in;}
–>

Thank you for the feedback and advice.Â I have all of my reports already working in MS Access (from way back on Vantage 5.2 -> because we just went from 5.2 to 9.05).Â I have been working on converting what I can to BAQâ€™s/dashboards, but then I ran into this issue.Â MAJOR issue for us in proceeding in report conversion so at this point I am only going to do the simple ones and wait til we upgrade to 10.1 to do all the others JÂ

Topic		Replies	Views
Epicor 9 702A - BAQ - Total Sales value / Job Info/ Total Cost Yahoo Archive	5	858	December 12, 2014
BAQ rows duplicating issue Yahoo Archive	4	571	January 7, 2015
BAQ: Summary Tables in E9 Yahoo Archive	15	1550	March 9, 2011
Epicor 9.05.700C - BAQ return summary data Yahoo Archive	5	550	January 28, 2013
BAQ - Summary Tables Yahoo Archive	1	586	June 8, 2011

9.05.702 BAQ issues w/summary tables

Related Topics