One solution might be the Systems Plus bolt-on application for Mapics.
The application is demand driven (customer or master schedule), retaining
the demand details.
By retaining the demand detail the required supplies (PO and Shop Orders)
can be linked back to the supported demand.
Because a single PO or Shop Order is linked to ALL supported top level
demand several very powerful capabilities are supported.
One is the reporting of all lower level components required by top level
demand - essentially what your user requested.
Another is the calculation of a projected ship date for every demand.
Plus there is a business intelligence component, complete with graphics.
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter_Vidal@xxxxxxxx
Sent: Friday, December 10, 2010 7:55 AM
Subject: [MAPICS-L] How I can determine "real" requirements on REQMTS?
Good morning / afternoon:
An user wants to create a query, reading REQMTS, and he wants to list all
requirements but excluding anything that has to do with forecast. We know
we have available:
RQSOR = 2 propagated requirement
RQSOR = 3 customer requirement (redundant)
RQSOR = 4 blanket customer order (redundant) RQSOR = 6 manual requirement
RQSOR = 7 held customer requirement if RQCID *NE blanks; held manual
requirement if RQCID *EQ blanks RQSOR = 8 dependent requirements RQSOR = A
However, I believe that I may have to bring into the formula additional
fields like RQCID and RQPRT so we can get more definite scenarios to include
Your inputs are really appreciated, as always.
SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203,
New Port Richey, FL 34654-5111
727-844-2414 | Fax: 727-815-3120 | www.pall.com
"Imagination is more important than knowledge"
Albert Einstein (1879 - 1955)
This communication may contain information that is confidential, privileged
and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender immediately
and delete the original, all attachments, and all copies of this
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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.