I agree. I have tested this using items that are active in more than one
facility. When the facility field is blank, the data is obtained from IIM
item master. When it is populated, the data is obtained from files that
spell out facility. We also have to be careful with combination places ...
enter a warehouse that is valid for the facility, for example.

We can use RUNQRY *N name of file F4 ... there's an option to select records
... we have put CL for this on a BPCS menu, so we can rapidly view selected
contents of any file interactively, without bothering the users with
parameter choices. It then becomes practical to compare raw data with what
various programs are saying, without getting into the source code, which for
INV300 is pretty humongous.

However, sometimes data in different BPCS files can get out of
synchronization, with each other.

We do certain reorganizations on a regular basis, for force detail info
summarized into summary files. This has been controversial on this list. I
believe the out of sync is due to some BPCS programs not doing a good job
with some fields driven negative, some bugs in BPCS, and user update
programs crashing then they restart the job, instead of doing any recovery.
Also some reorg is buggy. If the detail files happen to be zero contents,
some programs do nothing, leaving a non-zero value in some summary files.

Have you ever used F1-help key for information about the various fields on
screen, to see what it says from a cursor location sensitive perspective?

Do you have access to BPCSDOC on your system, and is it any help?
We have inserted text into our BPCSDOC to expand what came with BPCS.

Al Mac
-----Original Message-----
From: bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+macwheel99=wowway.com@xxxxxxxxxxxx] On Behalf Of Don
Sent: Friday, April 16, 2010 2:18 PM
To: bpcs-l@xxxxxxxxxxxx
Cc: Tom Maresh
Subject: [BPCS-L] 405cd - IIM Inquiry - MTD and YTD fields

I can't remember if I ran this by the group before. It has to do with
whether or not I leave the facility field blank on INV300, and which
files/fields the program subsequently uses to figure the MTD and YTD

I have some notes written down - but don't know if they are accurate? My
note says that if I leave the facility code blank, the MTD and YTD fields
COME RIGHT FROM the IIM file itself. However, if I fill in a facility code,
the MTD and YTD data which shows on the screen actually comes from the ILI
and IWI files instead.

We are getting different numbers (on some part numbers) when alternating
inquiries between the blank and the filled in facility codes??

Don F. Cavaiani
IT Manager
Amerequip Corp.

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman

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