Overview
This query/report program shows the details of AP Sessions (source document) as selected according to possible combinations of filters. The output may be viewed on UI or Export in an excel file.
Navigation
Accounts Payable > Payable Edit List
Processing
This program has two different layouts depending on "Multiple Transactions per Session " marked True or False on the AP Control record. Both layouts have there own set of search filters which help to narrow down the search and then View or Export search results.
1. When "Multiple Transactions per Session " marked True
Fields
Company: The field represents the Financial Company for which the results will be shown. Automatically defaults to the users Current Financial Company.
All Open Sessions: When checked, all Open Sessions/transactions will be retrieved (field is mutually exclusive from other checkbox fields). "From Session Number" or "Thru Session Number" is o[tional and helps in limiting search results.
All Closed Sessions: When checked, all Closed Sessions/transactions will be retrieved (field is mutually exclusive from other checkbox fields). "From Session Number " or "Thru Session Number" is Required when using this checkbox.
Posted Sessions: When checked, all Posted Sessions/transactions will be retrieved (field is mutually exclusive from other checkbox fields). "From Session Number " or "Thru Session Number" is Required when using this checkbox.
All Session Statuses: When checked, ALL (Open, Closed, Posted) Sessions/transactions will be retrieved (field is mutually exclusive from other checkbox fields). "From Session Number " or "Thru Session Number" is Required when using this checkbox.
From Session Number: Enter the starting session number to define a range which will limit the search to just those within the range defined
Through Session Number: Enter the ending session number to define a range which will limit the search to just those within the range defined.
2. When "Multiple Transactions per Session " marked False
Fields
Company: The field represents the Financial Company for which the results will be shown. Automatically defaults to the users Current Financial Company.
Select by Date Range of Voucher Number: Option to select criteria based on either 'Date Range' or 'Transaction ID' of the Payable Transaction. This is a Required parameter.
Specify Vendor: Select checkbox which enables fields "From Vendor Number" and "Through Vendor Number" so that user must mention either one to narrow down search result.
From Vendor Number: Where the “Specify Vendor” is checked, the user enters the From Vendor that they wish to select.
Through Vendor Number: Where the “Specify Vendor” is checked, the user enters the Through Vendor that they wish to select.
From Date: Where the user selected 'Date Range' in the “Select by Date Range of Voucher Number” option, the From Transaction Date is entered/selected
Through Date: Where the user selected 'Date Range' in the “Select by Date Range of Voucher Number” option, the Through Transaction Date is entered/selected
From Transaction ID: Where the user selected 'Transaction ID' in the “Select by Date Range of Voucher Number” option, the From Transaction ID is entered
Through Transaction ID: Where the user selected 'Transaction ID' in the “Select by Date Range of Voucher Number” option, the Through Transaction ID is entered
Buttons
Buttons are common to both page layouts and perform the same function.
Show Payable Edit List: Displays the list of Payable transactions and line/distribution information for the selected Payable transaction.
Export to Excel: Exports the selected Payable transaction and its related line and distribution information.
Related Lists
'Show Payable Edit List' will result in the Payable Session, Transaction, Line, and Distribution information being displayed on the page as related lists. Where a user selects a specific Payable Session / Transaction, it will populate related Lines and Distribution. If there is more than one transaction in a session, then all Payable Transactions will be shown and the user can select any one to populate Lines and Distributions.
SEE ALSO
Payable Session
Payable Transaction
AP Control