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

Dynamics GP to Business Central: Migration Overview & Considerations

Jennifer Ryan

|

February 12, 2026
Microsoft Dynamics GP support sunsets on December 31, 2029. After that date, product enhancements, tax and security updates, and mainstream support will be discontinued. As a result, many organizations running…

Why Waiting for Perfect Data Means Never Starting with AI

Zoltan Orban

|

February 10, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents."Our data isn't…

Just Get Started: How Teams Are Actually Beginning with Microsoft Copilot

Clayton Jones

|

February 5, 2026
Getting started with Microsoft Copilot doesn't require perfect data, months of planning, or enterprise-scale resources. Small and medium-sized businesses running Microsoft 365 and Dynamics 365 Business Central are finding that…

Why Copilot in Outlook Beats Standalone AI Email Tools

Joel Trinidad

|

February 4, 2026
This post is part of our Microsoft Copilot, Explained series, which starts with everyday productivity tools like email and meetings before expanding into broader workflows and AI agents.Tools like ChatGPT…

Microsoft Copilot vs Copilot Chat vs Full Copilot

Joel Trinidad

|

February 3, 2026
This post is part of a series, Microsoft Copilot, Explained, which begins with productivity tools and building toward business workflows and AI agents. If you’ve been hearing more about Microsoft Copilot…

Microsoft Copilot for Operations vs Executives: Same Tool, Different Value

Zoltan Orban

|

January 29, 2026
Most conversations about AI in business stay at a high level: “It will transform how we work.”That might be true, but as someone who spends most days in the details—fixing…