Create an Account Set for a Joint Venture Definition

You can create an account set to identify the following types of accounts for a joint venture:

Distributable accounts
Distributable accounts contain the transactions that you need to split and distribute among the joint venture partners.
Distribution only accounts
Distribution only accounts contain transactions that aren’t directly related to costs or revenue. These transactions need to be accounted for the joint venture, but not invoiced to stakeholders.

When setting up an account set to identify distributable accounts, you can set it up for a specific joint venture or for use in multiple joint ventures.

To set it up for a specific joint venture, you select a joint venture and the ledger associated with the joint venture.
In this scenario, the primary segment value or values specified in the joint venture definition are automatically included as filter criteria for identifying distributable accounts.
To set it up for more than one joint venture, you select a ledger without specifying a joint venture.
In this scenario, you can set up filters for identifying the same category of accounts that exist under different primary segments. Remember that the primary segment values identified in a joint venture definition are unique to the joint venture. To identify distributable accounts, Oracle Joint Venture Management uses account combinations assembled from the primary segment values in the joint venture definition and the accounts identified in the account set. This helps ensure that the transactions identified for processing by Joint Venture Management are specific to a particular joint venture.

After you set up an account set for a joint venture, you must activate it and assign it to the joint venture definition.

To create an account set for a joint venture definition:

Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.
Select the Manage Joint Venture Account Sets task.
On Account Sets, click Add.
Or click Manage in Excel and use the spreadsheet to add multiple account sets. 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.
On New Account Set, perform these steps to complete the basic details for the account set:
1. Enter a name and description.
2. Select a ledger using one of these options:
  - Specify a joint venture and then click the “Use Joint Venture Ledger” checkbox to automatically select the ledger of the joint venture.
  - Specify a ledger without specifying a joint venture.
    
    When you assign this type of account set to a joint venture, the COA for the ledger specified here must match the COA for the primary ledger of the joint venture.
    
    Ignore the "Include Primary Segment Values” option. This option is applicable only to setting up an account set for an overhead method.
3. Click Create and then proceed to add filter sets and filters to the account set.
To add a filter set to an account set, perform these steps:
1. Open the account set from the Account Sets page.
2. Click Create Filter Set and give it a name and description.
  Important:
  Filter set names must be unique across all account sets.
3. Click Create.
To add filters to a filter set, perform these steps:
1. Click Add Filter and in the row that appears, enter the following details:
  - Filter Set. Select the filter set that you created.
  - Segment. Select from a list of segments in the ledger.
  - Operator. Select Is, Is Not, or Between.
  - Enter a value or a range of values according to the selected operator.
    Caution: You can include a primary segment value in a filter. However, before you do, make sure you understand how it will be processed based on the setup of the account set:
    - An account set that’s set up for a particular joint venture and the joint venture’s ledger
      The account set will automatically use the primary segment values identified in the joint venture definition as filter criteria. If you add a filter that includes one of the primary segment values, the filter overrides the use of any other primary segment values from the joint venture definition. For example, if the joint venture definition includes three primary segment values and you set up a filter with one of those primary segment values, only the single primary segment value will be used to identify transactions for that filter.
    - An account set that’s set up only for a ledger and not a joint venture
      If you use a primary segment value in the filter, the filter will only be used if the primary segment is valid for the joint venture that the account set is assigned to.
2. Click Submit at the end of the filter row.
Continue to add filter sets and filters as needed.

Your changes are saved automatically.
When complete, click Go back.