Advertisements

How to – Set Up a Colored Indicator on Cues in Madeira

You can customize to show color indicator of Cues that changes color based on the data values in the Cues.

The indicator appears as a colored bar along the top border of the Cue tile.

From the Cue Setup window, you set up indicators for all the Cues that are available.

You can specify up to two threshold values that define three ranges of data values (low, middle, and high).

To set up colored indicators on Cues

Under Activities on your Home page

CueSetup-1

Choose Set Up Cues.

CueSetup-2

The Cue Setup window appears. The window lists the indicators that are currently setup up on Cues.

CueSetup-3

To modify an indicator, edit the fields and modify, the values for the different thresholds.

The following table lists the colors that is displayed to the options of the Low Range Style, Middle Range Style, and High Range Style fields.

Option Color
None No color (same color as the Cue tile
Favorable Green
Unfavorable Red
Ambiguous Yellow
Subordinate Gray

I will come up with more informations in my up coming posts.

Till then keep exploring and learning.

 

 

Advertisements

Using Query Object to Calculate the Cue Data

Today we will learn to create a query to update Cue data.
SI-Cue-1

Creating a Query for Calculating the Cue Data
First, we will create a query object to calculate the number of open sales invoices from table 21 Cust. Ledger Entry.
Create a query for calculating the Cue data as below:
SI-Cue-2
Save the query.

Adding the Table Field for the Cue Data
Next we will add a field to the table Sales Invoice Cue (create new table) for holding the Cue data.
SI-Cue-3

SI-Cue-4
We will add a global function that returns the total amount of sales invoices for the current month from the query object that we created above procedure.

To add C/AL code to the table calculate the Cue data
Add a global function that is called CalcSalesThisMonthAmount as follows:

On the View menu, choose C/AL Globals.

On the Functions tab, in the Name column, enter CalcSalesThisMonthAmount.

Select the new function, and then in the View menu, select Properties.

Set the Local property to No.

In the C/AL Globals window, select the new function, and then choose Locals.

On the Return Value tab, set Name field to Amount and the Return Type field to Decimal.

On the Variables tab, add two variables as shown in the following table:

Name DataType Subtype
CustLedgerEntry Record Cust. Ledger Entry
CustLedgerEntrySales Query Cust. Ledg. Entry Sales

In C/AL code, add the following code on the CalcSalesThisMonthAmount function:

CustLedgerEntrySales.SETRANGE(Document_Type,CustLedgerEntry.”Document Type”::Invoice);

CustLedgerEntrySales.SETRANGE(Posting_Date,CALCDATE(‘<-CM>’,WORKDATE),WORKDATE);

CustLedgerEntrySales.OPEN;

IF CustLedgerEntrySales.READ THEN

Amount := CustLedgerEntrySales.Sum_Sales_LCY;

SI-Cue-5
Save the table.

Adding the Cue to the Role Center Page
To display the Cue fields on the Role Center, We will create a new Page [PageType  = CardPart] name Sales Invoice Cue.
SI-Cue-6

SI-Cue-7
Page Designer should look similar to shown above illustration.

Open the C/AL code for the page, and then add the following code to the OnAfterGetRecord Trigger to assign the Sales This month field to the CalcSalesThisMonthAmount function of table Sales Invoice Cue:

“Sales This Month” := CalcSalesThisMonthAmount;

SI-Cue-8
Also add code to the OnOpenPage Trigger.

RESET;
IF NOT GET THEN BEGIN
INIT;
INSERT;
END;

Formatting the Cue Data
We does not want to display any decimal places. To achieve this, we set the AutoFormatType Property and AutoFormatExpr Property of the Cue field on the page. As shown above.

To change the data format

In the Properties window, set the AutoFormatType property to 10.

This enables you to create a custom data format.

Set the AutoFormatExpr property to the following text.

‘<precision,0:0><standard format,0>’

<precision,0:0> specifies not to display any decimals places.

<standard format,0> specifies to format the data according to standard format 0.

Close the Properties windows, and then save and compile the page.

Run the Page created above the output should be similar to as below:
SI-Cue-9

Now you can add this CardPart Page to any of your Role Centre Page.

Enhanced Cues

Cues appear as tiles in the Microsoft Dynamics NAV client that display business data and key performance indicators (KPIs) on RoleCenters. Microsoft Dynamics NAV 2015 includes the following new features that expand the data that can be displayed in a Cue, and enhance Cue set up and appearance.

Coloured Indicators

You can configure the Cue to display a bar along its upper border that changes colour based on the data in the cue.
New Images

You can change the image that displays on the Cue or set up the Cue without an image. There are several images to choose from.
Normal Fields

In previous Microsoft Dynamics NAV versions, you could only set up Cues based on FlowFields for data. In Microsoft Dynamics NAV 2015, you can also use normal fields, which expands your possibilities for the Cue data source, such as using Query objects or source expressions.
Decimal and Text Data Types

In previous Microsoft Dynamics NAV versions, you could only set up Cues to display on integer data types. In Microsoft Dynamics NAV 2015, you can also use decimal and text data types. This provides you with additional data aggregation possibilities instead of just COUNT, such as SUM, MAX, MIN, and AVG.
Custom Formatting of Data

By using the AutoFormat property, you customize the format of the value that appears in a Cue. For example, you can set the number of decimal places, or place a symbol such as a +, -, or %, before or after a value.
Cues

Important

Most of the contents you find in this blog will be either inherited from MSDN or Navision Developer IT Pro Help. Some places images are also directly taken from these sites. Purpose is simple to try those stuffs and re-produce adding few things as per my understanding to make easy understanding for others and quick reference.

Here nothing under my own brand or authorship of the content. At any point of time we are just promoting Microsoft stuffs nothing personnel with same.

Hope stuffs used here will not violate any copyright agreement with them. In case by mistake or in-intestinally it happens and the Microsoft feels these should not be used Microsoft have full right to inform me about same and will be glad to take down any such content which may be violating the norms.

Purpose is to promote Navision and share with community.

FB Profile

Like FB Page

%d bloggers like this: