Newly created BAQ doesn't show up in Test Form

Patricia,


This is a known issue, fixed on SCR121789.


Ernie Lowell

Diba Industries

Hi All,

Does anyone know a reason why a newly created BAQ and Report doesn't show up when you click Test Form and the one you created does? If so, how do you fix it?

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com








[Non-text portions of this message have been removed]
Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc
Sorry,
Epicor 905.702A
Crystal Reports

I created a BAQ called OrderShippingStatus
Added in the tables I needed, analyzed and tested the BAQ. Data was displayed with no errors.

I created a report called OrderShipStatus to go with it.
Added Option fields like ShipDate to run the report by a date range and OrderNum and PartNum to run the report by either OrderNum or PartNum.
Report doesn’t have filters at this time.

I clicked Test Form to see if it worked and instead of getting OrderShipStatus I get a BAQ I created about a month ago.

The BAQ and the .rpt I just created above are in the Query Designer and the Report Designer.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 3:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Newly created BAQ doesn't show up in Test Form



Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc



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

BAQ Report Designer, Generate Sample Data, Then test again.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 16:03
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

 

 

Sorry,
Epicor 905.702A
Crystal Reports

I created a BAQ called OrderShippingStatus
Added in the tables I needed, analyzed and tested the BAQ. Data was displayed with no errors.

I created a report called OrderShipStatus to go with it.
Added Option fields like ShipDate to run the report by a date range and OrderNum and PartNum to run the report by either OrderNum or PartNum.
Report doesn’t have filters at this time.

I clicked Test Form to see if it worked and instead of getting OrderShipStatus I get a BAQ I created about a month ago.

The BAQ and the .rpt I just created above are in the Query Designer and the Report Designer.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 3:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Newly created BAQ doesn't show up in Test Form



Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc


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

This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the Specialty Screw Corporation company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.

Patrick,

Thank you.

I tried your suggestion and got the message below but when I tried Test Report Form again I still don’t see my OrderShipStatus.
[cid:image001.png@01CFD8DE.68270240]

This is part of what I see when I do Test Report Form
[cid:image002.png@01CFD8DE.68270240]

All Received Inventory is something I did about a month ago. Is there a step I missed?

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 4:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form


BAQ Report Designer, Generate Sample Data, Then test again.

Patrick Winter

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 16:03
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form



Sorry,
Epicor 905.702A
Crystal Reports

I created a BAQ called OrderShippingStatus
Added in the tables I needed, analyzed and tested the BAQ. Data was displayed with no errors.

I created a report called OrderShipStatus to go with it.
Added Option fields like ShipDate to run the report by a date range and OrderNum and PartNum to run the report by either OrderNum or PartNum.
Report doesn’t have filters at this time.

I clicked Test Form to see if it worked and instead of getting OrderShipStatus I get a BAQ I created about a month ago.

The BAQ and the .rpt I just created above are in the Query Designer and the Report Designer.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...<mailto:phall@...%3cmailto:phall@...>>
www.cbcings.com<http://www.cbcings.com>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 3:50 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] Re: Newly created BAQ doesn't show up in Test Form



Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc


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

This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the Specialty Screw Corporation company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.



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

Patricia,

 

You’ll need to contact Epicor Support and ask for the following fix program:

 

**RETRO FIX FOR SCR 121789 - BAQ Designer - returns incorrect Test form when using Action > Test Report Form option in BAQ Report designer.

 

Regards,

Scott Lepley

Business Systems Analyst

Restek Corporation

110 Benner Pike

Bellefonte, PA  16823

814.353.1300

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 5:33 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

 

Patrick,

Thank you.

I tried your suggestion and got the message below but when I tried Test Report Form again I still don’t see my OrderShipStatus.
[cid:image001.png@01CFD8DE.68270240]

This is part of what I see when I do Test Report Form
[cid:image002.png@01CFD8DE.68270240]

All Received Inventory is something I did about a month ago. Is there a step I missed?

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 4:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

BAQ Report Designer, Generate Sample Data, Then test again.

Patrick Winter


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 16:03
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

Sorry,
Epicor 905.702A
Crystal Reports

I created a BAQ called OrderShippingStatus
Added in the tables I needed, analyzed and tested the BAQ. Data was displayed with no errors.

I created a report called OrderShipStatus to go with it.
Added Option fields like ShipDate to run the report by a date range and OrderNum and PartNum to run the report by either OrderNum or PartNum.
Report doesn’t have filters at this time.

I clicked Test Form to see if it worked and instead of getting OrderShipStatus I get a BAQ I created about a month ago.

The BAQ and the .rpt I just created above are in the Query Designer and the Report Designer.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...<mailto:phall@...%3cmailto:phall@...>>
www.cbcings.com<http://www.cbcings.com>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 3:50 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc


Ok. Thanks for replying.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...>
www.cbcings.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 5:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form


Patricia,

You’ll need to contact Epicor Support and ask for the following fix program:

**RETRO FIX FOR SCR 121789 - BAQ Designer - returns incorrect Test form when using Action > Test Report Form option in BAQ Report designer.

Regards,
Scott Lepley
Business Systems Analyst
Restek Corporation
110 Benner Pike
Bellefonte, PA 16823
814.353.1300

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 5:33 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form


Patrick,

Thank you.

I tried your suggestion and got the message below but when I tried Test Report Form again I still don’t see my OrderShipStatus.
[cid:image001.png@01CFD8DE.68270240]

This is part of what I see when I do Test Report Form
[cid:image002.png@01CFD8DE.68270240]

All Received Inventory is something I did about a month ago. Is there a step I missed?

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...<mailto:phall@...%3cmailto:phall@...>>
www.cbcings.com<http://www.cbcings.com>


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 4:27 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

BAQ Report Designer, Generate Sample Data, Then test again.

Patrick Winter


From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 16:03
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: RE: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

Sorry,
Epicor 905.702A
Crystal Reports

I created a BAQ called OrderShippingStatus
Added in the tables I needed, analyzed and tested the BAQ. Data was displayed with no errors.

I created a report called OrderShipStatus to go with it.
Added Option fields like ShipDate to run the report by a date range and OrderNum and PartNum to run the report by either OrderNum or PartNum.
Report doesn’t have filters at this time.

I clicked Test Form to see if it worked and instead of getting OrderShipStatus I get a BAQ I created about a month ago.

The BAQ and the .rpt I just created above are in the Query Designer and the Report Designer.

Patricia Hall
Systems Analyst

[cid:image002.png@...7982E0]

3137 East 6th Street
Muscle Shoals, Al 35661

T: 256.978.6294
C: 256.366.8697
F: 256.383.8224
E: phall@...<mailto:phall@...<mailto:phall@...%3cmailto:phall@...<mailto:phall@...%3cmailto:phall@...%3cmailto:phall@...%3cmailto:phall@...>>>
www.cbcings.com<http://www.cbcings.com<http://www.cbcings.com%3chttp:/www.cbcings.com>>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>> [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 25, 2014 3:50 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com%3cmailto:vantage@yahoogroups.com>>
Subject: [Vantage] Re: Newly created BAQ doesn't show up in Test Form

Now that there are three versions of Epicor (vantage, E9, and E10) talked about the most, it is really important that posting includes full context of the version, what type of report, etc.

In the case of E9 it could be a Crystal Report or a SSRS, in E10 most likely a SSRS report.

Not sure what you mean by "newly created" and "the one you created does".

Jim Kinneman
Encompass Solutions, Inc






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