web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Price Rounding
Microsoft Dynamics RMS (Archived)

Price Rounding

(0) ShareShare
ReportReport
Posted on by jdc03 900

Having some trouble with the Price Rounding feature in the Inventory Wizard.  Attempting to have prices round to the closest $0.25, but the Wizard just isn't giving me the results I'm looking for.

Example, current vs expected ... but as you can see from the pictures, it's taking the A price of $9.89 and rounding it to $10.25

Price $10.29 $10.25
Price A $9.89 $10.00
Price B $9.53 $9.50
Price C $7.62 $7.50

 

 

 

 

2185.rounding2a.JPG

 

Help??

*This post is locked for comments

I have the same question (0)
  • jdc03 Profile Picture
    jdc03 900 on at
    RE: Price Rounding

    Thank you Wizard and Ramy! A quick right-click showed that the Formula was still set for Reg. Price ... easy fix! 

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: Price Rounding

    After finalize filling your items in Inventory wizard sheet right click on price level A and select formula select your formula and select apply to all rows click OK

  • Verified answer
    RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Price Rounding

    It is not clear from your screenshots what calculation option you selected to set Price A, but if I run Task 110 set to generate Price Level A at 20% off regular price and round to the nearest .25, the routine does indeed generate the correct prices for all items selected rounded to nearest .25. The same procedure works as expected to set retail price based on % margin, or Price C based on markup from cost, etc.

    The export/import function in the wizard allows you to export data from the worksheet,  massage the data column shown in white elsewhere, then import those changes back into the worksheet and commit. This is independent of an calculation performed to generate the worksheet. The right-click formula option also works independent of the worksheet generator.

  • Community Member Profile Picture
    Community Member on at
    RE: Price Rounding

    Hello,

    If you use round to the nearest as demonstrated in this example. The process only updates the discounted pricing or the updated pricings to the nearest dollar of the retail value. I'm not completely sure if it would calculate a percentage of a dollar like .25 correctly. 

    There are some pretty good examples in Store Operations Manager/Help/Contents/TYPE IN THE KEYWORD TO FIND (Price Rounding). Hope that helps you.  

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July 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