Open A/R Detail with Aging by Fund Lesson


In this lesson you will learn how to run the A/R Detail with Aging by Fund report.


Steps:

  1. Click the State of Nebraska link.

    Step 1
  2. Click the Accounts Receivable link.

    Step 2
  3. Click the Inquiries & Reports link.

    Step 3
  4. Click the A/R Reports link.

    Step 4
  5. Click the Open A/R Detail with Aging by Fund link.

    Step 5
  6. Click the Data Selection option.

    Step 6
  7. Click the Submit button.

    Step 7
  8. Click the drop down list of the Right Operand column for the Fund row.

    Step 8
  9. Click the Literal list item.

    Step 9
  10. Enter the 5 digit fund number into the Literal Value field. Enter "56650".

    Step 10
  11. Click the OK button.

    Step 11
  12. 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
  13. 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
  14. Click the OK button.

    Step 14
  15. 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 – blank

    Step 15
  16. Click the Date tab.

    Step 16
  17. Ensure the Date - As Of field is blank.  

     

    In this lesson this field is already blank.

    Step 17
  18. Leave all other Processing Option tabs as they are.

     

    Click the OK button.

    Step 18
  19. Note:  To run the report in CSV click the Document Setup tab.

    Step 19
  20. Click the CSV(Comma Delimited) option.

    Step 20
  21. 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