Material on hand with no demand

Yahoo Archive
1
Could I get this report?



From: Stan Chmura [mailto:schmura@...]
Sent: Thursday, February 12, 2009 8:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Material on hand with no demand



RE: how stock is turning over, have you looked at the Inventory Usage
report?



_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Julie Lehmann
Sent: Thursday, February 12, 2009 8:57 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Material on hand with no demand

Bruce,
I have a 6.1 Report Builder Report that is a listing of parts in
inventory
and shows if there is any demand.
It uses PartWhse.OnHandQty; PartWhse.AllocQty &
PartWhse.JobunfirmAllocQty.
I also include class & cost.
Maybe that would be a start for you?

Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Bruce Ordway
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, February 11, 2009 4:30 PM
Subject: [Vantage] Material on hand with no demand

Hi,

We have quite a few parts that are NOT Non-Stock.
Because of this, we can accumulate inventory.
And, it could sit.

I have been looking for a stock report that might list all inventory on
hand that doeesn't currently have any demand.

Also, looking for something to give me an idea of how stock is turning
over.

Is there an exsting report you use?
If not, any ideas what tables to start looking into for building a
report?

"Stock Status" and "Time Phase Material Requirements" reports give some
insight but not exactly what I need.

Bruce

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

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





[Non-text portions of this message have been removed]
2
Bruce,
I have a 6.1 Report Builder Report that is a listing of parts in inventory and shows if there is any demand.
It uses PartWhse.OnHandQty; PartWhse.AllocQty & PartWhse.JobunfirmAllocQty. I also include class & cost.
Maybe that would be a start for you?

Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Bruce Ordway
To: vantage@yahoogroups.com
Sent: Wednesday, February 11, 2009 4:30 PM
Subject: [Vantage] Material on hand with no demand


Hi,

We have quite a few parts that are NOT Non-Stock.
Because of this, we can accumulate inventory.
And, it could sit.

I have been looking for a stock report that might list all inventory on
hand that doeesn't currently have any demand.

Also, looking for something to give me an idea of how stock is turning
over.

Is there an exsting report you use?
If not, any ideas what tables to start looking into for building a
report?

"Stock Status" and "Time Phase Material Requirements" reports give some
insight but not exactly what I need.

Bruce





[Non-text portions of this message have been removed]
3
RE: how stock is turning over, have you looked at the Inventory Usage
report?



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Julie Lehmann
Sent: Thursday, February 12, 2009 8:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Material on hand with no demand

Bruce,
I have a 6.1 Report Builder Report that is a listing of parts in inventory
and shows if there is any demand.
It uses PartWhse.OnHandQty; PartWhse.AllocQty & PartWhse.JobunfirmAllocQty.
I also include class & cost.
Maybe that would be a start for you?

Julie
Mercury Minnesota Inc.

----- Original Message -----
From: Bruce Ordway
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Wednesday, February 11, 2009 4:30 PM
Subject: [Vantage] Material on hand with no demand

Hi,

We have quite a few parts that are NOT Non-Stock.
Because of this, we can accumulate inventory.
And, it could sit.

I have been looking for a stock report that might list all inventory on
hand that doeesn't currently have any demand.

Also, looking for something to give me an idea of how stock is turning
over.

Is there an exsting report you use?
If not, any ideas what tables to start looking into for building a
report?

"Stock Status" and "Time Phase Material Requirements" reports give some
insight but not exactly what I need.

Bruce

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



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

We have traditionally tracked our inventory in three groups where
there is little or no demand from Jobs or Sales Orders categorizing
it as 'slow moving', 'obsolete' and 'excess'. This was a manual
process and prone to error until we created several SQL routines to
programmatically identify the parts in our Plant's inventory that met
this criteria. The routines run nightly and set two UD Checkboxes
and a UD Number field on the PartPlant table based on the results.
These fields can then be viewed in Dashboards, Reports or UI
Customizations.

The SQL scripts are a little long for posting here but I would be
happy to send them to you. If you are interested, please contact me
directly.

Nathan Bonner
Business Systems Analyst
Total Plastics, Inc.
269.553.5838 (Office)
269.344.0711 (Fax)
bonner.n@...





--- In vantage@yahoogroups.com, "Julie Lehmann" <jlehmann@...> wrote:
>
> Bruce,
> I have a 6.1 Report Builder Report that is a listing of parts in
inventory and shows if there is any demand.
> It uses PartWhse.OnHandQty; PartWhse.AllocQty &
PartWhse.JobunfirmAllocQty. I also include class & cost.
> Maybe that would be a start for you?
>
> Julie
> Mercury Minnesota Inc.
>
> ----- Original Message -----
> From: Bruce Ordway
> To: vantage@yahoogroups.com
> Sent: Wednesday, February 11, 2009 4:30 PM
> Subject: [Vantage] Material on hand with no demand
>
>
> Hi,
>
> We have quite a few parts that are NOT Non-Stock.
> Because of this, we can accumulate inventory.
> And, it could sit.
>
> I have been looking for a stock report that might list all
inventory on
> hand that doeesn't currently have any demand.
>
> Also, looking for something to give me an idea of how stock is
turning
> over.
>
> Is there an exsting report you use?
> If not, any ideas what tables to start looking into for building
a
> report?
>
> "Stock Status" and "Time Phase Material Requirements" reports
give some
> insight but not exactly what I need.
>
> Bruce
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
> We have traditionally tracked our inventory in three groups where
> there is little or no demand from Jobs or Sales Orders categorizing
> it as 'slow moving', 'obsolete' and 'excess'.

FWIW, Epicor 9 has a formal Slow Moving/Obsolete reporting system.

Mark W.