Subject
The steps here explain the most common way to use the Process Rebates function with Rockton Pricing Management (RPM) and Acumatica.
Resolution
Rebate are a great incentive program, but they come with manual processes. The Rebate Management (Process Rebates) function allows users 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, we have a computer electronics store offering a 1% Rebate when a laptop is purchased within the month of August. To accomplish this, create a Price Calculation in RPM for the rebate amount. Then, assign that Price Calculation to the Price Schedule. When an Invoice is processed in Acumatica using that Price Schedule, the Price Calculation (rebate amount) calculates and is tracked for repayment. When appropriate, the Process Rebates function is used directly in Acumatica to process the repayment of the rebate value.
Follow the steps below process a rebate.
Create Price Calculation
Create a Price Calculation for the 1% rebate for computer purchases.
- In RPM, expand the Pricing menu and click Price Calculations.
- Click Add New.
- Enter a Price Calculation Name. For this example, Laptop Rebate – August.
- Select the appropriate Price Mode Option for your calculation. For this example, Percent Adjustment.
- Enter the Amount or Percent based on the Price Mode selected. For this example, enter 1.0
- Do no mark Modify Unit Price since our example is to pay out the rebate to the customer later.
- From the Tracking tab, mark the Track as Extended Price Adjustments check box. If this is marked, a 1% rebate is offered for each computer sold rather than the first one.
- Next, mark the Track Adjustments check box.
- Select a Debit GL Account and a Credit GL Account.
- Mark the User Can Edit check box if you want the user to be able to change the rebate amount after it has been calculated on a transaction.
- Click Save & Close.
Assign to a Price Schedule
This example assumes you have a Price Schedule assigned to computers.
- In RPM, expand the Pricing menu and click Price Schedules.
- Select a Price Schedule where you wish to assign the Price Calculation and click Edit. In this example, Retail Pricing Schedule.
- In the Price Calculations grid, select Add New.
- Highlight the Price Calculation created in the previous steps and click Select. In this example, Laptop Rebate – August.
- Click Save & Close.
Note: If your Price Schedule has more Items than those receiving the Rebate, you can assign a Pricing Filter to the Rebate Price Calculation so only those Items are given the rebate.
Process an Invoice in Acumatica
- In Acumatica, go to Sales Orders and then click Invoices.
- Click New Record (+).
- Select a Customer.
- In the Details section, click Add Row (+) to add line detail.
- Enter an Inventory ID on the line.
- Enter Qty of 1.
- Click Save.
- From the Details section Switch Between Grid and Form (pencil icon) to see the line detail. Notice the Laptop Rebate was computed.
- Click Release.
- On the more menu (…), click Pay, and then click Release.
Process Rebates in Acumatica
- In Acumatica, go to Receivables or Payables and click Process Rebates or use the Search and type Process Rebates.
- Click New Record (+).
- In the Document to Create, select a Document Type from the drop-down. In this example, credit the Customer so select Credit Memo.
- Select Customer to credit.
- Enter a Description.
- Select an Inventory Item to process the rebate against. You may want to have an Item specific to rebates where quantities are not tracked.
- Enter or select the GL Account Filter used for the rebate price calculation.
- Select the appropriate Debit / Credit Action.
- From the Adjustment Lines section, view the rebate values available for selection based on the criteria entered on the rebate batch.
- Select the necessary lines. They will disappear from the Available section and move to the In Batch section.
- View the In Batch tab to see the rebate values that will be part of the batch before processing.
- Click Save.
- Click Process.
After the operation is completed, notice the Batch Doc Ref Nbr field is now populated with a direct link to the document created. The linked document can now be processed through normal business processes.