|
Bottom Line: Poor design (IMHO). For what it's worth, the structure of the Item Warehouse Inventory file (IWI) is such that customer order and shop order demand is combined into one field (WCUSA - Allocated to Orders), not separated out like it is in the Item Master (IIM) - ICUSA and IPRDA. This is why MSI runs home to IIM to get the data (it can't diferentiate at the IWI level). The design is silly because almost nobody cares about data like this at the GLOBAL level unless you have only one whse. If you're actually using BPCS, the data is misleading at best. You have to get to the source of the demand (detail files) before the info is meaningful. Go back to ECL and FSO - these files will give you the basis of what you're looking for. If you have v6.0.04 or v6.1 and are full client/server, hide the fields in MSI and you'll avoid the questions. I've heard of companies rewriting the logic to sum these MSI values from detail records so that they can be filtered by whse, but performance would surely suffer. Devin +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
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 [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.