Auditor F/A Listing Lesson


In this lesson you will learn how to run the Auditor F/A Listing Report.


Steps:

  1. Click the State of Nebraska link.

    Step 1
  2. Click the Fixed Assets link.

    Step 2
  3. Click the Inquiries & Reports link.

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

    Step 4
  5. Click the Auditor F/A Listing link.

    Step 5
  6. Select the version you want to run by clicking the check box next to it.

    Step 6
  7. Click the Select button.

    Step 7
  8. Click the Data Selection option.

    Step 8
  9. Click the Submit button.

    Step 9
  10. In the first row, verify:

     

      Left Operand is "Date – Acquired (F1201)[BC]"

      Comparison is "is less than or equal to"

      Right Operand is "jdAsOfDate_DAJ [PO]

    Step 10
  11. In the second row, verify:

     

      Left Operand is "Ledger Type (F1202)[BC]"

      Comparison is "is equal to"

      Right Operand is "F2"

    Step 11
  12. In the third row, verify:

     

      Left Operand is "Fiscal Year (1202)[BC]"

      Comparison is "is equal to"

      Right Operand is "mnFiscalYear [PO]

    Step 12
  13. In the fourth row, verify:

     

      Operator is "Or"

      Left Operand is "Date – Disposed or Retired (F1201)[BC]"

      Comparison is "is less than"

      Right Operand is "jdAsOfDate_DAJ [PO]

    Step 13
  14. In the fifth row, verify:

     

      Left Operand is "Ledger Type (F1202)[BC]"

      Comparison is "is equal to"

      Right Operand is "F2"

    Step 14
  15. In the sixth row, verify:

     

      Left Operand is "Fiscal Year (1202)[BC]"

      Comparison is "is equal to"

      Right Operand is "mnFiscalYear [PO]

    Step 15
  16. If running this report for Fiscal Year end purposes, click the drop down list of the Left Operand column on the first blank row.

    Step 16
  17. Click the Object Account (F1202) (OBJ) [BC] list item.

    Step 17
  18. Click the drop down list of the Comparison column.

    Step 18
  19. Click the is greater than list item.

    Step 19
  20. Click the drop down list of the Right Operand column.

    Step 20
  21. Click the Literal list item.

    Step 21
  22. Enter "171500" into the Literal Value field.

    Step 22
  23. Click the OK button.

    Step 23
  24. Click the check box of the new row.

    Step 24
  25. Click the Up button until the new row is above the row with "Or" in the Operator field.

    Step 25
  26. Click the Up button.

    Step 26
  27. Click the Up button.

    Step 27
  28. Note: If you add a new row of data selection above the row with "Or" in the Operator field, that row of data selection will also have to be added below the row with "Or" in the Operator field.

     

    Click the drop down list of the Left Operand column on the bottom blank row.

    Step 28
  29. Click the Object Account (F1202) (OBJ) [BC] list item.

    Step 29
  30. Click the drop down list of the Comparison column.

    Step 30
  31. Click the is greater than list item.

    Step 31
  32. Click the drop down list of the Right Operand column.

    Step 32
  33. Click the Literal list item.

    Step 33
  34. Enter "171500" into the Literal Value field.

    Step 34
  35. Click the OK button.

    Step 35
  36. Click the OK button.

    Step 36
  37. Complete the following fields:

     

    As of Date - if running report for fiscal year end, enter the last date of the current Fiscal year. Otherwise, enter the current date.

    Agency - enter your three (3) digit Agency number.

    Division- enter your three(3) digit division number, if applicable.

    Fiscal Year - enter year for which you want the report generated. (ex. 3 for Fiscal Year 2003)  

     

    In this lesson we will not change the Processing Options.

    Step 37
  38. Click the OK button.

    Step 38
  39. Note: To run this report in CSV, click the Document Setup tab and checkmark CSV (Comma Delimited).  

     

    In this lesson we are not going to run the report as CSV.

    Step 39
  40. Click the OK button.

    Step 40
  41. Click the Close button.

    Step 41

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 Training Guide.

 

You have successfully completed this lesson.

Table of Contents  Start Topic