Monitoring supplier rebate agreements

All Supplier Rebate transactions for each agreement number are viewed in 'Sup Rebate Agr Transaction File. Display' (PPS478). The program shows all rebate transactions for each division and agreement with further filtering possible. The Rebate transaction status field indicates the last action performed for the record.

These statuses are available for each record in the transaction file:

  • 1 – Preliminary

  • 3 – Computed

  • 7 – Included in a batch invoice for supplier rebate claim

  • 8 – Updated in accounts payable

  • 9 – Cancelled

The transaction file also shows the values for Rebate rate, Generating Value, Rebate Base value, Net Amount, Supplier invoice number, Invoice batch number, and Rebate amount per transaction, enabling detailed monitoring for each transaction and agreement.

The transaction file (PPS478) also enables an overview of changes to rates and rebate amounts following changes in the agreement structure which affect the calculated rate, such as the percentages and scale rate tiers. If Option 10 – Update from Invoice or Option 20 – Update Rate is run through (PPS477), changes are immediately reflected in (PPS478), enabling ease of access and control over the result of the calculation and changes made to the agreement structure and terms.

Note: Changes are only applied to records with rebate status 1 – Preliminary, or 3 – Computed.