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

Microsoft 365 Copilot for Outlook | Manage Email Smarter

Joel Trinidad

|

November 7, 2025
The Email Overload Holding Teams BackFor most of us, email isn’t just communication—it’s command central. But the volume is relentless. Between updates, requests, and follow-ups, your inbox can feel like its own full-time…

Copilot for Power BI: Your Personal Data Assistant

Joel Trinidad

|

October 30, 2025
Microsoft has been steadily adding AI features to their broad range of business products, and Power BI is no exception. Copilot can be utilized to take full advantage of your…

How to Migrate Fixed Assets from Dynamics GP to Business Central Smoothly

George Rios

|

October 28, 2025
PlanningWhen working on a migration of Dynamics GP fixed assets to Business Central, you will want to identify which fields you want to transfer from one system to another. It…

Introducing the BCS Support Portal

TJ Sedarski

|

October 23, 2025
At Bond Consulting Services, we know how important it is to get help when you need it, and to know where things stand once you’ve asked. That’s why we are…

Announcing Unlimited Support for Dynamics 365

TJ Sedarski

|

October 17, 2025
It's like having an in-house Dynamics team - without the overhead A Smarter Way to Get Support for Microsoft DynamicsWe've listened to your feedback and we're making support simpler, faster, and…

Meet Bond Consulting at Community Summit NA 2025

TJ Sedarski

|

October 9, 2025
Discover how we’re helping growing companies streamline operations and accelerate ROI with Microsoft Dynamics 365.Community Summit North America is right around the corner! From October 19–23 in Orlando, FL, business…