Enter rebate information in a matrix cell to ensure that you are accurately reimbursed by the vendor for rebates offered to your customers. The matrix cells used to derive costs or pricing for contract or rebated items depend on how the customer-specific matrix cells have been defined.
From the Maintenance > Price Maintenance menu, select Sell Matrix or Quick Sell Matrix to display the Sell Matrix Maintenance window or Quick Sell Matrix Maintenance window.
Note: Not all options described below are available in Quick Sell Matrix.
Create a new sell matrix cell, or enter the necessary information to display the matrix cell for which to add rebate information.
In the Matrix Type field or Type column, enter a matrix type. The matrix cells the system uses for assigning costs or pricing for contract or rebated items depend upon how you defined the customer-specific matrix sells. Enter one of the following matrix types:
Click the Rebates tab to display the sell matrix rebate options, and complete the following as needed:
|
In the column... |
Description |
|
Mode |
Enter one of the following:
|
|
Contract Number |
Enter the contract number for the rebate offer. The vendor supplies this number, and it appears on the Customer Sales Rebate Report. You can sort the report by contract number. Note: For product sales information from this matrix cell to display on the rebates report, entry is required in this field or in the Contract Number field on the Customer Rebate Maintenance dialog box (Maintenance > Customer > Pricing > Rebate) |
|
Rebate Vendor |
Enter the vendor's name for which the Customer Sales Rebates Report for this item will be submitted. By defining the rebate vendor, you can create a report for that vendor. Note: For product sales information from this matrix cell to display on the rebates report, entry is required in this field or in the Rebate Vendor field on the Customer Rebate Maintenance dialog box (Maintenance > Customer > Pricing > Rebate). |
|
Prc Eff Date Override |
Do one of the following if the vendor accepts a rebate based on a specific date. The date you enter here overrides the order ship date when applying a rebate:
|
|
Rebate Expiration Date |
If you entered a rebate override date in the Rebate Effective Date field, enter the date in this field that reflects when the override date is no longer valid. If this field is blank, the system uses the matrix cell's expiration date for the rebate information. |
|
Check Sell Group Rebates |
Select the check box for the system to search for sell group rebates when a customer orders products in this sell group. Otherwise, the system does not check for sell group rebates, but prices the item using the matrix set up. |
|
(Optional) Enter the factor by which you want to adjust the COGS and COMM-COST on a rebate matrix. The system applies the factor entered when the sell price on the sales order is manually increased. The factor is used on the difference of the increase. This entry makes sure the system respects special rebate agreements. For example, a sell price is increased by $1.00, the factor is applied to the increase, ($1.00 x .90), = .90. Costs will increase by ninety cents (.90). Note: You can use the Sell Matrix Upload Utility to load values, if needed. Note: The system uses the information in the basis code REB-COST for the price line to make sure that there is not a "negative rebate." The system does not allow the rebate to exceed the COGS calculation. |
|
|
(Optional) For special rebate agreements, you set COGS for the rebate. In some cases when the Rebate Multiplier column is used, the COGS automatically updates for any change to the sell price of the product. Use the Minimum COGS Threshold field column to protect the rebate COGS from going below the value specified. Note: You can use the Sell Matrix Upload Utility to load values, if needed. |
See Also: