How to Process RPM Rebates in Acumatica

Subject

The steps here explain how to use the Process Rebates function within Rockton Pricing Management (RPM) and Acumatica.

Resolution

Rebates are a great incentive program, but they come with manual processes. The Rebate Management (Process Rebates) function allows you to easily setup, track, and accurately pay out rebate transactions for Customers. There are numerous ways to calculate rebates using RPM, but you can also use the Process Rebates screen for commissions, royalties, monthly fees and more.

In this example, there is a computer electronics store offering a 1% rebate to customers who purchase a laptop in the month of August. To accomplish this, create a Price Calculation within RPM to calculate the rebate amount. Next, assign this Price Calculation to the Price Schedule. When you create an invoice in Acumatica using that Price Schedule, RPM will automatically calculate and track the rebate amount. The “Process Rebates” function in Acumatica can then be used to facilitate the reimbursement of the calculated rebate value.

Follow the steps below to process a rebate.

Create Price Calculation

Create a Price Calculation for the 1% rebate for computer purchases.

1. In RPM, expand the Pricing menu and click Price Calculations.
2. Click Add New.
3. Enter a Price Calculation Name, such as Laptop Rebate – August.
4. Select the Price Mode Option for the calculation. For this example, Percent Adjustment.
5. Enter the Amount or Percent based on the Price Mode selected. For this example, enter 1.0
6. Do no mark Modify Unit Price since our example is to pay out the rebate to the customer later.
7. From the Tracking tab, mark the Track as Extended Price Adjustments check box. If this is marked, a 1% rebate is offered for each laptop sold rather than the first one.
8. Mark the Track Adjustments check box.
9. Select a Debit GL Account and a Credit GL Account.
10. Mark the User Can Edit check box if you want to be able to change the rebate amount after it has been calculated on a transaction.
11. Click Save & Close.

Note: You can also create a Pricing Filter to assign to the Price Calculation encompassing any date ranges or Item information in which to filter the rebates. This filter can be assigned to the Price Calculation or the Price Schedule.

Assign to a Price Schedule

This example assumes you have a Price Schedule already created.

1. In RPM, expand the Pricing menu and click Price Schedules.
2. Select a Price Schedule where you wish to assign the Price Calculation and click Edit.
3. In the Price Calculations grid, select Add New.
4. Highlight the Price Calculation created in the previous steps and click Select.
5. Click Save & Close.

 

 

Process an Invoice in Acumatica

1. In Acumatica, go to Sales Orders and then click Invoices.
2. Click New Record (+).
3. Select a Customer.
4. In the Details section, click Add Row (+) to add line detail.
5. Enter an Inventory ID on the line.
6. Enter Qty of 1.
7. Click Save.
8. From the Details section Switch Between Grid and Form (pencil icon) to see the line detail. Notice the Laptop Rebate was computed.
9. Click Release.
10. On the more menu (…), click Pay, and then click Release.

 

Process Rebates in Acumatica

1. In Acumatica, go to Receivables or Payables and click Process Rebates or use the Search and type Process Rebates.
2. Click New Record (+).
3. In the Document to Create, select a Document Type from the drop-down. In this example, credit the Customer so select Credit Memo.
4. Select Customer to credit.
5. Enter a Description.
6. Select an Inventory Item to process the rebate against.
7. Enter or select the GL Account Filter used for the rebate price calculation.
8. Select the appropriate Debit / Credit Action.
9. From the Adjustment Lines section, view the rebate values available for selection based on the criteria entered on the rebate batch.
10. Select the necessary lines. They will disappear from the Available section and move to the In Batch section.
11. View the In Batch tab to see the rebate values that will be part of the batch before processing.
12. Click Save.
13. Click Process.

After the operation is complete, notice the Batch Doc Ref Nbr field populates with a direct link to the document created. You can process the linked document through normal business processes.