Pricing Methods for GP and Acumatica

What is a Pricing Method?

The Pricing Method in Rockton Pricing Management (RPM) is used to determine how you want to calculate the price on a transaction line. There are three Pricing Methods to choose from when you are setting up the RPM Connector to use in RPM. In order to decide which method to use, you first want to understand how your ERP system is tied to RPM, then decide how you want pricing to be determined.

The RPM Connector ties your ERP to RPM. A Price Schedule is created in RPM and matches the Price Level in Microsoft Dynamics GP or the Customer Price Class in Acumatica. If a Price Schedule exists in RPM, it must match to a record in the ERP. The Price Schedule is then used to determine pricing for your transaction lines and whether any price adjustments should be calculated on that line.

The Pricing Method on the RPM Connector is important because it determines which Price Schedule to use when calculating the price for the transaction line. You decide if you want the price to be determined based on the Price Schedule you assign or if you want the system to determine the best Price Schedule to use.

What are the 3 Methods?

1. Static

The static Pricing Method always uses the Price Schedule that defaults onto the transaction in the ERP. The Price Level or Customer Price Class remains the same and drives the Price Schedule RPM uses to calculate the price. For example, if Dynamics GP has a Price Level called Retail and is the default for the Sales Transaction Line when you enter the transaction, then the Retail Price Schedule is automatically used. The price from that Price Schedule is assigned to the line. The same is true in Acumatica. If a Customer Price Class of Retail is used on the Sales order or invoice, then the price is determined by the Retail Price Schedule in RPM.

2. Dynamic

The dynamic Pricing Method is a more advanced method for assigning a Price Schedule to a transaction. It lets RPM determine the best Price Schedule to use. When a transaction is entered, RPM reviews the valid Price Schedules in RPM, and the first Price Schedule found that matches the information on the transaction is used. This is usually based on combinations of Customer, Item, Date, and other attributes. Dynamic pricing allows for more of those complex pricing scenarios.

3. Hybrid

When the hybrid Pricing Method is selected, both Static and Dynamic Pricing Methods are used. With this option, you allow the ERP system to specify which Price Schedule to use (Static Pricing) or leave the Price Schedule blank, and a Price Schedule is selected for you (Dynamic Pricing).

This allows the flexibility of:

  • Allowing a specific Price Schedule to default,
  • Allowing the user to override the Price Schedule,
  • Using Dynamic Pricing to determine the best Price Schedule for the scenario

RPM Company Setup for the Microsoft Dynamics GP Connector:

RPM Company Setup for Microsoft Dynamics GP Connector

RPM Settings for the Acumatica Connector:

Rockton Pricing Management Settings for Acumatica Connector

There’s no need to stress about selecting the right option for your business. If the Pricing Method you selected doesn’t meet your needs, simply go in the RPM Company Setup window and change the Pricing Method at any time.

These are the basics of the RPM Connector Pricing Methods. If you have any questions or need assistance with selecting the right Pricing Method, feel free to reach out to us at

Need help with your pricing strategies?

  • Download our checklist
  • Schedule a demo to learn more about Rockton Pricing Management

Rockton's Word of the Year is Gratitude

Word of the Year

Starting the year with a ‘Word of the Year’ is a powerful tool to align with their intention, focus their attention, and ultimately shape their execution.

During recent leadership meetings, we thought why not?  Why not come up with a word of the year for our team.  Something to help us align with our true intentions, to focus our attention, and to help shape our execution.  So, what did we pick?  Gratitude.

It might seem like a funny choice for a business.  After all, we need to turn a profit to keep the doors open.  How will Gratitude help us thrive, help us be a successful business? Gratitude helps us focus on our teams’ overall well-being

A company is nothing without its people – Team, Family, Customers, Partners, and Community.

We pride ourselves on our value statement – We improve the lives and business success of our employees and customers. And this year we are doing this by intentionally focusing on Gratitude.

Gratitude can improve your overall well-being, working memory, sleep, immune system, relationships, and coping with emotional upheavals. I think we can all agree. After the past 10+ months, we could all use more of this… and TRAVEL, I could use more travel 😉

What did we do first?

Our first Gratitude activity was a charitable donation drive.  Rockton offered to match any donation made to a charity, of the team members’ choice, within a set timeframe.

During a recent company meeting each team member spent time explaining a bit about the charity they chose.  What an eye-opening and inspiring activity?!  Often the most common charities come to mind first. We heard that not only food shelves are suffering right now, but some zoos are struggling to feed their animals too. And about some of the trickle-down effects caused by someone being incarcerated without being able to post bail.

Our team ended up donating just under $8,000 to our local communities.  Here is a list of who our team supported this past month.

Who are we donating to?

Bonner Community Food Bank

Children’s Cancer Center

UMOM New Day homeless shelter

Denver Zoo

East Bay Food Pantry

Children’s Hospital Colorado

Rise Against Suicide

Coal Creek Meals on Wheels

Great Plains Food Bank

Matthew’s Voice Project

Chad Smith Ride for Life


Attention Homes

Bail Project

Angel B Wilson Foundation

Ronald McDonald House

Sanford Children’s Hospital

Outdoor Adventure

Our Tradition

Rockton has a tradition of giving back to the community in a variety of ways. We have our 1-1-1 rule, where 1% of our team’s time, 1% of company profits, and 1% of our product is given to charities in our communities. Also, each year at GPUG Summit we give away one of our products for free to a Non-Profit. In 2020 we gave out 2. Check out those winners here.

Dynamics GP Tools for New Users

Joining a new company and learning a new system can be overwhelming but rest assured there are some tools to help you along the way.

How can these tools help make your work simpler & easier®?

How about:

  • Faster searches
  • Quality control tracking
  • Help navigating GP
  • Manage and train new hires

What are these 3 tools?


  • Replaces the need to click on the magnifying glass in Dynamics GP, making it quick and easy to search for things.
  • It already comes preset up. So, you don’t have to be a developer to work with this product.
  • You’d be able to use SmartFill without having to know every little nuance about how things are named in Dynamics GP as well as your 3rd party solutions.


  • Quickly track and report on any changes to specific fields in the system. This is great for training and accuracy, staying informed on data changes, and fraud prevention.
  • Get your questions answered when someone changes a specific field on a window.
  • Audits are field-specific, which means you can set up and track any field on any window across GP and Dexterity-based 3rd party solutions.

Dynamics GP Toolbox

  • Manage security by user or role or copy security from one user to another (great for setting up new users).
  • Print out an accurate security report to know exactly what users can get to, whether it’s Windows, reports, or different fields.
  • Use a search tool to help navigate to windows.  This helps new users get accustomed to the system, or you find windows you don’t often use.

These are just a few highlights of what these three products have to offer.  We could go on for hours on how they can make your work simpler & easier®.

Next Steps:

If you have any questions, please email us at

Stop the Exchange Rate Search in Dynamics GP

Do you have to search daily to find the newest exchange rate and then manually update GP?  Do you wish you could automatically update those exchange rates?

If you are already updating multiple currencies in Dynamics GP, you know updating them seems to be a daunting and daily occurrence.

Wouldn’t it be nice if you could automatically update those exchange rates quickly and easily?

There’s a tool ⚒️ for that.

What is the Exchange Rate Import tool?

  • It’s an important extension to the Multi-Currency Management Module for Microsoft Dynamics GP
  • Uses advanced technology to automatically load currency exchange rates into the Microsoft Dynamics GP database

What does it do?

It provides an automated 1-step process that imports those exchange rates directly into the Dynamics GP multi-currency tables. Imagine never having to look up an exchange rate every again.

What sources can you use to update the exchange rates?

  1. European Central Bank
  2. Bank of Canada
  3. Commonwealth Foreign Exchange
  4. Open Exchange Rate (most popular)

Each source maintains its own list of available currencies. Our staff will assist in finding the best source for your needs.

How does it make your work simpler & easier®?

Saves you time each day since you don’t have to waste it on researching exchange rates anymore.

You can also simplify your accounting operations with automated imports of currency exchange rates into the Dynamics GP exchange rate tables.

What does it cost?

Pricing for the Exchange Rate Import tool is $800/annually, no matter the number of GP users. Support is also included after you go live. We provide an installation/configuration manual to assist you with the quick and easy setup process. But if you find you need some help, we’re here for you.

How do you get started? You can:

  • Contact sales for a demo or quote
  • Try it out for free for 30 days

Date Driven Pricing For Acumatica and Dynamics GP

Date-driven pricing is an integral part of any business, for the simple reason that every company, no matter the industry, needs to update pricing on a regular basis. Maybe you only adjust yours a couple times a year, or maybe you’ve got your fingers on the pulse and make continuous changes.

Either way, incorporating date-driven pricing into your strategy is crucial for staying ahead of your competition and optimizing profits. After all, the alternative is remaining stagnant, and in a fast-paced digital world, that’s equivalent to falling behind.

The most common date-driven pricing challenges

Unfortunately, it’s not enough to simply include date-driven pricing in your overall strategy. You’d also need a powerful ERP solution to make pricing changes based on date efficiently. Revenue managers often face challenges when it comes to updating company pricing, as the process tends to be largely manual and involves numerous spreadsheets.

When you’re dealing with substantial customer segments and a chunky catalog of products, even doing a limited-time promotion can be a ridiculously time-consuming task if your ERP system lacks the relevant capabilities. Not to mention the inconvenience of having to make pricing changes the night before discounts kick in.

Traditional ERP software nowadays enables you to assign specific price levels to customers, so you can roll out the pricing in bulk. This allows you to easily pull default prices for transactions, and adjust manually as you see fit. Some more sophisticated ERP solutions may even have date-driven pricing functionalities, but these tend to be limited.

The potential of date-driven pricing

We would not be exaggerating if we said every business needs date-driven pricing to successfully make profit. It just comes down to finding a way to turn what’s historically been a manual, time-consuming process into a seamless, automated operation.

Having a powerful date-driven pricing system enables you to effortlessly handle a range of pricing scenarios and strategically drive your company’s profits. In fact, read below for 3 ways you could start enabling this strategy today.

3 Ways to use Date-Driven Pricing

1. Special customer bundles

Bundle pricing strategy is a popular approach to optimizing revenue and tends to work splendidly when offered for a limited amount of time. Putting a single (often more attractive) price on a group of products or services is a great way to win over customers willing to hand over more cash upfront. It’s no wonder Christmas and Valentine’s Day bundles are so common across various industries, including food distributors and manufacturers!

2. Special occasion sales

And speaking of holidays, the festive season is a prime time to unleash the power of date-driven pricing. In addition to occasion-specific promotions, you can employ the same strategy for monthly or seasonal discounts, limiting your clearance rates to a single day. Wholesalers, for instance, often take advantage of this strategy.

3. Special reduced rates

Tracking competitor pricing and adjusting your rates accordingly is a huge task in and of itself. If you’re trading in a busy market space, attracting customers with price savings is an essential strategy for success. Whether you choose to charge less for your offering, or increase your prices in pursuit of a premium brand image, maintaining dynamic date-driven pricing is a must.

The benefits of a date-driven pricing tool

Date-driven pricing management is vital for your company and could be draining all of your resources. The key to freeing up time so you can focus on other areas of your business without dropping the dynamic pricing ball lies in automation.

With the help of a powerful pricing management solution, you can set up pricing by date in advance and let the system do all the time-consuming work behind the scenes. Just create the date ranges you need, and you can rest assured that your customers would be seeing the right prices at the right times.

