See Microsoft 365 Copilot in action across Outlook, Teams, Excel + more.

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

Free vs Paid: How Microsoft 365 Copilot Unlocks Real Productivity ROI

TJ Sedarski

|

November 13, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.Copilot Free Chat is a good place to start in…

What the 2026 Business Central Updates Mean for Small and Midsized Organizations

Lupe Haro

|

November 12, 2025
Microsoft is doubling down on what matters most to today’s small and midsized organizations: automation, intelligence, and agility.The upcoming Dynamics 365 Business Central 2026 Release Wave 1 focuses on AI-powered…

Microsoft 365 Copilot Is Hot! Highlights from Community Summit 2025

TJ Sedarski

|

November 11, 2025
This article is part of our “Work Smarter with Copilot” series—spotlighting the latest Microsoft 365 Copilot updates announced at Community Summit 2025.One message rang loud and clear at this year’s…

How Microsoft 365 Copilot in Outlook Helps You Manage Email Smarter (and Tame Your Inbox)

Joel Trinidad

|

November 7, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Email Overload Holding Teams BackFor most of…

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…