Peter,
If you have integrator, you will have to create the field on the item
warehouse object that is the total lead time .
Attribute tab
Create
On the general tab--build the logical expression
by selecting the fields you want to add together
(<PUR&+<REV& ,,,,,, etc)
Once you add the field you can use it in a view or subset.
Regards,
From: Peter_Vidal@xxxxxxxx
To: mapics-l@xxxxxxxxxxxx
Date: 08/17/2011 02:53 PM
Subject: [MAPICS-L] How to setup a SUBSET to filter a single value
of (A+B+C+D) instead individually
Sent by: mapics-l-bounces@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
This message and any files transmitted with it contain privileged and confidential information. This message is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, copying, or exploitation of, or taking any action in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender by email reply and delete this message from your system. Thank you.
midrange.com
