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

AI Agent & Copilot Podcast: Finastra Chief AI Officer Lays Out Range of Use Cases, Microsoft Collaboration

May 9, 2025

ServiceNow, Cisco Integrating Systems to Lock Down AI Apps and Data

May 5, 2025

Workday’s Gerrit Kazmaier on Platform Power, Ecosystem Growth, and AI Trust | Cloud Wars Live

May 1, 2025

AI Apps Run Rampant in the Shadows, While Corporate Controls Lag Behind

April 29, 2025
Add A Comment

Comments are closed.

Recent Posts
  • Microsoft Adopts A2A Protocol, Agentic AI Era Begins
  • AI Agent & Copilot Podcast: Finastra Chief AI Officer Lays Out Range of Use Cases, Microsoft Collaboration
  • IBM Launches Microsoft Practice to Accelerate AI, Cloud, and Security Transformation
  • AI Agent & Copilot Podcast: JP Morgan Chase CISO Publicly Pushes for Stronger Security Controls
  • ServiceNow Re-Invents CRM for End-to-End Enterprise

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

Join Today

Most Popular Guidebooks

Accelerating GenAI Impact: From POC to Production Success

November 1, 2024

ExFlow from SignUp Software: Streamlining Dynamics 365 Finance & Operations and Business Central with AP Automation

September 10, 2024

Delivering on the Promise of Multicloud | How to Realize Multicloud’s Full Potential While Addressing Challenges

July 19, 2024

Zero Trust Network Access | A CISO Guidebook

February 1, 2024

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.