- Implementing Joint Venture Management
- Create an Ownership Definition Assignment Rule
Create an Ownership Definition Assignment Rule
Create ownership definition assignment rules using the Ownership Definition Assignment Rules page.
To expedite the setup, you can create a new assignment rule by copying an existing assignment rule. You can also define multiple assignment rules in a Microsoft Excel spreadsheet and then upload them all at once from the spreadsheet.
Joint venture accountants and joint venture application administrators can create and manage ownership definition assignment rules.
- Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.
- Click the Manage Joint Venture Ownership Definition Assignment Rules task.
-
On Ownership Definition Assignment Rules, click Add.
Or click More Actions, Manage in Excel and use the spreadsheet to add multiple ownership definition assignment rules. The spreadsheet contains instructions on how to complete the columns, which reflect the fields in the user interface and include a list of values for fields when applicable.
- In the Details section, enter a name and description for the assignment rule.
- In the Joint Venture field, select the joint venture that you are creating the assignment rule for. Only joint ventures with an Active status are displayed in the list.
-
Enter a number for the processing sequence.
The processing sequence determines the order in which you want assignment rules processed when you set up multiple assignment rules for the same time frame. If you’re setting up only one assignment rule, you must still enter a number.Tip: For the sequence, you're highly encouraged to use a numbering pattern such as 10, 20, 30, and so on. This gives you the ability to insert additional assignment rules in between existing ones in the future.
-
In the Start Date and End Date fields, enter an effective date range for the
assignment rule.
The date range is compared against the period for which the assignment rules process is run to determine which assignment rules to use for the selected period.
-
Select either an ownership definition or direct billed stakeholder.
If you don't see the ownership definition or direct billed stakeholder in the list, then you need to add it to the joint venture definition first. Update the joint venture definition accordingly and then return to the assignment rule to make your selection.
-
Specify the account or joint venture account set with joint venture
transactions that you want to apply the assignment rule to.
- To specify a single account, click the Account field and select each segment value to identify the account, or use the search filters to identify the account.
- To specify an account set, select the account set from the list. Only
account sets with an Active status are displayed in the Account Set
list.Note: The ledger of the account or account set must match the ledger of the joint venture on the assignment rule.
- Click Save.
-
If setting up an assignment rule for project-related transactions:
- Click Add in the Project Information area.
-
In the available row, select one or a combination of the following
project values to identify project-related transactions:
- Project number, task number, expenditure type
- Project number, expenditure type
- Project number, task number
- Project number
- Expenditure typeNote: Only expenditure types set up with the "Miscellaneous Transaction" expenditure type class are supported. For more information, see Expenditure Categories and Types. You can't add a row with a task number only because a task number can't exist without a project number.
- Add additional rows as needed.
- When complete, click Submit.