Conditional Queue Colors for Home Page Activities in NAV 2015


Microsoft Dynamics NAV 2015 offers some flexibility when customizing the Cues on the Activity Parts of the Role Center. One way to enhance the user experience and highlight exceptions or add meaning to the values presented on the tiles is to add color coding. This requires minimal development.


Example: Purchase Invoices Due Today

The standard cue displays the number of open Vendor Ledger Entries with a Due Date of <= Work Date.

While the count of “11” documents is a good indictor – what if we could add color to the tiles to bring meaning to the value for No. of Documents:No. of DocumentsColor Indicator<10Green11..20Yellow>20Red

To accomplish this:

  1. Save a copy of the respective Activities Page, e.g. Account Manager Activities.

  1. Add a Global Variable ‘CueSetup’ of Type Codeunit and Subtype Cue Setup and Fn ‘CalculateCueFieldValues’. Add a second Variable of Type Text.

  1. Add Code to OnAfterGetRecord Trigger

  1. Change field property SourceExpr for ‘Purchase Invoices Due Today’ to assign CueColor variable

  1. Re-open Role Center page or restart client and review/test changes by editing the Due Date on Vendor Ledger Entries

Cue Colors can be used in the following ways:

  1. Without conditions, i.e. static

  2. Conditional colors based on Boolean variables

  3. Conditional colors based on Text or CU variables

Microsoft Gold Partner Logo_edited.png
  • LinkedIn Social Icon
  • Twitter Social Icon
  • Facebook Social Icon
  • YouTube Social  Icon

Austin  |  Dallas  |  Houston  |  New Orleans  |  Nashville