9Trade Funds

Trade Funds

This chapter covers the procedures necessary to set up and assign funds to account promotions, promoted categories, and promoted products. Topics include:

• About Trade Funds

• Scenario for Managing Funds for Account Promotions

• Process of Managing Trade Funds

• Creating Funds

• Adding Child Funds to Parent Funds

• Adjusting Funds

• Reviewing Deals

• Reviewing Fund Payments

• Transferring Fund Amounts Without Constraint

• Reconciling Deals

• Closing Deals

• Forecasting Accrual Funds (End User)

• Transferring Fund Amounts with Constraint (End User)

• Approving Fund Transfers (End User)

• Submitting Payments for Funds (End User)

• Reviewing Funds (End User)

• About Configuring Trade Funds

• Configuring Trade Funds

About Trade Funds

A fund is a named appropriation of money to spend on account promotions over a specific period of time for specific accounts and specific categories and products. Fixed funds are fixed amounts of money allocated in a lump sum. Accrual funds are funds in which the amount of money is calculated based on product movement.

Marketing administrators set up funds and allocate larger funds to child funds that account managers use. Account managers can manage funds. They create deals for account promotions, submit payments against deals, and track fund activities.

Scenario for Managing Funds for Account Promotions

Marketing administrators and account managers perform the process in this example scenario for managing funds for account promotions. Your company might follow a different process according to its business requirements.

A large beverage manufacturing company develops a new category of fruit-flavored beverages. The account manager plans to run an account promotion with a feature and display of the new category. To pay for the account promotion, he uses funds that the marketing administrator establishes. He sets aside funds to pay for the account promotion by creating a deal for the feature and display.

After the account promotion runs, the account manager submits payments against the deal to pay for the account promotion.

Process of Managing Trade Funds

This topic lists the tasks that administrators and end users typically perform to manage funds. Your company might follow a different process according to its business requirements.

Administrator Procedures

The following list shows tasks that administrators typically perform to manage trade funds:

1. Creating Funds

2. Adding Child Funds to Parent Funds

3. Adjusting Funds

4. Reviewing Deals

5. Reviewing Fund Payments

6. Transferring Fund Amounts Without Constraint

7. Reconciling Deals

8. Closing Deals

End-User Procedures

The following list shows tasks that end users typically perform to access and use trade fund information:

• Forecasting Accrual Funds (End User)

• Transferring Fund Amounts with Constraint (End User)

• Approving Fund Transfers (End User)

• Submitting Payments for Funds (End User)

• Reviewing Funds (End User)

Creating Funds

Marketing administrators create funds that account managers use. Marketing administrators can manually create funds or use fund groups to automatically generate funds. Fund groups hold created funds and contain generic information that administrators can apply when generating a fund. Marketing administrators can create fixed funds and accrual funds.

This task is a step in Process of Managing Trade Funds.

Creating Fixed Funds

Fixed funds have a predetermined amount of money allocated in a lump sum that you use over a specified period of time. Administrators can manually create or automatically generate fixed funds. They usually automatically generate fixed funds for accounts from the same organization, and they manually create fixed funds for single accounts.

To manually create a fixed 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 Fixed in this field.
   Amount	The amount of money in this fund.
   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.
   Period	The period of time in which you can use this fund.
   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.

Use the following procedure to automatically generate a fixed fund.

To automatically generate a fixed 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 Fixed 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. You do not need to complete this field for fixed funds.
   Basis Period	The period of time for which the basis is valid. You do not need to complete this field for fixed funds.
   Source Category	The category with products that are used to calculate accruals. You do not need to complete this field for fixed funds. It acts as the parent source category. If it exists, only sub-categories of the selected category appear in the categories pick applet at the source 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.
   Amount	The amount of money in this fund group. This amount is divided between different accounts based on the percentage for each account.
   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, and 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. Enter a value in the Percentage field for each account record.

   The value in the Percentage field determines how much of the Amount field for the fund group is allocated to the account.

6. 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. The target products are the products that your company wants to promote in this account promotion.

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

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

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. In the Fund Groups list, create a new record, and complete the necessary fields.

3. Click the Accrual Details view tab.

4. Associate one or more categories for accrual.

   1. In the Category Name field, select a category.

   2. Click OK.

5. Associate one or more products for accrual.

   The products can be specific products or an assortment of associated categories.

6. Enter accrual rates for categories.

7. Click Apply Rates to apply category rates to accrual products.

8. If necessary, manually override accrual rates at the product level.

9. In the Fund Groups list, click Publish Accruals to publish accrual rates to child account funds.

10. Navigate to the child account fund.

11. 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. In the Fund Groups list, create a new record, and complete the necessary fields.

3. Click the Accrual Details view tab.

4. Associate one or more categories for accrual.

   1. In the Category Name field, select from the accrual Type, Period, and Organization fields.

   2. Click OK.

5. Associate products for accrual.

   The products can be specific products or an assortment of associated categories.

6. Enter accrual rates for categories.

7. Click Apply Rates to apply category rates to accrual products.

8. If necessary, manually override accrual rates at the product level.

9. In the Fund Groups list, click Publish Accruals to create new, or edit and delete existing accruals in the source and target category or products.

10. Navigate to a child account fund.

11. 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. In the Fund Groups list, create a new record, and complete the necessary fields.

3. Click the Accrual Details view tab.

4. Associate categories for accrual.

5. Associate products for accrual.

   The products can be specific products or an assortment of associated categories.

6. Enter accrual rates, accrual percent, and start and end dates for categories.

7. Click Apply Rates to apply category rates to accrual products.

8. If necessary, manually override accrual rates at the product level.

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 Administration - Data screen, then the Funds view.

2. Create a new fund group or account fund.

   Include values in the Period and Organization fields.

3. Click the Accrual Details view tab.

4. Associate one or more categories for accrual.

5. Associate one or more products for accrual.

   The products can be specific products or associated categories.

6. Enter accrual rates for categories.

7. Click Apply Rates 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 Administration - Data screen, then the Fund Groups view.

2. Create a new fund group or account fund.

   Include values in the Period and Organization fields.

3. Click the Accrual Details view tab.

4. Associate one or more categories for accrual.

5. Associate one or more products for accrual.

   The products can be specific products or associated categories.

6. Enter accrual rates for categories.

7. Click Apply Rates to apply category rates to accrual products.

8. If necessary, manually override accrual rates at the product level.

Adding Child Funds to Parent Funds

The Funds module supports a multi-level fund hierarchy. For example, a parent fund can have child funds, which in turn can have child funds. This hierarchy allows marketing administrators to divide into smaller funds the fund records that you transfer from an external database using Siebel Enterprise Integration Manager (EIM).

This task is a step in Process of Managing Trade Funds.

To add a child fund to a parent fund

1. Navigate to the Administration - Data screen, then the Funds view.

2. In the Funds list, select a parent fund record.

3. Click the Child Funds view tab.

4. In the Child Funds list, create a new record, and complete the necessary fields.

Use the following procedure to add a grandchild fund to a fund.

To add a grandchild fund to a fund

1. Navigate to the Administration - Data screen, then the Funds view.

2. In the Funds list, select a parent fund record.

3. Click the Child Funds view tab.

4. In the Child Funds list, drill down on the Fund field hyperlink for a child record.

   In the Funds list, the child fund record appears.

5. In the Child Funds list, create a new record (the grandchild fund), and complete the necessary fields.

Adjusting Funds

After you create a fund, you can increase or decrease the amount of a fund. Typically, you adjust a fund to reflect changes in market conditions.

This task is a step in Process of Managing Trade Funds.

To create an adjustment for a fund

1. Navigate to the Administration - Data screen, then the Funds view.

2. In the Funds list, select a fund record.

3. Click the Adjustments view tab.

4. In the Adjustments list, create a new record.

5. In the Amount field, enter a negative or positive amount, for example, 5,000 or -5,000, for the fund adjustment.

6. Enter a description of the adjustment, for example, the reason for the adjustment.

   The new amount of money available in the fund appears in the Sub-total field in the More Info view for the fund.

Reviewing Deals

You can review a deal for an account promotion, a promoted category, and a promoted product, or you can review the deals for a fund.

This task is a step in Process of Managing Trade Funds.

To review a deal for an account promotion

1. Navigate to the Promotions screen, then the Account Promotions List view.

2. Drill down on the Promotion field hyperlink for the account promotion, and click the Deals view tab. For details about the fields in the Deals view, see Creating Deals for Account Promotions.

3. Select a deal and scroll down to the Payments view to examine payments for this deal.

   The records in this view are created when you submit payments against funds. For more information, see Submitting Payments for Funds (End User).

4. Click the Bundled Products view tab to examine details of the bundled products for this deal.

Use the following procedure to review a deal for a promoted category.

To review a deal for a promoted category

1. Navigate to the Promotions screen, then the Account Promotions List view.

2. Drill down on the Promotion field hyperlink for an account promotion.

3. Scroll down to the Promoted Categories list, and drill down on the Category field hyperlink.

   Details about deals for the promoted category appear in the Deals view. For details about the fields in this view, see Creating Deals for Promoted Categories.

4. Select a deal and scroll down to the Payments view to examine payments for this deal.

   The records in this view are created when you submit payments against funds. For more information, see Submitting Payments for Funds (End User).

5. Click the Bundled Products view tab to examine details of the bundled products for this deal.

Use the following procedure to review a deal for a promoted product.

To review a deal for a promoted product

1. Navigate to the Promotions screen, then the Account Promotions List.

2. Drill down on the Promotion field hyperlink for an account promotion.

3. Scroll down to the Promoted Categories list, and select a category.

4. Scroll down to the Promoted Products list, and drill down on the Product field hyperlink.

   Details about deals for the promoted product appear in the Deals view. For details about the fields in this view, see Creating Deals for Promoted Categories.

5. Select a deal and scroll down to the Payments view to examine payments for this deal.

   The records in this view are created when you submit payments against funds. For more information, see Submitting Payments for Funds (End User).

6. Click the Bundled Products view tab to examine details of the bundled products for this deal.

Use the following procedure to review deals for a fund.

To review the deals for a fund

1. Navigate to the Administration - Data screen, then the Funds view.

2. In the Funds list, select a fund record.

3. Click the Deals view tab.

   The deals for the fund and the payments from the fund appear.

Reviewing Fund Payments

You can review all payments against a fund.

This task is a step in Process of Managing Trade Funds.

To review fund payments

1. Navigate to the Administration - Data screen, then the Funds view.

2. In the Funds list, select the fund record.

3. Click the Payments view tab.

   The Payments list displays all payments against the fund.

Transferring Fund Amounts Without Constraint

Administrators can transfer amounts between funds, with no constraints as to time, type, or account ID. End users have a more constrained ability to transfer funds. For information about how end users can transfer funds, see Transferring Fund Amounts with Constraint (End User). For information about how end users can approve fund transfers, see Approving Fund Transfers (End User).

Note: Transfers that administrators create in the Funds view automatically advance to the status of Paid after entry is complete.

This task is a step in Process of Managing Trade Funds.

To transfer a fund amount without constraint

1. Navigate to the Administration- Data screen, then the Funds view.

2. Select a fund record, and click the Fund Transfer view tab.

3. Create a new record:

   • If you want to transfer an amount into this fund, complete the necessary fields in the Transfer In subview.

   • If you want to transfer an amount out of this fund, complete the necessary fields in the Transfer Out subview.

Note: You can transfer money between funds of different currencies.

Reconciling Deals

You can reconcile a deal’s amounts to all payments for that deal.

This task is a step in Process of Managing Trade Funds.

To reconcile a deal to the associated payments

1. Navigate to the Administration - Data screen, then the Fund Deals view.

2. In the Fund Deals list, select the deal record.

3. Click Release Commitments.

   The deal amount is updated to the sum of all payments.

Closing Deals

You can close a deal when you want to prevent users from making any further payments against the deal.

Note: If you want to reconcile and close the same deal, reconcile the deal before you close it. For more information, see Reconciling Deals.

This task is a step in Process of Managing Trade Funds.

To close a deal

1. Navigate to the Administration - Data screen, then the Fund Deals view.

2. In the Fund Deals list, select the deal record.

3. From the Status field drop-down list, select Closed.

   The deal is closed, and users can make no further payments against the deal.

Forecasting Accrual Funds (End User)

Account managers or administrators might want to forecast the amount of revenue that an accrual fund will generate. They can forecast using any of the Administration Fund views or using the Funds view for an account. The forecast calculation is based on SVP baseline records that are associated with the fund. When the user clicks the Forecast button, the appropriate SVP baseline records are used to forecast the accrual fund. The following rules determine the baseline records that are used:

• The start and end dates of the baseline record must be within the effective start and end dates of the source product.

• The account of the baseline record must be the same account for the source product.

• The product of the baseline record must be the same as the source product.

These SVP baseline records are associated with an accrual fund in much the same way that SVP baseline records are associated with account promotions.

After the SVP baseline records are associated with the accrual fund, adjustments are made for partial weeks. Then the SVP baseline records are rolled up to the source product, where the Accrual Rate or Accrual % is applied to calculate the forecast for source products. Then, the forecast for each source product is rolled up to the account accrual fund.

This task is a step in Process of Managing Trade Funds.

To create a forecast for an accrual fund

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.

3. In the Funds list, select an accrual fund record, and click Forecast.

   The appropriate baseline records are associated with the fund, and the Forecast field for the fund is populated.

After you create the forecast for the accrual fund, you can examine the forecasted revenue for the fund and for each source product that is associated with the fund.

To review the forecasted revenue for accrual funds and associated source products

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.

3. In the Funds list, select an accrual fund record for which you created a forecast.

4. Examine the Forecast field for this record.

   This field is the forecasted value of the fund and is calculated from the rollup of the Forecast field from all source products.

5. Scroll down, and click the Source Products view tab.

6. For each source product examine the following fields:

   • Est Total Volume. This field is the rolled-up value of the Estimated Total Volume of all the SVP baseline records associated with this source product. This field is also adjusted for partial periods.

   • Forecast. This field is calculated as follows:

     • If the basis is cases, the Est Total Volume multiplied by the Accrual Rate of the source product.

     • If the basis is revenue, the Est Total Volume multiplied by the Accrual %.

Transferring Fund Amounts with Constraint (End User)

Account managers can transfer amounts between funds. Typically, transferring funds requires approval from a regional sales manager or a marketing administrator. For information about approving fund transfers, see Approving Fund Transfers (End User).

Note: When transferring funds, end users can access funds only if they are on the account team of the fund account. Administrators, however, can access all account funds with no time, type, or account constraints. For information about how administrators can transfer funds, see Transferring Fund Amounts Without Constraint.

This task is a step in Process of Managing Trade Funds.

To transfer a fund amount with constraint

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.

3. In the Funds list, select a fund record.

4. Click the appropriate view tab, and create a new record:

   • If you want to transfer an amount into this fund, click the Transfers In view tab.

   • If you want to transfer an amount out of this fund, click the Transfers Out view tab.

   Note: You can transfer money between funds of different currencies.

5. Complete the necessary fields.

   Note: The From and To fields in the Transfers In and Transfers Out view tabs display only funds that are allocated to the current account.

6. In the Submitted To field, select the employee who is responsible for approving the transfer.

   The transfer appears in the Transfer Approvals view of the employee that you select.

7. Change the Status field to Submitted.

Approving Fund Transfers (End User)

Regional sales managers and marketing administrators can view and approve fund transfers.

This task is a step in Process of Managing Trade Funds.

To approve a fund transfer

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.

3. In the Funds list, select a fund record.

4. Click the Transfer Approvals view tab.

5. In the Status field drop-down list, select Approved.

Submitting Payments for Funds (End User)

Before running an account promotion, account managers can create deals for the account promotion, its promoted categories, and its promoted products. After they run the account promotion, the account managers submit payments for those deals.

The following table summarizes a payment at different status stages and the results that the end user sees.

