Aged Inventory Report

Yahoo Archive
1
if you're not using Lot tracking you can't age a specific part. We lot
track some parts but not all so what we've done is look for parts with
the last parttran activity.

For example, purchased parts the last time it was issued to a job and
manufactured parts, the last time it was shipped to a customer. So, the
report lists onhand by part then a subreport looks for last activity
date. Not a perfect aging but it has worked well for us.

BTW, we're on 6.1

To answer your question on how to get the last date. Group by part then
create a subtotal for the trandate selecting "Max" date. That will give
you the most recent date.

HTH,
Mike Lowe
Connor Manufacturing Services



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of g2hav
Sent: Wednesday, November 29, 2006 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Aged Inventory Report



I need to create an "Aged Inventory" report. Can anyone help?

We are on 8.0.809b SQL/64

My approach is that I would use the Part, PartTran and PartWhse
tables.

Get "ONLY" the last transaction record for each part from the
PartTran table. How do I do this?
Then do a "If then Else" statement to get the records older than 180
days
if yes then "0" Else "1".
Then filter for only the "0" records.

Am I close?
Is there a different way?
Does someone have it already and will share it?

Thank you for any help.

Gerry Haviland
Senior Systems Analyst




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



[Non-text portions of this message have been removed]
2
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]
3
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.)
4
I could also use a report that shows old inventory as requested by Troy
Funte from Liberty Electronics
5
I need to create an "Aged Inventory" report. Can anyone help?

We are on 8.0.809b SQL/64

My approach is that I would use the Part, PartTran and PartWhse
tables.

Get "ONLY" the last transaction record for each part from the
PartTran table. How do I do this?
Then do a "If then Else" statement to get the records older than 180
days
if yes then "0" Else "1".
Then filter for only the "0" records.

Am I close?
Is there a different way?
Does someone have it already and will share it?

Thank you for any help.

Gerry Haviland
Senior Systems Analyst