Create an Account Set for an Overhead Method

You can set up an account set to identify transactions for an overhead method according to how you've set up your financial structure.

• Select a joint venture and the ledger associated with the joint venture.

  Use this option if you are basing the overhead calculation on transactions associated with the joint venture.

• Select a joint venture and select a ledger that's different than the ledger of the joint venture.

  Use this option if the transactions that you want to identify for a joint venture are in a different ledger than the ledger of the joint venture. This enables you to base overhead calculations on transactions in a different ledger, for example if you track costs for accounting, maintenance, and other general business operations in a ledger that's different from the joint venture.

• Select a ledger without specifying a joint venture.

  This enables you to associate the same account set to overhead methods in multiple joint ventures. Use this option to identify transactions in the same accounts, typically transactions for general business operations, as a basis for calculating overhead for more than one joint venture.

After you set up the account set, you need to activate it and assign it to an overhead method.

To create an account set for an overhead method:

1. Navigate to Setup and Maintenance and select the Joint Venture Management functional area under the Financials offering.
2. Select the Manage Joint Venture Account Sets task.
3. 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.
4. On New Account Set, enter a name and description for the account set.
5. 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.

     After you click Save, the name of the ledger is displayed in the Default Ledger field.

   • Specify a joint venture and then select a ledger that's different than the ledger of the joint venture. With this option, the joint venture is for information purposes only.
   • Specify a ledger without specifying a joint venture.
6. Click Save and continue to set up the account set.
7. If you selected a joint venture and the “Use Joint Venture Ledger” checkbox, you can also select these options:
   • Validate Primary Segment Values. The application validates that any primary segment values that you enter in a filter set are primary segment values identified in the joint venture definition. Any other primary segment values aren't allowed in the filter.
   • Include Primary Segment Values. Use this option if you want the account set to automatically filter on all primary segment values identified in the joint venture definition of the selected joint venture. You don't have to explicitly add filter sets with filters for the primary segment values. You only have to set up filter sets if you need to enter segment values other than the primary segment values to identify other accounts.

     See the example following this task for more information about using this option.

8. Click Save and then proceed to add filter sets to the account set.
9. To add a filter set:
   1. In the Filter Sets area, click Add.
   2. Enter a name and description for the filter set.
      Note: Avoid using the same name for a filter set in more than one account set. Try to make the filter set names unique in each account set.
10. To add a filter to a filter set:
    1. In the filter set, click Add Filter and then enter the following details for the filter:

       • 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. But before you do, make sure that you understand how it will be processed based upon 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 a 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. Add additional filters as needed.
    3. Click Save.
11. When complete, click Submit to save and exit the page. Or you can click Submit and Next to create another account set.