Siebel Consumer Goods Guide > Trade Funds > Creating Funds >

Creating Accrual Funds

Administrators can manually create or automatically generate accrual funds. They usually automatically generate accrual funds for accounts from the same organization, and they manually create accrual funds for single accounts.

Accrual funds are calculated using source product records that are based on product sales data. For example, if you sell 5,000 cases at a price of $1.50 for each case, the accrual is $7,500. You use established accruals over a specified period of time.

Trade managers or trade administrators can enter fund rates or fund group rates at the category level and cascade the rates to child products.

You can obtain product sales data from your customers, back-office applications for order processing, data warehouses, and Siebel orders in a specific state. Administrators can import this sales data into the S_MDF_ACCRUAL table using the following methods:

• Siebel Enterprise Integration Manager (EIM)

  This method uses the EIM_MDF table. You import only shipment and accrual rate data. To calculate the total fund amount, the user must instigate the business logic that starts the calculation process. To instigate this business logic, administrators can create a button for a custom business service.

• Siebel Enterprise Application Integration (EAI)

  The WriteRecord method in the CS Fund Source Product business component calculates the total fund amount and updates the fund record.

• Business services and workflow processes

  The WriteRecord method in the CS Fund Source Product business component calculates the total fund amount and updates the fund record.

You can also use the Source Products view in Siebel Consumer Goods to add product sales data to an accrual fund as described in Step 3 and Step 4 of the following procedure.

To manually create an accrual fund

1. Navigate to the Administration - Data screen, then the Funds view.
2. In the Funds list, create a new fund record, and complete the necessary fields.

   The following table describes some fields.

   Field	Comments
   Account	The account that is eligible for the fund.
   Fund	The name of the fund.
   Type	Select Accrual in this field.
   Source Category	The category with products that are used to calculate accruals. It acts as the parent target category. If it exists, only sub-categories of the selected category appear in the categories pick applet at the target category level.
   Target Category	The category that contains the target products for this fund. The target products are the products that your company wants to promote in this account promotion. It acts as the parent target category. If it exists, only sub-categories of the selected category appear in the categories pick applet at the target category level.
   Period	The period of time in which you can use this fund.
   Basis	The value (for example, Cases or Revenue) used to accrue funds. For a Cases basis, accrual fund fields are calculated as follows: The Amount field is populated with the result of the Accrual Rate field for each source product multiplied by the Shipments field for each source product. The Forecast field is populated with the result of the Accrual Rate field for each source product multiplied by the Est Total Volume field for each source product. For a Revenue basis, accrual fund fields are calculated as follows: The Amount field is populated with the result of the Accrual % field for each source product multiplied by the Revenue field for each source product. The Forecast field is populated with the result of the Accrual % field for each source product multiplied by the Est Total Revenue field for each source product.
   Basis Period	The period of time for which the basis is valid.
   Organization	The umbrella organization for the account for this fund. For more information about organizations and accounts, see Managing Accounts and Siebel Applications Administration Guide.

3. Click the Source Products view tab, and in the Source Products list, click Products.

   All products of the source category and any subcategories are listed. You can also manually add other products that are not in the source category.

4. Complete the applicable fields in the Source Products list.

   The source product fields are used to calculate the Amount field and the Forecast field for the accrual.

Use the following procedure to automatically generate an accrual fund.

NOTE:  The Accrual field is not exposed on the Administration - Products view. To set the accrual rate for a product, you must use Siebel Tools to expose this field on the Product business component.

To automatically generate an accrual fund

1. Navigate to the Administration - Data screen, then the Fund Groups view.
2. In the Fund Groups list, create a new record, and complete the necessary fields.

   The following table describes some fields.

   Field	Comments
   Name	The name of the fund group.
   Type	Select Accrual in this field.
   Period	The period of time in which you can use this fund group.
   Basis	The value (for example, Cases or Revenue) used to accrue funds.
   Basis Period	The period of time for which the basis is valid.
   Source Category	The category with products that are used to calculate accruals. If it exists, only sub-categories of the selected category appear in the categories pick applet at the target category level.
   Target Category	The category that contains the target products for this fund. The target products are the products that your company wants to promote in this account promotion. It acts as the parent target category. If it exists, only sub-categories of the selected category appear in the categories pick applet at the target category level.
   Organization	The umbrella organization for the accounts for this fund group. The accounts that you can select for this fund group depend on this organization. For more information about organizations and accounts, see Managing Accounts and Siebel Applications Administration Guide.

