I used to get the check number related to a paid invoice by bringing back the "Applied to Doc No." using the document number of the invoice.
Since we converted to RTC, this jet report function no longer brings back the check number. Does any one know how to tie the invoice number to the check number? Its hard, for me, to figure out in RTC or Classic view how it now works.
Date
Votes
1 comment
-
Jet Reports Historic Posts I think the key is to look at the Detailed Vendor Ledger table, which has a field called Vendor Ledger Entry No. The total of all fields with the same Vendor Ledger Entry No. should be zero when a payment has fully paid an invoice. The Document Type and Document No. fields show that something is (1) an invoice and the PPI number or (2) the payment and check number.
Where it gets more tricky is that the GL contains the GL Accounts that have been charged, but the Detailed Vendor Ledger table contains the link between the check and the expense. The best method is probably determined by how the client wants to run a report. Do they want to enter a check number and see all the related info or do they want to enter an invoice and see which check(s) paid for it? Or do they want to see all activity for a specific vendor?
Now that I look at this a little more closely, I remember that the Vendor Ledger Entry No. in both the Vendor Ledger and the Detailed Vendor Ledger tables is the same number used in the GL. In the example below, the Vendor Ledger table shows record number 37581, which is the same number used in the GL and in the Detailed Vendor Ledger table. That’s your link.
[See the attachment for a screenshot showing some transactions and how they are related.]
- Zac
Please sign in to leave a comment.