This walkthrough demonstrates tasks that are performed by the following user roles:

• Microsoft .NET developer
  
• Microsoft Dynamics NAV developer and IT professional
  

To complete this walkthrough, you need:

• Cue table 50001 Sales Invoice Cue and page 50001 Sales Invoice Cue page from Walkthrough: Creating a Cue Based on a FlowField.
  This walkthrough uses these objects which you can create by using the instructions in the Walkthrough: Creating a Cue on a Role Center topic. The actual IDs and names of these objects might be different.
  
• Microsoft Dynamics NAV 2015 with a developer license.
  
• The CRONUS International Ltd. demonstration database. This walkthrough uses the following objects:
  
  • Table 21, Cust. Ledger Entry
    
  • Page 25, Customer Ledger Entries
    

1. In the Microsoft Dynamics NAV 2015 Development Environment, on the Tools menu, choose Object Designer, choose Query, and then choose New.

2. In Query Designer, on the first line, set Type column to DataItem, and then set the Data Source column to Cust. Ledger Entry (table ID 21).

3. Under the DataItem, add a Filter control for the Document Type field and a Filter control for Posting Date field of the Cust. Ledger Entry table. Then, add a Column control for Sales (LYC) field that uses a Totals method type to return a sum from the table. The Query Designer will look similar to the following table.

   Type	Data Source	Name	Method Type	Method
   DataItem	Cust. Ledger Entry	<Cust. Ledger Entry>
   Filter	Document Type	<Document Type>
   Filter	Posting Date	<Posting Date >
   Column	Sales (LYC)	<Sum_Sales_LCY>	Totals	Sum

4. Save the query as follows:

   1. On the File menu, choose Save.
      
   2. In the Save As window, in the ID field, enter an ID for the query object, such as 50001. The ID must be in a valid range for your solution.
      
   3. In the Name field, enter Cust. Ledg. Entry Sales Query.
      Select the Compiled check box, and then choose the OK button.
      

1. In the Microsoft Dynamics NAV 2015 Development Environment, open table 50001 Sales Invoice Cue from Object Designer.

2. Add a new field for the Cue. In the Field Name, enter Sales This Month and set the Data type to Decimal.

   This defines the Cue data field.

   Note
   By default, fields are normal fields as defined by the field's FieldClass Property.

1. On the View menu, choose C/AL code to open the C/AL code for the table.

2. Add a global function that is called CalcSalesThisMonthAmount as follows:

   1. On the View menu, choose C/AL Globals.

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

      By default, all functions are set to local functions as specified by the Local Property, so you must change the function to be global as described in the following steps.

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

   4. Set the Local property to No.

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

   The C/AL Locals window appears. From her you will add a return value and variables.

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

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

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

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

   	Copy Code
   CustLedgEntrySales.SETRANGE(Document_Type,CustLedgerEntry."Document Type"::Invoice); CustLedgEntrySales.SETRANGE(Posting_Date,CALCDATE('<-CM>',WORKDATE),WORKDATE); CustLedgEntrySales.OPEN; IF CustLedgEntrySales.READ THEN Amount := CustLedgEntrySales.Sum_Sales_LCY;

1. On the File menu, choose Save.

2. Select the Compiled check box.

3. Choose the OK button.

1. In Object Designer, open the page 50001 Sales Invoice Cue.

   To add a Cue, you add Field control under a CueGroup control. For this walkthrough, you will add the new Cue under the existing CueGroup control for Sales Invoices, after the Sales Invoices - Open field.

2. In a blank row under the existing CueGroup control, set the Type to Field, and then set the SourceExpr column to the "Sales This Month" field as follows.

   1. Select the row, and then on the View menu, choose Field Menu.

      The Field Menu window opens and displays the list of available fields from the Sales Invoice Cue table.

   2. Select the Sales This Month field, and then choose the OK button.

      In the Caption field, enter Sales This Month. The Caption value defines the text that appears below the Cue.

      Page Designer should look similar to the following illustration.

      

3. 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 50001 Sales Invoice Cue:

   	Copy Code
   "Sales This Month" := CalcSalesThisMonthAmount;

4. To set up a link (drill down) from the Cue to page 25 Customer Ledger Entries, do the following:

   1. Select the Sales This Month field row, and then on the View menu, choose Properties.

   2. In the Properties window, set the DrillDownPageID property to Customer Ledger Entries (ID 25) and choose the OK button.

   3. Close the Properties window.

5. Save and compile the page.

The Cue is now available on the page. To view the page, in Object Designer, select the page 50001 Sales Invoice Cue, and the choose Run.

Viktor wants to display the amount in the Cue so that it is preceded with "kr", which indicates Danish Krone is the currency. Additionally, he does not want to display any decimal places. To achieve this, he sets the AutoFormatType Property and AutoFormatExpr Property of the Cue field on the page.

To change the data format