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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2021 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.