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 :
Business Central forum

Change in Sales Unit of Measure Does Not Change Unit Price

(0) ShareShare
ReportReport
Posted on by 10

For a particular Item, I am using different units of measure for the Base Unit (LINEAR FEET) and Sales Unit (PCS).  I have correctly set up PCS as a function of LINEAR FEET (thanks to Alexey Finogenov) so why didn't the Unit Price change when I changed the Sales Unit of Measure from LINEAR FT to PCS?  Before the change, Unit Price auto calculated based on the Cost and Profit. 

As an example of what I would expect, please consider the following:

Base Unit = LINEAR FT

Sales Unit = PCS

PCS = LINEAR FT x 10

Unit Cost = $2 (per LINEAR FT) (would be $20 if Base Unit was PCS)

Profit = 50%

Unit Price (in LINEAR FT) = Cost + Profit = $2 + $2 = $4

Therefore, when Sales Unit of Measure is changed to PCS, Unit Price should = $4 x 10 = $40.

Why doesn't the new Unit Price automatically calculate when the Sales Unit of Measure is changed?

I have the same question (0)
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,300 Super User 2026 Season 1 on at

    The Unit Price on Item Card is based on your Base Unit of Measure, not the Sales Unit of Measure.

    When you fill in the Sales Order, it will use the Sales Unit of Measure and calculate the sales price by converting the base quantity unit to sales unit.

  • Community Member Profile Picture
    on at

    The Unit price on the Item card relates to the Base UOM.

    If you want different sales prices per UOM, you must set it up in the Sales Price table related to the Item

  • Aaron M Profile Picture
    10 on at

    I see what you mean.  The Sales Order correctly calculated the Sales Price of one unit by converting the base units to sales units. and applying the base unit price.  

    However, I still think it's more intuitive for the Item card to display the Unit Price in terms of Sales Units.  I'm not going to sell by the linear foot (base unit).  I'm only going to sell by piece (sales unit).

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans