Microsoft Copilot $21 now $18/user/month + 1 month free

September 26, 2024

Conditional Pricing Customization 

In today’s dynamic sales environment, everyone is on the hunt for any discounts that can save them money. When these sorts of discounts apply it is important to display discounted prices to specific clients while keeping the original retail price for others. This article explores a customization technique using conditional fields to dynamically adjust pricing on generated invoices based on the availability of discounts, ensuring transparency and meeting your specific business needs. 

Customization Solution: 

To implement conditional pricing in Dynamics 365 Sales, we created a set of calculated fields that dynamically determine the appropriate price based on whether a discount applies. These fields, Discounted Price per Unit and Discounted Extended Amount, populate the template with the discounted amount if a discount is available, otherwise displaying the original price. 

Screenshot of Conditional Field within Dynamics 365 Sales 

Calculated Field: displays discounted price per unit if discount applied; otherwise, displays price per unit. 

 

Screenshot of conditional field within Dynamics 365 Sales

 

Next, we would map these calculated fields to your quote word template to ensure the correct price information is displayed on the generated document. Here is an example: 

example template for an invoice featuring the BCS logo

Implementing This Customization: 

By implementing this customization, businesses can enhance transparency, maintain data integrity, and achieve greater flexibility in their pricing strategies. This empowers organizations to provide accurate pricing information to customers while preserving essential data for tracking and reporting purposes. Additionally, the customization’s adaptability allows businesses to tailor their pricing strategies to various scenarios and customer segments. Conditional pricing customization is a valuable tool; however, the complexity of implementation may vary depending on your specific requirements and the existing structure of your Dynamics 365 Sales environment. 

For more information about implementing this customization and how it can benefit your business, reach out to Bond Consulting Services at Sales@BondConsultingServices.com or click here to schedule a free consultation. Our Dynamics 365 experts can guide you through the process and ensure it aligns with your overall business processes. Alternatively, you can always visit our YouTube channel for helpful video walkthroughs and recorded webinars.  

 

Other articles

What Copilot “Cowork” Means for Business Users

Zoltan Orban

|

March 26, 2026
Microsoft recently introduced Copilot Cowork, and I wanted to take a closer look at what it represents in practical terms, especially for business users working across Microsoft 365 and related…

Why CRM Data Quality Matters More Than Data Volume

Marisa Mini

|

March 24, 2026
A database of 100,000 messy, outdated records is far less valuable than 5,000 that are clean and accurate. Companies often obsess over data volume. But when more data is prioritized over…

From Reactive to Predictive: AI in Business Central Distribution

Zoltan Orban

|

March 19, 2026
Most distribution teams don’t lack reporting. If anything, they often have too much of it. Dashboards, planning worksheets, inventory reports, and KPIs are readily available inside Dynamics 365 Business Central. Yet…

AI Agents in Business Central: How the Payables Agent Works

Jennifer Ryan

|

March 17, 2026
If you're curious how AI agents in Microsoft Dynamics 365 Business Central actually work, we're hosting a live walkthrough of the Payables Agent on March 26. See live how the agent…

Migrating 1.3 Million CRM Records in Dynamics 365: Why We Used a Custom Console App

Marisa Mini

|

March 5, 2026
A government client needed to restructure 1.3 million contact records in Microsoft Dynamics 365 CRM. At that scale, traditional UI tools and flows can throttle, fail silently, or leave a…

AI Agents in Manufacturing ERP: D365 Business Central Guide

Seetharaman Andiappan Rajaram

|

March 4, 2026
AI agents are now live inside Microsoft Dynamics 365 Business Central. For manufacturers evaluating AI in ERP systems, the practical question isn’t what an agent is it’s how AI agents…