Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Need to add NEW U of M to all Price Levels is there a fast way to do this?

Posted on by 254

Hello All!

Recently I have been tasked with adding a completely NEW U of M to all of our Price Levels. I have found that I can do this fairly quickly in Price List Utilities but the filtering options to include/exclude items are very limited. I am hoping for another "mass update" tool, or simply a faster way to do this.

Any suggestions or ideas are welcome!!!

Thank you in advance!

CK

*This post is locked for comments

  • Crystal Karlson Profile Picture
    Crystal Karlson 254 on at
    Re: Need to add NEW U of M to all Price Levels is there a fast way to do this?

    Dear Ahmed,

    This would work but I do not want to create a new item, only add a new U of M to existing Price Levels. Price List Utilities also has the limitation of only updating one Price Level at a time, which also consumed time and clicking. Thank you for your input though! I appreciate it!

    CK

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Need to add NEW U of M to all Price Levels is there a fast way to do this?

    Use the Inventory utilities to create a price list for one item, and then use the utility again to copy this price list to a range of the items

    Inventory >> utilities > price list utilities

  • Verified answer
    Crystal Karlson Profile Picture
    Crystal Karlson 254 on at
    Re: Need to add NEW U of M to all Price Levels is there a fast way to do this?

    Dear Dan,

    Thank you for taking the time to comment. I was fairly sure I wasn't going to get a good answer but I wanted to double check. Price List Utilities works for this just needs a few more filtering options and I could have completed the task MUCH quicker. But even as is, it was still better than manually entering everything!

    Thanks again!

    CK

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Need to add NEW U of M to all Price Levels is there a fast way to do this?

    Hello Crystal,

    Unfortunately there is no other mass update tool in GP for Price levels besides the Price List Utility you mentioned. There may be a 3rd party customization to do this or you could try contacting your Microsoft Partner to see if they are able to create something that will do this. You could also have a script written to do this though I would not recommend updating the table information to do it.

    I will leave this post open for others to post with ideas or possible solutions to this question.

    Best regards,

    Dan Moore

    Customer Online Technical Community

    -----------------------------------------------------------------------------------------

    We hope you get value from our new forums platform! Tell us what you think:

    social.microsoft.com/.../threads

    ------------------------------------------------------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans