How to Search and Filter Accounts Payable Records

Go To User Guide - Accounts Payable

Accounting>File>Accounts Payable>Add/Edit Payables>Find Button find.png

In the Browse A/P Records dialog you can enter a search term in the search field, this utilized RFMS Smart Search. Filter and existing search using the Find, find.png, button. Using the Find button without entering a search term simply browsed all records available within the filter parameters.

search and filter ap records.png

Using the Filter

  • When the Find button is selected the Find Payables dialog comes up. Enter all desired parameters and then select Save to apply it. 
  • Search parameters can be saved and re-loaded by using the Save and Load buttons.
  • Use the Clear, clear button.png, button to reset the fields. 
Field Explanation
Supplier Enter a supplier name or use the F8 button to select from the supplier list.
Invoice # Enter all or part of an invoice number.
Stores Select which store records to include in the search.
Invoice Date From/To Enter a date range for date that appears on the invoice.
Trans. Date From/To The transaction date is the system date that is inserted when the invoice is added or edited.
Due Date From/To Enter a date range of when the invoice is due to be paid.
Date Paid From/To Enter a date range of when the invoice was paid.
Check # From/To Enter a range of numbers from corresponds to the checking account check numbers used.
Paid Online Allows listing only those A/P which were paid online
Act Code Search using the account code the payable was recorded under. Use the F8 key to search account codes.
Tied To Enter the order number from a customer order in Order entry.
Open Payables Only Include only payables with OPEN status.
Origin Include or exclude different A/P origins from the search.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.