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...
Knowledge Base
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...