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