Field Definitions: Plan Setup (04-32-01)

Overview

Below are descriptions of each field on the Instant Rebate Plan Setup screen.

Header Section

Plan ID
This number uniquely identifies the instant rebate plan and is auto-generated by the system. Additionally, the Plan ID is used as the Invoice Number in Accounts Receivable.

Description
Enter a description for this instant rebate plan.

# of groups
Enter the number of groups for this plan.

With groups, you have two options:

  • You can set up a single group that contains one or more items. As long as the instant rebate plan is active and the quantity being sold on the transaction is the same as the quantity set up on the instant rebate plan for the item, these items qualify for the rebated price.
  • You can set up multiple groups that each contain one or more items. With this option, a customer must purchase at least one item in each group to qualify for the instant rebate. Additionally, the quantity ordered must match the quantity set up for the item on the instant rebate plan. When setting up multiple groups, each group usually contains similar items. For example, one of the groups could be HDTVs and another group could be Blu-Ray players.

Starts
Enter or select from the calendar the date that the instant rebate begins. Only purchases made on or after this date are eligible for the rebate.

Ends
Enter or select from the calendar the date that the instant rebate ends. Only purchases made on or before this date are eligible for the rebate.

A/R Account
Enter the Accounts Receivable account to which the vendor reimbursements for the rebate are applied.

Vendor
Enter the Vendor that is offering the instant rebate.

Vendor reimbursement %
Enter the percentage of the rebate that the vendor will reimburse your company for (i.e. If the vendor is reimbursing you for 65% of the rebate, enter “65.00” in this field).

The amount entered here is multiplied by the rebate amount to arrive at the Vendor Price Rebate and the Unit Cost Rebate, which pre-prompt in those respective fields when adding a new item to the plan.

For example, if the Rebate is $39.99 and the Vendor reimbursement is 65%, $25.99 will appear in the ‘Vendor Price Rebate’ field and the ‘Unit Cost Rebate’ field. These amounts can be modified if necessary.

Billing frequency (days)
Enter the number of days between each vendor billing for the rebate.

Final billing after end
Enter the number of days after the rebate end date (specified in the ‘Ends’ field) that vendor will received the final bill.

Payment terms
Enter the payment terms for the vendor reimbursement.

Last date billed
The last day that the vendor was billed appears in this field automatically.

Final billing
Check this box if the final billing has been sent to the vendor. The instant rebate does not become inactive until this box is checked.

NOTE: The system will check this box automatically when the final billing is run for the vendor (based on the Ending Date and Final billing after end settings).

Item Add Section

Item
Enter the item number eligible for the instant rebate.

Group
Enter the group that this item belongs to. Groups are usually organized by item type (TVs, Blu-Ray Players, etc.)

Selling Price

Normal
The price from Field 18 of Inventory Master Inq/Maint (03-01) for the item appears in this field and cannot be changed.

Rebate
Enter the instant rebate amount for the item. For example, if the rebate is $20.00, enter “20.00” in this field.

Rebated
When you enter an amount in the Rebate field, that amount is subtracted from the Normal Selling Price to arrive at the amount that appears in this field. This amount can be changed for fixed pricing (see the Fixed Price field definition below for additional information).

Fixed Price
If this box is checked, the item is sold for the amount in the ‘Rebated’ field, even if the selling price is changed during POS Entry (02-02).

If this box is unchecked, the amount the customer pays for the merchandise is the current selling price (it could have been changed during POS Entry) minus the amount in the ‘Rebate’ field.

Min Price

Normal
The price from Field 17 of Inventory Master Inq/Maint for the item appears in this field and cannot be changed.

Rebated
By default, the Minimum Price for the rebate item is calculated as the Normal Minimum Price minus the Selling Price Rebate amount.

If this amount should be different, enter the new price in this field.

GM%

Normal
This is the Gross Margin percentage calculated by the system using the Normal Selling Price.

Rebated
This is the Gross Margin percentage calculated by the system using the Rebated Selling Price.

Vendor Price

Normal
This is the current Vendor Price for the item (taken from Field 13 of Inventory Master Inq/Maint.)

Rebate
This is the amount of reimbursement that your company receives from the vendor. It is calculated using the following formula:

(Selling Price Rebate x Vendor Reimbursement %)

For example, if the Selling Price Rebate for the item is $50.00 and the Vendor reimbursement is 65%, the Vendor Rebate amount would be $32.50.

You can change the amount if necessary.

Rebated
This is the new Vendor Price based on the rebate amount. It is calculated by subtracting the Rebate Vendor Price from the Normal Vendor Price and cannot be changed.

Unit Cost

Normal
This is the current Unit Cost for the item (taken from Field 14 of Inventory Master Inq/Maint.)

Rebate
This is the amount that the Unit Cost of the item is reduced, based on the rebate. It is calculated using the same formula as the ‘Vendor Price Rebate’ field and can be changed if necessary.

Rebated
This is the new Unit Cost based on the rebate amount. It is calculated by subtracting the Rebate Unit Cost from the Rebate Unit Cost and cannot be changed.

Quantity
Quantity Enter the quantity of the item that must be sold in order for it to be eligible for the instant rebate.

NOTE: If there is only one group on the plan, the customer can order any quantity of the item and it still qualifies for the rebate.