Knowledge Base
RPM is not Calculating the Correct Price
Issue Rockton Pricing Management (RPM) is not calculating prices or is calculating incorrect prices. Causes The ERP does not have the "Enable Rockton Pricing Management" check box marked. The Price Schedule is not active. Pricing Mode is incorrect....
Price Calculations are not Calculating as Expected
Issue When entering a transaction or executing a Pricing Test Scenario, the Price Calculations do not calculate as expected in Rockton Pricing Management (RPM). Resolution Check the following on the Price Calculation to determine if it is affecting...
Cancel an RPM Rebate Batch in Acumatica
Subject The steps here explain how to cancel a rebate batch that was processed using Rockton Pricing Management (RPM) and Acumatica. Resolution The Process Rebate function allows you to generate Rebate Batches for processing rebates to Customers or...
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...
How to Setup and Use Document Attributes on a Price Calculation with RPM and Acumatica
Subject The steps here explain how to setup and use Document Attributes as part of a Price Calculation in Rockton Pricing Management (RPM) and Acumatica. Resolution In this example, we use the State from the Shipping Address of the Customer...
How to Create a Document Attribute in Acumatica for RPM
Subject The steps here explain how to create a Document Attribute in Acumatica and use it as part of a Price Calculation in Rockton Pricing Management (RPM). Resolution Document Attributes in RPM are a powerful feature that can provide so...
Using Date Driven Pricing on Price Sheets in Rockton Pricing Management
Subject The steps here explain how to create Price Sheets in Rockton Pricing Management (RPM) for prices in a specific date range and schedule price changes to automatically take effect when needed. RPM enables you to create price changes ahead of...
Using Date Driven Pricing on Pricing Filters in Rockton Pricing Management
Subject The steps here explain how to create Pricing Filters in Rockton Pricing Management (RPM) for prices in a specific date range and schedule price changes to automatically take effect when needed. RPM enables you to create price changes ahead...
Information on Rounding Rules in Rockton Pricing Management
Subject This article provides information on Rounding Rules in Rockton Pricing Management (RPM), including the options available and how to set them up. Information Rounding Rules allow you to assign rounding preferences for prices. When...
Set up a Rounding Rule Using Round to Nearest and Ends In Options
Subject This article provides the steps on how to set up a rounding rule so the price rounds to the nearest .99. For example, if the price calculates as $8.77, then RPM returns the price of $8.99. If the price calculates as $8.22, then RPM returns...
Set Up a Rounding Rule Using Round Down and Multiple Of Options
Subject This article provides the steps on how to set up a rounding rule so the price rounds down and use multiples of .25. For example, if the price calculates as $8.77, then RPM returns the price of $8.75. Resolution A local garden store...
Set Up a Rounding Rule in RPM Using Round Down and Ends In Options
Subject This article provides the steps on how to set up a rounding rule so the price rounds down to the nearest .25. For example, if the price calculates as $8.77 the price RPM returns is $8.25. Resolution A local garden shop wants the...
Data Flow Between Acumatica and Rockton Pricing Management
Subject Rockton Pricing Management (RPM) is a pricing engine that works in conjunction with an ERP, such as Acumatica. To calculate pricing, specific data from Acumatica needs to be shared with RPM so the pricing engine can calculate the price and...
Data Flow Between Dynamics GP and Rockton Pricing Management
Subject Rockton Pricing Management (RPM) is a pricing engine designed to work with an ERP system like Microsoft Dynamics GP. To calculate pricing, Dynamics GP must share specific data with RPM so the web application can calculate the price and...
How Price Levels in Dynamics GP Correspond to Price Schedules in Rockton Pricing Management
Subject The information here provides details on Price Schedules in Rockton Pricing Management (RPM) and their relationship with Price Levels in Dynamics GP. More Information The Price Schedule in RPM is a powerful entity that generates...
How Customer Price Classes in Acumatica Correspond to Price Schedules in Rockton Pricing Management
Subject The information here provides details on Price Schedules within Rockton Pricing Management (RPM) and their relationship with Customer Price Classes in Acumatica. More Information The Price Schedule in RPM is a powerful entity that...
Cannot insert the value NULL into column ‘xxx’, table ‘PricingManagementdbo.RPMxxx’; column does not allow nulls.
Error When importing data within Rockton Pricing Management (RPM), the following error message can occur: Cannot insert the value NULL into column ‘xxx’, table ‘PricingManagementdbo.RPMxxx’; column does not allow nulls. UPDATE fails. The statement...
Helpful Tips on the Export and Import Function in RPM
Subject The information here provides some helpful tips, and more detail into the Export and Import functions in Rockton Pricing Management (RPM). This includes the options available for Admin and Non-Admin users, and helpful tips for using the...
How to Copy Data from One Company to Another Company in RPM
Subject The steps here explain how to copy data, such as Price Calculations, Price Schedules, and Price Sheets from one company to another in Rockton Pricing Management (RPM). More Information Currently, there is not a Copy function in RPM....
How to Use the ‘Use Value from Entity’ Option on a Price Calculation in RPM for a Specific Discount or Markup
Subject This article describes how to set up pricing in RPM to accommodate changes to entity values. For example, you may have discounts or markups for customers that are negotiated but change periodically. The “Use Value from Entity” option allows...
Enable User Account that has been Disabled in RPM
Issue A users account is disabled in Rockton Pricing Management (RPM) and they are unable to log in. RPM allows a user 3 attempts to log in with an incorrect password, prompting with the following messaging after each incorrect entry. If by the...
How to Use Is Between in a Filter in RPM
Subject The steps here explain how to create a Pricing Filter in Rockton Pricing Management (RPM) to accomplish an ‘is between’ scenario. More Information When setting up pricing in RPM, you may need to create filters where you have a range of...
A remove range operation on table ‘SY_Current_Activity’ error with Clear Stranded Activity Records
Error You receive the following error after you log into Dynamics GP. A remove range operation on table ‘SY_Current_Activity’ failed accessing SQL data. If you click OK, you receive the following. [Microsoft][SQL Server Native Client 11.0][SQL...
How to Use SmartFill to Lookup Intercompany General Ledger Accounts
Subject: The steps shown below describe how to set up a SmartFill Custom SQL Object to allow you to lookup Intercompany General Ledger accounts. Resolution: Create a new SmartFill Object following these steps: Click Microsoft Dynamics GP | Tools |...
How to create a SOD Group ID, Exclusion ID, and review the SOD Reports
Subject: The steps here describe how to create a Segregation of Duties (SOD) Group ID, an Exclusion ID, and how to review the SOD reports. Information: These steps may be used in different scenarios, but the example here is specific to Payables...
Registration verification failed
This article replaces TK00142. Error: When attempting to register Project Cost, you receive the following error on the PC Registration Details window. Registration verification failed Cause: This is a known issue with some versions of .NET...
The Project Cost dictionary version is incompatible with the system database version or company database version.
This article replaces TK00141. Error: You restored a Live company database to a new test database and received the following error. The Project Cost dictionary version is incompatible with the system database version or company database version....
Cannot retrieve Windows Domain information at this time.
This article replaces TK00139. Error: When attempting to open the PC System Setup window, you receive the following error. Cannot retrieve Windows Domain information at this time. You will not be able to assign a Windows User until the Windows...
Project Cost Web Suite Portal Will Not Display – Logon Window is Blank
This article replaces TK00140. Error: When attempting to open the Web Suite portal window after installing Project Cost, the portal will not display or the logon window is blank. Cause: Domain group NETWORK SERVICE needs added in pcWebSuite...
The Currency/Price Level/U of M combination is not included in the price list for this item.
This article replaces TK00136. Error: When attempting to process SOP transactions, you receive the following error on the Error Report. 144 The Currency/Price Level/U of M combination is not included in the price list for this item. Cause: The...