Re: System 21 - System 21 advance pricing

Hello Gary,
Many many thanks.
Regards,
Anuj Gupta

On Wed, Jun 2, 2010 at 4:12 AM, Gary Brown
<gary.brown-amAT3M5DVhYyHzeer08dnFaTQe2KTcn/@public.gmane.org>wrote:

> 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.
>
>
_______________________________________________
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.