Pending Amount	Submitted Amount	Paid Amount
For the deal that is associated with the record that has a status of Pending, Requested, or Rejected, the Payments Pending field is updated with the amount of the record.	After the payment is approved, the end user manually changes the status of the record to Submitted. For the deal that is associated with the record, the Payments Pending field is decreased, and the Payments Submitted field is increased by the amount of the record.	The back office updates the status of the record to Paid. (You can also manually change the status of the record to Paid.) For the deal that is associated with the record, the Payments Submitted field is decreased, and the Payments Paid field is increased by the amount of the record. For the fund that is associated with the deal, the Payments field is updated. In the plan, account promotion, promoted categories, and promoted products containing the deal, the Actual Total Spend field is updated with the amount of the record.

Note: You must request approval for a new payment record before you can submit it. After the payment receives approval, you can change the status to Submitted. For information about approving payments, see Approving or Rejecting Payments.

After submission, payments are sent to the back office for processing. When processing is complete, the status of the payment changes to Paid. The application identifies and processes payments with a status of Paid. For more information about this processing and the results, see About Configuring Trade Funds.

This task is a step in Process of Managing Trade Funds.

To submit a payment against a fund

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Checkbook view tab.

3. In the Checkbook list, perform either of the following actions, as appropriate for your needs:

   • Query for a check.

   • Create a new check.

4. In the Payments list, create a new payment, click the select button in the Deal ID field, select a deal in the Pick Allocation dialog box, and click OK.

5. In the Amount field for the payment, enter the payment amount.

6. (Optional) In the Pay To field, enter the name of the check recipient.

7. (Optional) In the Document # field, enter the payment number as issued by the financial application (for example, a check number or credit memo number).

8. (Optional) In the Issue Date field, enter the date on which the financial document was issued for payment.

Reviewing Funds (End User)

Account managers can review funds to track estimated, committed, and actual spending.

This task is a step in Process of Managing Trade Funds.

To review funds

1. Navigate to the Accounts screen, then the Accounts List view.

2. Drill down on the Name field hyperlink for an account, and click the Funds view tab.

   The Funds list displays all funds that are associated with the account record.

3. Click the More Info view tab to review the fields.

   The following table describes some fields.

Field	Comments
Fund	The name of the fund.
Fund Id	The automatically generated identification number of the fund.
Account	The account that is associated with the fund.
Type	The fund type (Accrual or Fixed). Accrual funds are funds in which the amount is calculated from the products and accruals that are associated with the fund. Fixed funds are fixed amounts of money allocated in a lump sum.
Period	The period of time for which the fund is valid.
Start	The starting date of the fund.
End	The ending date of the fund.
Basis	The value (for example, Cases or Revenue) used to accrue funds.
Unallocated	Calculated by subtracting allocations to child funds from the fund subtotal.
Estimated	The amount in deals with a status other than Committed or Closed.
Committed	The amount in deals with a status of Committed or Closed.
Uncommitted	The amount from a fixed fund that is not allocated to a child fund. Calculated by subtracting the committed amount from the fund subtotal.
Amount	The beginning amount of the fund.
Adjustments	The adjustments to the fund amount. Includes decreases or increases to the fund amount. Excludes transfers, accruals, and payments.
Transfers	The sum of the approved transfers into or out of the fund.
Sub-total	Amount plus Adjustments plus Transfers.

About Configuring Trade Funds

This topic contains information that might be useful when configuring the trade fund features. Topics include:

• About Rolling Up Paid Payments

• About the Consumer Goods Payment Business Service

• Funds Configuration for Enterprise Integration Manager

• Specialized Methods Invoked in Funds

• User Properties for Funds

About Rolling Up Paid Payments

After the end user submits payments, the payments are sent to the back office for processing. After the payments are processed, the status of the payment is changed to Paid. When the payment status is changed to Paid in a back-office system, the following events occur, resulting in the aggregation, or rolling up, of payment data in Siebel Consumer Goods:

1. The CG Payment workflow policy (part of the CG Payment workflow group) is invoked.

2. The Workflow Monitor Agent task is started for the CG Payment workflow group, which monitors the CG Payment policy.

3. When the payment status is updated to Paid, the workflow process is executed.

4. The workflow policy invokes the CG Payment Process workflow.

5. The workflow process invokes the CG Payment Business Service.

