In this lesson you will learn how to run the A/R Detail with Aging by Fund report.
Click the State of Nebraska link.Step 1
Click the Accounts Receivable link.Step 2
Click the Inquiries & Reports link.Step 3
Click the A/R Reports link.Step 4
Click the Open A/R Detail with Aging by Fund link.Step 5
Click the Data Selection option.Step 6
Click the Submit button.Step 7
Click the drop down list of the Right Operand column for the Fund row.Step 8
Click the Literal list item.Step 9
Enter the 5 digit fund number into the Literal Value field. Enter "56650".Step 10
Click the OK button.Step 11
Note: To view the amount a specific customer (vendor) owes by fund complete the following information in the first blank row: (please note: this same information for a single supplier can be found on the Customer Ledger Inquiry)
Left Operand = Address Number (F0101) (AN8) [BC]
Comparison = is equal to
Right Operand = choose Literal from the drop-down arrow and enter the Customer or Facility address book number.
In this lesson we are not going to add this row.Step 12
Note: To view the amounts due based on date, complete the following information on the first blank row (use this to run report without current items by entering a date 30 days past):
Left Operand = Date - For G/L (and Voucher) - Julian (F03B11) (DGJ) [BC]
Comparison = is equal to
Right Operand = choose Literal from the drop-down arrow and enter the due date from which to run the report
In this lesson we are not going to add this row.Step 13
Click the OK button.Step 14
Enter or verify the following information under the Aging tab:
Aging Specification – leave blank (if "1" is entered, all processing options entered will be ignored)
Aging Date - leave blank, or enter aging date to age open balances
Data Type – enter date type from which to age accounts
Aging Method –
− Enter "1" to view report by number of days (current, 30-60 days, 60-90 days, etc.)
− Enter "2" to view column headings by fiscal periods (1, 2, 3)
− Enter "3" to view report by month (January, February, etc.)
Aging Category 1 – 30- (negative)
Aging Category 3 – 30
Aging Category 4 – 60
Aging Category 5 – 90
Aging Category 6 – 120
All others – blankStep 15
Click the Date tab.Step 16
Ensure the Date - As Of field is blank.
In this lesson this field is already blank.Step 17
Leave all other Processing Option tabs as they are.
Click the OK button.Step 18
Note: To run the report in CSV click the Document Setup tab.Step 19
Click the CSV(Comma Delimited) option.Step 20
Click the OK button.Step 21
To view the report you will need to go to View Job Status. For more information go to the Reports Lesson under the System Basics work instructions.
You have successfully completed this lesson.
Table of Contents Start Topic