Slow Moving Inventory Report

Yahoo Archive
1
OK, I found the BAQ for slow moving inventory in the files section. I read the instructions. It says it was written in Vantage 8.03.404. I am on Vista 8.03.409c. I copied the first file and change the company ID to mine. When I tried to import it I got the following messge: The BAR Report Definition Import file (saved name of file) is in the incorrect format and cannot be imported.
I am a Master Scheduler, not an IT person. Can someone please help me decode this message and tell me if I can get this report to work for me?
Georgia

--- In vantage@yahoogroups.com, Grace Chandra <grace@...> wrote:
>
> Lynn,
> I know its been such a long time, but would you mind sending me the BAQ Report as well?
> Thank you so much.
>
> Grace Chandra
> Controller
> - - - - - - - - - - -Â - - - - - - - - - - -Â - - - - - - - - - - -Â - - - - - - - - - -
> t.  (630) 889-8100 FC Lighting
> f.  (630) 889-8106 3609 Swenson Ave.
> e. grace@... St. Charles, IL 60174
> w.  www.fclighting.com
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Lynn
> Sent: Wednesday, May 06, 2009 10:18 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Slow Moving Inventory Report
>
> I have a BAQ and BAQ Report which queries all the Part Bins to look for parts in stock, then it finds the last inventory transaction date from the PartTran table.
>
> It also has links to the CustXPrt, Customer, and Part tables in order to show the Customer name, Customer Part Number and SearchWord.
>
> The BAQ could easily be used in a dashboard instead of a BAQ CR for even more flexibility. In fact, I was planning on making a dashboard from it.
>
> If this is what you are looking for, I could send it to you.
>
> Lynn
>
2
Does anyone have a slow moving inventory report written that they would
be willing to share? I'm on version 8.03.405A.



Thanks,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]
3
I have a BAQ and BAQ Report which queries all the Part Bins to look for parts in stock, then it finds the last inventory transaction date from the PartTran table.

It also has links to the CustXPrt, Customer, and Part tables in order to show the Customer name, Customer Part Number and SearchWord.

The BAQ could easily be used in a dashboard instead of a BAQ CR for even more flexibility. In fact, I was planning on making a dashboard from it.

If this is what you are looking for, I could send it to you.

Lynn



--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> Does anyone have a slow moving inventory report written that they would
> be willing to share? I'm on version 8.03.405A.
>
>
>
> Thanks,
>
>
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Lynn,

I would be interested in this BAQ as well!

Thanks Lynn,

Dave
Xybix
8.03.407A P
davidh@...


--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> I have a BAQ and BAQ Report which queries all the Part Bins to look for parts in stock, then it finds the last inventory transaction date from the PartTran table.
>
> It also has links to the CustXPrt, Customer, and Part tables in order to show the Customer name, Customer Part Number and SearchWord.
>
> The BAQ could easily be used in a dashboard instead of a BAQ CR for even more flexibility. In fact, I was planning on making a dashboard from it.
>
> If this is what you are looking for, I could send it to you.
>
> Lynn
>
>
>
> --- In vantage@yahoogroups.com, "Late, Travis" <tlate@> wrote:
> >
> > Does anyone have a slow moving inventory report written that they would
> > be willing to share? I'm on version 8.03.405A.
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Travis Late
> >
> > ERP Project Manager
> >
> > M-B Companies, Inc
> >
> > 1200 Park Street
> >
> > Chilton, WI 53014
> >
> > Phone: 920-898-1560 Ext.152
> >
> > Cell: 920-960-0062
> >
> > Email: tlate@ <mailto:tlate@>
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
5
I would be interested in this.



Thanks,

Travis



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lynn
Sent: Wednesday, May 06, 2009 10:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Slow Moving Inventory Report








I have a BAQ and BAQ Report which queries all the Part Bins to look for
parts in stock, then it finds the last inventory transaction date from
the PartTran table.

It also has links to the CustXPrt, Customer, and Part tables in order to
show the Customer name, Customer Part Number and SearchWord.

