Smartlist of or Modifying Computer Checks Edit List

(0) Share

Report

Posted on by Kyle Hoffman

Is there any way to create a smartlist of the information in a Computers Checks Edit List before the checks are run? Also is there a way or a report that will include the Document Number of the invoice instead of the or in addition to the voucher number of an invoice that is marked to be paid?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sunbeam De Jesus on at

Like (1)

Report

Hi,

Existing Smartlist I am afraid theres none, but lets see what others may say.

But you can build your own smartlist using smartlist builder, use table PM10300 header and PM10100 Distribution. This table contains unposted transaction in check run.

How to add Doc number...

https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYLSVQUSPTNTNSMQPYZOTPQTMQMPMKOWSZMWYLOYMYLXPSKXQKLOWZKKLWYTSTYPRXMMQMMNRYROVXYKLT

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

what is the procedure specific to the "Computer Checks Edit List" report via Payables Management?

Was this reply helpful? Yes No
Kyle Hoffman 45 on at

Like (0)

Report

Thanks for the reply. I will give the smartlist builder a try. As for the link about adding the document number, I currently to not have access to customersource. I am working on getting a logon setup. Is there any way you could reply with the information in the knowledgebase article?

Was this reply helpful? Yes No
Kyle Hoffman 45 on at

Like (0)

Report

After a batch is built for computer checks, a Computer Checks Edit List is run to then match up the invoices being paid from this edit list to the actual copies of the invoices. The actual copies do not have the voucher number which makes it difficult to do quickly. That is why the document number is needed on the report because the document number is written on the actual copies of the invoices we are matching to the edit.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

I believe you're going to find that the check selection process stores records in a Temp table that you won't be able to query on. If the checks are printed but not posted, then they would appear in the PM10300 table.

I could be wrong but my recollection tells me this is so . . .

Was this reply helpful? Yes No
Victoria Yudin 22,769 on at

Like (1)

Report

I personally hate the Check Edit List that prints out-of-the-box, I just don't understand why one check has to take half a page...so I have made my own 'replacement' Crystal report for it. My report uses the PM10201, PM10300 and PM20000 tables. Depending on the fields you want to see, if using Multicurrency, you'd need to add the MC20103 table.

Was this reply helpful? Yes No
Marshall Hudnall 30 on at

Like (0)

Report

I know this is old and not sure if anyone is still looking for something like this but here is what I found to do exactly this.

https://support.microsoft.com/en-us/help/912953/how-to-add-the-document-number-and-the-document-due-date-from-invoices

Was this reply helpful? Yes No