Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and Copilots
    • Innovation & Leadership
    • Cybersecurity
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
  • Summit NA
  • Dynamics Communities
  • Ask Copilot
Twitter Instagram
  • Summit NA
  • Dynamics Communities
  • AI Copilot Summit NA
  • Ask Cloud Wars
Twitter LinkedIn
Cloud Wars
  • Home
  • Top 10
  • CW Minute
  • CW Podcast
  • Categories
    • AI and CopilotsWelcome to the Acceleration Economy AI Index, a weekly segment where we cover the most important recent news in AI innovation, funding, and solutions in under 10 minutes. Our goal is to get you up to speed – the same speed AI innovation is taking place nowadays – and prepare you for that upcoming customer call, board meeting, or conversation with your colleague.
    • Innovation & Leadership
    • CybersecurityThe practice of defending computers, servers, mobile devices, electronic systems, networks, and data from malicious attacks.
    • Data
  • Member Resources
    • Cloud Wars AI Agent
    • Digital Summits
    • Guidebooks
    • Reports
  • About Us
    • Our Story
    • Tech Analysts
    • Marketing Services
    • Login / Register
Cloud Wars
    • Login / Register
Home » D365FO How To: Manage Unit Prices with > 2 Decimals
Business Apps

D365FO How To: Manage Unit Prices with > 2 Decimals

Kaare BoraasBy Kaare BoraasJanuary 16, 2021Updated:June 18, 20212 Mins Read
Facebook Twitter LinkedIn Email
Share
Facebook Twitter LinkedIn Email

On most Dynamics 365 for Finance and Operations projects, there is confusion around how to deal with unit prices where the decimal precision is greater than 2 (e.g. fuel $1.1638 per L). Many projects go down the road of customization to achieve this, but there is a standard feature intended for this purpose. It allows any level of decimal precision.

There is a field called “Price Unit” that indicates how many units the unit price relates to. By default, the price unit is 1, but it can be changed in the master record for the item or directly on a PO, SO, invoice, etc. If you want to enter a unit price for fuel of $1.1638 per L you would actually need to enter a unit price of $116.38 and a per unit of 100. So the cost is $116.38 for 100 L (i.e. $1.1638 per L). The same as how gas stations display their prices. When the system calculates the total cost, it will use the extra decimal precision and then round the total correctly to 2 decimals. So if you buy 10L you would pay $11.64.

Don’t forget that you will have to update the output forms like the PO and SO to accommodate this. For example, you can’t send a PO to a vendor with a unit price is $116.38 without including that it is for 100 units. You will either have to add the price unit field to the output or calculate the unit price for one unit ($116.38 divided by 100) and include it on the form.

 

Dynamics 365 CE / CRM
Share. Facebook Twitter LinkedIn Email
Kaare Boraas

As a Relationship Manager in Business Technology with PCL, Kaare is responsible for project delivery and solution management for all construction related applications.

Related Posts

PwC Updates AI Agent Orchestrator With Support for AWS-Native Services

July 25, 2025

SAP Still #1 in Apps Growth, but Big Backlog Slowdown

July 24, 2025

Microsoft Drives AI and Copilot Functionality Deeper Into Top Security Platforms

July 22, 2025

Microsoft MCP Server Gives Broad AI Access to Corporate Assets Stored in Dataverse

July 18, 2025
Add A Comment

Comments are closed.

Recent Posts
  • PwC Updates AI Agent Orchestrator With Support for AWS-Native Services
  • Google Cloud: While Oracle Stuck in Past, We Are Building Future
  • SAP Q2 Results: The Good News, and the Not-As-Good News
  • SAP Still #1 in Apps Growth, but Big Backlog Slowdown
  • U.K. Government Partners with Google Cloud to Modernize Infrastructure and Upskill 100,000 Workers

  • Ask Cloud Wars AI Agent
  • Tech Guidebooks
  • Industry Reports
  • Newsletters

Join Today

Most Popular Guidebooks and Reports

SAP Business Network: A B2B Trading Partner Platform for Resilient Supply Chains

July 10, 2025

Using Agents and Copilots In M365 Modern Work

March 11, 2025

AI Data Readiness and Modernization: Tech and Organizational Strategies to Optimize Data For AI Use Cases

February 21, 2025

Special Report: Cloud Wars 2025 CEO Outlook

February 12, 2025

Advertisement
Cloud Wars
Twitter LinkedIn
  • Home
  • About Us
  • Privacy Policy
  • Get In Touch
  • Marketing Services
  • Do not sell my information
© 2025 Cloud Wars.

Type above and press Enter to search. Press Esc to cancel.

  • Login
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }