Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Price Method - Price L...
Microsoft Dynamics GP (Archived)

Price Method - Price Level Change

(0) ShareShare
ReportReport
Posted on by Megabass 300

We would like to change the price method of our items from currency amount to % of List price and then add multiple price levels (i.e. Wholesale, Retail...).  Unless I am using it wrong, In order to use Price List Utilitiy Wizard the price method must already exist for the items. We have too many items to manually change each one. Is there an easy way to make a mass change to an items price method from Currency Amount to % of List Price, so then I could use Price List Utility?  Would I just use integration manager to "update" inventory items price method to % of list price?

Thank You

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Price Method - Price Level Change

    Instead of IM would I be able to update the IV00101 table to change the Price Method and then run the Price List Utility? I did a quick test in a VM and it appeared to work, however this might not be a *Safe* approach. Any thoughts?

    Cheers,

    Graham

  • Megabass Profile Picture
    Megabass 300 on at
    RE: Price Method - Price Level Change

    Thank you very much for the help. I will go the route of using Integration Manager to change the price method and use the Macro if it does not work.  

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Price Method - Price Level Change

    Open transactions will not be affected as the price is retrieved only at the time of adding the item to a sales document.

  • Megabass Profile Picture
    Megabass 300 on at
    RE: Price Method - Price Level Change

    Thank you for the suggestions.  Do you know if and when we make these changes, how it will affect the prices of open orders/invoices/backorders? If we keep the price level name the same as what exists for items on open sales transactions now, will it change them or are open sales transactions prices not going to be affected by the change?

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Price Method - Price Level Change

    Create a macro file with help of word mail merge and play within item price list window to update the values whatever you wants.

    To create a macro file from word mail merge, follow below link.

    community.dynamics.com/.../how-to-use-word-mail-merge-and-macros-to-import-data.aspx

    Hope this helps!!!

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Price Method - Price Level Change

    Hi,

    I agree that using IM to update the price method would most likely be your best/safest bet.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans