RE: GRN's

Steve,
I haven't personally done this, but I'd look at logical GRNS, over
PMP09.  Exclude records with blanks in GRNO09.  Find the record per part
with the maximum transaction date?

Hope that works

-----Original Message-----
From: Steve Dodkins [mailto:Steve.Dodkins@xxxxxxxxxxxxxxx]
Sent: Thursday 22 May 2003 10:37
To: 'Jbausers-L (E-mail)
Subject: [SYSTEM21] GRN's


Hi All
 
Does any one know of an easy way to find the last GRN receipt date per
part
number for use in a query which will show slow moving stocks?

Regards 

Steve Dodkins 


  _____  

 IMPORTANT NOTICE This email (including any attachments) 
 is meant only for the intended recipient. It may also contain
confidential
and privileged information. If you are not the intended recipient, any
reliance on, use, disclosure, distribution or copying of this email or
attachments is strictly prohibited. This email is not intended to be
relied
upon by any person without subsequent written confirmation of its
contents.
ebm-ZIEHL (UK) Ltd. cannot accept any responsibility for the accuracy or
completeness of this message as it has been transmitted over a public
network.   Furthermore, the content of this e-mail is the personal view
of
the sender and does not represent the advice, views or opinion of our
company. Accordingly, our company disclaim all responsibility and accept
no
liability (including in negligence) for the consequences of any person
acting, or refraining from acting, on such information prior to the
receipt
by those persons of subsequent written confirmation. In particular (but
not
by way of limitation) our company disclaims all responsibility and
accepts
no liability for any e-mails which are defamatory, offensive, racist or
in
any other way are in breach of any third party's rights, including
breach of
confidence, privacy or other rights. If you have received this e-mail
message in error, please notify me immediately by telephone. Please also
destroy and delete the message from your computer. Any form of
reproduction,
dissemination, copying, disclosure, modification, distribution and/or
publication of this e-mail message is strictly prohibited.  If you have
received this E-mail in error, or suspect that the message may have been
intercepted or amended, please notify ebm-ZIEHL (UK) Ltd on +44(0)1245
468555. 

ebm-ZIEHL (UK) Ltd Chelmsford Business Park, Chelmsford, Essex CM2 5EZ 


 
_______________________________________________
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 transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please
do not read, copy, use or disclose this transmission and please notify
us immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission
from your system.

Although we have taken steps to ensure that this email and attachments
are free from viruses, we advise that in keeping with good computing
practice the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means
of email communications.

_____________________________________________________________________
This transmission and any attachments are confidential and are intended solely 
for the named addressee (s). If you are not the addressee, please do not read, 
copy, use or disclose this transmission and please notify us immediately by 
telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from 
your system.

Although we have taken steps to ensure that this email and attachments are free 
from viruses, we advise that in keeping with good computing practice the 
recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of email 
communications.