Re: System 21 - System 21 advance pricing

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 <anujgupta17@xxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
01/06/2010 04:50 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
System 21 Users <system21@xxxxxxxxxxxx>
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.