Generating rebate accruals report

Note: You can also generate accrual reports by using the Rebate Accrual Query form.
  1. Open a supplier rebate agreement.
  2. On the supplier rebate agreement page, click Rebate Accruals.
  3. Specify this information:
    Report Type
    Select a report type:
    • The supplier cumulative rebate summary shows accumulated values for each period for the generating value, accumulative value, spent, total spent, period rebate, and total rebate from purchase orders made under the agreement.
    • The supplier cumulative rebate details shows accumulated values for each month for the generating value, paying amount, and accrued rebate for each item.
    Report Category
    Specify whether or not to include base rebates in the accrual report. Each base incentive becomes an additional row in the report, with the corresponding value displayed in the Pending Rebate column.
    Report Basis
    Select the type of purchase order to use as a report basis:
    • Purchase Orders
    • Purchase Orders with Receipts only
    Note: This field is not displayed when the accruals are period-based.
    Incentive

    Select the incentive number that shows in the accrual report. The corresponding description of the selected incentive number is displayed beside the dropdown list.

    Year
    Select the year of the accrual data that shows in the report.

    This parameter filters the transaction date when the accruing incentive has a claim type value of Once, Never, or Periodically.

    When the accruing incentive claim type is M3 Calendar, this shows and filters the M3 calendar year setup.

    Priority
    Select the priority of the accrual data that shows in the report.

    This option is only available for the Report Type Supplier Cumulative Rebate Details.

  4. Optionally, click Related Purchase Orders to view the contribution of purchased orders to the accrued rebate amount.

    When you select Purchase Order as report basis, the Related Purchase Orders form shows a report with these fields:

    • Supplier Number

    • Warehouse

    • Item Number

    • Purchase No

    • PO Line No

    • PO Line Sub

    • Ordered Qty

    • Ordered Qty UM

    • Generating Value

    • Paying Amount

    • Accrued Rebate Amount

    • Incentive No

    • When you select Purchase Order with receipts only as report basis, the Related Purchase Orders form shows a report with these fields::

      • Supplier Number

      • Warehouse

      • Item Number

      • Purchase No

      • PO Line No

      • Receipt No

      • Received Qty

      • Received Qty UM

      • Generating Value

      • Paying Amount

      • Accrued Rebate Amount

      • Incentive No

    Note: This option is available only from the detailed report type.
  5. Optionally, click Claim Detail Report to view the claims related to the agreement.