Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

Mark Rockwell, Rockton Software

Mass Update Prices Using the Price List Wizard


Email | Print

Dynamics GP TIps and Tricks

 

If you are using Standard Pricing, the Price List Wizard is a major time saver when it comes to updating, copying, and all-around managing price lists.  Who has the time to update prices one by one? The Price List Wizard utility allows you to select the necessary wizard to manage your pricing needs. Each wizard will guide you through the steps to complete the process.

 

Available Wizards

 

  • Add Price List Wizard – add new records to your price lists.
  • Update Price List Wizard – update multiple existing records in your price lists.
  • Copy Price List Wizard – copy an existing price list to other items.
  • Remove Price List Wizard – remove existing records from your price lists.
  • Assign Currency Wizard – assign a currency to your items. Only available if using Multicurrency.

 

Let’s go through an example. We are going to use the Price List Wizard utility to update prices for several, existing items at the same time. To update a group of items, they need to share a common price method, such as currency or % markup current cost. The Price Method is assigned on the Price Level for the Item.  The combination of currency, price level, unit of measure, and quantity breaks must already exist in each item's price list to mass update using the wizard.

 

Price List Wizard Steps

Before following these steps, be sure to make a backup should you receive any undesired results.

    1. Navigate to Microsoft Dynamics GP | Tools | Utilities | Inventory | Price List Utilities to open the wizard.
    2. Select Update Price List Wizard.

 

    1. Click Next.
    2. Select the Price Method you want to update, for example Currency Amount.
    3. Click Next.
    4. Select the Update Type. The following options are available but are visible based on the Price Method you selected in step 4.
      1. Percentage - enter the new percentage value you wish to calculate as the price for the Items, such as 120%.
      2. Fixed Percentage - increase the current value by that percentage. For example, you may have a current value of 115% and want to increase by 5%, so you enter 5%.
      3. Fixed Amount – increase the current value by that amount. For example, you may have a current value of $89 and you want to increase by $5, you enter 5.00 to increase the value to $94.
    5. Click Next.
    6. Set the rounding information for the record you are changing. This window only appears if you chose Currency Amount as the Price Method. If you do not wish to use rounding, leave the Round Policy as None.
    7. Select a restriction to limit which price list records to update. For example, you may choose a specific Item range, Price Group, Price Level, and others. When you have selected your range, click Insert.
    8. After you have inserted your selections, click Next.
    9. Review the records in the 'Preview the records to be updated' screen and unmark any you wish to exclude from the update. You may also manually edit the New Price here by typing in the price you wish to use for this Item.

 

    1. Click Next.
    2. Click Finish in the Complete the Update Price List Wizard window to update the price lists with the new rates.

 

 

 

When you click Finish you are prompted to print the Update Price List Audit Report. Print this report if you would like to review or keep a record of your price changes.

If you find you need to end the process at any time during the wizard, you may do so by clicking Cancel. Changes are not made to your Items until you have gone through the wizard and you click Finish.

See how easy that was? The Price List Wizard is a fast and easy way to manage your prices in Dynamics GP!

About Rockton Software

Rockton Software, a Microsoft Dynamics Partner, is an Independent Solutions Vendor (ISV) based in the United States. The company started in 1999 by offering custom development for clients using Microsoft Dynamics GP accounting software. Today, Rockton Software is a creative company with add-on products for Dynamics GP as well as custom development. The Dynamics GP product suite consists of SmartFill, Dynamics GP Toolbox, Auditor, Dynamics Report Manager, Omni Price, Project Cost, and our newest addition to the Rockton product family, Rockton Pricing Management.

 

Work Simpler & Easier® isn’t just a catchy motto. It’s a lifestyle.

 

Rockton Software is a virtual company with employees in seven states and its headquarters in Erie, Colorado. Serving over 100,000 users worldwide, Rockton Software supports innovation by offering Microsoft Dynamics add-ons for all industries. Whether you’re in need of auditing, pricing, searching, reporting, or general user enhancements, we’ve got the solution for you!

 

Here are some ways you can learn more and get connected:

Ask This Expert a Question / Leave a Comment