New COMPANYPROPERTY function in NAV 2018

One of the new functions which were introduced in NAV2018 is COMPANYPROPERTY which has two properties

DISPLAYNAME: Which will return the display name from the company record

URLNAME: Which will return the name in the URL Format.

You can setup the Display Name on the company page as shown in the below figure:

As per Microsoft documentation, the change of display name now has immediate effect on reports as well as displaying the company name in the UI of the client

I have tried to the change the Display Name for testing but the change is not reflected on the RTC client, it did reflect in reports and in the web client. It would be nice if the same change is reflected in the RTC client when the System Indicator Company is used.

The URLNAME function returns the following output

One issue I have noticed is if we go to the company information card and make any change to the system indicator the display name is reverted to the original company name.

If you have any other tips or suggestions, please do share them in the comments below.

Share:

Read more..

Using Placeholders in NAV Reports

Placeholders provide a method to customize the formatting and insert as an expression inside the textbox.

To add a placeholder, click inside the textbox, then right-click and select Create Placeholder as shown in the figure.

Modifying or removing a field in a standard report like Sales Order (10075) is a pain because all the textboxes show their expressions as <<Expr>>, as shown below. Trying to identify which textbox contains the field that you want to modify or remove could be tiring.

If we have used Placeholders inside the textbox then it will be much easier to identify them as Placeholders not only allows you to add expressions but also gives you the option to add Labels to it. The labels will appear on the report layout as shown below.

Microsoft does a good job in naming the textboxes so it is easy to identify them using the name, for example if I look at the same report in Document Outline you can see how they named

The advantage with placeholder labels is you can view that in design mode.

Placeholders also have the ability to format the text differently. You can add more than one Placeholder in a textbox. Similar to Textboxes, Placeholders also have many tabs as shown in the figure below, which will allow you to format and customize text accordingly.

You can add more than one placeholder in a single text box and format each placeholder differently.

One other advantage of Placeholder is, it has the option to Interpret HTML tags. You can add configure your expression to render using HTML formatting. This allows us to add HTML tags directly into the expression, such as line break, font, bolding, underline….

For example, we can use the following expression in the Value field, and select the HTML option for Markup type in the above figure.

<font face="Arial"><b>T </b></font> ' + “Phone No." + '<br>'

If you have any other tips or suggestions, please do share them in the comments below.

Share:

Read more..

Validate Email Address in NAV using RegEx

Last week I was working on a shipment notification project where I need to send Email Notification of the shipment and one thing we need to check is the email address is valid or not. In Standard NAV the SMTP mail codeunit or Mail Management codeunit has a function to checkValidEmailAddress but it does a very basic validation and it did not meet our needs so I have written a new function to validate the email address.

I have used  RegEx( Regular Expression) and According to Wikipedia

“A regular expression, regex or regexp^[1] (sometimes called a rational expression)^[2][3] is, in theoretical computer science and formal language theory, a sequence of characters that define a search pattern. Usually this pattern is then used by string searching algorithms for "find" or "find and replace" operations on strings.”

Since we have the access the functions of RegEx function using DotNet, I went a ahead and wrote the following function to validate the email address using RegEx.

In our case we could store multiple email addresses in a field, so I have used String Array to parse and validate the email address.

PROCEDURE ValidateEmailAddresses@1000000008(EmailAddresses@1000000000 : Text);
     VAR
       RegEx@1000000004 : DotNet "'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.RegularExpressions.Regex";
       DotNetString@1000000003 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.String";
       EmailAddrArray@1000000002 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Array";
       Convert@1000000001 : DotNet "'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Convert";
       I@1000000005 : Integer;
       EmailAddress@1000000006 : Text;
     BEGIN
       EmailAddresses := CONVERTSTR(EmailAddresses,',',';');
       EmailAddresses := DELCHR(EmailAddresses,'<>');
       EmailAddrArray := RegEx.Split(EmailAddresses,';');
       FOR I := 1 TO EmailAddrArray.GetLength(0) DO BEGIN
         EmailAddress := EmailAddrArray.GetValue(I-1);
         IF NOT RegEx.IsMatch
               (EmailAddress,'^[\w!#$%&*+\-/=?\^_`{|}~]+(\.[\w!#$%&*+\-/=?\^_`{|}~]+)*@((([\-\w]+\.)+[a-zA-Z]{2,4})|(([0-9]{1,3}\.){3}[0-9]{1,3}))$') THEN
           ERROR(Text106);
       END;
     END;

I got the above email address regular expression pattern from the below link, so please visit the below to know what validation it does.
https://www.rhyous.com/2010/06/15/regular-expressions-in-cincluding-a-new-comprehensive-email-pattern/

If you have any other tips or suggestions , please do share them in the comments below.

Share:

Read more..

How to print a remote file from NAV

I have seen couple of times the requirement where we need to print a document from NAV which is not a report, it could be a marketing campaign letter, sales sheets or any other document.

Most of the time we upload these kind of documents on a website/remote site, so if we need print those documents with every invoice or any other statement, below is the function you can use from NAV.

In the below example I just took a random PDF URL from the web and used it for testing.

The key in this function is to download the document from the web using WebClient locally and then use the Process to print the document to the printer.

LOCAL PROCEDURE PrintRemoteFile@1240060002();
     VAR
       FileURL@1240060000 : Text;
       ProcessStartInfo@1240060001 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.ProcessStartInfo";
       Process@1240060002 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Diagnostics.Process";
       WebClient@1240060003 : DotNet "'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Net.WebClient";
       LocalFileName@1240060004 : Text;
     BEGIN
       FileURL := 'http://che.org.il/wp-content/uploads/2016/12/pdf-sample.pdf';
       ProcessStartInfo := ProcessStartInfo.ProcessStartInfo();
       WebClient := WebClient.WebClient();
       LocalFileName := 'C:\Temp\TempFile.pdf';
       WebClient.DownloadFile(FileURL,LocalFileName);
       ProcessStartInfo.FileName := LocalFileName;
       ProcessStartInfo.Verb := 'Print';
       ProcessStartInfo.CreateNoWindow := FALSE;
       Process := Process.Process;
       Process := Process.Start(ProcessStartInfo);
       MESSAGE('Document Printed');
     END;

If you have any other tips or suggestions to resolve this error, please do share them in the comments below.

Share:

Read more..

Dynamics NAV Cumulative Update Download Links

Microsoft releases cumulative update every month for NAV 2013, NAV 2013 R2, NAV 2015 and NAV 2016. I always have to find the links for the downloads when I want to update, below are the quick links to find the cumulative updates for these releases and to download them. You need to have partner or customer source login to download them.

FOR NAV 2013

Released Cumulative Updates for Microsoft Dynamics NAV 2013

FOR NAV 2013 R2

Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2

FOR NAV 2015

Released Cumulative Updates for Microsoft Dynamics NAV 2015

FOR NAV 2016

Released Cumulative Updates for Microsoft Dynamics NAV 2016

At these links if you click on the Knowledge Base ID it will take you to the download page to download that cumulative update.

Microsoft Dynamics NAV Team posts blog each month on cumulative update release when they release a new one and on that blog, there are also links to the respective cumulative update.

I hope this helps people to find the download links for these cumulative updates easily.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Ctrl + Alt + F1 Shortcut Key is not working in RTC to Zoom

As I explained in my last post , the shortcut key (Ctrl + Alt + F1) is used in RTC for About this Page function, which will allow us to view all fields of a record.  This Shortcut Key is very important to view the fields on the subpage as it does not have the Menu option to see Help –> About this Page.

On some computers, this shortcut key does not work and it even happened on my laptop, the reason is because of the conflict of having the same shortcut key on another application. These days most of the computers come with an application called Intel HD Graphics Control Panel or other Intel application to control graphics. This application uses the same shortcut key to open the Display Panel and because of this NAV, RTC shortcut key does not work.

To resolve this, please open the Intel HD Control Panel using Programs and Click Options as shown in Fig 1, it will show you all the Hot Keys for the application

Fig 1: Intel HD Graphics Control Panel

As you can see in Fig 2. to open Display Panel it uses <Ctrl> <Alt> <F1> shortcut and which conflicts with NAV application and causes the shortcut not to function on NAV. On my laptop to resolve this I have disabled the Hot Keys by turning it off and restarted the computer.

In certain cases turning it off did not work so I have to change the Hot Key for Open Display Panel to something else and restart the computer. If disabling does not work try to change the hotkey and restart the computer.

In all the cases where I  have seen this issue the application which caused was Intel HD Graphics, but I believe it depends on upon your computer. If you run this kind of issue please make sure to check with other running application hot keys.

I hope this helps to resolve some of you who are running into the same issue.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

How to view all fields of a record (Zoom on Record)

In the older version i.e. in classic client version of NAV, to view all the fields for the a record you use the function zoom (Ctrl + F8) which will allow us to see all the fields of the record, it is very useful function to see other field values which are not on the form and it is easy to find a particular field  by selecting the first letter of the field.

For example in below fig. 1 by using zoom i can see all the field values of the selected customer record.

Fig 1 : Customer Card Form

You can use the same function even on the subform, for example if you want to view the fields of the sales line on the sales order form then you just need to select the salesline record and use the zoom function. Example Fig. 2

Fig 2 : Sales Order

In the newer version i.e in RTC to achieve the same results we use About this Page function which will allow us to view all the fields, filters and source expressions of a record. It can be accessed from the page as shown in the fig: 3

Help –> About this Page

Fig 3: Customer Card

The shortcut key for About this Page function is (Ctrl + Alt+ F1)

When you are on the document page to view the fields of a subpage you don’t have the option to use Help –>  About this page, so to view all the fields of a subpage record you need to select the line and use the shortcut (Ctrl + Alt + F1).

Example to view fields of a sale line on the Sales Order  Fig 4.

Fig 4: Sales Order Page

I have seen instances where the shortcut Key Ctrl + Alt + F1 does not work, i will explain it in my next blog post how to resolve that issue

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Auto Load Dynamics NAV Modules On PowerShell Startup

Dynamics Navision PowerShell cmdlets were introduced with the release of version 2013 and with every new release they have added more cmdlets to manage Navision.  There are several of them which can be used to create instances, to install, backup, upgrade, and automate several tasks.  I will discuss several of those cmdlets and some scripts in my next series of blog on PowerShell.

In this post let’s discuss how can we load those cmdlets. When you open PowerShell console or PowerShell ISE, by default it does not load the NAV cmdlets automatically you need to use the following cmdlet to import them

Import-Module 'C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1' 

If you develop any other modules, custom functions or scripts you need to execute the same import-module cmdlet for your every .ps1 file path.

How can we automate this so that it will load all custom scripts when you open the Console or ISE without executing the commands ?

 

We can create aliases (which are short name to a cmdlet) but those are only kept for the current session and there are few short-comings which I will discuss in my next post. The best option to load the custom modules,functions or scripts automatically is to use a Profile. A profile is a windows PowerShell script which runs automatically when you start a new session. There are different type of profiles, but let’s concentrate today on current user profile which is stored in the following directory

%UserProfile%\My Documents\WindowsPowerShell\

 

To know your profile path you can type $Profile which will return the profile path. To check if the profile file exists or not use the following cmdlet

test-path $profile (Which will return true if the file exists or else false)

If the file does not exist, then create a new profile file using the below cmdlet, it will overwrite the existing file if file already exists.

new-item –path $profile –itemtype file –force

(If you don’t the syntax of any command please use help or Get-Help)

One tip on the Help command, sometimes it is hard to scroll through the help when it displays in the console, you can use the parameter –ShowWindow to open help in a new GUI window

For Ex: to know more about Test-Path use

Help Test-Path –ShowWindow  which will open the help in a new window which is easy to scroll and search as shown below

 

Create a new folder in the C:\ drive and call it UploadScripts. Copy all your custom scripts or functions and in our case we will copy NAVAdminTool.ps1 and will paste in the newly created folder.

Now open the profile file which is created in

%UserProfile%\My Documents\WindowsPowerShell\Microsoft.PowerShellISE_profile.ps1

Add the following code so that everytime the profile is loaded it will load all our scripts.

Set-ExecutionPolicy remoteSigned

$uploaddir = “C:\UploadScripts”

Get-ChildItem “${uploaddir}\*.ps1” | %{.$_}

Write-Host -fore Green "All Custom Scripts Loaded"

Every time now you open the console or ISE now it will load all the scripts in that folder.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

How to fix : “CA Dollar” on Amount Description Line in Navision Check Report

 

When ever you print a check in Navision does it print the amount description line as CA Dollar instead of US Dollar

For example:

****Ten Thousand Twenty Eight CA Dollars and 20/100

instead of

****TEN THOUSAND TWENTY EIGHT AND 20/100 US DOLLARS

 

I have come across this issue many times and recently I had one more occurrence, so I decided to write this post so that I can reference back and also help others who encounters the same issue

To fix the above issue we need to setup the following:

1. On the Company information card, on the payments tab make sure you fill-up

• US Country/Region Code
• Canada Country/Region Code
• Mexico Country/Region Code

 

 

 

 

 

 

2. On the Bank Account Card, Fill the Country/Region code on the General Tab.

The above two setups will fix the issue and will print US Dollar instead of CA Dollar.

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post..

Share:

Read more..

NAV Programming Best Practices

Microsoft provided some best practices to follow for Dynamics NAV when designing pages and doing programming, please check the below link for more information.
https://msdn.microsoft.com/en-us/library/ee414204(v=nav.90).aspx

Share:

Read more..

Object Numbering Conventions In Navision

Microsoft provided object numbering convention to follow for Dynamics NAV and please check the below link for more information, it is important to follow this Conventions while making customizations as it will help to upgrade easily and support.

https://msdn.microsoft.com/en-us/library/ee414238(v=nav.90).aspx

Share:

Read more..

How to Read/Write Notes in Navision using C/AL

In this post I will discuss how to read the notes and how to create the notes programmatically. When you create a note where the data is saved in the Navision ? I have seen this question being asked several times in the community forum. The answer is the notes are saved in binary format in a blob field (Note) in the Record Link table (2000000068) and the way it maps to the record is using Record ID.

Read Notes:

To read notes you need to find the “Record ID” of the record using Record Reference and then use that to filter the Record Link table and then convert value in the blob field (Note) into readable text.

In the below example the ReadNotes function takes SalesHeader as parameters and displays the first note associated with it.

Write Notes:

To create note once we again need to get the “Record ID” of the record which can be retrieved using Record Reference, and we also need to convert the text into bytes to store in the “Note” Blob Field. Since the Record Link primary key Link ID is set to Auto Increment we don’t need to find the next available “Link ID”, as INSERT statement will take care of retrieving it and assigning it.

There are two helper functions below SetText and HtmlEncode, you need these functions to write notes.

PROCEDURE ReadNotes@1240060000(SalesHeader@1240060003 : Record 36);
    VAR
      RecordLink@1240060000 : Record 2000000068;
      NoteText@1240060001 : BigText;
      Stream@1240060002 : InStream;
      RecRef@1240060004 : RecordRef;
    BEGIN
      RecRef.GETTABLE(SalesHeader);
      RecordLink.SETRANGE("Record ID",RecRef.RECORDID);
      IF RecordLink.FINDFIRST THEN BEGIN
        REPEAT
          RecordLink.CALCFIELDS(Note);
          IF RecordLink.Note.HASVALUE THEN BEGIN
            CLEAR(NoteText);
            RecordLink.Note.CREATEINSTREAM(Stream);
            NoteText.READ(Stream);
            NoteText.GETSUBTEXT(NoteText, 2);
            MESSAGE(FORMAT(NoteText));
          END;
       UNTIL RecordLink.NEXT = 0;
      END;
    END;

    PROCEDURE WriteNote@1240060001();
    VAR
      LinkID@1240060000 : Integer;
      Customer@1240060001 : Record 18;
      RecRef@1240060002 : RecordRef;
      RecordLink@1240060003 : Record 2000000068;
    BEGIN
      Customer.GET('10000');
      RecRef.GETTABLE(Customer);
      RecordLink.INIT;
      RecordLink."Link ID" := 0;
      RecordLink."Record ID" := RecRef.RECORDID;
      RecordLink.URL1 := GETURL(CLIENTTYPE::Current, COMPANYNAME, OBJECTTYPE::Page, PAGE::"Customer Card");
      RecordLink.Type := RecordLink.Type::Note;
      RecordLink.Created := CURRENTDATETIME;
      RecordLink."User ID":=USERID;
      RecordLink.Company:=COMPANYNAME;
      RecordLink.Notify := TRUE;
      SetText('Test Note For the Customer 10000',RecordLink);
      RecordLink.INSERT;
    END;

    LOCAL PROCEDURE SetText@4(NoteText@1001 : Text;VAR RecordLink@1000 : Record 2000000068);
    VAR
      SystemUTF8Encoder@1011 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Text.UTF8Encoding";
      SystemByteArray@1010 : DotNet "'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.System.Array";
      OStr@1008 : OutStream;
      s@1007 : Text;
      lf@1006 : Text;
      c1@1005 : Char;
      c2@1004 : Char;
      x@1003 : Integer;
      y@1002 : Integer;
      i@1009 : Integer;
    BEGIN
      s := NoteText;
      SystemUTF8Encoder := SystemUTF8Encoder.UTF8Encoding;
      SystemByteArray := SystemUTF8Encoder.GetBytes(s);

      RecordLink.Note.CREATEOUTSTREAM(OStr);
      x := SystemByteArray.Length DIV 128;
      IF x > 1 THEN
        y := SystemByteArray.Length - 128 * (x - 1)
      ELSE
        y := SystemByteArray.Length;
      c1 := y;
      OStr.WRITE(c1);
      IF x > 0 THEN BEGIN
        c2 := x;
        OStr.WRITE(c2);
      END;
      FOR i := 0 TO SystemByteArray.Length - 1 DO BEGIN
        c1 := SystemByteArray.GetValue(i);
        OStr.WRITE(c1);
      END;
    END;

    LOCAL PROCEDURE HtmlEncode@20(InText@1000 : Text[1024]) : Text[1024];
    VAR
      SystemWebHttpUtility@1001 : DotNet "'System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'.System.Web.HttpUtility";
    BEGIN
      SystemWebHttpUtility := SystemWebHttpUtility.HttpUtility;
      EXIT(SystemWebHttpUtility.HtmlEncode(InText));
    END;

The two above functions SetText and HtmlEncode are copied from the standard Navision Codeunit (454 Job Queue - Send Notification)

Download the object from this link Notes Management

Please leave your comments, feedback or any suggestions you have for me to improve my blog and also if you have any questions, feel free to post.

Share:

Read more..

Empty Rows/Columns on the Navision Report when printed to Excel

I was asked recently to create a  custom sales report which salespersons wants to output the data into excel, since RTC reports have the option to save as excel, I created a simple report with row header and values, so that users can run this report and use Print Save as Excel option, but when the report is saved as excel it created empty rows and columns.

Below is the example of the excel when the report is saved as excel

In my report design the tablix does not have any hidden rows or any other header rows, so I was started checking how those empty rows are created and can be avoided

This is the screenshot of my report design, as you can see there are only two rows, one is the header and other is the detail.

After spending an hour or so, I realized that space is not because of the tablix, but rather the space above the tablix and on the sides, once I removed all the space and made sure there is no space as shown below, the issue was fixed.

Below is the screenshot of the excel after the change

If you encounter these kind of issue, just don’t concentrate on the tablix on the report, do check the space around it . When the report is exported to excel it takes the whole report into consideration, so try to avoid blank spaces if you know the report will be used as excel.

Please leave your comments, feedback or any suggestions you have for me to improve me my blog and also if you have any questions, feel free to post..

Share:

Read more..

Simple Tool to clear the data from the field in Navision

It is quite often during the implementation or re-implementation projects that there is a need to change a field data type or delete the field after it was added. The issue is if that field has the data, then in order to change the data type or to delete the field we have to clear the field value otherwise you will get the error. Below is an example of such error

