Stock Status Report - filter by Part #

Yahoo Archive
1
If it is a one off, create a part Class that is called "Temp"
Select your 30 parts, change the part class (keep a list so you can fix it later)
Run the report and put the class back to what is was.

Bruce

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
>
> it is just a one off for the auditors who want it pretty quick.
>
> --- In vantage@yahoogroups.com, "CharlieSmith" <CSmith@> wrote:
> >
> > Are they always the same 30 parts? Are they different classes?
> >
> > You are better off writing a BAQ and BAQ Report.
> >
> >
> >
> > Charlie Smith
> >
> > 2W Technologies LLC, Sr. Business Consultant
> >
> >
> >
> > Phone: (312) 533-4033 x8046
> >
> > (860) 620-9553
> >
> > Fax: (847) 374-3620
> >
> > 2W Tech on Facebook
> > <http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
> > 32409> www.2WTech.com <http://www.2wtech.com/>
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of michael.hutcheson@
> > Sent: Monday, December 06, 2010 11:59 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Stock Status Report - filter by Part #
> >
> >
> >
> >
> >
> > we are after info in the stock status report for approx 30 parts...
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Dale Schuerman" <dale.schuerman@> wrote:
> > >
> > > If you are looking at only one part number wouldn't "Part Tracker" or
> > > "Part On-Hand Status Dashboard" work?
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > > Of michael.hutcheson@
> > > Sent: Monday, December 06, 2010 10:25 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Stock Status Report - filter by Part #
> > >
> > >
> > >
> > >
> > >
> > > come to think of it, could i just create a BAQ search using the part #
> > ?
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <
> > mailto:vantage%40yahoogroups.com> ,
> > > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > > >
> > > > Hello,
> > > >
> > > > I've had a request to configure the stock status report to filter by
> > > part #. Is it possible to add filters to standard Vantage report
> > > options? Currently you can only filter by Part Class and\or plant. My
> > > other thought was to create a copy of the stock status report and then
> > > have this prompt the user for a part number - however, every single
> > Part
> > > Number would have to be dumped out first which takes some time.....
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks,
> > > >
> > > > Michael
> > > >
> > > >
> > > > Vantage 8.03.406/Progress
> > > >
> > >
> > >
> > >
> > >
> > >
> > ########################################################################
> > > 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]
> >
>
2
Hello,

I've had a request to configure the stock status report to filter by part #. Is it possible to add filters to standard Vantage report options? Currently you can only filter by Part Class and\or plant. My other thought was to create a copy of the stock status report and then have this prompt the user for a part number - however, every single Part Number would have to be dumped out first which takes some time.....

Any ideas?

Thanks,

Michael


Vantage 8.03.406/Progress
3
come to think of it, could i just create a BAQ search using the part # ?




--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I've had a request to configure the stock status report to filter by part #. Is it possible to add filters to standard Vantage report options? Currently you can only filter by Part Class and\or plant. My other thought was to create a copy of the stock status report and then have this prompt the user for a part number - however, every single Part Number would have to be dumped out first which takes some time.....
>
> Any ideas?
>
> Thanks,
>
> Michael
>
>
> Vantage 8.03.406/Progress
>
4
no, that doesn't work

--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> come to think of it, could i just create a BAQ search using the part # ?
>
>
>
>
> --- In vantage@yahoogroups.com, "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I've had a request to configure the stock status report to filter by part #. Is it possible to add filters to standard Vantage report options? Currently you can only filter by Part Class and\or plant. My other thought was to create a copy of the stock status report and then have this prompt the user for a part number - however, every single Part Number would have to be dumped out first which takes some time.....
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Michael
> >
> >
> > Vantage 8.03.406/Progress
> >
>
5
If you are looking at only one part number wouldn't "Part Tracker" or
"Part On-Hand Status Dashboard" work?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, December 06, 2010 10:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Stock Status Report - filter by Part #





come to think of it, could i just create a BAQ search using the part # ?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I've had a request to configure the stock status report to filter by
part #. Is it possible to add filters to standard Vantage report
options? Currently you can only filter by Part Class and\or plant. My
other thought was to create a copy of the stock status report and then
have this prompt the user for a part number - however, every single Part
Number would have to be dumped out first which takes some time.....
>
> Any ideas?
>
> Thanks,
>
> Michael
>
>
> Vantage 8.03.406/Progress
>




########################################################################
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]
6
we are after info in the stock status report for approx 30 parts...

--- In vantage@yahoogroups.com, "Dale Schuerman" <dale.schuerman@...> wrote:
>
> If you are looking at only one part number wouldn't "Part Tracker" or
> "Part On-Hand Status Dashboard" work?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Monday, December 06, 2010 10:25 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Stock Status Report - filter by Part #
>
>
>
>
>
> come to think of it, could i just create a BAQ search using the part # ?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I've had a request to configure the stock status report to filter by
> part #. Is it possible to add filters to standard Vantage report
> options? Currently you can only filter by Part Class and\or plant. My
> other thought was to create a copy of the stock status report and then
> have this prompt the user for a part number - however, every single Part
> Number would have to be dumped out first which takes some time.....
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Michael
> >
> >
> > Vantage 8.03.406/Progress
> >
>
>
>
>
> ########################################################################
> 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]
>
7
You should be able to load those 30 parts into a UD table(or hard code
the 30 parts into the BAQ filter).



Write a BAQ to read the UD01 and link to the PartBin(other tables if
required).



Write a dashboard or a BAQR using the BAQ



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, December 06, 2010 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Stock Status Report - filter by Part #





we are after info in the stock status report for approx 30 parts...

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dale Schuerman" <dale.schuerman@...> wrote:
>
> If you are looking at only one part number wouldn't "Part Tracker" or
> "Part On-Hand Status Dashboard" work?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Monday, December 06, 2010 10:25 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Stock Status Report - filter by Part #
>
>
>
>
>
> come to think of it, could i just create a BAQ search using the part #
?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I've had a request to configure the stock status report to filter by
> part #. Is it possible to add filters to standard Vantage report
> options? Currently you can only filter by Part Class and\or plant. My
> other thought was to create a copy of the stock status report and then
> have this prompt the user for a part number - however, every single
Part
> Number would have to be dumped out first which takes some time.....
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Michael
> >
> >
> > Vantage 8.03.406/Progress
> >
>
>
>
>
>
########################################################################
> 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]
8
Are they always the same 30 parts? Are they different classes?

You are better off writing a BAQ and BAQ Report.



Charlie Smith

2W Technologies LLC, Sr. Business Consultant



Phone: (312) 533-4033 x8046

(860) 620-9553

Fax: (847) 374-3620

2W Tech on Facebook
<http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
32409> www.2WTech.com <http://www.2wtech.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of michael.hutcheson@...
Sent: Monday, December 06, 2010 11:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Stock Status Report - filter by Part #





we are after info in the stock status report for approx 30 parts...

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dale Schuerman" <dale.schuerman@...> wrote:
>
> If you are looking at only one part number wouldn't "Part Tracker" or
> "Part On-Hand Status Dashboard" work?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of michael.hutcheson@...
> Sent: Monday, December 06, 2010 10:25 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Stock Status Report - filter by Part #
>
>
>
>
>
> come to think of it, could i just create a BAQ search using the part #
?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <
mailto:vantage%40yahoogroups.com> ,
> "michael.hutcheson@" <michael.hutcheson@> wrote:
> >
> > Hello,
> >
> > I've had a request to configure the stock status report to filter by
> part #. Is it possible to add filters to standard Vantage report
> options? Currently you can only filter by Part Class and\or plant. My
> other thought was to create a copy of the stock status report and then
> have this prompt the user for a part number - however, every single
Part
> Number would have to be dumped out first which takes some time.....
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Michael
> >
> >
> > Vantage 8.03.406/Progress
> >
>
>
>
>
>
########################################################################
> 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]
9
The big feature of the regular stock status report is the "as of" date. If you just want the current snapshot, BAQ advanced search dashboard will work fine.

And I would use analysis code or one of the UD checkbox fields in part maintenance to flag the part rather than take up a UD table.


--- In vantage@yahoogroups.com, "michael.hutcheson@..." <michael.hutcheson@...> wrote:
>
> Hello,
>
> I've had a request to configure the stock status report to filter by part #. Is it possible to add filters to standard Vantage report options? Currently you can only filter by Part Class and\or plant. My other thought was to create a copy of the stock status report and then have this prompt the user for a part number - however, every single Part Number would have to be dumped out first which takes some time.....
>
> Any ideas?
>
> Thanks,
>
> Michael
>
>
> Vantage 8.03.406/Progress
>
10
it is just a one off for the auditors who want it pretty quick.

--- In vantage@yahoogroups.com, "CharlieSmith" <CSmith@...> wrote:
>
> Are they always the same 30 parts? Are they different classes?
>
> You are better off writing a BAQ and BAQ Report.
>
>
>
> Charlie Smith
>
> 2W Technologies LLC, Sr. Business Consultant
>
>
>
> Phone: (312) 533-4033 x8046
>
> (860) 620-9553
>
> Fax: (847) 374-3620
>
> 2W Tech on Facebook
> <http://www.facebook.com/pages/Chicago-IL/2W-Technologies-LLC/1391945694
> 32409> www.2WTech.com <http://www.2wtech.com/>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of michael.hutcheson@...
> Sent: Monday, December 06, 2010 11:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Stock Status Report - filter by Part #
>
>
>
>
>
> we are after info in the stock status report for approx 30 parts...
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Dale Schuerman" <dale.schuerman@> wrote:
> >
> > If you are looking at only one part number wouldn't "Part Tracker" or
> > "Part On-Hand Status Dashboard" work?
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of michael.hutcheson@
> > Sent: Monday, December 06, 2010 10:25 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Stock Status Report - filter by Part #
> >
> >
> >
> >
> >
> > come to think of it, could i just create a BAQ search using the part #
> ?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <
> mailto:vantage%40yahoogroups.com> ,
> > "michael.hutcheson@" <michael.hutcheson@> wrote:
> > >
> > > Hello,
> > >
> > > I've had a request to configure the stock status report to filter by
> > part #. Is it possible to add filters to standard Vantage report
> > options? Currently you can only filter by Part Class and\or plant. My
> > other thought was to create a copy of the stock status report and then
> > have this prompt the user for a part number - however, every single
> Part
> > Number would have to be dumped out first which takes some time.....
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Michael
> > >
> > >
> > > Vantage 8.03.406/Progress
> > >
> >
> >
> >
> >
> >
> ########################################################################
> > 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]
>