Hello:I have determined that the only place the check number exists in SQL payables tables for the Vendor ID is in the PM80200 table.
With the Originating Transaction Source field data in that table, I was able to create a SmartList for the voided check's journal entry. Upon trying to drill-back to Source Document in the Inquiry Zoom window, however, GP gave me a message saying that "Transaction history does not exist for this transaction". This is shown in the screenshot below that I have uploaded.
The Cash Account in the G/L is correct. But, Bank Reconciliation SmartList reporting still shows this unreconciled check number.
The only thing that I can think of to eliminate that record from Bank Reconciliation is use GP's Remove Bank History window.
Can anyone think of any other avenues to go on, before taking this step?Thank you!John
If you've found this thread useful, dive deeper into User Group community content by role