PY Variance Report Lesson


In this lesson you will learn how to run the PY Variance Report.


Steps:

  1. Navigation:

    There are multiple menu paths to the report which are listed below.  This lesson will be using the  Accounting navigational steps.

     

    Accounting > Inquiries & Reports > Accounting Reports > Agency Financial Reports > Variance Reports > PY Variance - Ag/Fund or PY Variance - Ag/Fund/Prog

     

    or

     

    Budget - Agencies > Inquiries & Reports > Accounting Reports > Agency Financial Reports > Variance Reports > PY Variance - Ag/Fund or PY Variance - Ag/Fund/Prog

    Step 1
  2. Click the State of Nebraska link.

    Step 2
  3. Click the Accounting link.

    Step 3
  4. Click the Inquiries & Reports link.

    Step 4
  5. Click the Accounting Reports link.

    Step 5
  6. Click the Agency Financial Reports link.

    Step 6
  7. Click the Variance Reports link.

    Step 7
  8. Click the PY Variance - Ag/Fund link.

    Step 8
  9. Click the Data Selection option.

    Step 9
  10. Click the Submit puhbutton.

    Step 10
  11. Click the drop down list of the Right Operand column of the Agency Number row.

    Step 11
  12. Click the Literal list item.

    Step 12
  13. Enter the desired information into the Literal Value field. Enter "065".

    Step 13
  14. Click the OK button.

    Step 14
  15. Click the drop down list of the Right Operand column for the Object Account row.

    Step 15
  16. Click the Literal list item.

    Step 16
  17. Enter an object account or range of accounts. 

     

    To enter a single object account click on the Single Value tab. 

     

    To enter a range of object accounts click on the Range of Values tab and enter a range of object accounts in the From and To fields.

     

    Note: Enter a range of 111100 - 999999 to see all accounts.  

     

    In this lesson we are going to enter a range of object accounts.

    Step 17
  18. Enter "350000" into the Literal Value From field.

    Step 18
  19. Press [Tab].

    Step 19
  20. Enter "450000" into the Literal Value To field.

    Step 20
  21. Click the OK button.

    Step 21
  22. Click the OK button.

    Step 22
  23. Enter the fiscal year into the Fiscal Year field.

     

    Example: Enter 9 for fiscal year beginning July 1, 2009  

     

    Enter "9".

    Step 23
  24. Press [Tab].

    Step 24
  25. Enter the month into the Period Number - General Ledger field.

     

    Example: Enter 1 for July, 2 for August, etc.    

     

    Enter "2".

    Step 25
  26. Click the OK button.

    Step 26
  27. Note: To run this report in CSV format (Microsoft Excel), click the Document Setup tab and checkmark CSV.  

     

    In this lesson we are not gonig to run this as CSV.

    Step 27
  28. Click the OK button.

    Step 28

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 Guides.

 

You have successfully completed this lesson.

Table of Contents  Start Topic