A/P Detail with Aging Lesson


In this lesson you will learn how to run the A/P Detail with Aging Report.


Steps:

  1. Click the State of Nebraska link.

    Step 1
  2. Click the Accounts Payable link.

    Step 2
  3. Click the Inquiries & Reports link.

    Step 3
  4. Click the Accounts Payable Reports link.

    Step 4
  5. Click the A/P Detail Reports link.

    Step 5
  6. Click the A/P Detail - with Aging link.

    Step 6
  7. Click the Data Selection option.

    Step 7
  8. Click the Data Sequencing option.

    Step 8
  9. Click the Submit button.

    Step 9
  10. Click the drop down list of the Right Operand for the Fund row.

    Step 10
  11. Click the Literal list item.

    Step 11
  12. Enter the fund number into the Literal Value field. Enter "10000".

    Step 12
  13. Click the OK button.

    Step 13
  14. Note: To run this report for a specific supplier, complete the following information in the first blank row:

    Left Operand - Address Number (F0101) (AN8)[BC]

    Comparison - is equal to

    Right Operand - enter the supplier address book number.

     

    Note: To run this report for a specific due date, complete the following information in the first blank row:

    Left Operand - Date - Discount Due - Julian (F0411)(DDNJ)[BC]

    Comparison - is equal to

    Right Operand - enter the due date for which you wish to run report (or enter a range of due dates on the range of values tab.)  

     

    In this lesson we are not going to add these lines.

    Step 14
  15. Click the OK button.

    Step 15
  16. Click the Show Available Columns. link.

    Step 16
  17. Click the option.

    Step 17
  18. Click the Add button.

    Step 18
  19. Click the option.

    Step 19
  20. Click the Up button until Discount Due Date is at the top of the list.

    Step 20
  21. Click the Up button.

    Step 21
  22. Click the Up button.

    Step 22
  23. Click the Up button.

    Step 23
  24. Click the Up button.

    Step 24
  25. Click the Up button.

    Step 25
  26. Click the Up button.

    Step 26
  27. Click the OK button.

    Step 27
  28. Verify the following:

     

    Aging Date = blank

    Note: When left blank the Aging Date will automatically populate as the current date.

     

    Date Type = I

    Step 28
  29. Click the OK button.

    Step 29
  30. Click the OK button.

    Step 30

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