Rebate transaction overview (DMR44601)

This program displays all rebate transactions that originate from the same source, i.e. from the same invoice/purchase statistic line. It is, therefore, possible to determine how the rebates have been calculated for various transactions.

This panel can be accessed from Sales order enquiry, Invoice enquiry, Purchase order enquiry and from the Rebate transaction detail panel.

Function keys

Selection fields

Invoice no

Displays the invoice number for the invoice line from which the listed rebate transactions originate. This field is only displayed when the program is accessed from the Invoice enquiry or when the program is accessed for a customer rebate transaction.

Order no

Displays the order number for the order line from which the listed rebate transactions originate. The order number can either be a sales order number or a purchase order number, depending from where this program is accessed. This field is only displayed when the program is accessed from the Sales order enquiry, Purchase order enquiry or when the program is accessed for a supplier rebate transaction.

Invoice line

Displays the invoice line number for the line from which the listed rebate transactions originate. This field is only displayed when the program is accessed from the Invoice enquiry or when the program is accessed for a customer rebate transaction.

Order line

Displays the order line number for the line from which the listed rebate transactions originate. The order line number can either be a sales order line number or a purchase order line number, depending from where this program is accessed. This field is only displayed when the program is accessed from the Sales order enquiry, from the Purchase order enquiry or when the program is accessed for a supplier rebate transaction.

Invoice date

Displays the invoice date for the sales order/invoice line from which the listed rebate transactions originate. This field is only displayed when the program is accessed from the Invoice enquiry or when the program is accessed for a customer rebate transaction or Sales order enquiry.

Reception date

Displays the reception date for the PO line from which the listed rebate transactions originate. This field is only displayed when the program is accessed from the Purchase order enquiry or when the program is accessed for a supplier rebate transaction.

Supp inv dat

Displays the supplier invoice date for the PO line from which the listed rebate transactions originate. This field is only displayed when the program is accessed from the Purchase order enquiry or when the program is accessed for a supplier rebate transaction.

Customer

Displays the customer number and the customer name for the invoice line from which the listed customer rebate transactions originate. This field is only displayed when the program is accessed from the Sales order enquiry, Invoice enquiry or when the program is accessed for a customer rebate transaction.

Supplier

Displays the supplier number and the supplier name for the purchase order line from which the listed supplier rebate transactions originate. This field is only displayed when the program is accessed from the Purchase order enquiry or when the program is accessed for a supplier rebate transaction.

Warehouse

Displays the transaction warehouse for the invoice/purchase statistic line from which the listed rebate transactions originate.

Item

Displays the concatenated item code and item description for the invoice/purchase statistic line from which the listed rebate transactions originate.

Quantity

Displays the transaction quantity for the invoice/purchase statistic line from which the listed rebate transactions originate.

Unit

Displays the transaction unit for the invoice/purchase statistic line from which the listed rebate transactions originate.

Line amount

Displays the line amount for the invoice/purchase statistic line from which the listed rebate transactions originate.

Cash disc

Displays the expected cash discount amount for the order line from which the rebate transaction originate. If the rebate agreement flag for “Target, reduce cash discount” is equal to YES, this amount is reduced from the “Target line amount” before that amount is accumulated to the target turnover.

Currency

Displays the transaction currency for the invoice/purchase statistic line from which the listed rebate transactions originate.

Agreement type

This column lists the rebate agreement type on the rebate agreement from which the rebate transaction originates.

Sequence

This column lists the rebate agreement type sequence for the agreement type on the rebate agreement from which the rebate transaction originates.

Rebate agreement

This column lists the rebate agreement ID on the agreement from which the rebate transaction originates.

Affect margin

This column lists the affect margin flag on the rebate agreement from which the rebate transaction originates. The affect margin flag indicates if the rebate transaction has been included in an expected rebate amount calculation for a sales order line. It also indicates if the rebate amount is included in the system balance type for Rebate, affect margin cost.

End rebate

This column lists the end rebate flag for the rebate agreement type on the rebate agreement from which the rebate transaction originates. If it is set to YES, no more rebate amounts are calculated for the following rebate transactions created for the invoice/purchase statistic line. All of the subsequent transactions are only used for target accumulation.

Single rebate

This column lists the single rebate flag for the rebate agreement type on the rebate agreement from which the rebate transaction originates. If it is set to YES, no more rebate amounts are calculated for the following rebate transactions created for the invoice/purchase statistic line originating from rebate agreements with the same agreement type. All of the subsequent transactions with the same agreement type are only used for target accumulation.

Target contributor

This column indicates if the rebate transaction is a target contributor, i.e. if the Target line amount is used to accumulate the target turnover on the rebate agreement from which the rebate transaction originates.

Rebate qualifier

This column indicates if the rebate transaction is a rebate qualifier, i.e. if a rebate amount has been calculated for the transaction. The Rebate line amount is accumulated to the agreement turnover on the rebate agreement from which the rebate transaction originates.

Target UOM quantity

This column lists the transaction quantity according to the Target UOM unit in case one is defined on the rebate agreement from which the rebate transaction originates. If a target UOM unit is defined it is this quantity that is accumulated to the target turnover on the rebate agreement.

Target UOM unit

This column lists the target UOM unit in case one is defined on the rebate agreement from which the rebate transaction originates. If a target UOM unit is defined, the unit quantities are to be defined accordingly on the target limits.

Rate UOM quantity

This column lists the transaction quantity according to the Rate UOM unit in case one is defined on the rebate agreement from which the rebate transaction originates. If a rate UOM unit is defined, it is this quantity that is multiplied with the reached rate (which is an amount per the defined unit) in order to calculate the correct rebate for the transaction. If a rate UOM unit is defined, it is this quantity that is accumulated to the agreement turnover on the rebate agreement.

Rate UOM unit

This column lists the rate UOM unit in case one is defined on the rebate agreement from which the rebate transaction originates. If a rate UOM unit is defined, the rate amounts on the target limits are to be defined accordingly.

Rebate currency

This column lists the rebate currency that is defined on the rebate agreement from which the rebate transaction originates. All amounts for this transaction are displayed according to this currency.

Target, reduce cash discount

This column indicates if the expected cash discount amount is reduced from the Target line amount before the amount is accumulated to the target turnover on the rebate agreement from which the rebate transaction originates.

Rebate, reduce cash discount

This column indicates if the the expected cash discount amount is reduced from the Rebate line amount before the amount is accumulated to the agreement turnover on the rebate agreement from which the rebate transaction originates, and before the rebate amount is calculated for the transaction.

Target line amount

This column lists the line amount that has been used for accumulation to the target turnover (unless a target UOM unit is defined) on the rebate agreement from which the rebate transaction originates. This amount can differ from the original line amount if the “Target, reduce cash discount” flag is equal to YES on the rebate agreement, or if the “Target, reduce rebate” flag is equal to YES on any preceding rebate transaction.

Rebate line amount

This column lists the line amount that has been used for accumulation to the agreement turnover on the rebate agreement from which the rebate transaction originates, and it is also this amount that has been used to calculate the rebate amount (unless rate UOM amount/unit is used). This amount can differ from the original line amount if the “Rebate, reduce cash discount” flag is equal to YES on the rebate agreement, or if the “Rebate, reduce rebate” flag is equal to YES on any preceding rebate transaction.

Current target turnover

This column lists the current target turnover (including the target line amount/qty target UOM unit for this transaction) on the rebate agreement at the situation when this transaction was created for that agreement.

Current agreement turnover

This column lists the current agreement turnover (including the rebate line amount/qty rate UOM unit for this transaction) on the rebate agreement at the situation when this transaction was created for that agreement.

Rate

This column lists the rate that was used to calculate the rebate amount on the rebate transaction.

Rebate amount

This column lists the calculated rebate amount for the rebate transaction. If the rebate amount is manually changed, this field will display the manually entered rebate amount.

Original rebate amount

This column lists the original rebate amount for the rebate transaction. If the rebate amount is manually changed, the originally calculated rebate amount is moved to this field. The flag for Manually changed is then set equal to Y. The original rebate amount is also updated in one other scenario. When a rebate agreement is closed and the rebate transaction is already selected for rebate claim, there might be a difference between rebate amount and claim/pay amount. Since claim/pay amount in this situation is moved to rebate amount, then the rebate amount is first moved to original rebate amount. To make it possible to establish from where original rebate amount is assigned its value, manually changed will in this case be set equal to N.

Manually changed

This column indicates if the original rebate amount holds a value because of a manual change of rebate amount on the rebate transaction (manually changed = YES), or if the original rebate amount holds a value because of close agreement for a transaction selected to a claim/payment and a difference between claim/pay amount and rebate amount (manually changed = NO)

Target, reduce rebate

This column indicates if the rebate amount from this transaction will reduce the target line amount for transactions that are created for subsequent rebate agreements.

Rebate, reduce rebate

This column indicates if the rebate amount from this transaction will reduce the rebate line amount for transactions that are created for subsequent rebate agreements.

Status

This column lists the rebate transaction status.

A transaction can have the following statuses:

F	Final. The transaction is not yet selected for any rebate claim/payment.
S	Selected. the transaction is created for a rebate claim/payment that is not yet claimed/paid.
O	Order created. The transaction is selected for a rebate claim/payment with claim method = A/R and a claim/payment order has been created.
C	Claimed/Paid. The transaction has been claimed/paid.
D	Deleted. The transaction is either manually deleted or belongs to a rebate agreement that has been manually deleted while the transaction had status F.

Claim/pay amount

This column lists the rebate amount that will be claimed/paid for the rebate transaction. This amount can differ from the calculated rebate amount if the claim/pay amount was changed because of a manual rebate amount change on the rebate claim/payment header. The amounts can also differ if the agreement has been rebuilt after the transaction was selected for a rebate claim/payment.