If you have multiple companies in the database then you to have to clear the data in all the companies before you make the change, normally I create a process report to clear the data and run that in each company but it is a tedious task if you have many companies. I have come across this situation many times, so I have created a simple tool called Clear Fields, this is a process report with option to filter on the table and the field you want to clear, it also has the option to clear the data in all the companies, so you don’t have to change company and run this in each company.

As of now this is only designed to clear one field at a time and it handles any field type, in the future I plan to extend this and add more options to it. I have uploaded the .fob and .txt objects in the below location, it also has a word document which will explain the above the request page options

Download Objects: http://1drv.ms/1Mwrzum

Please leave your comments, feedback or any suggestions you have for me to improve me my blog and also if you have any questions, feel free to post..

Share:

Read more..

Cumulative Update 12 for Microsoft Dynamics NAV 2015 has been released(Build 42951)

This Cumulative Update 12 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features released in previous Cumulative Updates.

Share:

Read more..

Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 has been released (Build 42950)

This Cumulative Update 24 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features released in previous Cumulative Updates.

Share:

Read more..

How to find out who created/modified sales order/purchase order in Navision

In standard Navision if you want to find out who created/modified a document i.e. sales order, purchase order, transfer order… you cannot unless you do have a customization or you have to enable a change log setup

 

In this blog I will discuss how to make the customization to achieve this, but if you want to know how to achieve this using change log setup please refer to the following links

http://www.archerpoint.com/blog/Posts/setting-change-logs-microsoft-dynamics-nav-2013

https://msdn.microsoft.com/en-us/library/hh169208%28v=nav.71%29.aspx?f=255&MSPPError=-2147217396

 

Please note if you are using change log to trace for insertion and modification, then don’t include all the fields in your change log setup include only some fields.

How to achieve with customization: You need to have development license to make the below modifications

This example is for Sales order but you can do the same for other documents.

Open development environment and from the Object Designer select table tab on the left hand side and choose table 36 – Sales Header

Select Design and add the following four fields,

1. Created By (Code 50)

2. Created On ( DateTime)

3. Last Modified By (Code 50)

4. Last Modified On (DateTime) 

The field number’s can be different. Save the change by choosing File –> Save and Then File –> Exit.

Open the table 36 again in design mode, then from Menu choose View –> View C/AL Code or Press F9

As show in the below Figure 1, you need add the custom code in the OnInsert Trigger and OnModifiy Trigger of the object

Figure 1: Showing Table 36 Sales Header in Design Mode C/AL Code – OnInsert and OnModify Triggers

OnInsert()
// SK0001 >>
"Created By" := USERID;
"Created On":= CURRENTDATETIME;
// SK0001 <<

OnModify()
// SK0001 >>
"Modified By" := USERID;
"Modified On" := CURRENTDATETIME;
// SK0001 <<

Save the changes by choosing File –> Save and Then File –> Exit.

Now you can go to the Sales Order Page (42) or  Sales List Page and add those fields, if you want to track this in purchase or transfer then you can repeat the same steps as above but for the purchase use  38 – Purchase Header  table and for Transfer Order – 5740 Transfer Header Table.

With these simple modifications now you can track who created/modified or when they created/modified.

Please leave your comments and suggestions.

Share:

Read more..

Change color of non-editable field on Navision page

Whenever you make a field non-editable on the page and if that field does not have any table relation set on the table then the background of the field shows in grey color as show in the below figure

For this example I made the salesperson code field non-editable on the customer card page, as you can see it shows value in the blue but where as the Last Date Modified field textbox background is gray it is little dull and sometimes hard to read, it is not a big deal but how can you make that field look like salesperson code field without any table relation ?

Figure 1: Customer Card showing Salesperson Code and Last Date Modified fields in non-editable mode.

There is a field property called “LookUp”, which provides a lookup window for the textbox, you normally don’t see this property being used other than on Journal Pages or other. Ex: Item Journal, General Journal…. . This property is set there because the batch name field source is a variable so you have to explicitly set to LookUp.

