Aged Inventory Report

I could have sworn I played with that report about three weeks ago, but now
that I said I had it I can't find it anywhere for the life of me. My apologies
for getting your hopes up. If I find it I will make sure to post it on the
site. But it sounds like our shipping manager (who requested it in the first
place) does not have it and said that the one I passed on to him "did not work
well" whatever that is supposed to mean. Once again I am sorry.

Oleg Tumarkin
Herker Industries
If anyone has written this report please send it to me as well.

thanks

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, July 20, 2000 11:02 AM
To: vantage@egroups.com
Subject: [Vantage] Aged Inventory Report


Anyone have a report (Crystal or Report Builder) that would show which items
in STK have been there the longest, or even when the last transaction for a
particular part going into Stock happened?

We suspect there have been parts sitting around for years that we want to
clear out and write off. We'd like Vantage to find them.

Troy Funte
Liberty Electronics



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


------------------------------------------------------------------------

Need technology solutions for your business? Respond.com can help.
Just tell us your IT needs. We'll bring the right providers to you
http://click.egroups.com/1/6324/13/_/411782/_/964108950/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Please include me on the list for this report. Thanks!!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


Anyone have a report (Crystal or Report Builder) that would show which items
in STK have been there the longest, or even when the last transaction for a
particular part going into Stock happened?

We suspect there have been parts sitting around for years that we want to
clear out and write off. We'd like Vantage to find them.

Troy Funte
Liberty Electronics



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


------------------------------------------------------------------------

Need technology solutions for your business? Respond.com can help.
Just tell us your IT needs. We'll bring the right providers to you
http://click.egroups.com/1/6324/13/_/411782/_/964108950/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

------------------------------------------------------------------------
Great brand name shoes at Zappos.com.
Click Here!
http://click.egroups.com/1/7060/13/_/411782/_/964111782/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Please include me also.

Marvin R. Myers
Computer Systems Engineer
marvin@...





At 09:57 AM 07/20/2000 -0700, you wrote:
>Please include me on the list for this report. Thanks!!
>
>Kimberly Maxwell
>Westwood Precision, Inc.
>PH: 425-347-1303 Ext. 41
>Fax: 425-353-8945
>email: kimberly.maxwell@...
>www.westwoodprecision.com
>
The report can be done in report builder, but granted their is a long
"crunch time" (around 10 minutes). It all depends on much you filter the
PartTrans table. You will need the following tables: Part - PartWhse -
PartBin - PartTrans (all with inner-joins).

My suggestion : when building this report put every table on a seperate
group.

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: John [SMTP:JYohann@...]
> Sent: Thursday, July 20, 2000 2:27 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Aged Inventory Report
>
> Troy, (and others)
>
>
> I was asked to produce just this very report a few weeks back. I tried
> running it in Report Builder and Crystal but both crashed after a long
> period of crunching data. My solution was this: Export the required
> tables
> from Progress to a SQL server database and then write queries and reports
> in
> MS Access to crunch the data. We got what we wanted in a few minutes.
> SQL
> server is much faster when building reports using views. If anyone would
> like more info on how this was accomplished drop me an email off list.
>
> John Yohannan
> Bracalente Mfg.
>
>
>
>
>
> ------------------------------------------------------------------------
>
> Need technology solutions for your business? Respond.com can help.
> Just tell us your IT needs. We'll bring the right providers to you
> http://click.egroups.com/1/6324/13/_/411782/_/964108950/
> ------------------------------------------------------------------------
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
> to
> www.egroups.com, login and be sure to save your password, choose My
> Groups,
> choose Vantage, then choose Files. If you save the password, the link
> above
> will work the next time you try it.)
>
>
>
> ------------------------------------------------------------------------
> Old school buds here:
> http://click.egroups.com/1/7081/13/_/411782/_/964117609/
> ------------------------------------------------------------------------
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
I have Aged Inventory Report, I thought it was available on Onelist website,
but if not e-mail me off the list and I'll send it to you.

Oleg Tumarkin
Herker Industries

On Thursday, July 20, 2000 1:27 PM, John [SMTP:JYohann@...] wrote:
> Troy, (and others)
>
>
> I was asked to produce just this very report a few weeks back. I tried
> running it in Report Builder and Crystal but both crashed after a long
> period of crunching data. My solution was this: Export the required tables
> from Progress to a SQL server database and then write queries and reports in
> MS Access to crunch the data. We got what we wanted in a few minutes. SQL
> server is much faster when building reports using views. If anyone would
> like more info on how this was accomplished drop me an email off list.
>
> John Yohannan
> Bracalente Mfg.
>
> Anyone have a report (Crystal or Report Builder) that would show which items
> in STK have been there the longest, or even when the last transaction for a
> particular part going into Stock happened?
>
> We suspect there have been parts sitting around for years that we want to
> clear out and write off. We'd like Vantage to find them.
>
> Troy Funte
> Liberty Electronics
>
>
>
>
> ------------------------------------------------------------------------
>
> Need technology solutions for your business? Respond.com can help.
> Just tell us your IT needs. We'll bring the right providers to you
> http://click.egroups.com/1/6324/13/_/411782/_/964108950/
> ------------------------------------------------------------------------
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
>
>
> ------------------------------------------------------------------------
> Old school buds here:
> http://click.egroups.com/1/7081/13/_/411782/_/964117609/
> ------------------------------------------------------------------------
>
> We no longer allow attachments to files. To access/share Report Files,
please
> go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
Included me also!

Kathy Hambleton
Electron Energy Corporation



-----Original Message-----
From: Kimberly Maxwell [mailto:kimberly.maxwell@...]
Sent: Thursday, July 20, 2000 12:58 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Aged Inventory Report


Please include me on the list for this report. Thanks!!

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com


Anyone have a report (Crystal or Report Builder) that would show which items
in STK have been there the longest, or even when the last transaction for a
particular part going into Stock happened?

We suspect there have been parts sitting around for years that we want to
clear out and write off. We'd like Vantage to find them.

Troy Funte
Liberty Electronics



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


------------------------------------------------------------------------

Need technology solutions for your business? Respond.com can help.
Just tell us your IT needs. We'll bring the right providers to you
http://click.egroups.com/1/6324/13/_/411782/_/964108950/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

------------------------------------------------------------------------
Great brand name shoes at Zappos.com.
Click Here!
http://click.egroups.com/1/7060/13/_/411782/_/964111782/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)



------------------------------------------------------------------------
Respond.com - Technology Solutions for your Business!
http://click.egroups.com/1/6828/13/_/411782/_/964112330/
------------------------------------------------------------------------

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)