Creating project funding hierarchies
The information that is required to create hierarchies
depends on the funding structure and the funding type.
- On the Project Funding List page, select the Project Funding By Structure tab.
- Open an 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 valid dates
that can be used:
- Estimate Close Date
- Actual Date
- Submit Date
- Notice Date
- Receive Date
- Proposal Date
- If the funding type is External Grant or External Customer, select the Receivable Customer tab.
-
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 Receivables company.
- Accounts Receivable Code
- Select the AR code for the customer. This code is assigned to a customer. It is used to process open items and to override the process level when open items are used for memos and invoices. This field is available when the Allow Detailed Invoice Accrual Distributions field on the receivables company is not selected.
- Receivable Finance Structure
- Select the structure to use for journalizing invoices. This finance structure is used to post and report open receivables by project. If the project, funding source, or any user dimension is specified, the result is a single accounts receivable entry to that project and user dimensions. If the project field is blank, an accounts receivable entry is created for each unique posting project on the invoice. This field is available if the Allow Detailed Invoice Accrual Distributions check box on the Receivables company is selected.
- 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. If this field is specified, open items in Receivables are totaled by contract activity.
- Document Number
- Specify the document number of the funding.
- If the funding type is External Grant or Intercompany Billing, select the Grant Reporting tab.
-
Specify this information:
- Grant ID
- Specify the grant ID.
- Direct Or Pass Thru
-
- Select Direct if 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
- If the Include In SEFA check box is selected, then this field must be selected for the funding source to show on the Schedule of Federal Awards Worksheet. Assistance Living Numbers (ALN) are used 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. They are used in government reporting and auditing.
- Program Title
- Select the title of the grant.
- In the FFR Reporting section, select the values that show on the Federal Financial Report.
- Click Save.
-
To create a child project funding within an existing funding structure, use
this procedure:
- Select a funding structure.
- Select Actions > Create Child Funding Source Within.
- Repeat steps 4-7