PM Check remittance errors

(0) Share

Report

Posted on by Jason Buckingham

1,340

Does anyone have a recommendation as to why we are randomly experiancing checks printing with old invoices on the remittance.

The check may be cut against one invoice and the remittance will print that invoice and another old invoice that is not applied to the payment?

I am thinking there may be a data corruption or duplicate numbers in the system somewhere.

Any ideas where to start?

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Jason, I would take one of the examples where an old invoice is on the remittance and check the Payables Apply tables (PM10200, PM10201, PM30300) to see if the payment is actually showing applied to the old invoice in any of those tables. If not, then it may be a report issue. Is the remittance report the original or has it been modified?

Hope this helps,

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

Like (0)

Report

Do you have "Print Previously Applied Documents on Remittance" checked on the Payables Management Setup window? If so, that may (correctly) result in what you are describing. Excerpt from my book:

"Print Previously Applied Documents on Remittance: If this option is checked, any check printed will show all payments and credit memos applied since the last check was printed for the same vendor. For example, if a check is printed, then a wire transfer is entered and a credit memo is applied for the same vendor, the next check to this vendor will show the apply detail for the wire and the credit memo on the check stub.

What setting to choose for this may depend on how your company typically pays vendors. If it is primarily by check, you may want to leave this checked. If it is a combination of payment methods, you may decide to leave this unchecked in order to not clutter up check stubs and create confusion for your vendors."

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

Like (0)

Report

Cool Victoria. I learn (or am forced to recollect - lol) something new every day . . .

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Yep,

Victoria is, as usual, right on the money. That would be my guess as well.

Kind regards,

Leslie

Was this reply helpful? Yes No
Rita C. 820 on at

Like (0)

Report

Hello,

I am having this very same issue. My Payables set up is to print "Invoices Only" and my "Print Previously Applied Documents on Remittance" is NOT checked. However.....I'm getting historical documents on my Remittance. And a remittance is printing....even though I'm only paying 3 invoices. This is an intermittant issue. We cannot narrow it down to any particular vendor. This is occurring in a company that has a very high volume of payables. It's become quite the issue. Do you have any other suggestions?

Anything you can provide would be greatly appreciated.

Thank you

Rita C

Was this reply helpful? Yes No
Jason Buckingham 1,340 on at

Like (0)

Report

Hello Rita,

If my memory serves me correct, we found that there was a corrupt record in the PM30300 table in my case. Since this issue was reported, and I had resoved it, we have switch support software and I no longer have the details of this case. Sorry I could not be too much help on this one.

Was this reply helpful? Yes No
Rita C. 820 on at

Like (0)

Report

Thank you for responding Jason.

I'm going to review my tables to see if anything pops out.

Was this reply helpful? Yes No
Kimberley Stevens 720 on at

Like (0)

Report

Hi Rita,

Did you ever get a resolution to this? I have a client with the same issue.

Cheers!

Kimberley

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

When you look at which documents are printing, that shouldn't be, do they relate in any way to the voucher being paid? Was something recently applied involving that document. Did they start life as a credit memo or pre-payment?

Kind regards,

Leslie

Was this reply helpful? Yes No
Rita C. 820 on at

Like (0)

Report

Hi! Yes...it's a temporary fix, but its been working for us.

I run a script as the AP girl notices that there are a lot of credits being applied in the Edit Check window.

DELETE PM20100

WHERE VendorID = 'VendorID'

AND KeySourc = 'REMITTANCE'

/* The following code is used to remove all zero dollar remittances. */

DELETE PM20100

WHERE KeySourc = 'REMITTANCE'

hope that helps you!!

Rita

Was this reply helpful? Yes No