Re: PO Line Items

Or you could simply link PMP09 to PLP15 and check BBAL15 to BTMT15. 

If BBAL15 = PTMT15 it hasn't been paid.
If BBAL15 = 0 then it has been paid in full.
If BBAL15 <> 0 and <> PTMT15 it has had a part payment.

Accessing PLP50 will get you the check number and date of payment.

Richard Caldicott
Director of Implementations
& Efficiency
Tandy Brands Accessories
817-548-0090 extn 146



DBarry@xxxxxxxxxxxxx 
Sent by: system21-bounces@xxxxxxxxxxxx
12/21/2006 09:10 AM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
System 21 Users <system21@xxxxxxxxxxxx>
cc
system21@xxxxxxxxxxxx, system21-bounces@xxxxxxxxxxxx
Subject
Re: [SYSTEM21] PO Line Items






Bill,

You need to link the following files to accomplish this

PMP09  to PLP50 by company and Invoice number to document reference
PLP50 to PLP45 by payment reference number and select only payment status 
code of '15' 


Dave Barry
Programming Manager
Dawn Food Products, Inc.
(517) 780-4354




Bill.Geissinger@xxxxxxxxxxxxxxxxx
Sent by: system21-bounces@xxxxxxxxxxxx
12/21/2006 09:39 AM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
system21@xxxxxxxxxxxx
cc

Subject
[SYSTEM21] PO Line Items






For each PO line, I need to determine whether it has been paid or not - 
not whether it has been invoiced, but paid.  How can I do that?


The information contained in this email, including attachments, is 
confidential and may be legally privileged and protected from disclosure 
by the Electronic Communication Act, 18 U.S.C. 2510-2521. It is intended 
solely for the addressee(s), and if the reader is not the intended 
recipient, you are hereby notified that any access, use, reproduction, 
disclosure or dissemination of this communication by anyone is strictly 
prohibited. Any action taken or omitted to be taken in reliance on this 
email is prohibited and may be unlawful. Neither Hutchinson Sealing 
Systems Inc., the Hutchinson Group nor any of its subsidiaries shall 
assume legal liability or responsibility for any incorrect, misleading or 
altered information contained herein. If you have received this message in 

error, please notify the sender immediately by replying to the email and 
deleting it from your computer.
_______________________________________________
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 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.