Creating and Maintaining Ineligible Costs1.0

Supplemental Job Aid

Date: 10/17/2017

Revision History
Date / Version / Location / Update Description
10/17/2017 / 1.0 / Original

Target Audience: PC Processor

Purpose: This Supplemental Job Aid provides the Department Project Processor the instructions forcreating and maintaining ineligible accounts for Business Units with Federal Funds meaning Business Units using Grants, Customer Contracts and Project Costing.

Maintaining Ineligible Costs (in Project Costing (PC)):

In this example, an existing Federal Grant Project and Activity with its associated Contract and Grant, ineligible Cost value(s) will be added to the Project. In order to validate the Ineligible Expense accounts that were added, the ZZ_INELIGIBLE_COST query will be run. Also, the ZZ_PROJECT_TRANSACTION query will be run, this report provides all the transactions associated with the Project, Activity, Account, Alternate Account, Ineligible Cost and Fund used to validate the Ineligible Accounts process.

Step 1: Navigate to find an ExistingProject Type – FEDRL and Project Activity in Project Costing.

Main Menu Project Costing Project DefinitionsGeneral Information.

Step 2: Search for an existing FEDLR project, On theFind an Existing Valueenter:

  • Business Unit:Your Department BU
  • Project Number: Entering an existing Project for the BU
  • Click Search.

In Search Results, select >Project

Project Page displays

On this page, it can be verified that a Contract is linked to this project.

Step 3: Click On the Contract Number linkto verify existing contract.

General Information page displays with Contract number details:

Contract Number: 00000022

Contract Type: GRANTS

Contract Status: Active

Step 4: Clickon Lines tab to verify the project.

In theContract Lines section, click theDetailsub-tab

General Information page displays.

In the Contract Lines section, click on the “Contract Terms” hyperlink

The Contract Terms page displays the Associated Projects & Activities section, validate the project number and activity.

Step 4: To enter Ineligible Cost in Project Costing, navigate to the Ineligible CostPage.

Main Menu  Fi$Cal Processes Fi$Cal Extension  PC  Ineligible Cost

Ineligible Cost page displays,

Step 5: On the Ineligible Cost page, click the Add a New Value tab. In the Add a

New Valuefields, enter:

  • PC Business Unit: <Your Department BU>
  • Contract: <Existing Contract for your Department BU>
  • Project: <Existing Project Number for your Department BU>
  • Activity: <Existing Activity

Click, the Addbutton.

Project Ineligible Cost page displays; Ineligible Accounts are set up.

Step 6: On the Project Ineligible Cost page in the Account field, enter Ineligible

Cost values based on your Federal Project, your business processes. Enter Account.

By entering the Account, the Alternate Account fielddisplays to input information.

Open the magnifying glass and select the information.

Add additional Ineligible Accounts by clicking on the + sign and additional rows will be displayed.

For this example, three Accounts were entered.

Additional rows and Accountsvalues can be added for Federal Projects to capture

Ineligible Costs based upon the Grant.

Click the Save button.

Step7: To validate the Ineligible Accounts, ZZ_INELIGIBLE_COST query is run.

Navigate to:Main Menu  Reporting Tools Query  Query Viewer

Enter Query Name - ZZ_INELIGIBLE_COST

Query Viewer page is displayed.

Under the Run to Excel header, click the Excel hyperlink.

Enter Business Unit:

Results – Accounts values are displayed

Step 8:The Query sample belowdisplays various fields with data and for purpose of the this Job Aid,the Project Number, Activity, Account, Alternate Account

Ineligible Cost, and FundCoderecords will be highlighted.

Run the - ZZ_PROJECT_TRANSACTIONS Query

Navigate to:Main MenuReporting ToolsQueryQuery Viewer

Query Viewer page displays.

Enter the following information:

Fill in the Query Name - ZZ_PROJECT_TRANSACTIONS

Select > Search

Then, under the Run to Excel header, click the Excelhyperlink.

TheZZ_PROJECT_TRANSACTIONS – Project Transaction Listing displays

Fill in in the following fields:

  • Business Unit: <Your Department BU>
  • Project Number:
  • From Date xx/xx/xxxx To Date xx/xx/xxxx
  • Date Type: A < Acct Date >

Then, click View Results.

The Query Results are displayed in two screen shots below:

An existing Federal Grant Project and activity with its associated Contract and Grant, Ineligible Cost values were added to the Project and results were validated.

Two Queries were processed: The ZZ_INELIGIBLE_COST query to validate the Accounts added to the project and the ZZ_PROJECT_TRANSACTIONS queryto validate data and todemonstrate the various fields that this report provides.

FI$Cal.359 - Creating and Maintaining Ineligible Costs1.0

Created: 10/17/2017Page 1 of 20