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
(&LTPUR&+&LTREV& ,,,,,, 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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.