From performing complex calculations to keeping track of sale expiration dates, the right date-driven pricing management tool will keep everything running smoothly in the background, incorporating seamlessly with your existing ERP system.

What’s next?

We know when it comes to pricing it can be overwhelming and there’s a lot to consider.

If you’re not sure where to begin when it comes to a pricing strategy or just need some guidance, you can:

  • Download our pricing strategies checklist to help you get started
  • Schedule a demo and learn how we can help you with date-driven pricing

Rockton Software is moving to a new system effective
January 1, 2021

We’re in the midst of improving our internal and external processes and applications to make things here at Rockton work simpler & easier®. We want to make you aware of some things that will be temporarily unavailable during this transition period.

What’s Changing?

We’re moving to a new Portal for self-service, which could impact you in the following ways. As of the listed dates below, you will NO LONGER be able to do these tasks on the portal.

Effective immediately:

  • Add a new customer
  • Edit customer details
  • Add a new contact
  • Prorate a renewal

 Effective December 31, 2020 at 4:00 PM MST:

  • Generate a quote for additional users
  • Acknowledge a renewal
  • Pay a renewal, an additional user quote, a consulting invoice, or any other invoice
  • Store a credit card
  • View unpaid sales documents

After December 31, 2020 at 4:00 PM MST, you will need to contact sales or renewals to request a quote or to pay an invoice. You’ll still have the ability to view and email-only sales documents that were paid on or before 12/31/2020 (you can no longer view unpaid sales documents).

What’s not changing?

For the foreseeable future, you may continue to access registration keys and view customer billing history (for invoices paid prior to 1/1/2021).

We apologize for any inconvenience, and we look forward to serving you via email and phone during our regular business hours, Monday – Friday from 9:00 – 5:00 MST.

We’ll continue to keep you posted as we roll out our new and improved processes. Look for updates in our newsletters, emails, and on our website.

What made it on the list?

The Event of the Summer

Over 200 people attended, but if you didn’t, don’t worry. We saved the recordings for you. Mark your calendar – our Winter event is Feb. 2 & 4.

PC vs PA – What you need to know

Download this one-pager to make sure you know the ins-and-outs and select the one that’ll meet your business needs.

How Dynamic is Your Pricing?

You can generate profitable revenue with flexible pricing and real-time demand. Whether your pricing is based on certain customers or quantities, or whether the shirt is green or blue, we got you covered.

Saving Time & Saving Lives

Read how the Donor Network of Arizona uses SmartFill to save time on their searches so they can focus more on what they do best, saving lives!

Streamline Your Rebate Process

Are you ready to ditch those spreadsheets and manual processes? Here is your chance to learn how.

See Why We Had Over 100 Attendees

We’ll show you:

  • How to find information up to 83% faster with this quick and easy Google-style data search tool.
  • Access your cloud and on-premise data from one, easy to use app.

Got Pricing?

You have options, and we’ve done the homework for you. Compare Standard and Extended Pricing, Omni Price, and RPM to see which one will work for you

Who’s working remotely this year?

This webinar sure hit home with all of the remote workers.

  • Track data changes and changes in productivity too
  • Make finding records across the system simple and easy
  • Log out those idle users

Are you a couch survivor?

We hope you were a part of our Rockton Staycation. We rocked the socks, masks, glasses, and couch. Check out this parody, it sure was popular with over 900 views.

Staycation all I ever wanted…..

If you’ve attended one or all thirteen of the last GPUG events, you know Mark took the stage with a song. We still have one more parody to end the year.

Search and Spend in Dynamics GP

Are you looking for ways to reduce costs and improve efficiency in your procure-to-pay process?

Ready to find information up to 83% faster?

Let’s discover how to achieve savings and efficiency gains by proactively managing business spend and speed up searching for key records in Dynamics GP.

Take it outside

Extending the functionality of GP by taking the purchasing solution outside which then extends that out to all the users through mobility and allowing them to be able to create those POs and move the process forward. Fraxion is a true cloud procurement software that enables complete spend management – from purchase requisitioning and approvals to expense management and spend analysis.

