Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Increasing customer pr...
Microsoft Dynamics RMS (Archived)

Increasing customer prices

(0) ShareShare
ReportReport
Posted on by J Sully 40

I'm not sure if my situation is unique, it seems odd to me, but I'd appreciate any ideas.

I'm using Store Operations Manager v 2.0.0105

I have a group of customers that subsidize our stock and we sell items to them at cost.  But we also sell to other customers that don't buy in and it would be nice to add a price % increase to those accounts.  

I've found the customer discount option (and I tried putting in a negative discount :) but that didn't work)  I could raise prices on all my items and give the preferred customers a discount but it's not very viable with just me working on it.

Are there any other ideas people have?

*This post is locked for comments

  • Sad Profile Picture
    Sad 650 on at
    Re: Increasing customer prices

    Hi,

    You need to update PriceA every time you change the Item Price , or you create a new item.

  • Suggested answer
    Trent Bourgois Profile Picture
    Trent Bourgois on at
    Re: Increasing customer prices

    Hello,

    You could modify the query to something like this:

    UPDATE Item SET PriceA = (Cost * %)

    EG: (Cost * 1.25) would set PriceA to Cost + 25%.  

    or

    UPDATE Item SET PriceA = (Cost + X)

    EG: (Cost + 5) would set PriceA to Cost + $5.

     

    Let us know if you have any other questions.

  • J Sully Profile Picture
    J Sully 40 on at
    Re: Increasing customer prices

    That's a great idea, i'll be excited to try it!

    Is there a way to set PriceA = cost + %  ? or cost + surcharge?

  • Verified answer
    Trent Bourgois Profile Picture
    Trent Bourgois on at
    Re: Increasing customer prices

    Hello J Sully,

    Thank you for your questions.

    Have you tried to set price levels for the items and customers?

    You could set your preferred group of customers to price level A, and have price level A set to the item's cost.

    An SQL query could easily set price level a to equal the items' costs.

     

    Backup your database before proceeding with these steps.

    To set all items' Price Level A to be equal to their costs:

    1. Log into Store Operations Administrator

    2. Click on Query | New

    3. Copy paste the following query into the query window:

    UPDATE Item SET PriceA = Cost

    4. Press F5 to process the query.

    Note: If an item's cost changes, it will not automatically update its Price Level A. You will have to repeat these steps when costs change.

     

    Let us know if you have any other questions.

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