This can vary with BPCS version, how you have setup your BPCS, and what else
you want to do with the query.

In our case, with multi-facility on 405 CD, where each facility is either a
plant (factory) and/or a system of product distribution (e.g. purchase for
resale), we might use the CIC file which has cost summaries and MRP planning
data for each combination of item and facility.

We have problems with "inactive items" where the management and staff has
been unable to reach a consensus regarding disposition of items whose
business has dried up, which have no inventory on-hand, no orders, no recent
activity. To eliminate such items from a report, I use YTD and MTD totals
in IIM file, and sometimes in EOY reports use SQL to search ITH and archived
files from prior years. This can also eliminate items which are "inactive"
because they are brand new, so maybe look at BOM (MBM file) or routings (FRT
file) or elsewhere for a date of last activity.

Note that while ITE file sets rules for dates of last activity, there are
bugs in some BPCS programs which disregard the rules for last activity
tracking. For example, we changed ITE to not update last activity for a
cycle count correction, or physical inventory correction. BPCS physical
inventory software ignores that request.

Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of
Sent: Thursday, December 16, 2010 7:52 AM
To: David.ANTONISSE@xxxxxxxxxxxxxxx
Cc: jminto@xxxxxxxxxxx; dick.bailey@xxxxxxxx; bpcs-l@xxxxxxxxxxxx;
Subject: Re: [BPCS-L] Query


Something happened to your subscription to the bpcs-l list. Please
resubscribe at
Please do not forward general list type questions on to individual

I'm sure that, at that time, we're all looking forward to offering you

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2021 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 [javascript protected email address].

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