Generating rebate accruals report
- Open a supplier rebate agreement.
- On the supplier rebate agreement page, click Rebate Accruals.
-
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.
-
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. -
- Optionally, click Claim Detail Report to view the claims related to the agreement.