|
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 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.