G/L Account Detail - Date Ranges Report Lesson


In this lesson you will the steps for running the G/L Account Detail - Date Ranges Report.

 

Navigation:  There are multiple menu paths for this report.  This lesson uses the Accounting  menu path.

 

State of Nebraska > Accounting  > Inquiries & Reports > Accounting Reports > General Ledger Reports > G/L Account Detail – Date Ranges

 

or

 

State of Nebraska > Grants & Projects > Inquiries & Reports > Grants & Projects Reports > Grants Reports > G/L Account Detail – Date Ranges


Steps:

  1. Click the  State of Nebraska link.

    Step 1
  2. Click the Accounting  link.

    Step 2
  3. Click the Inquiries & Reports link.

    Step 3
  4. Click the Accounting Reports link.

    Step 4
  5. Click the General Ledger Reports link.

    Step 5
  6. Click the G/L Account Detail - Date Ranges link.

    Step 6
  7. There are two versions of this report.

     

    Version NIS0001 -

    In the data selection of this version the Object Accounts are preset with "486500-961000", and the Business Unit preset is blank.

    Step 7
  8. Version NIS0003 -

    In the data selection of this version the Object Accounts and Business Unit fields are preset to "Blank". 

     

    Use this version for more flexibility if you are not doing data selection related to Grants or Construction type projects.

    Step 8
  9. Click the NIS0001 option.

    Step 9
  10. Click the Select button.

    Step 10
  11. Click the Data Selection option.

    Step 11
  12. Click the Submit button.

    Step 12
  13. To enter a specific Business Unit click the Right Operand list of the last row (Business Unit).

    Step 13
  14. Click the Literal list item.

    Step 14
  15. Enter the Business Unit you want to run the report for in the Literal Value: field. 

     

    For this lesson enter "65025009" into the Literal Value: field.

    Step 15
  16. Click the OK button.

    Step 16
  17. Click the OK button.

    Step 17
  18. Enter the begining date of the date range in the Date - Report Begins field and the end date of the range in the Date - Report Ends field.  

     

    In this lesson we are not going to change the dates in these fields.

    Step 18
  19. In the Show Grant totals field enter "Y" to show grant totals or "N" not to show grant totals.  

     

    In this lesson we are leaving "N" in the Show Grant totals field.

    Step 19
  20. In the Posted/Unposed field enter:

     

      B - To show both Posted and Unposted.

      P - To show just Posted.

      U - To show just Unposted.  

     

    In this lesson we will not change this field.

    Step 20
  21. In the Beginning Balance field enter:

     

      F - To include the total fiscal year to date.

      I - To include the total inception to date.

      

    Leave blank to include the total only in the selected time period.  

     

    In this lesson we are not changing this field.

    Step 21
  22. In the Show Invoice Number or Batch field enter "I" to show Invoice Number on the report or "B" to show the Batch on the report. 

     

    Note: If left blank the Invoice Number will default.  

     

    For this lesson we will not change this field.

    Step 22
  23. Click the OK button.

    Step 23
  24. Click the OK button.

    Step 24
  25. Click the Close button.

    Step 25

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