How To: Creating a New Plan (04-32-01)

Overview

This tutorial describes how to create new instant rebate plan.

Setup Requirements

Before you create an Instant Rebate plan, you must complete these steps.

Video

Step-by-Step

1. Click the New button.

Click image to enlarge.

2. The Plan Setup window opens. Take a look at the ‘Plan ID’ field. The Plan ID uniquely identifies this plan and is auto-generated by the system.
• Since this number is also used as Invoice Number in Accounts Receivable, you should put some thought into how your instant rebate plans are going to be set up and organized in order to simplify the billing process.

3. Enter the description for this instant rebate plan in the ‘Description’ field.

4. Enter the number of item groups that are contained in this instant rebate. 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 sold matches the quantity set up for the group, these items qualify for the rebated price whenever they are sold on a transaction.
• 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 (in the ‘Quantity’ field) 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.

5. In the ‘Starts’ and ‘Ends’ fields, enter or select from the calendar the date range for the instant rebate. The rebate applies to purchased items only during this time period.

6. In the ‘A/R Account’ field, enter the A/R Account for this instant rebate. Rebate payments that you receive from the vendor will post to this account.

7. Enter the vendor offering this instant rebate in the ‘Vendor’ field.

8. In the ‘Vendor reimbursement %’ field, enter the percentage of the rebate that the vendor is paying to your company. For example if the vendor is reimbursing you for 65% of the rebate, enter ‘65.00’ in this field.

9. In the ‘Billing frequency (days)’ field, enter the number of days in between each vendor billing for the instant rebate. For example, if the vendor is being billed weekly, enter “7” in this field.
• Enter “-1” to bill the vendor within the next 24 hours (Plan Billing must still be run). This also enables billing for undelivered items.
• If you enter “0” or leave this field blank, the vendor is billed periodically.

10. Enter the number of days after the ‘Ends’ date (the final billing) that the vendor should be billed.

11. Enter the Payment Terms for the vendor reimbursement.
• If terms are set up for the vendor in A/R Master File Maint (12-20), they pre-prompt in this field.

12. Click Add or press the Enter key on your keyboard.

Click image to enlarge.

13. The Item Add section of the screen now appears. In the ‘Item’ field, enter the first item number that is part of this instant rebate plan. Click the Search button to look up an item.
    NOTE: You can also add an item by entering its MFG SKU or Barcode number in the ‘Item’ field.

14. From the ‘Group’ drop-down list, select the group this item belongs to.
• Remember, you can have one or more groups on a single plan. The customer must purchase one item from each group to receive the instant rebate.

15. In the ‘Rebate’ field, enter the amount of the instant rebate.

16. The entered Rebate amount is subtracted from the Selling Price and appears in the ‘Rebated’ field. Accept or modify this amount.

17. Notice the ‘Fixed Price’ checkbox below the ‘Rebated’ field.

    Check this box and the items cannot be sold (in POS Entry) below the Minimum Selling Price set up in Inventory Master File Inq/Maint (03-01). The item is always sold for the amount in the ‘Rebated’ field, even if the selling price is changed on the line during entry.

    NOTE: When this box is checked, you can also modify the ‘Rebated Selling Price’ field on this screen.

    If the box is unchecked, the amount the customer pays for the merchandise is always the selling price entered during POS Entry minus the amount in the ‘Rebate’ field. Note that this could result in items being sold below the Minimum Selling Price.

18. By default, the Rebated Minimum Price for the item is calculated by subtracting the rebate amount from the Normal Minimum Price (Field 17 of Inventory Master File Inq/Maint).

    If the Rebated Minimum Price should be different from the default, enter the new amount in the ‘Rebated Min Price’ field.

    If the Rebated Minimum Price does not need to be changed, leave the ‘Rebated Min Price’ field blank.

19. Accept or modify the pre-prompted Vendor Price Rebate amount. The amount that appears in this field is calculated by taking the amount entered in the ‘Selling Price Rebate’ field and multiplying it by the percentage entered in the ‘Vendor reimbursement %’ field.

20. Accept or modify the Unit Cost Rebate amount. The amount that appears in this field is the same as the amount that initially appeared in the ‘Vendor Price Rebate’ field.

21. In the ‘Quantity’ field, enter the quantity of the item that must be purchased in order for it to qualify for the instant rebate.

22. Click the Add button to add this item to the plan or click the Add All button to add all items with the same Brand and Product Type as the entered item to the plan.
    NOTE: Fixed Prices cannot be used with the ‘Add All’ option.

Click image to enlarge.

23. The item appears in the box at the bottom of the screen.
• To make changes to the item, click inside the ‘Instant Rebate’, ‘Rebated Price’, ‘Rebate Paid’, and/or ‘Unit Cost Reduction’ fields for the item and make the necessary modifications.
• You can also make changes to the item by entering it in the ‘Item’ field. Make sure to click the Add button when you’re finished to save the changed.
• To remove this item from the plan, click the Delete button.

Click image to enlarge.

24. Repeat steps 13-22 until all items are added to the plan.

25. When you are finished adding items to the instant rebate plan, click ‘Done.’