web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Set price levels to % ...
Microsoft Dynamics RMS (Archived)

Set price levels to % percentage

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I'm wondering if there is any way to set the price levels of items to particular % discounts. We use price levels A, B & C to distinguish between staff, VIP and trade customers. Staff receive a high percentage off of most items but a smaller percentage on others (such as electrical) so we cannot just set an individual user discount, nor can we use the Inventory Wizard as other items have slightly different discounts compared to others.

Currently, when we receive new stock and it's being entered into the system these percentages have to be calculated individually which is incredibly time consuming. Is there a better/quicker way we can do this?

Any help much appreciated.

Thanks!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    for a 20% rebate..

    PriceA * 80

    then you run

    price A / 100

    Or SQL it...

    RMS administrator.. run query.

    Update Item Set PriceA = Price * 0.80 where item.ItemLookupCode = 'YOURBARCODE'

    that would give you a 20 percent on Price Level A...

    Or PM for custom work

    Backup DB First.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Sounds like you are setting the discount based on department,  so why wouldnt the inventory wizard work?

    You can select only that department for the price update or use a custom filter. Plus you can review all the changes prior to commiting them to the database.

    For the custom filer, you might need some help refining the statement but it would save you a lot of time.  

    Or you could store the discount percentages in the SubDescription fileds under the item then run a sql query like

    update item set priceA = price * subdescription1 where  subdescription1 > 0

    update item set priceB = price * subdescription2 where  subdescription2 > 0

    update item set priceC = price * subdescription3 where  subdescription3 > 0

    this is just an example, backup your database before running an queries.  Also this will under give you 3 discount percentages

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans