Check Stub Data - Reprint or Query

(0) Share

Report

Posted on by K Day

7,365

I am looking to find out how to get the data from a prior check stub. I have created a Smartlist Builder report where you can enter a check number and get back the Voucher / Vouchers that were paid by that check, but it doesn't tell me all the information that was printed on the check. For example, the check stub might have some credit memos that were applied to other vouchers that have nothing to do with the check. An example would be if you selected "Apply Unapplied Credit Memos" at the time of building the check batch and you select to print that info on the stub. I feel like it might be the case that report writer is looking at some temp tables when printing the info on the check.

Has anyone done this before? I'm going to look in the Checkbook and the PM tables to see what I can find.

*This post is locked for comments

All responses (1)

Answers (0)

K Day 7,365 on at

Like (0)

Report

Re: Check Stub Data - Reprint or Query

I haven't found the exact script yet, but there is a table called PM80500 and in there is a column called KEYSOURC. For one transaction I was looking for in particular, this KEYSOURC field was populated with the Voucher Number of the payment with an extra 6 tacked on the end. If this field is blank, I supposed that payment was a straight payment for some vouchers. If there is data, then it seems to always be the voucher number with a 6 at the end of it. These all seem to be the ones with the documents that are printed on the stub.