Creating project funding hierarchies

Select Project Ledger > Setup > Project Funding List.

Select the Project Funding Sources By Structure tab.

Open the enterprise structure and select the Hierarchy tab.

Select Actions > Create.

In the Dimension Type field, select whether the funding structure is Summary or Posting.

If the dimension type is Summary, then specify this information:

Project Funding: Specify the name or code for the project funding source. You cannot change the name or code after you save it.
Description: Provide the description for the project funding source. When posting external funding sources, you can use the same name as the Receivables customer.
Budget Identifier: If you use budget edit, then specify the budget identifier.
Person Responsible: Select the HR employee who is responsible for managing the project structure and its children. This field is used to control whether the My Project page is displayed to the Project Manager role. The responsible person can only be selected on summary level projects.
Responsible Team: Select the team of HR employees who are responsible for managing the project structure and its children. This field is used to control whether the My Project page is displayed to the Project Manager role. The responsible team can only be selected on summary level projects.
Address Code: Specify the address code of the location for the project funding.

If the dimension type is Posting, then specify this information:

Project Funding: Specify the name or code for the project funding source. You cannot change the name or code after you save it.
Description: Provide a description for the project funding source. When adding posting external funding sources, you can use the same name as the Receivables customer.

System Project Funding: Select this check box to designate the structure as the project funding structure for the system.
We recommend that you create a system dimension for processes where the system dimensions are used, for example, the retained earnings process.
Include In Budget Edit: If you use budget edit, select this check box on posting dimensions to define the accounting string to use in budget edit templates.
Address Code: Specify the location address code for the project funding.

If the dimension type is Posting, then on the Project Funding tab, specify this information:

Type

Select the type of funding source for the structure.

Begin Date

Select the begin date.

End Date

Select the end date of the funding. If End Date is blank, then there is no end date to the funding.

Amount

Specify the amount of the funding. If this field is blank, then funding is unlimited.

Currency

Select the currency of the funding. If Amount is blank, then this field can be blank. The currency cannot be changed after the funding is attached to a project contract.

Revenue Structure Option

Select whether the revenue structure is specified as a full or partial finance code block for the project funding.

If the Type is Internal, then you can select None. If you select None, then the GL Transaction Detail records are not created when the Journalize Invoice and Journalize Revenue actions are run.
If front end split is enabled on the contract, then the Finance Dimension 1 or the Accounting Unit is required in the Partial Revenue Finance Structure field. The value in this field is used as the default on the fund for expense entries.

Revenue Recognition Option

Select whether the revenue entries are created in detail or in summary.

Select Summary to summarize revenue entries by code block.
Select Detail to create revenue entries by the originating transactions. Milestones are always recognized in detail.

The selected value applies to both revenue recognition methods. In both actions, this field is used to determine revenue entries:

For combined methods, revenue is credited when invoices are journalized.
For separate methods, revenue is credited when revenue is journalized.

Partial Revenue Finance Structure

Specify the dimensions to override for revenue for the project funding. The values from the originating expense are used in dimensions that are blank. The list is filtered on revenue accounts because the account is generally a revenue account. When another account type is required, any account can be specified.

Full Revenue Finance Structure

Specify the full revenue finance structure for the project funding. The list is filtered on revenue accounts because the account is generally a revenue account. When another account type is required, any account can be specified.

Department

Select a department for the project funding source.

Division

Select a division for the project funding source.

Offset Finance Structure

If the funding type is Internal Fund, provide the account string to which the project funding offset is posted.

Payables Company

Select the payables company if the funding source type is Intercompany Billing. The payables company is the To Accounting Entity for intercompany document and intercompany billing transactions. The setup for payables company must include the intercompany billing setup.

Payables Expense Finance Structure

Select the dimensions to use for the finance structure when the funding source type is Intercompany Billing. These dimensions are used with the finance structure for intercompany billing recharge item Payables Expense Account to generate the payables expense distribution. The finance code block for Payables begins with the finance structure for the recharge item. The blank dimensions are completed from the finance structure of the funding source.

If the funding type is External Grant, then specify the applicable dates for the grant. This list shows the possible dates that can be specified:

Estimate Close Date
Actual Date
Submit Date
Notice Date
Receive Date
Proposal Date

If the funding type is External Grant or External Customer, then select the Receivable Customer tab and specify this information:

Receivable Company

Specify Receivables company for the grantor.

AR Interface Option

Select a Receivables interface option:

Summary: Select the dimensions to use for the finance structure when summarizes transactions to a single Receivables line by project contract. You cannot see posting projects on any accounts receivable reports and inquiries.
Detail creates full transaction detail. Use this option if cash is applied at the line level in Receivables. Line level detail for accounts receivable reports and inquiries are displayed.
Summarize By Posting Project summarizes transactions by posting project. You can see invoice line items summarized by posting projects on accounts receivable reports and inquiries.

Receivable Customer

Select a customer from the specified Receivables company.

Bill To

Specify the customer to which to send the bill. If this field is blank, then the address from the receivable customer is used on invoices as the bill to address.

Receivable Process Level

Select the billing process level of the specified Receivables company.

Accounts Receivable Code

Select the Receivables code for the customer that is used for open item processing. This code overrides the code of the process level during open item entry for memos and invoices.

Invoice Type Code

Select an invoice type for the company customer. You can group invoices that are sent to Receivables with this code. If no values are available to select, then no invoice types are available for the company customer.

Jurisdiction Code

Select a jurisdiction code to use for the receivable customer.

Customer PO Number

Specify the purchase order number of the customer for the funding. This number is available on the invoice for customer reference.

Letter of Credit

Specify a letter of credit for the funding.

This option provides open items in Receivables, totaled by contract activity.

Document Number

Specify the document number of the funding.

If the funding type is External Grant or Intercompany Billing, then select the Grant Reporting tab and specify this information:

Grant ID

Specify the grant ID.

Direct Or Pass Thru

Specify whether the grant is Direct or Pass Thru.

Select Directif the institution is the prime or direct sponsor that is receiving the federal award.
Select Pass Thru if the institution is a sub contractor for the grant. Expenses that are incurred by the pass thru sponsor are billed to the prime.
If you select Pass Thru, then specify the company and customer for the prime sponsor.

Pre-Award ID

If you use a third party pre-award system, then specify a grant identification number. The grant identification number is used for tracking.

Prime Sponsor, Receivable Customer

If you selected Pass Thru, then specify the receivable company and customer.

Include In SEFA

Select this check box to include the grant in the SEFA report.

Prime Sponsor Award Number

Specify the award number for the prime sponsor of the grant.

Major Category

Select the major category for the grant.

ALN

Specify the Assistance Listing Numbers (ALN). These numbers are for federal programs, projects, services, and activities that provide assistance or benefits to the American public. ALNs are located on notices for federal grant and cooperative agreement awards and are often used in government reporting and auditing.

This field is formerly Catalog of Federal Domestic Assistance (CFDA).

Program Title

Specify the program title of the grant.

In the FFR Reporting section, select the values that show on the Federal Financial Report. This list shows the fields that are available:

Required Recipient Share
Recipient Share Of Expenditures
Federal Program Income
Expended Deduction Alternative
Expended Addition Alternative
Type
Rate
Base Amount
Amount Charged
Federal Share

Click Save.

To create a child project funding within an existing funding structure, select a funding structure and select Actions > Create Child Funding Source Within and repeat steps 4-7.