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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.