Export Earned Accruals to Microsoft Excel from Program Checkbook

Export earned accruals to Microsoft Excel from the Program Checkbook to provide supporting rebate details for customer programs. The export includes the associated invoiced order details for transactional accruals. This helps program managers or claim analysts to understand the accruals that make up earned balances for a customer and a program. Use these details to research accruals to understand if manual adjustments are required for a program, or to provide you additional information on how accruals are derived from corresponding invoiced orders.

Program Checkbook

Program Checkbook

Earned Accruals Extract Notification

Earned Accruals Extract Notification

Earned Accrual Spreadsheet

Earned Accruals Spreadsheet

This feature serves as an audit trail of rebate accruals earned by each customer in a program.

Here's the demo of these capabilities:

YouTube direct link

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Order Management

If you haven't implemented Customer Channel Programs, then refer to the Roadmap for Setting Up Customer Promotions chapter in the Implementing Channel Revenue Management guide.

After you implement Customer Channel Programs:

  1. Configure one or many program types.
  2. Define and activate programs based on the configured program type.
  3. Create accruals.

Tips And Considerations

You can download the earned accrual extract file by selecting the Bell notification from the Fusion Home page or any ADF UI. You can't download the file by selecting the Bell notification from a Redwood UI.

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can extract customer accruals for a program:

  • Extract Customer Accruals (CJM_EXTRACT_CUSTOMER_ACCRUALS_PRIV)
  • Extract Customer Accruals (CJM_EXTRACT_CUSTOMER_ACCRUALS_PRIV_OBI)

These privileges are new in this update.