Is it possible to lookup an AP payment or an AR receipt by cheque number?
If the vendor number is known, the best place to look up a cheque is in Vendor Activity. Go to AP Vendors / Vendor Activity. Enter the vendor number and go to the Payments tab. The list of payments can be sorted by date or payment number and there is a filter for the starting value in the list to reduce the number of records displayed.
If the customer number is shown, the best place to look up a cheque is in Customer Inquiry (see Customer Inquiry in AR for more detail about this function) and go to the Receipts tab. The list of receipts can be sorted by date or receipt number and there is a filter for the starting value in the list to reduce the number of records displayed.
If the customer number or vendor number is not known, we can use the Reverse Transactions function in Bank Services to aid in our lookup efforts. Looking up cheque numbers is not a specific function of Reverse Transactions, but the selection criteria enable us to use it for this 'off-label' purpose. Go to Bank Services / Bank Transactions / Reverse Payments. Enter the bank code and then the module we need to look at under 'Source Application'. Select the checkbox to 'Reverse Multiple Transactions'. This opens up several selection criteria which include the Check No., Payment (Receipt) Date, Payment (Receipt) Amount as well as Vendor or Customer Number. Enter the criteria for the search and click the go buttons (>>) or F7 to bring up the results in the detail grid below. Highlight the specific record that is needed and click on the 'Check/Receipt No. (or Check/Payment No.) to drilldown to the specific details of the transaction. Once you have the information that you are looking for, close the screen without posting any reversals.