RE: Query Help

The PO notes are stored in file 'ESN'. Use SNTYPE = 'P' and SNCUST = PO# to
list notes for a given PO in query.
Regards ................ Parry 

>       Parry Sidhu
>       IT Manager
>               ABS Pumps Limited
>               Elm Park Court
>               Tilgate Forest Business Centre
>               Brighton Road, Crawley
>               West Sussex  RH11 9BP
> 
>               Tel :           +44 (0)1293 744800
>               Direct Dial :   +44 (0)1293 744814
>               Fax :           +44 (0)1293 543392
>               Mobile :                +44 (0)7802 502246
>               E-mail :                parry.sidhu@xxxxxxxxxxxx
> 
>               Visit us at     www.abspumps.com
> 


-----Original Message-----
From: Higgins, Shaun [mailto:HigginSH@xxxxxxxxxxxxxx]
Sent: 29 December 2003 19:17
To: 'bpcs-l@xxxxxxxxxxxx'
Subject: Query Help


I can not  find a way to pull the PO note field into my queries. 
Has anyone had similar problems ? Solution ?

Shaun Higgins



_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.


**********************************************************************
This email message has been checked for the presence of 
computer  viruses
**********************************************************************