Setup No. Series in Navision 2013 or 2015

Setup No. Series in Nav 2013 or 2015

Number series is a great feature in Navision that allows automatically insert a number when new record is inserted into the table.

Step by step explain, how to setup a new No. Series on table and use on Page in Navision 2013 or 2015.

Step 1 – Create a number series in table No. Series (308).

Navision 2009 : Excel create in Report using Excel buffer and Automation

There are many ways to create a Excel from Report in the Microsoft Dynamics NAV 2009.
1. Using Excel Buffer table
2. Using Automation variable

Using Automation variable is faster way to create Excel.

Variable in Report
Name    DataType    Subtype
Excel    Automation    'Microsoft Excel 12.0 Object Library'.Application   
Book    Automation    'Microsoft Excel 12.0 Object Library'.Workbook   
Range    Automation    'Microsoft Excel 12.0 Object Library'.Range   
Sheet    Automation    'Microsoft Excel 12.0 Object Library'.Worksheet
j           Text                 30

OnPreReport
  CREATE(Excel,TRUE,TRUE);
  Excel.Visible(TRUE);
  Book:=Excel.Workbooks.Add();
  Sheet:=Excel.ActiveSheet;
  Sheet.Name := 'Sheet Name';

Field Finder : how to find a table field used in all other tables

Field Finder

How to find a table field used in other table.

Some times, it is very important to know that a particular table field used in which tables.

For Example, Customer table has a field No, to find Customer No. used in other table.

Note: This form shows all the table in which Customer No. used except one table i.e. base table , because in Customer table (18) this field is used as ‘No.’

Click here to Download

MSD Navision Table and Field Property

Table Properties

A table in C/SIDE has a number of properties that determine the behavior of the table. When you create a table, C/SIDE automatically defines a number of default values for these properties.

Property name	Use
ID Property	Sets a unique identifier for the table.
Name Property	Defines the table name, which is used as the table caption.
Caption Property	Displays the table caption in the currently selected language. This value is taken from the CaptionML Property, if a value is set.
CaptionML Property	Provides the text that is used to identify a control or other object in the user interface. This property is multilanguage enabled and can contain a list of text in different languages. The text that is actually used is selected according to the current language setting of the user.
Description Property	Include an optional description of the table. This description is for internal purposes only and is not visible to the end user. A short description of the table’s purpose makes it easier to maintain the application.
DataPerCompany Property	Determines whether data in this table is available to all companies or only the current company. Yes if data is available only to this company; otherwise, No. The default value is Yes.

Microsoft Dynamics NAV Numeric Function

POWER Function (NUMBERS)

Raises a number to a power. For instance you can use this function to square the number 2 to get the result, 4.

NewNumber := POWER(Number, Power)

Example

Text constant	ENU value
Text000	'%1 raised to the power of %2 = %3'
Text001	'%1 raised to the power of %2 = %3'
Text002	'%1 raised to the power of %2 = %3'

Number1 := 2;                                   Power1 := 8;

Number2 := 100;                              Power2 := 0;

Number3 := 5;                                   Power3 := 0.5;

Res1 := POWER(Number1, Power1);

Res2 := POWER(Number2, Power2);

Res3 := POWER(Number3, Power3);

MESSAGE(Text000, Number1, Power1, Res1)

MESSAGE(Text001, Number2, Power2, Res2);

MESSAGE(Text001, Number3, Power3, Res3);

The message windows display the following:

2 raised to the power of 8 = 256

100 raised to the power 0 = 1

5 raised to the power of 0.5 = 2.2360679775

The last message window shows that raising a number to the power of 0.5 corresponds to the square root of the number.