How to setup and use Document Attributes on a Price Calculation with RPM and Dynamics GP

Subject

The steps here explain how to setup and use Document Attributes as part of a Price Calculation in Rockton Pricing Management (RPM) and Dynamics GP.

Resolution

In this example, we use the Site ID from the Sales Transaction to include a shipping cost, which automatically calculates into the transaction unit price. Additionally, when the default site ID is WAREHOUSE, a fee of $5.50 is added to the transaction.

To steps on configuring Document Attributes for Site ID in RPM and Dynamics GP, see Method 2 in the knowledge base article How to create a Document Attribute in Dynamics GP to be used in a Price Calculation together with RPM.

Once you have configured the Document Attribute in RPM and in Dynamics GP, proceed with the following steps so that when you enter  transactions in Dynamics GP, the Price Adjustment calculates.

 

Create Pricing Filter

  1. In RPM, click Pricing Filters from the Pricing menu.
  2. Click Add New.
  3. Enter Site ID=Warehouse as the Pricing Filter Name.
  4. Enter a Description, if desired.
  5. Click Save.
  6. Click Add New from the Pricing Filter Values grid.
  7. Select Document from the Entity drop-down.
  8. Select DefaultSiteID from the Document Attribute lookup.
  9. Select Equals as the Operand.
  10. Enter WAREHOUSE as the Value.
  11. Click Save.

 

Create Price Calculation

  1. In RPM, click Price Calculations from the Pricing menu.
  2. Click Add New.
  3. Enter Warehouse Site Charge as the Price Calculation Name.
  4. Select Fixed Adjustment as the Price Mode Option.
  5. Enter 5.50 in the Amount field.
  6. Mark the Modify Unit Price checkbox.
  7. Mark the From Base Starting Price checkbox.
  8. Select Site ID = Warehouse from the Pricing Filter lookup.
  9. Mark the Track Adjustments checkbox, if desired.
  10. Select a Debit and Credit GL Account from the lookup.
  11. Click Save.

 

Update Price Schedule

  1. In RPM, click Price Schedules from the Pricing menu.
  2. Select the appropriate Price Schedule and click Edit.
  3. Click Add New from the Price Calculations grid on the Price Schedule.
  4. Select Warehouse Site Charge and click Select.
  5. Click Save & Close.

 

Enter Sales Transaction

With setup complete, you can process a Sales Transaction in Dynamics GP with RPM. The Site Charge for “Warehouse” is included whenever the Default Side ID on an Invoice is designated as WAREHOUSE. Below are the steps to verify the calculation takes place as intended.

  1. In Dynamics GP, go to Transactions | Sales | Sales Transaction Entry.
  2. Create an Invoice for AARONFIT0001 and tab through the header information. Validate WAREHOUSE is the Default Site ID.
  3. Add an invoice line for Item 128SDRAM, qty 1.
  4. Click Additional and then select RPM – Sales Line Details from the Sales Transaction Entry header. You will observe an adjustment of $5.50 has been included as a Warehouse Site Charge.

  1. Click OK to close the Rockton Pricing Management – Sales Line Details window.
  2. Change the Default Site ID to WC1.
  3. Click Additional and then click RPM – Recalculate Trx.
  4. Click Yes when prompted a Recalculate will occur. Notice the price has now changed.
  5. Click Additional and then click RPM – Sales Line Details again. Notice no adjustment appears since the Default Site ID is no longer WAREHOUSE.
  6. Click OK to close the Rockton Pricing Management – Sales Line Details window.
  7. From Actions, click Delete.
  8. Click Delete when confirming to delete the record.