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

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…

How to Use D365 Business Central Analysis Mode

Carlos Lozano

|

March 3, 2026
Transforming Data into Decisions for Modern Businesses Organizations using Microsoft Dynamics 365 Business Central generate significant volumes of financial and operational data. However, collecting data is only the first step. The…

BCS Partners with RUX Software to Deliver Equipment Rental and Field Service on Business Central

Jackie Gant

|

February 26, 2026
Bond Consulting Services (BCS) has partnered with RUX Software to deliver equipment rental and asset management capabilities for small and mid-sized businesses running on or moving to Microsoft Dynamics 365…

What AI Agents in Dynamics 365 Actually Do (A Plain-English Guide)

Jennifer Ryan

|

February 19, 2026
From Assistance to ActionIf you've been using Microsoft 365 Copilot, you've probably noticed something shift. Email gets drafted faster. Meeting notes appear without you scrambling. Spreadsheet analysis that used to…

D365 Business Central: Realistic AI Agent Scenarios for Operations Teams

Zoltan Orban

|

February 18, 2026
A Practical Look at Where AI Actually Helps in BC TodayThere’s a lot of talk about AI and ERP becoming fully automated. In reality, most teams aren’t trying to replace…