Several reports have filters that appear to only accept one entry if you search, but you can actually put in more. Trying doing a "paste insert" from a column of part numbers in excel into that filter tab.
I am writing a report for our warehouse which shows quantity in each
location for a set of parts specified at runtime. This group of parts does
not have anything in common in Epicor. What I found with the BAQ Report
Designer is that I can specify a filter, but the user is limited to results
selected from one search. We have around 7000 parts, so finding each one
and selecting as a group is not feasible. If the user searches for and
selects one part, then goes to perform another search, the previous result
is removed.
Does anyone have an idea for how to allow the user to specify a set of
parameters in this way? I am thinking of the fulfillment workbench, where
the user can keep adding to the grid with new searches.
I am not committed to doing this in BAQ Report Designer if there is another
way to accomplish this.
I am writing a report for our warehouse which shows quantity in each
location for a set of parts specified at runtime. This group of parts does
not have anything in common in Epicor. What I found with the BAQ Report
Designer is that I can specify a filter, but the user is limited to results
selected from one search. We have around 7000 parts, so finding each one
and selecting as a group is not feasible. If the user searches for and
selects one part, then goes to perform another search, the previous result
is removed.
Does anyone have an idea for how to allow the user to specify a set of
parameters in this way? I am thinking of the fulfillment workbench, where
the user can keep adding to the grid with new searches.
I am not committed to doing this in BAQ Report Designer if there is another
way to accomplish this.
Well, you can cntl+select in your searches, but with 7000 parts, that will still be hard...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tanya Denison
Sent: Tuesday, November 27, 2012 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Multiple filters on BAQ Report
I am writing a report for our warehouse which shows quantity in each
location for a set of parts specified at runtime. This group of parts does
not have anything in common in Epicor. What I found with the BAQ Report
Designer is that I can specify a filter, but the user is limited to results
selected from one search. We have around 7000 parts, so finding each one
and selecting as a group is not feasible. If the user searches for and
selects one part, then goes to perform another search, the previous result
is removed.
Does anyone have an idea for how to allow the user to specify a set of
parameters in this way? I am thinking of the fulfillment workbench, where
the user can keep adding to the grid with new searches.
I am not committed to doing this in BAQ Report Designer if there is another
way to accomplish this.
*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *Karen Schoenung
*Sent:* Tuesday, November 27, 2012 8:52 AM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Multiple filters on BAQ Report
Well, you can cntl+select in your searches, but with 7000 parts, that will
still be hard...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tanya Denison
Sent: Tuesday, November 27, 2012 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Multiple filters on BAQ Report
I am writing a report for our warehouse which shows quantity in each
location for a set of parts specified at runtime. This group of parts does
not have anything in common in Epicor. What I found with the BAQ Report
Designer is that I can specify a filter, but the user is limited to results
selected from one search. We have around 7000 parts, so finding each one
and selecting as a group is not feasible. If the user searches for and
selects one part, then goes to perform another search, the previous result
is removed.
Does anyone have an idea for how to allow the user to specify a set of
parameters in this way? I am thinking of the fulfillment workbench, where
the user can keep adding to the grid with new searches.
I am not committed to doing this in BAQ Report Designer if there is another
way to accomplish this.
Perhaps I'm not completely understanding, but you say these parts have
nothing in common within Epicor. Why not give them something in common via
a UD field? Are these special in-house part groups or something? If so,
I'd suggest doing it that way and mass updating that UD field via DMT or
another supported product from Epicor. Once you update your 7000 parts with
this UD field value, then you would be able to filter in a BAQ but you may
have to treat it as an Option field.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tanya Denison
Sent: Tuesday, November 27, 2012 1:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Multiple filters on BAQ Report
Yes, that was my first thought, but the sampling they need is not sequential
at all, so hitting Ctrl+Select on each item would be onerous.
*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On Behalf
Of *Karen Schoenung
*Sent:* Tuesday, November 27, 2012 8:52 AM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Multiple filters on BAQ Report
Well, you can cntl+select in your searches, but with 7000 parts, that will
still be hard...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Tanya Denison
Sent: Tuesday, November 27, 2012 9:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Multiple filters on BAQ Report
I am writing a report for our warehouse which shows quantity in each
location for a set of parts specified at runtime. This group of parts does
not have anything in common in Epicor. What I found with the BAQ Report
Designer is that I can specify a filter, but the user is limited to results
selected from one search. We have around 7000 parts, so finding each one and
selecting as a group is not feasible. If the user searches for and selects
one part, then goes to perform another search, the previous result is
removed.
Does anyone have an idea for how to allow the user to specify a set of
parameters in this way? I am thinking of the fulfillment workbench, where
the user can keep adding to the grid with new searches.
I am not committed to doing this in BAQ Report Designer if there is another
way to accomplish this.
[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]
------------------------------------
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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5422 - Release Date: 11/27/12
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2629/5422 - Release Date: 11/27/12