Re: GRN referencing explanation, please

["OleBlighty" <oleblighty@xxxxxxxx>]

Dan,

After accessing the INP95, just take positions 8 through 14 of the reference
number (REFN95) and access the PMP09 record by Company, Item and GRN number,
this will give you the PO and Advice Note Number.  If my memory serves me,
you may get multiple hits if you are using Lot/Serial controlled item.  If
this is the case, the lot/serial number on the INP95 record (LOCN95)
corresponds to the PMP09 Internal Reference No (sorry, can't remember the
field name but it's a field about two thirds of the way into the file field
list!!!).

The GRN no. is a system issued unique number per order/receipt.  It is used
to link receipt lines together in the same way as the event number is A/R or
A/P.

Hope this helps a little.

Regards,

Mark.

----- Original Message -----
From: Dan Bale <dbale@genfast.com>
To: <JBAUSERS-L@midrange.com>
Sent: Wednesday, September 29, 1999 8:57 AM
Subject: GRN referencing explanation, please


>
>
> Could someone provide a definition of the GRN value?  In PMP09, it is
field
> GRNO09.  In INP95, the GRN is (for those records where TRAN95='P')
referenced in
> field REFN95 in the format "GRN NO nnnnnnn" where nnnnnnn appears to be a
> sequence number unique by stockroom, item number, and purchase order.
>
> Or put another way, since there is no P.O. number in INP95, I need to tie
a
> purchase receipt transaction in INP95 back to PMP09 in order to get the
P.O.
> number.
>
> TIA,
> Dan Bale
>
>
>
>
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---