How Price Levels in Dynamics GP tie to Price Schedules in Rockton Pricing Management
Subject The information here provides details on Price Schedules in Rockton Pricing Management (RPM) and how they tie to the Price Levels in Dynamics GP. More Information The Price Schedule in RPM is a powerful entity used to generate pricing information and carry that pricing to Dynamics GP. The Price Schedule includes details such as
How Price Classes in Acumatica tie to Price Schedules in Rockton Pricing Management
Subject The information here provides details on Price Schedules in Rockton Pricing Management (RPM) and how they tie to the Price Classes in Acumatica. More Information The Price Schedule in RPM is a powerful entity used to generate pricing information and carry that pricing to Acumatica. The Price Schedule includes details such as the Price
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 has been terminated. The error message varies based on the table or column referenced. Cause This issue can occure when importing
Helpful Tips on the Export and Import Function in RPM
Subject The information here provides some helpful tips, and a bit 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 function. More Information The export and import function in Rockton Pricing Management (RPM) is simple,
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, Price Sheets etc., from one company to another in Rockton Pricing Management (RPM). More Information Currently, there is not a Copy function in RPM. However, you can still easily copy data from one company to another by using the Export
How to Use the ‘Use Value from Attribute’ 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 attribute values. For example, you may have discounts or markups for customers that are negotiated but change periodically. The “Use Value from Attribute” option allows a Price Calculation to easily calculate based on an existing Customer/Item Attribute and the value
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 third attempt a correct password is not entered for the user, that
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 values. For example, you want dates June 1 through August 31st or between
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 Server]The server principal “<user id>” is not able to access the database “<database name>” under the current security context.
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 | Setup | SmartFill | Objects and then click the plus sign (+) Enter an Object
Back to Top