3. In the Accounts list, click Apply to add eligible accounts to the fund.
4. In the Pick Account dialog box, select the account records to add, or click Select All to add all eligible account records.

   To be eligible, an account must have:

   • The same organization as the fund group.
   • A check in the Fund Eligible field.

     NOTE:  To verify that the Fund Eligible field is checked, navigate to the Accounts screen, then the Accounts List view.

5. Click the Target Products view tab, and in the Target Products list, click Products.

   All products of the target category and any subcategories are listed.

6. Click the Source Products view tab, and in the Source Products list, click Products.

   All products of the source category and any subcategories are listed. You can also manually add other products that are not in the source category.

7. Click the Accounts view tab, and in the Funds list, click Generate.

   Accrual funds are created based on the fund group and the accounts.

   Administrators can also use the Source Products view in Siebel Consumer Goods to assign accrual details at the fund group and publish these details to the account fund.

To assign a rate at the fund group level and publish to account fund

1. Navigate to the Administration - Data screen, then the Fund Groups view.
2. Create a new Fund Group. Click the New button and enter the appropriate values in the fields.
3. Click the Accrual Details view tab.
4. Associate one or more categories for accrual. In the Category Name field, select a category and click OK.
5. Associate one or more products for accrual with a category. The products can be specific products or an assortment of associated categories.
   1. Select the relevant Category Name.
   2. Enter accrual rates for categories.
   3. In the Accrual Details view, click the Apply Rates button to apply category rates to accrual products.
   4. As necessary, manually override accrual rates at the product level.
   5. In the Fund Groups view, click the Publish Accruals button to publish accrual rates to child account funds.
6. Navigate to the child account fund.
7. Add account-specific accrual rates at the category or product level as necessary.

Administrators can also assign rates at the fund group and publish to the account fund.

To assign accrual details at fund group and publish to account fund

1. Navigate to the Administration - Data screen, then the Fund Groups view.
2. Create a new Fund Group. Click the New button and enter the appropriate values in the fields
3. In the Accrual Details view, associate one or more categories for accrual.
   1. In the Category Name field, click the multiple select button.
   2. Select from the accrual Type, Period, and Organization fields.
   3. Click OK.
4. Associate products for accrual. The products can be specific products or an assortment of associated categories.
5. Enter accrual rates for categories.
6. In the Accrual Details view, click the Apply Rates button to apply category rates to accrual products.
7. As necessary, manually override accrual rates at the product level.
8. Click the Publish Accruals button to create new, or edit and delete existing accruals in the source and target category or products.
9. Navigate to a child account fund.
10. Add account specific accrual rates at the category or product level as necessary.

Administrators can also assign rates at the fund group source categories and products.

To assign accrual details at a fund group source category and product

1. Navigate to the Administration - Data screen, then the Fund Groups view.
2. Create a new Fund Group.
3. Navigate to the Administration - Data screen, then Fund Groups, and then the Accrual Details view.
4. Associate categories for accrual.
5. Associate products for accrual. The products can be specific products or a number of associated categories.
6. Enter accrual rates, accrual percent, and start and end dates for categories.
7. Click the Apply Rates button to apply category rates to accrual products.
8. Manually override accrual rates at the product level as necessary.

Administrators can also assign rates at the account fund group source categories and products.

To enter a fund rate at the category level and cascade the rate to child products

1. Navigate to the Data Administration screen, then the Funds view.
2. Create a new fund group or account fund. Include values in the Period and Organization fields.
3. Navigate to the Data Administration screen, then Funds, and then the Accrual Details view.
4. Associate one or more categories for accrual.
5. Associate one or more products for accrual. The products may be specific products or associated categories.
6. Enter accrual rates for categories.
7. Press the Apply Rates button to apply category rates to accrual products.
8. If necessary, manually override accrual rates at the product level.

To enter a fund group rate at the category level and cascade the rate to child products

1. Navigate to the Data Administration screen, then the Fund Groups view.
2. Create a new fund group or account fund. Include values in the Period and Organization fields.
3. Navigate to the Data Administration screen, then Fund Groups, and then the Accrual Details view.
4. Associate one or more categories for accrual.
5. Associate one or more products for accrual. The products may be specific products or associated categories.
6. Enter accrual rates for categories.
7. Press the Apply Rates button to apply category rates to accrual products.
8. If necessary, manually override accrual rates at the product level.