× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The days on hand figure is a very handy one indeed, wether it is based on
past history or on forecast , or on open orders. In all cases, BPCS has no
native report that does this calculation. It has to be programmed.

The calculation, if it is based on history, will be dependent of what type
of usage in ITH you wish to include. EG; transaction codes B, M, MI, A, etc.

Daniel Warthold P. eng CPIM




----- Original Message -----
From: "Joe McCormick" <joemccormick@xxxxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, February 14, 2006 10:18 AM
Subject: [BPCS-L] Days of cover based on historical usage


Hi,
How can I tell how many days of cover I have for an item (parent or
component) based on historical usage. Eg if I have 10 of item x on hand and
4 were issued to shop orders in the last 50 days then based on historical
usage I have 125 days of cover.
Our forecasting is poor so I need to look at history before committing to
buy stock. I would prefer to dump into excel so that I can sort by days of
cover. We are currently using version 6.1

Thanks

Joe


----------------------------------------------------------------------------
----


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.7/259 - Release Date: 13/02/2006



----------------------------------------------------------------------------
----


> -- 
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: daniel.warthold@xxxxxxxxxxxx
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.