• Subject: Re: PMP09 - Purchase Transactions file questions
  • From: "OleBlighty" <oleblighty@xxxxxxxx>
  • Date: Thu, 2 Dec 1999 17:41:33 -0800

Dan,

As an alternative to using PMP09 you can use INP95 looking at transaction
type (TRAN95) of 'P' for receipts (also look for code 'R' if you are using
Direct Deliveries).  This file does not contain the Vendor number but it
does contain the GRN in field REFN95 so you can easily access the order line
details.  I like this file because it contains not only the receipt quantity
and cost but both the date entered on the system (REFD95) and the date keyed
as the "receipt date" by the user (DTMV95).

If you use INP95 then you don't have to worry about multiple records in
PMP09 for the same order line (partial receipts) and flags such as the
receipt required (RYRN09).  To know what has actually been recieved by
looking at PMP09 you need to look at the Transaction Quantity (TQTY09) being
greater then Zero.  The receipt date on the record will be the date the user
keyed in.  Those PMP09's you see with a future receipt date will be for
lines not yet received.

If the report is only for receipts that have been Invoice Matched for then
you must use PMP09 as the driver.

As I say, just my opinion, but I would drive off the INP95 file.

Let me know if you need any assitence.

Regards,

Mark.

----- Original Message -----
From: Dan Bale <dbale@genfast.com>
To: <JBAUSERS-L@midrange.com>
Sent: Thursday, December 02, 1999 11:14 AM
Subject: PMP09 - Purchase Transactions file questions


>
>
> I have been asked to produce a report of the "top ten suppliers" by
dollars,
> Y-T-D.  I am using the Purchase Transactions (PMP09) file to retrieve the
> receipt quantity and price, multiplying these two to get total dollars.
>
> Unfortunately, my understanding of how this file is used is limited.  I am
> seeing transactions with the receipt date in the future.  What do I need
to
> check to see if this item has _actually_ been received?
>
> Also, what date would you recommend using to select for Y-T-D?
>
> Thanks!
>
>
>
>
>
> +---
> | 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.
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].