New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

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.  

 

Share On: 

Other articles

From Frustration to Future-Ready: What Growing Distributors Need to Know About Their Systems

Jennifer Ryan

|

January 8, 2026
I spent years on the other side of the table — inside distribution businesses, closing books at midnight, trying to reconcile inventory that never quite matched, and juggling spreadsheets that…

How Miron Violetglass Scaled 40% Without Adding Headcount

Jennifer Ryan

|

January 6, 2026
Every distributor reaches a point where growth exposes the cracks: too many spreadsheets, too much manual work, and not enough visibility. Miron Violetglass hit that moment and what happened next…

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…