Track the Dollar Amount Associated with a Promotional Discount in RPM

Mar 8, 2022

Do you want to be able to track the dollar amount associated with a specific discount? Maybe you want to see how much of a discount is given to a specific customer or for a specific promotion. If you use exclusive GL accounts for discounts from promotions, you can easily see that information in Acumatica with the help of Rockton Pricing Management (RPM).

 

For Example

Let’s take a look at an example of how to use RPM to create a discount for a promotion you want to run for the month of April.  Then, track the amount tied to that discount in the general ledger when the discount is used on transactions during the month.

 

How it’s done

A Price Calculation is what drives a price adjustment on a transaction to change the base price of an item. It is where you assign the discount based on an amount or a percentage. In this example, let’s say we are running a promotion specifically for our Loyal customers. They get $10 off when they purchase a specific item in April.  The Price Calculation is set up for this amount and tied to a specific GL Account to track the discount. Here is an example of what the Price Calculation could look like.

 

We already have a Price Schedule for our Loyal Customers so we can easily add this new Price Calculation to the Price Schedule.  RPM knows to look for the Item and Customer information to get the correct price.

 

Now that we have RPM set up to track the discount to a designated account, enter transactions as you normally would in Acumatica. We have already entered some transactions using this Price Schedule with the Price Calculation.

 

We can see the Price Calculations that were assigned on the transactions, for our new promotion. Click Edit and scroll down to the Price Adjustments area. RPM makes it easy to see your price adjustments within Acumatica. This way, you can verify the information before the transaction is posted. You can even click the View Diagnostics button to see how RPM found the price it returned.

 

View the GL Account

After the transactions are posted, you can view the GL account to get the total associated with that particular discount. How you view the information is entirely up to you. It can be done through a report, inquiry, whatever way you prefer to view GL Account information.  Do keep in mind, if you have multiple discounts posting to the same GL Account, you will see all the transactions.

Summary

While this example is specific to a discount from a promotion, Rockton Pricing Management allows you to track specific GL accounts with any of the Price Calculations you want to use. It doesn’t have to be a discount. It could be royalties, margins, fees, or any other adjustments you use. RPM makes your work simpler & easier®.

 

If you would like more information on Rockton Pricing Management or would like to see a demo, please contact sales@rocktonsoftware.com or call 877-4ROCKTON (877-476-2586).

Send this to a friend