6. The business service rolls up (aggregates) Paid payments in the plan, account promotion, promoted category, and promoted product (if the payment is associated with the promoted product):

   • If a paid payment is associated with an account promotion, the payment is rolled up to the account promotion and the plan that contains the account promotion (if a plan is available).

   • If a paid payment is associated with a promoted product, the payment is rolled up to the promoted product, promoted category that contains the promoted product, account promotion that contains the promoted category, and plan that contains the account promotion (if a plan is available).

CG Payment Business Service completes the rollup, you can verify if the workflow succeeded by looking at the Actual Total Spend field of the plan, account promotion, promoted category, and promoted product. The Actual Total Spend field is the sum of all the payments at that level and lower.

About the Consumer Goods Payment Business Service

The CG Payment Business Service uses the CPG Plan business object and the following business components:

• CPG Plan Account Promotion

• CG MDF Promotion Allocation

• CPG Promo Deal Payment

• CS CG Plan Account Promotion Category

• CG Promo Product Fund Payment

• CS CG MDF Promotion Category Allocation

• CS CG Promotion Category Deal Payment

• CPG Plan Account Promotion Product

• CPG MDF Allocation

• CPG Check Payment via MDF

The business service performs the following primary steps:

• Copies the Amount field into Paid Amount in the Paid bucket.

• Rolls up the Paid Amount to the Payments Paid field in the Parent.

• Rolls up Paid payments in the allocation to the Actual Total Spend field in the parent promotion.

When the workflow process in About Rolling Up Paid Payments invokes the CG Payment business service, the same business service executes the following actions:

1. The CG Payment business service gets the ROW_ID of the payment record with a status of Paid.

2. Gets the Fund Allocation Id, which is the Allocation Id of the payment record.

3. Gets the CPG Plan business object and the CG MDF Promotion Allocation business component.

4. Runs through the records in the CG MDF Promotion Allocation business component and positions to the record with the ROW_ID of the Fund Allocation Id.

5. Finds the values of the Fund Promotion Id, Plan Account Promo Prod Id, and Plan Account Promotion Cat Id fields from the positioned record so as to determine the deal type as seen in the following table:

   Deal Type	Fund Promotion Id	Plan Account Promo Prod Id	Plan Account Promotion Cat Id
   Promotion Deal	NOT Empty	Empty	Empty
   Promoted Category Deal	NOT Empty	Empty	NOT Empty
   Promoted Product Deal	NOT Empty	NOT Empty	NOT Empty

6. Based on the deal type, the business service instantiates the following business components from the CPG Plan business object as seen in the following table:

   Deal Type	Business Component
   	Parent BC	Child BC	Grand Child BC
   Promotion Deal	CPG Plan Account Promotion	CG MDF Promotion Allocation	CPG Promo Deal Payment
   Promoted Category Deal	CS CG Plan Account Promotion Category	CS CG MDF Promotion Catetgory Allocation	CS CG Promotion Category Deal Payment
   Promoted Product Deal	CPG Plan Account Promotion Product	CPG MDF Allocation	CG Promo Product Fund Payment

7. The CG Payment business service then executes the Parent business component.

8. The CG Payment business service positions the Parent BC of the deal on the following Id field as seen in the following table:

   Deal Type	ROW_ID
   Promotion Deal	Fund Promotion Id
   Promoted Category Deal	Plan Account Promo Prod Cat Id
   Promoted Product Deal	Plan Account Promo Prod Id

9. Next, it positions the Child business component with Fund Allocation Id.

10. Finally, it positions the Grand Child business component with ROW_ID as in Step 1 of this procedure.

11. After the Grand Child is positioned, it sets the following values for this business component:

    • Paid Amount = Trade Fund Amount

    • Submitted Amount = 0

    • Pending Amount = 0

12. After the values are set, it saves the record with updated values and forces the Rollup.

Funds Configuration for Enterprise Integration Manager

The COST_TYPE_CD column on the S_MDF_ALLOC table has a List of Values (LOV) bounded property and is part of the S_MDF_ALLOC_U2 key. It is used to uniquely identify the ALLOC records. Currently, you cannot remove the LOV bounded flag on the COST_TYPE_CD column. This property definition causes EIM to search for a bounded LOV value. Because EIM cannot find the unique values for this column on the List of Values table, EIM cannot update the allocation record error.

Specialized Methods Invoked in Funds

The procedures documented in this chapter include buttons that invoke specialized methods, as described in the following table.

Button	Method	Description	Supported On
Apply	ShowPopup	Shows a group of eligible accounts.	Bus Comp Layer
	OK	Adds fund participants to the fund group.
Generate	FundGenerate	Adds account funds to the fund group.	Bus Comp Layer
Products	OnCatalogProducts	Adds all products that belong to the source category or target category of the fund or fund group.	Bus Comp Layer
Refresh	OnRefreshMvg	Refreshes the form.	Bus Comp Layer
Release Commitments	ReleaseCommitment	Adjusts the amount of the deal to equal the sum of the deal payments.	Bus Comp Layer

User Properties for Funds

The following information lists the user properties administrators must set to control propagation of source products from fund groups to account funds.

Parent Object Type	Business Component
Description	You can set the following user properties on the CS Fund Group business component: Populate Products. The value can be Y or N. The default value is N. When you set the value to Y, the source and target products at the fund group level are populated when users click the Generate button to generate account funds. Total Records. The value is a number, for example, 10. The default value uses the business service. If the total number of source and target records at the fund group level exceeds the number in this field, the business service process is used to generate the account funds. Otherwise, the client process is used to generate the account funds.
Functional Area	CS Fund Group

Configuring Trade Funds

To use the CG Payment Process, you need to export the workflow process from the sample database of the Consumer Goods application and import the workflow process into the server database. Complete the procedures in this topic.

To export the workflow process

1. From the Siebel Consumer Goods application, connect to the sample database.

2. Navigate to the Administration - Business Process screen, then the Workflow Processes view.

3. In the Workflow Processes list, query for a Name of CG Payment Process.

4. Click Menu, and select Export Workflow.

5. Export the CG Payment Process in XML format to a location from which you can retrieve it.

Use the following procedure to import the workflow process.

To import the workflow process

1. From the Siebel Consumer Goods application, connect to the server database.

2. Navigate to the Administration - Business Process screen, then the Workflow Processes view.

3. Click Menu, and select Import.

4. Import the CG Payment Process workflow that you exported in XML format to the server database.

Before you run the Process Simulator for the first time, you must set your debug options. For more information, see Siebel Business Process Framework: Workflow Guide.

To execute the workflow process invoked by Workflow Policy

1. Navigate to the Administration - Business Process screen, then the Workflow Policy Actions view.

2. In the Actions list, create a new action, select Run Workflow Process in the Program field for the action, and perform the following steps:

   1. In the Arguments list, create a new argument.

   2. In the Argument field of the Arguments list, select ProcessName.

   3. In the Value field of the Arguments list, enter the name of the workflow process (for example, CG Payment Process) that you want to invoke as the argument value.

3. Navigate to the Administration - Business Process screen, then the Workflow Policy Groups view.

4. In the Policy Groups list, create a new group, and enter a name for the group in the Name field.

5. Navigate to the Administration - Business Process screen, then the Workflow Policies view.

6. In the Policies List, create a new policy, and perform the following steps:

   1. In the Conditions list, create a policy condition that must be met to invoke the workflow process.

   2. In the Actions list, create a new action, and enter the name of the action that you created in Step 2 of this procedure..

7. Run Generate Triggers.

   For more information about generate triggers, see Siebel Business Process Framework: Workflow Guide.

8. If you are using the Run Workflow Process program, verify that the Workflow Process Manager server component is online.

9. Run Workflow Monitor Agent.

   For more information about Workflow Monitor Agent, see Siebel Business Process Framework: Workflow Guide.

Use the following procedure to access the CG Payment Process workflow process.

To access the CG Payment Process workflow process

1. Navigate to the Administration - Business Process screen, then the Workflow Processes view.

2. In the Workflow Processes list, click Menu and select New Query.

3. In the Name field, enter CG Payment Process.

4. Click Menu, and select Run Query.

5. In the Name field, drill down on the CG Payment Process hyperlink.

   The Workflow Process Designer view appears. Use the graphical flowchart tool in this view to modify the business service. For more information about workflows, see Siebel Business Process Framework: Workflow Guide.