By the way, the file is so large (over 1MB zipped), because I saved some data with the report. That way you can fiddle with it and see what it does without waiting 2 hrs for it to run the first time. Also, I saved it as a Crystal version 7 report.
Troy
Troy
----- Original Message -----
From: Troy Funte
To: Vantage
Sent: Saturday, March 24, 2001 10:35 PM
Subject: Re: [Vantage] Obsolete or slow moving inventory report
I just uploaded a file that we call Inventory Aging Report. This is designed for Vantage 3.0.
This report shows parts that have had no "valid activity" in a past time period.
TIME PERIOD: The time period is specified by the seed date entered by the user and shown at the top of the report.
VALID ACTIVITY: A Valid Activity is any inventory transaction (PartTran.TranType) that is not one of the following: stk-stk, adj-qty or adj-cst. (since these transactions don't actually move inventory anywhere, we didn't consider them 'activity'.)
This report takes a LONG time to run, as it has to peruse 145,000 transactions in our case. PartTran is a huge table. If you happen to be fortunate enough to not have parts in more than one bin location, you can speed this baby up by using the PartBin.OnHandQty field, instead of a subreport to gather the OnHandQty's from multiple bins.
Designed using Vantage 3.0 database tables and fields. You may need to adjust things for Vantage 4.0 or 5.0, I don't know.
Troy Funte
Liberty Electronics
P.S. Disclaimer: If you throw away a perfectly good and usable part because this report said it was obsolete, I take no credit or blame. If your controller says this report is a piece of junk, I take no credit or blame. If you get a promotion and a raise because your boss thinks this is the best piece of programming work he/she has ever seen, then I'll take 10% :-)
----- Original Message -----
From: Amy Mackay
To: 'Egroup'
Sent: Tuesday, March 20, 2001 3:19 PM
Subject: [Vantage] Obsolete or slow moving inventory report
Does anyone have a report they are willing to share that would accomplish
the following?
I want to see parts that we have on hand that have not had inventory
transactions against them this year ( trandate < 1/1/01).
I've used the PartBin table linked to the PartTran table, but I'm missing
something. If a part has a transaction in '99 AND in '01, I do NOT want to
see the record at all. I ONLY want to see records of current inventory
parts that ONLY have transactions prior to 1/1/01. Attached is an extremely
rough version of what I've started with a few extra fields to help me
troubleshoot. No luck yet.
Any help would be greatly, greatly appreciated. Thank you.
Amy T. MacKay
Parkinson Technologies
amackay@...
(p) 401-762-2100 x 324
(f) 401-762-2295
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Click Here to Find Software Faster
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Click Here to Find Software Faster
To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]