Viewing Suspense Transactions

   Overview   

You can run a query in OneUSG Connect to view positions funded by suspense accounts. The query Positions Funded by Suspense (180_CA_SUSPENSE_FUNDED) can be accessed from the System Manager Reporting page under Queries > Commitment Accounting.

In this article, you will learn the steps to run a query to view suspense transactions in OneUSG Connect.

 

1. Step 1

Manager Self Service page displayed with the System Manager Reporting tile highlighted

First, log into OneUSG Connect

On the Manager Self Service page, click the System Manager Reporting tile.

2. Step 2

System Manager Reporting page displayed with the Positions Funded by Suspense link highlighted

The System Manager Reporting page is displayed.

In the Queries menu on the left side of your screen, follow the navigation:

Commitment Accounting > Actual and Encumber query group

Click the Positions Funded by Suspense link.

3. Step 3

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense query search page displayed with the View Results button highlighted

The 180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense query search page is displayed on the right of the page.

You can use the search fields to limit your results by Combo Code and/or Project ID. To return all results in a field, leave the % sign in the field.

Adjust the Beginning Date and Ending Date as needed.

Click the View Results button.

4. Step 4

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense query searched results displayed with the Excel Spreadsheet link highlighted

The results are displayed.

You can download the results section in three formats (i.e., Excel SpreadSheet, CSV Text File, and XML File).  

Example shown here: Excel SpreadSheet.

5. Step 5

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense query searched results displayed with the Open button highlighted

Click to open the file when prompted.

Click the Open button.

6. Step 6

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense Excel Spreadsheet displayed with the Enable Editing button highlighted

The file opens in Protected View.

Click Enable Editing to be able to edit the document.

7. Step 7

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense Excel Spreadsheet displayed with the Row 2 data highlighted

You can filter and sort the data in each column to view the information you need.

Columns show Employee ID, Name, HR Department ID, Pay Group, Pay Period End, Line Number, and Earnings Code

8. Step 8

180_CA_SUSPENSE_FUNDED - Positions Funded by Suspense Excel Spreadsheet displayed with the Row 2 data highlighted

Scroll to the righ t to view additional columns, including Combo Code, Position Number, Paycheck Number, Pay Check Date, Earnings, and the chartstring information.

Additional Information:

To correct a position funded by a suspense account, please see the OneSource Training Library topics Correcting an Invalid Funding Error and Correcting Payroll Entries Charged to Suspense Accounts.

Associated SOPs

SOP_CA_004 Invalid Funding Maintenance

SOP_CA_007 Suspense Correction

Print Article