Obsolete or slow moving inventory report

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
----- 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]
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]
Dear All,
We have been struggling with this one for the last 6
months as well and I couldn't get Report
Builder/Crystal to do what I wanted. Eventually we
started downloading the transaction history records
for stk-mtl issues each month into separate pages in
an xl spreadsheet. Then we download the stock status
report into a different page at the end of each month
and use a really horrendous set of lookup tables to
find out what hasn't moved over 6/12 months and class
it as excess or slow moving inventory according to its
movements.

Don't know if this helps?

If anyone has a better solution it would be much
appreciated here also.


Mike Kerwin

Business Support Manager
Cooper Crouse-Hinds(UK)Ltd

mike.kerwin@...
+44 (o)1795 586339



--- Amy Mackay <amackay@...> wrote:
> 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
> ---------------------~-~>
> Make good on the promise you made at graduation to
> keep
> in touch. Classmates.com has over 14 million
> registered
> high school alumni--chances are you'll find your
> friends!
>
http://us.click.yahoo.com/n4HqaC/DMUCAA/4ihDAA/P0AVlB/TM
>
---------------------------------------------------------------------_->
>
> 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
> http://docs.yahoo.com/info/terms/
>
>


____________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.co.uk
or your free @... address at http://mail.yahoo.ie
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]