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
State of Nebraska > Grants & Projects > Inquiries & Reports > Grants & Projects Reports > Grants Reports > G/L Account Detail – Date Ranges
Click the State of Nebraska link.Step 1
Click the Accounting link.Step 2
Click the Inquiries & Reports link.Step 3
Click the Accounting Reports link.Step 4
Click the General Ledger Reports link.Step 5
Click the G/L Account Detail - Date Ranges link.Step 6
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
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
Click the NIS0001 option.Step 9
Click the Select button.Step 10
Click the Data Selection option.Step 11
Click the Submit button.Step 12
To enter a specific Business Unit click the Right Operand list of the last row (Business Unit).Step 13
Click the Literal list item.Step 14
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
Click the OK button.Step 16
Click the OK button.Step 17
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
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
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
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
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
Click the OK button.Step 23
Click the OK button.Step 24
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