Tuesday, July 14, 2015

Announcement of Microsoft Dynamics NAV 2016

Hi,

You must have read about it .. but a day before ago at WPC the new upcoming version of Microsoft Dynamics NAV 2016 was announced.

Now the Microsoft Dynamics NAV 2016 officially called “Corfu”. Yesterday Microsoft declare this at World Partner Conference 2015.





The NAV 2016 Overviews are:
  • Office 365
  • Azure
  • Winodws(Now with Phone)
  • CRM Online
  • e-Everything
  • Workflows
  • Functionality
  • Engineering

Remember one thing this time It is not announced by name Microsoft Dynamics NAV 2015 R2(Release 2).This time It is announced with unique name “Corfu”. 

Hopefully, Microsoft Dynamics NAV 2016 officially called “Corfu” will released till August 31, 2015 for NAV Partners Only.

Microsoft Dynamics NAV 2015 is not released for Indian localization yet but this time Let's see, what happens. Hopefully, Microsoft will launch NAV 2016 for Indian localization. So guys Finger Cressed!

Let's wait for next update.

Thanks
Niraj kumar

http://niraj-msnav.blogspot.com
http://nirajdynamicsnav.wordpress.com

Monday, July 13, 2015

Page N of M

Hi,
In NAV2013R2, It is easy to print page no. like "1 of 10" but in NAV2009, It is a logical because there is no any function to find out total page no. I have also never done this task in classic view but I tried to solve this query because it was a new for me and asked by one of my colleague. Now I am going to write down the step by step procedure to implement it.

1) Create the new Form named "Page N of M" FROM Customer table.


2) Form Design view will look like this...



3) Add the following global variables...
 Name DataType Subtype Length
Txt000 Text 100
CountRec Integer
r Decimal
q Integer
Flag Integer

4) Write the following code on "OnInit Report"....

MESSAGE('%1',Customer.COUNT);

                   Txt000 := ' of ';

5) Write the following code on "OnPreSection" of Customer body....

CountRec += 1;


6) Write the following code on "OnPreSection" of Customer Footer....

                               Flag +=1;
                                IF Flag=1 THEN BEGIN
                                   MESSAGE('%1',CountRec);
                                   r := COUNT MOD CountRec;
                                   q := COUNT DIV CountRec;
                                   IF r > 0 THEN
                                   q := q+1;
                                   Txt000 := Txt000 + FORMAT(q);

                                 END;


7) Now save and close the form and run.





You can also find the object from this link

Thanks
Niraj Kumar

http://niraj-msnav.blogspot.com
http://nirajdynamicsnav.wordpress.com




Tuesday, July 7, 2015

Cumulative Update 28 for NAV 2013 has been released

Cumulative Update 28 for NAV 2013 has been released

Hi,
Cumulative update 28 has been released for NAV2013 (Build No. 41767) this month.

Cumulative Update 28 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013.
The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU - Australia
  • AT - Austria
  • BE - Belgium
  • CH - Switzerland
  • DE - Germany
  • DK - Denmark
  • ES - Spain
  • FI - Finland
  • FR - France
  • IS - Iceland
  • IT - Italy
  • NA - North America
  • NL - Netherlands
  • NO - Norway
  • NZ - New Zealand
  • SE - Sweden
  • UK - United Kingdom
You can download the cumulative update 28 from this link
To download this update you must have "Customer Source" or "Partner Source" login ID.

Thanks & Regards
Niraj Kumar

Tuesday, June 16, 2015

NAV 2013 R2- Cumulative update 20 has been released

NAV 2013 R2- Cumulative update 20 has been released  

Hi,
Cumulative update 20 has been released for NAV2013 R2(Build No. 41371) this month.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  •   AU - Australia
  •   AT - Austria
  •   BE - Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE - Germany
  •   DK - Denmark
  •   ES - Spain
  •   FI  - Finland
  •   FR - France
  •   IS - Iceland
  •   IT - Italy
  •   NA - North America
  •   NL - Netherlands
  •   NO - Norway
  •   NZ - New Zealand
  •   RU – Russia
  •   SE - Sweden
  •   UK - United Kingdom

You can download this cumulative update from this Link

To download this update you must have "Customer Source" or "Partner Source" login ID

Thanks & Regards
Niraj Kumar



Thursday, May 28, 2015

Obtaining Input Without Form


Hi,

Sometimes you don't want to use an entire form to get user input. In this case, we use dialog box window before opening the main form to give input and according to given input we can open form. As we know dialog boxes are not a substitute for forms, but they work just fine for quick input to our form.

Now I am going to implement a simple form as our requirement that open a window before opening the main form to take input.

1) Create a new form named "Input Window Before Main Form" and select some fields according to you. You can also use another name.

2) Form Designer look like this...


3) Add the following global variables...
Name DataType Subtype Length
Window Dialog
DocumentType Option
DocumentNo Code 20