Why does it sit outside of GP?

The reason the Fraxion solution sits outside of GP is because that’s what makes it easily accessible to users, the interface is easy to use, and everyone can move through the system very easily.

Different Areas of Spend Management

  1. Procurement Side
  2. Expense Management
  3. AP Automation
  4. Spend Analysis

If you look at the PO module within GP, many customers describe it as bulky and hard. It takes up a user to use it and they ‘re using things like Business Portal to potentially do that.

How can you achieve savings and efficiency gains?

Most employees want to make great decisions when they’re doing their purchasing, but because of lack of information that kind of going on gut feel. What we want to do is make those more data driven decisions and be able to put the budgets in their hands.

Give them the information and tools they need at their fingertips:

  • What have we spent
  • What are we committed to
  • Approvals into the right hands
  • 2 and 3 way match
  • Bring it all back into GP

Now you’ll get more control of your spending, automate your workflows, and provide visibility and analytics that allows you to become more efficient.

Do you find that it takes too long to search for things in Dynamics GP?

Think about using Google. You start typing into your Google search bar, maybe you’re looking for ‘snow pants’ as an example. As soon as you start typing the word snow, Google’s anticipating what you are looking for and starts sending you suggestions such as a snow shovel, snowblower, and snow pants. You get that list right away to select the right option a little bit faster without typing in the entire word.

That’s pretty much what SmartFill does for GP and your 3rd Party Solutions. It’s a super search tool. Anyone that touches GP could and should use SmartFill.

Intuitive Places

Have you ever noticed every GP window has lots of magnifying glasses? You may use those for your typical look-ups. Well, not anymore.

Let’s focus on purchasing and vendors. If you use the magnifying glass you have to wait for that list to load of all your vendors or all your items. That can get really time consuming. You’re waiting for the list then sorting the list looking for that Vendor and it can sometimes take a while.

Well, it can get a whole lot easier. You can just type the item description or part of the Vendor’s name into the field and SmartFill will do all the magic. You never have to click on the magnifying glass again!

Out of the box

You don’t have anything to set up. SmartFill is ready to go. There are 20 searchable objects that are searching over 4000 Windows in GP, plus you can add as many of your own as you want as well as customize the existing objects to your liking. As soon as you install this product, which takes about five minutes, you’re ready to search.

These are the tools and the ways to automate your procure-to-pay processes as well as save time and money with a fantastic productivity tool for your entire team.

Next Steps:

  • View the webinar recording
  • Try SmartFill for free for 30 days
  • For a quick review of your procure-to-pay requirements and 10% off your order please contact

: How To Improve Security & Multi-Entity Management

Rockton Software and Binary Stream tackle the challenges Dynamics GP Users face when it comes to security, user management, and multi-entity management.

The POWER of 1

Imagine if you could take many databases and bring it down to one. One database, one single login, but multiple companies and with all the security you need.

Multi-Entity Management handles intercompany transactions in a single database, whether you have 5, 10, 20, or even 600 companies.

Yes, you can:

  • put them all in 1 database
  • end up with a single sign-on
  • have complete control of security for the access of your users
  • have a single set of master records you can share between companies or not
  • have different rules for different companies

All of this functionality is available even within a single SQL database your GP world sits on. Imagine accessing all the companies and never having to logout and log into different databases ever again.

Ways to set-up system security

You can restrict users from certain databases while giving them access to others. All the security is done over all of your companies but from one database.

You can:

  1. Identify what companies the AP Clerk can see (in one database)
  2. Assign any vendors to any combination of companies
  3. Users can see only those databases they have access to

Something for everyone

With Dynamics GP Toolbox you’re not just getting a tool, you are getting an entire tool kit. This toolkit contains 27 tools. These tool ideas came from users like you.

These tools can help anyone who uses Dynamics GP. We cover security and system administration as well as some to enhance your business processes pieces and end-user experience.

