Re: Database help, Accounts Payable.

Hi Jim,

As Nick said, it's PLP20.  Try to match it with CSP20.

Regards,

Teresa Dionisio
Allegro Mfg. Inc.
323-724-0101 ext 4327
Fax 323-722-7341
teresa@xxxxxxxxxxxxxx <mailto:teresa@xxxxxxxxxxxxxx> 


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of
system21-request@xxxxxxxxxxxx
Sent: Thursday, September 14, 2006 10:00 AM
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 4, Issue 95


Send SYSTEM21 mailing list submissions to
        system21@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
        system21-request@xxxxxxxxxxxx

You can reach the person managing the list at
        system21-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."


Today's Topics:

   1. [SYSTEM21] Datebase help, Accounts Payable. (Jim Kerr)
   2. Re: [SYSTEM21] Datebase help, Accounts Payable. (Adams, Nick)


----------------------------------------------------------------------

message: 1
date: Wed, 13 Sep 2006 19:35:15 -0700
from: "Jim Kerr" <JKerr@xxxxxxxxxxxxxxxxxxxxxx>
subject: [SYSTEM21] Datebase help, Accounts Payable.

I hope someone can point me in the right direction. I am trying to put
together a query to retrieve AP information. 

 

I am trying to get invoices and their payment transactions tied together.
How does a payment transaction (PLP20) match up with a an invoice
transaction ? Is it through Cash Manager ? 

 

Thanks in advance. 

 

Jim.

 



------------------------------

message: 2
date: Thu, 14 Sep 2006 08:38:38 +0100
from: "Adams, Nick" <Nick.Adams@xxxxxxxxxxxxxxxxxxxxxxx>
subject: Re: [SYSTEM21] Datebase help, Accounts Payable.


Jim

The Payment and invoices are related on PLP20, The allocation of a
payment to invoices is through master Transaction type of AL

To get the allocations of a payment you would select:
Etype20 = 'PY'
Lref20 = The payment reference number which will be the same in AP, CM
and GL

The Mtyp20 shows allocation (AL)
The Tref20 will show the original AP reference number and the ttyp20 the
original transaction type.

Hope this helps

Nick
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Jim Kerr
Sent: 14 September 2006 03:35
To: 'System 21 Users'
Subject: [SYSTEM21] Datebase help, Accounts Payable.

I hope someone can point me in the right direction. I am trying to put
together a query to retrieve AP information. 

 

I am trying to get invoices and their payment transactions tied
together.
How does a payment transaction (PLP20) match up with a an invoice
transaction ? Is it through Cash Manager ? 

 

Thanks in advance. 

 

Jim.

 

_______________________________________________
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) digest 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.



End of SYSTEM21 Digest, Vol 4, Issue 95
***************************************