Salesforce

Payable Edit List

« Go Back
Article

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

    Settings
    Payable Edit List
    Payable-Edit-List

    Powered by