In this article, we will attach a rule to the already existing Quick Ribbon button. The rule will disable the button on the ribbon if there are existing invoices with over $100,000 outstanding.
The configuration steps will be similar to the Part 1 of the article with just a couple of changes.
First, we will configure a formula that will return either a true or false - therefore we will use a Clientside - Calculation type formula. We will use a Decision Table for this.
Step 1: Configure the N52 Formula
The below formula return false if the Potential Customer field on the Quote is empty or if it is filled and the Outstanding Invoices calculation returns a value over $100,000. It will return true if the field is filled and the calculation returns less than $100,000.
Step 2: Add the Quick Ribbon rule to the Command using Ribbon Workbench.
Open the Workbench and connect to your instance of Dynamics 365.
We are again using the same solution with just the Quote entity from previous examples.
On your existing Command click on the Add Enable Rule.
Set the name of the rule to be something meaningful. In this example, we are using new.quote.N52.QuoteFormRule.
There will be 4 steps in this rule, each of them will be CustomRules.
The first three will be used to load N52 support files on for the rule and the fourth will be used to execute the formula.
The function name should be set to isNaN
We pass in 1 parameter which is the shortcode of the formula we created earlier.
When we navigate back to the Command we can see the rule is there.
Publish the solution and the rule is now active.
When there are over $100,000 of invoices the ribbon button is not shown.
When the value of open invoices is less than $100,000 then the Ribbon is displayed.