Re: System 21 - System 21 advance pricing
Gary Brown <gary.brown-amAT3M5DVhYyHzeer08dnFaTQe2KTcn/@public.gmane.org>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <OF747A64DE.49B5A232-ONCA257735.007C3967-CA257735.007CB1ED@appliedaustralia.com> |
Hi Anuj,
The file that hold the customers linked to a group is OEP19
We used the following query to list of customers linked to a group
CONO19 EQ 'Z1'
AND PRTP19 EQ 'CSP'
AND ITMG19 EQ 'SP1'
PRTP19 is the pricing type from the first screen
ITMG19 is the customer group
regards,
Gary Brown
IT Manager
Applied Australia Pty Ltd
Anuj Gupta <[email protected]>
Sent by: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
01/06/2010 04:50 PM
Please respond to
System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]>
To
System 21 Users <system21-Zwy7GipZuJhWk0Htik3J/[email protected]>
cc
Subject
[SYSTEM21] System 21 - System 21 advance pricing
Hello Dear,
Could anyone please help us on it?
In System21 I am trying to get a list of customers who use Customer Group
\\"DT\\". The only file I can find which shows Customer Group is in OEP16
but it appears that if there is a Customer Group record there is no
account
details - refer screen print of file below. If this is the case what is
the
\\"link\\" between OEP16 & SLP05 / OEP20?
Thanks in advance.
Anuj Gupta
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.