Cannot Find Payables Check in Microsoft Dynamics GP

John Ellis
John Ellis used Ask the Experts™

A Microsoft Dynamics GP 2016 end user is having an issue where she needs to void a check dated 11/21/2018.

The check's corresponding invoice shows as voided.  But, the check is nowhere to be found.

When I say that, I mean that the client can see the check in a Bank Reconciliation SmartList as an unreconciled check.

But, when double-clicking on that record of the SmartList, the check does not appear.  The Checkbook Register Inquiry window and a screenshot of the voided historical invoice appears, instead.

When looking through Payables Inquiry windows and payables tables in SQL, this check is not found.

I recreated the payables keys file, including running check links, but to no effect.
Do you all have any thoughts on how to find this check so that it can be voided?

Thank you!

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Hi John,

Can you see any records for the check in PM00400, PM20000, PM30200, or PM30300?  

If you do find any records, do they indicate the check transaction was voided?  Is there an apply record for the check, but no check transaction record?

If you don't see any records for the check in those tables, my guess is that it was somehow deleted in PM, but the transaction is still present in the CM tables.

I asked the client to conduct an increase adjustment in Bank Transaction Entry, debiting and crediting the same G/L account.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial