How to setup a SUBSET to filter a single value of (A+B+C+D) instead individually
Peter_Vidal-/[email protected]
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <OF8F576A33.6E1072F3-ON852578EF.006C3BAE-852578EF.006D3A45@pall.com> |
Hi List!!! We are still on R6... I need to create a subset on the ITEM WAREHOUSE that will help me do something like this: WAREHOUSE = (PROMPTED) LEAD TIME CODE = 'M' TOTAL PUR LEADTIME <> 0 However, I am thinking in the possibility of having this new "field" called TOTAL PUR LEADTIME (listed before) and this should be equal to the sum of LTPUR, LTREV, CMTLT, LTADP, LTVEN, LTPAV and LTSAF and then use that field to subset the data. Is this possible in the browser? How I do this? (Embedded image moved to file: pic13290.gif) PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 UC#: 262-2414 | Direct: 727-844-2414 | Fax: 727-815-3120 | www.pall.com "Think like a wise man but communicate in the language of the people." William Butler Yeats (1865 - 1939) -------------------------------------------------------------------------------- Attention: 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 communication. -------------------------------------------------------------------------------- _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.