Scenario Overview

In this business scenario we want to abandon a process if the Budget Amount is less than 100,000. 

N52 Formula Manager Solution

The Formula Manager solution works like this:

  • Each time an Opportunity's Budget Amount is changed, a formula will trigger
  • The formula will check to see if the Budget Amount is less than 100,000
  • If it is, the formula will set the Opportunity's Process Status to Abandoned

N52 Formula Manager Steps

  • Create a new formula, setting the following values in the Formula Guide
    • Source Entity set to Opportunity
    • Set Formula Type to Save - Perform Action
    • Select the Classic editor
  • Change the Name of the formula to Abandon low budget Opportunities
  • Expand the Source & Target section
  • Set the Source Property to Budget Amount
  • Copy and paste the following formula into the formula editor:
    Iftrue([opportunity.budgetamount] < 100000, 
                   SetAttributeStatus( 1,  3)))
  • Click Save

Wizard - FindRecords

Please see below the wizard you can use to create the FindValue() function call used in this formula

Note: For the Equals Value, you will need to go to the Source tab and click on the Opportunity field


Did you know?

North52 TestShield benefits Dynamics 365 apps testing

Benefits of using North52 TestShield's automated testing framework for Dynamics 365 apps:

1. Accelerate Automated Testing
  • Enables continuous testing of Dynamics 365 apps with speed and agility
  • No-code test designer enables non-developers to build tests
2. Improves Test Coverage
  • Better ROI by a reduction in UAT defects and production defects
  • Defect prevention at early stages of the project life cycle
3. Fix Defects Faster
  • Get fast feedback on the impact of process changes
  • Repeatable automated test execution simplifies problem solving
  • Quickly resolves failing conditions from complex end-to-end tests
4. Faster Delivery and Higher Quality
  • Broader test coverage and fewer defects released to production
  • Reduced risk and faster release cycles through earlier and automated testing
  • Lower costs related to complex test environment management
  • Reduces time to market by validating builds faster
5. Increased Testing Productivity
  • Assist in the generation of automated test scripts that are repeatable and extensible
  • Detailed analysis of test trace logs enable easy detection of errors to be fixed
  • Automation can perform regression tests which ensures system stability while enhancing the application continuously
  • No manual operation increases efficiency and quality of testing

Learn more about TestShield