Re: 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.