Note: Remember that "DocumentType" is an option datatype. So use the correct option. Select the DocumentType and press "SHIFT+F4" to go to its properties and under the "OptionString" properties write the correct value.

4) Add the Text Constants...
Name ConstValue
Text001 Document Type: #1############# \Document No.:  #2#############

5) Now write the following code to the "OnOpenForm" trigger of the form...
Window.OPEN(Text001);
Window.INPUT(1,DocumentType);
Window.INPUT(2,DocumentNo);
Window.CLOSE;

SETRANGE("Document Type",DocumentType);
SETRANGE("No.",DocumentNo);

6) Now save and close the form and run. When you run your form then "Input Window" will open first.


7) After giving the input press Enter or click Cancel to exit.



Thanks & Regards
Niraj Kumar

http://niraj-msnav.blogspot.com
http://nirajdynamicsnav.wordpress.com

    

Wednesday, May 27, 2015

Problem in cumulative update 19 for Microsoft Dynamics NAV 2013R2

Problem in cumulative update 19 for Microsoft Dynamics NAV 2013R2

Hi,

Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 has a problematic change that will affect your implementation of the cumulative update.


The problem is in table 114, Sales Cr. Memo Header, where the number of field 1300, Canceled, is changed to 1301. A typical partner development license does not allow field changes, so you will run into the problem when you try to import CU 19.

So Microsoft is going to announced hotfixes very soon to resolve this issue.

So here are the different way to work around the problem until next cumulative update released.



Rename the old field and merge the new field. Write code to copy values from the old field to the new field. See the following code as an example.
SalesCrMemoHeader.SETRANGE("Canceled 2",TRUE);
SalesCrMemoHeader.MODIFYALL(Canceled,TRUE);
SalesCrMemoHeader.MODIFYALL("Canceled 2",FALSE);
Where “Canceled 2” is the renamed field.
Note:
You will not be able to remove the old field.
In table 112, Sales Invoice Header, field 1301, Canceled, is a FlowField that uses field 1301 in table 114 in its CalcFormula. Because table 112 is not part of CU 19, the CU will fail if you try to compile table 112 because it points to non-existing field 1300 in table 114.

Tuesday, May 26, 2015

Cumulative update 26 for NAV2013

NAV 2013 - Cumulative update 26 has been released  

Hi,
Cumulative update 26 has been released for NAV2013(Build No. 40940) this month.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions: 
  • AU - Australia
  • AT - Austria
  • BE - Belgium
  • CH - Switzerland
  • DE - Germany
  • DK - Denmark
  • ES - Spain
  • FI - Finland
  • FR - France
  • IS - Iceland
  • IT - Italy
  • NA - North America
  • NL - Netherlands
  • NO - Norway
  • NZ - New Zealand
  • SE - Sweden
  • UK - United Kingdom

You can download this cumulative update from this Link

To download this update you must have "Customer Source" or "Partner Source" login ID

Thanks & Regards
Niraj Kumar


Friday, May 22, 2015

Create Multiple copies of Report in nav2009r2

Sometimes there is a need to print the multiple copies of Report in navision 2009R2. To do this there is very simple way. Now I am going to create a report to print a multiple copies of report in very simple way. I am going to create a simple ILE report to print multiple copies.
1) Create new report in given format
Untitled
2) Set first "Integer" dataitem properties "DataItemTableView" as SORTING(Number) and "NewPagePerRecord" as Yes.
3) Set second "Integer" dataitem properties "DataItemTableView" as SORTING(Number) WHERE(Number=CONST(1)).
4) Set third "ILE" dataitem properties "DataItemTableView" as SORTING(Entry No.).
5) Now write the code on CopyLoop - OnPreDataItem()
IF NoOfCopies >= 3 THEN
ERROR(Text003);
NoOfLoops := ABS(NoOfCopies) + 1;
IF NoOfLoops <= 0 THEN
NoOfLoops := 1;
CopyText := '';
SETRANGE(Number,1,NoOfLoops);

6) Now write the code on CopyLoop - OnAfterGetRecord()
IF Number >= 2 THEN BEGIN
CopyText := Text001
END;
IF Number >= 3 THEN BEGIN
CopyText := Text004;
END;
CurrReport.PAGENO := 1;
7) Leave the second "Integer" dataitem. There is no need to write any code on this dataitem.
8) Write the code on ILE dataitem as you want to filter the data or leave blank.
9)
keep your variables as i wrote
Name DataType Subtype Length
NoOfCopies Integer
NoOfLoops Integer
CopyText Text 30
Name ConstValue
Text001 Duplicate
Text002 Sales Invoice
Text003 More than two(2) copies are not permitted....
Text004 Triplicate
10) Section part is look like this
Untitled
Untitled
11) Now run the report

Untitled

Untitled