Since we are focusing on security for this blog below are 3 of the 27 tools we wanted to point out.

1. Security Manager

Security Manager allows you to look at the security across your different companies, and flip between them so that you can see exactly what your users have access to.

What can you report on?

  • Your different roles
  • Your tasks that are under those companies
  • What users have access to
  • What windows in a company, what SmartLists, reports, roles, & posting permissions
  • Compare what a user has against another user
  • What roles users have across companies

This information can all be printed and customized. You can also export all this information to Excel. So if you need to make changes perhaps to a different company, or maybe you just want to copy everything over to a new company, you can export a file out into a different file format, import it back in, and then those changes you’ve made in that file will then be your security.

2. Inactivity Time-out

This has been a huge lifesaver since COVID hit and everyone started working from home. When users forget to log out of the system, whether at home or in the office, this tool is for you. Especially if you’re a bit restricted on the number of user licenses.

You can set a default number of minutes that a user can be inactive in Dynamics GP, regardless of company, before being gracefully logged out of the system.

You can set that time based on user groups and you can specially set times for particular users in a group. Maybe light users get 60 minutes and those who enter just time and expense get 30 minutes.

In summary:

  1. Consider assigning a shorter amount of inactivity time to people who are only periodically in the system. For example, those folks logging in to enter an order here or there or their time.
  2. If a user is actively working in the system, say entering transactions, printing reports, posting batches, entering data, etc. they will not automatically log out of the system. Users are only logged out if they are inactive and still logged into the system.
  3. The Inactivity Time-out Tool is going to completely remove you from that activity table so that the license is freed up for someone else to get into the system.

3. Period Open & Close

Whether you have 1 or many companies this a great time-saving tool. This tool was specifically built for a customer that has 138 companies.

Imagine going into GP and having to open and close periods for two days, every month, because you didn’t want to double click and close the financial series.By having every company in one list you can now pick the fiscal year and multi-select those companies you want to close. So, it’s a huge time saver and it’s great for minimizing the potential for user error.

Whether you need to manage users at home or at the office or manage multi-company challenges from master record consolidation to balancing intercompany transactions we’ve got you covered.

Next steps:

Donor Network of Arizona uses SmartFill for Dynamics GP

Saving Time & Saving Lives

How much time do you waste in a day looking up information in Microsoft Dynamics GP or even your third-party products? You know it’s in there, but coming up with the magical combination of words, numbers, or phrases to find it is another story. What a pain!

Who is the Donor Network of Arizona?

Donor Network of Arizona (DNA) is the federally designated, not-for-profit organ procurement organization for Arizona. They facilitate the transplantation of organs and tissues for transplantation in pursuit of their mission to make the most of life through the gift of organ and tissue donation.

Their organization only exists because of the generosity of organ and tissue donors and their gifts.

What Challenges Did They Have?

Donor Network of Arizona realized what a headache it was trying to look-up the right G/L account. Over the years, the naming conventions became less consistent, and as they grew, some departments were named slightly different than others. Talk about those growing pains.

Being a new employee also has its challenges. When you’re not familiar with any of the naming conventions, it can be difficult to look-up things quickly and easily, especially G/L accounts.

Vendor IDs quickly became an issue as well. In the earlier days, the IDs were much shorter. Suppose there were any changes made to the name or ID; that’s when it became difficult. You could no longer quickly lookup a certain vendor using current GP functionality.

How SmartFill Makes Their Work Simpler & Easier®

New employees no longer worry about not finding the information they need quickly and easily. Searching for something in Dynamics GP is easier and less time-consuming. Gone are the days when they have to try and come up with the magical combination of words, numbers, or phrases.

What does all this mean for the Donor Network of Arizona?

They spend less time on unproductive searches and, in turn, have more productive staff. They are more efficient and ultimately able to save more lives.

Read the full Customer Success Story here!

Please visit or to learn more about how you can register to be a donor.

Send this to a friend