Viewing Suspense Transactions

Summary

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

Body

   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

step image

First, log into OneUSG Connect

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

2. Step 2

step image

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

step image

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

step image

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

step image

Click to open the file when prompted.

Click the Open button.

6. Step 6

step image

The file opens in Protected View.

Click Enable Editing to be able to edit the document.

7. Step 7

step image

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

step image

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

Details

Details

Article ID: 151478
Created
Sun 9/25/22 10:08 AM
Modified
Fri 1/5/24 5:19 PM