Even though we don’t want to lookup in this scenario, but if you set this property to true on the above field “Last Date Modified” then the field will look as shown in the below figure

Figure 2: Customer Card showing Salesperson Code and Last Date Modified fields in non-editable mode after setting LookUp

Please let me know your comments and suggestions.

Share:

Read more..

Cumulative Update 10 for Microsoft Dynamics NAV 2015 has been released (Build 42222)

This Cumulative Update 10includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features released in previous Cumulative Updates.

Note You must convert the database if you are upgrading to this cumulative update from a cumulative update earlier than cumulative update 9 (build 41779). For more information, see Converting a Database in Help for Microsoft Dynamics NAV.

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

Where to download this cumulative update

You can download the cumulative update from KB 3086434 – Cumulative Update 10 for Microsoft Dynamics NAV 2015

Problems that are resolved in this cumulative update

The following problems are resolved in this cumulative update:

Platform hotfixes

ID	Title
375205	The SaveValues property stores variable lengths that lead to strange side effects.
375140	The Windows client is running slowly and consumes a lot of memory.
375134	Multiple lines are selected from a list after clicking on a single line.
375118	"Server page is not open" error message when closing a page.
375196	Different error messages appear if you setup the UI Elements Removal property to LicenseFile and to None when you start the client.
375338	Exception is thrown by Sync-NAVTenant after deleting a table.
375292	It is possible to create a dimension value with a blank value in the Dimension Code field.
374750	Data is changed after you run the Export to Excel function.
375308	It should be possible to ignore diagrams in Excel sheets when doing an import.
375213	The Windows client crashes when a modal page is opened in the background.
375311	"The metadata object Page XXXX was not found" error message
375327	The client crashes when you remove the Edit action from a sales order list in the Order Processor profile via personalization.
375275	Streaming of dotnet assemblies does not support processor architecture.
375337	The Windows client crashes if invalid characters are added to a text screen.
375332	Enable ADFS to allow e-mail logging in combination with Exchange Online.

Application hotfixes

ID	Title	Functional area	Changed objects
375121	When using the Send-to Excel function with StyleSheets, the DateTime fields are converted to strings.	Administration	N/A
375241	The upgrade process is stuck.	Administration	COD 104055
375298	Issues with the Profile Translation feature in Microsoft Dynamics NAV 2015 CU 9.	Administration	COD9170 Demotool\COD101994
375312	The upgrade hangs for Dimensions.	Administration	COD 104055
375087	The Negative-Sign Identifier field is not used correctly when importing files of type Fixed and the sign is placed before the amount.	Cash Management	COD 1201 COD 1241 COD 1262
375088	If the Data Line Tag field is empty, all lines are skipped when importing files of type Fixed.	Cash Management	COD 1201 COD 1241 COD 1262
375280	A note sent over on a purchase invoice from another user is posted and then creates duplicate notes in My Notifications.	Client	COD 1305 COD 5063 COD 5407 COD 5704 COD 5705 COD 5923 COD 5988 COD 86 COD 87 COD 900 COD 96 COD 97 TAB 904 COD 12469 COD 17368 COD 17387
375392	"The IC Partner does not exist. Identification fields and values: Code='XXX'" error message when you try to import an intercompany file to the inbox.	Finance	COD 427 COD 435
375190	If you apply entries with a payment tolerance, and a payment discount and a rounding precision are set up, then you get a wrong remaining amount in the payment and not in the invoice as expected on the Customer Ledger Entries page.	Finance	COD 12
375144	The Recurring Journal page allows the posting of lines that have already expired.	Finance	COD 13
375163	The Quote report prints an extra page in Word.	Finance	REP 1304
375346	An inbound item ledger entry applied to a previous outbound item ledger entry is not cost-adjusted when the outbound entry is related to a job.	Inventory	COD 22
375397	The line amount in job ledger entries is incorrect when you partially post receipt of a purchase order linked to a job and then create an invoice by using the Get Receipt Lines function and post.	Jobs	COD 90
375191	A job planning line is created when you post a job journal line with no value in the Line Type column.	Jobs	COD 1026
375249	"Due date must have a value in Planning Component: It cannot be zero or empty" error message when you run the Calculate Plan function on the Order Planning page.	Manufacturing	TAB 246
375315	If you create a new contact from the Related Contacts page, the Company No. field is not filled automatically.	Marketing	PAG 5050
375017	"Amount must be negative in Gen. Journal Line Journal Template Name=" error message when you post a prepayment credit memo in a sales order where a payment method code with a balance account is used.	Prepayments	COD 11 COD 444 COD 367
375283	The Amount Incl. VAT field and the Outstanding Amount field should be calculated in the same way on sales order lines.	Sales	TAB 36 TAB 37 TAB 38 TAB 39
375296	The Shipment No. and Shipment Line No. fields should not get filled in if you use the Copy Document functionality from a sales document.	Sales	COD 6620
375156	A reservation entry with a tracking entry type and with an order-to-order binding is created when you cancel the existing reservation and the Order Tracking & Action Msg. option is enabled.	Sales	COD 99000831
375336	The Restore functionality does not provide the accurate line amount when you restore a sales return order with the Line Discount option.	Sales	COD 5063
375185	"An attempt was made to change an old version of a Sales Header record. The record should first be reread from the database. This is a programming error" error message when you create a sales invoice through the Get Shipment Lines function.	Sales	COD 60 COD 70 TAB 111 TAB 121
375310	If you have a customer or a vendor with an empty country code, you can not check the validity of the VAT registration number.	VAT/Sales Tax/Intrastat	COD 249
375206	The Calc. Regenerative Plan function replans an existing sales order when you already picked for the sale.	Warehouse	COD 7307
375248	The Whse. Item Tracking line is not removed when you assign it to a production order component that is fully picked when the production order is of type Make to Order.	Warehouse	TAB 5405
375189	"Quantity (Base) must be 0 or 1 when Serial no. is stated" error message when setting a serial number in a picking document.	Warehouse	COD 7307

How to install a Microsoft Dynamics NAV 2015 cumulative update

See How to install a Microsoft Dynamics NAV 2015 Cumulative Update .

Share:

Read more..

Cumulative Update 29 for Microsoft Dynamics NAV 2013 has been released (Build 42219)

This Cumulative Update 29 includes hotfixes and regulatory features released for Microsoft Dynamics NAV 2013, including hotfixes and regulatory features released in previous Cumulative Updates.

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

Where to download this Cumulative Update

You can download the cumulative update from KB 3086433 - Cumulative Update 29 for Microsoft Dynamics NAV 2013 (Build 42219).

Problems that are resolved in this cumulative update

 

Platform hotfixes

Note You may have to compile the objects in your database after you apply this hotfix.

ID	Title
375110	"Server page is not open" error message when closing a page.
375137	Suppress .NET warning when running the NAV server and the client on the same machine.
375309	The Windows client disconnects when renaming a record.
375351	"The company <name> does not exist" error message when you try to change a language if the company name has a leading space character.

Application hotfixes

ID	Title	KB Functional Area	Changed Objects
375108	The expiration date on a recurring journal should not be based on the work date.	Finance	COD 13
375287	If you use the Insert G/L Accounts function on the Account Schedule page, the lines are inserted in the top if you place the cursor on a new line at the end.	Finance	PAG 104
375218	The Adjust Cost Item Entries batch job recognizes wrong costs on adjustment value entries when an inbound item ledger entry is reversed on a later date with a fixed cost application.	Inventory	TAB 339 TAB 5802
375305	Wrong average cost of the in-transit location after upgrading from a previous version to version 2013 with a new design.	Inventory	N/A
375142	The VAT Amount field is wrongly calculated if the Pmt. Disc. Excl. VAT and the VAT Tolerance % fields are enabled in the setup.	VAT/Sales Tax/Intrastat	COD 90

 

How to install a Microsoft Dynamics NAV 2013 cumulative update

See how to install a Microsoft Dynamics NAV 2013 cumulative update (https://support.microsoft.com/kb/2834770/ ) .

Share:

Read more..