Skip to main content

Balance Sheet Account Transaction Details

Controller's Office

Purpose

Generate the detailed transactions of a PeopleSoft Financials account as of a specific date range

Query

CU_GL_ACCOUNT_INQUIRY


Steps
Navigate to the Budget Management homepage

image2021-4-20_13-55-9 (1).png
Select Query Viewer
image2021-4-20_13-52-33 (1).png

Search for CU_GL_ACCOUNT_INQUIRY
image2021-4-20_14-17-21.png

Save it to your Favorites so you won't need to search for it next time
image2021-4-20_14-18-22.png

Select Run to HTML
image2021-4-20_14-18-55.png

Enter the Account and as of Date you are inquiring about; Hit View Results
image2021-4-20_14-20-52.png

The results will appear on the screen; select Excel SpreadSheet if you wish to download the results

image2021-4-20_14-22-9.png
Launching the query opened a new tab which you can close when you are done without exiting PeopleSoft
image2021-4-20_14-9-30 (1).png


How to find the balance in an account as of a specific date