Payables as of a Past Date – Fund Detail Report
  • 19 Sep 2023
  • Contributors
  • Dark
    Light
  • PDF

Payables as of a Past Date – Fund Detail Report

  • Dark
    Light
  • PDF

Article summary


Payables as of a Past Date – Fund Detail Report

This report provides total outstanding Voucher amounts for each Fund, based on the date you select.

You can run this report in either a detailed or summary format.

NOTE: You can also view payables by Fund for a range of dates. Refer to the Payables by Fund Report for more information.

NOTE: You can access this report from anywhere in FIMS by selecting Reports > Accounts Payable > Payables as of a Past Date – Fund Detail.

 

Payables As Of A Past Date Report Fields

Field

Description

ID Code

The payee’s Profile ID code.

Payee Sort Name

The payee’s report name.

Doc. No.

The number of the outstanding Voucher.

Doc. Date

The due date from the original Voucher.

Date Posted

The date when the Voucher was posted to Open Items.

Grant

Indicates whether the payable is a Grant (yes or no).

Amount

The total amount that is due for the payable.

Fund ID

The Fund ID for the Fund that will make the payment.

NOTE: There may be more than one Fund ID for a single payable if the Voucher has line items that are paid from different Funds.

Fund Sort Name

The sort name for the Fund that will make the payment.

NOTE: There may be more than one Fund Sort Name for a single payable if the Voucher has line items that are paid from different Funds.

Fund Amount

The amount due from each Fund making a payment on the Voucher. These amounts should always equal the total Amount due for the payable.

Difference

Indicates any difference between the Amount and Fund Amount columns.

IMPORTANT: There should never be a difference. If an amount appears in this field, contact FIMS Support for support.

Running the Payables as of a Past Date – Fund Detail Report

1. In the Accounts Payable module, select Reports > Payables as of a Past Date – Fund Detail. The Payables as of a Past Date Selection window opens.
Payables as of a Past Date Selection Window

2. Enter the Open Payables As Of date.

3. Click the arrow in the A/P Items drop-down box and select the type of payables you want to include on the report: All, Admin, All Grants, Scholarship Grants, or Non-Scholarship Grants.

4. Select either the Summary or Detail radio button to determine the output for the report.

5. Click OK.

6. Verify the Send To destination, and then click the Run Report button.

 


Was this article helpful?