The BAQ could easily be used in a dashboard instead of a BAQ CR for even
more flexibility. In fact, I was planning on making a dashboard from it.

If this is what you are looking for, I could send it to you.

Lynn

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...> wrote:
>
> Does anyone have a slow moving inventory report written that they
would
> be willing to share? I'm on version 8.03.405A.
>
>
>
> Thanks,
>
>
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
6
I uploaded 4 files to the Files section of this Group. They are in a folder titled Inv-Slow.

The 4 files are:
a Readme document explaining the BAQ.
the BAQ
the BAQ Report
the Crystal Report

If you want to use the BAQ without the BAQ/Crystal Report, then only import the BAQ (without the BAQ Report) and create a dashboard using the BAQ instead.

The BAQ can stand alone. The BAQ Report & Crystal Report can only be used in conjuction with each other and the BAQ.

Lynn




--- In vantage@yahoogroups.com, "ofcwiz" <DavidH@...> wrote:
>
> Lynn,
>
> I would be interested in this BAQ as well!
>
> Thanks Lynn,
>
> Dave
> Xybix
> 8.03.407A P
> davidh@...
>
>
> --- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@> wrote:
> >
> > I have a BAQ and BAQ Report which queries all the Part Bins to look for parts in stock, then it finds the last inventory transaction date from the PartTran table.
> >
> > It also has links to the CustXPrt, Customer, and Part tables in order to show the Customer name, Customer Part Number and SearchWord.
> >
> > The BAQ could easily be used in a dashboard instead of a BAQ CR for even more flexibility. In fact, I was planning on making a dashboard from it.
> >
> > If this is what you are looking for, I could send it to you.
> >
> > Lynn
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Late, Travis" <tlate@> wrote:
> > >
> > > Does anyone have a slow moving inventory report written that they would
> > > be willing to share? I'm on version 8.03.405A.
> > >
> > >
> > >
> > > Thanks,
> > >
> > >
> > >
> > > Travis Late
> > >
> > > ERP Project Manager
> > >
> > > M-B Companies, Inc
> > >
> > > 1200 Park Street
> > >
> > > Chilton, WI 53014
> > >
> > > Phone: 920-898-1560 Ext.152
> > >
> > > Cell: 920-960-0062
> > >
> > > Email: tlate@ <mailto:tlate@>
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
7
I have a slow moving/excess inventory report in .p/4GL that I would be
willing to share. Just email me tboogerd AT Rosenboom.com if you would
like it.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Wednesday, May 06, 2009 9:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Slow Moving Inventory Report








Does anyone have a slow moving inventory report written that they would
be willing to share? I'm on version 8.03.405A.

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

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





[Non-text portions of this message have been removed]
8
Lynn,
I know its been such a long time, but would you mind sending me the BAQ Report as well?
Thank you so much.

Grace Chandra
Controller
- - - - - - - - - - -Â - - - - - - - - - - -Â - - - - - - - - - - -Â - - - - - - - - - -
t.  (630) 889-8100 FC Lighting
f.  (630) 889-8106 3609 Swenson Ave.
e. grace@... St. Charles, IL 60174
w.  www.fclighting.com



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Lynn
Sent: Wednesday, May 06, 2009 10:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Slow Moving Inventory Report

I have a BAQ and BAQ Report which queries all the Part Bins to look for parts in stock, then it finds the last inventory transaction date from the PartTran table.

It also has links to the CustXPrt, Customer, and Part tables in order to show the Customer name, Customer Part Number and SearchWord.

The BAQ could easily be used in a dashboard instead of a BAQ CR for even more flexibility. In fact, I was planning on making a dashboard from it.

If this is what you are looking for, I could send it to you.

Lynn



--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> Does anyone have a slow moving inventory report written that they
> would be willing to share? I'm on version 8.03.405A.
>
>
>
> Thanks,
>
>
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate@...>
>
>
>
>
>
> [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