V6.1 Slow Moving/obsolete report

Yahoo Archive
1
Using the PartTran table, I selected records which did not include
significant transactions (PartTran.TranType <> "STK-STK", "QTY-ADJ", etc..).
I then created a parameter which selected records older than an input date.
From there I grouped the records on part number, and selected the greatest
PartTran.TransDate to display as the last transaction date with in that
group.



I used this report to find "dying" inventory. To take it a step further,
dead inventory gets zeroed out, so I added a filter to include only parts
with value greater than 0.



Hope this helps,



Bruce Butler

<mailto:bbutler@...> bbutler@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike McGee
Sent: Monday, January 14, 2008 11:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1 Slow Moving/obsolete report



Good morning all,

Has anyone found or created a good report for slow moving and obsolete
inventory on V 6.1?

Mike McGee PH: 931-432-1853

Materials Manager Fax: 931-432-1889

Flexial Corporation mmcgee@... <mailto:mmcgee%40flexial.com>

1483 Gould Drive www.flexial.com

Cookeville TN, 38501

NOTICE: This e-mail, including any attached files, is the property of
Flexial Corporation and as such may be legally privileged and is solely
for the intended recipient(s). Any unauthorized use, dissemination,
disclosure, copying or printing of this e-mail, or any attached file,
without the permission of Flexial Corporation is strictly prohibited.

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





[Non-text portions of this message have been removed]
2
Good morning all,



Has anyone found or created a good report for slow moving and obsolete
inventory on V 6.1?



Mike McGee PH: 931-432-1853

Materials Manager Fax: 931-432-1889

Flexial Corporation mmcgee@...

1483 Gould Drive www.flexial.com

Cookeville TN, 38501



NOTICE: This e-mail, including any attached files, is the property of
Flexial Corporation and as such may be legally privileged and is solely
for the intended recipient(s). Any unauthorized use, dissemination,
disclosure, copying or printing of this e-mail, or any attached file,
without the permission of Flexial Corporation is strictly prohibited.







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