RE: [SYSTEM21] Joining PCP62 and INP95

[Chris Payne <CPayne@xxxxxxxxxxxxxxx>]

When I contacted GEAC they recommended that I join on work order number,
unfortunately we make multiple transactions against the same work order so
that does not help uniquely identify a record. Mqty62 does not have the
quantity information I need, aval62 does, but PCP62 is lacking the date that
I need, which as far as I can tell resides only in DTMV95.

Chris 

-----Original Message-----
From: ALlanes@xxxxxxxxxxxxx [mailto:ALlanes@xxxxxxxxxxxxx] 
Sent: Wednesday, August 11, 2004 2:48 PM
To: System 21 Users
Subject: Re: [SYSTEM21] Joining PCP62 and INP95

Chris, have you attempted joining PCP62 and INP95 by works order number? 
You would have to select INP95 records by transaction type (manufacturing 
issue or receipt), where the transaction reference (REFN95) were equal to 
the WO number (WORD62).

Alternatively, have you looked at field MQTY62, to see if it contains the 
data you are seeking?
_______________________________________________
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.