Error Running Dynamics NAV 2018 client "The tenant default is not accessible"

Hello guest, looks like this year is surely fresh ! I received this error when i attempted to run the NAV client 2018. This error popped up after i had imported NAV objects .

Microsoft advises you to run the development environment with administrator rights.

• Select tools menu
• Select sync. Schema for all tables
• Select with validation

That should work, if it doesn't then run with the force option. For more information click here to read more from the Microsoft blog

ERROR .NET 4.7 keeps on rolling back during installation on windows 7 SP1

Hello guest, i promised myself to document every challenge i encounter during my operations with Dynamics NAV. Much as this is not directly linked allow me share it as you will not be able to have your Dynamics NAV 2018 install without .NET Framework 4.7

After encountering the above error, i had to search for a way to pass it as my client was waiting. We all know how new clients can be anxious.

From the information i obtained, the roll back and failure to install .NET framework 4.7 may fail because of files that could be left behind on the system in the previous installation attempts.

The solution is uninstall the previous versions of .NET Framework on the PC. However this has significant drawbacks that it may stop some applications on the system that require .NET from operating.

The solution is to do it safely using the .NET framework cleaner tool.
Download the tool here
Run the tool
You can now install you .NET Framework 4.7
Once that is successful, proceed with Dynamics NAV 2018 installation
Good luck!

Error installing .NET 3.5 on Windows Server 2012 R2 "Installation of one or more roles, role services or features failed "

Hello reader, as part of the infrastructure that supports Dynamics NAV, i met this error early this year during server installation for MSSQL 2014. My internet connection was not soo good. It could be the reason "Add roles & features" operation couldn't help. I had to look up for a solution on the web. 

Am prompted to share with you quick solutions.

Steps
Prepare an image containing the windows server that you installed.
Usually this the sources folder contains information to enable setup install the framework

• Run the Roles & Features wizard
• Select .NET 3.5 Framework.
• Click specifiy alternate path
• Navigate the Windows setup folder  for \Sources\srs
• Click okay & install

Just incase you need more information click here
Good luck!

"Failed to open image (Virtual box) for writing due to wrong permissions." VERR_VD_IMAGE_READ_ONLY error

Happy New Year, It has been long. I know this should be a place where we share only Dynamics NAV. I met that error as part of my routine Dynamics NAV operations. I felt it would nice i share about it.

Well to work around this error, i simply ran Virtual box as an administrator. 

The rest is history!

For more info, click here

Repeat table Header on all pages of a report

Hello reader, repeating table header across all pages of a report can be tricky especially if you are new to report design. It is not as difficult as it might seem. Here are the steps;

1. Open the report in layout mode. The RDLC kayout of your report should be on display
2. Go to column groups advance mode
3. A series of static groups is created
4. Select a static group for the row you would like to repeat
5. Set the properties of that Row static group as follow

             KeepWithGroup ="After"
             RepeatOnNewPage = "True"


The procedure is true for both Report builder and Visual Studio 
Based on article published  here
Cheers!

Dynamics NAV 2017 login error "Invalid Object Name master.dbo.$ndo.$rsvproperty"

Hello reader, now that you are here, i know you got the error below.

The error is most likely caused by a license. To sort it simply ;

• Open the database in development environment
• Go to file>Database>alter
• Click the integration Tab
• Check "Save License in Database" check box
• A window opens 
• Browse for the Dynamics NAV license on your PC
• Once you find it, select it and click open
• Restart the NAV server.

You are good to go.
Cheers!!!

Creating pages in AL (Dynamics NAV 2018/ Business Central) Part 3

Hello reader, as we continue to explore AL, remember we are following our project in the PDF I introduced to you in Part One.
In today's article, we will ;

• create a card page,
• Create a list page.
• Link the two using CardPageID property
• Add a menu item to the navigation pane of Order processor Role center

I recommend you create a new file "SeminarPages.al"

Paste the following code

page 50030 "Seminar Room Card"

{

    PageType = Card;

    SourceTable = "Seminar Room";

    layout

    {

       

        area(content)

        {

            group(General)//Pass the group name

            {

                field(Code;"Code")

                {

                   

                }

                 field(Name;"Name")

                {

                   

                }

               

                 field(Address;Address)

                {

                   

                }

                field("Address 2";"Address 2")

                {

                   

                }

                field(Allocation;Allocation)

                {

                }

                field("Internal/External";"Internal/External")

                {

                }

                field("Maximum Participants";"Maximum Participants")

                {

                }

                group("Communications")

                {

                    field(Contact;Contact)

                    {

                    }

                    field("Contact No.";"Contact No.")

                    {

                    }

                    field("Country/Region Code";"Country/Region Code")

                    {

                    }

                    field(City;City)

                    {

                    }

                    field(Comment;Comment)

                    {

                    }

                    field("E-Mail";"E-Mail")

                    {

                    }

                    field("Fax No.";"Fax No.")

                    {

                    }

                    field("home Page";"home Page")

                    {

                    }

                    field("Post Code";"Post Code")

                    {

                    }

                   

                }

            }

        }

    }

    actions

    {

        area(processing)

        {

            action(ActionName)

            {

                trigger OnAction();

                begin

                end;

            }

        }

    }

   

    var

        myInt : Integer;

}

page 50035 "Seminar Room List"

{

    PageType = List;

    CardPageId = "Seminar Room Card";

    SourceTable = "Seminar Room";

    layout

    {

        area(content)

        {

            repeater(Group)

            {

              

                field(Code;"Code")

                {

                   

                }

                 field(Name;"Name")

                {

                   

                }

               

                 field(Address;Address)

                {

                   

                }

                field("Address 2";"Address 2")

                {

                   

                }

                field(Allocation;Allocation)

                {

                }

                field("Internal/External";"Internal/External")

                {

                }

                field("Maximum Participants";"Maximum Participants")

                {

                }

                field(Contact;Contact)

                    {

                    }

                    field("Contact No.";"Contact No.")

                    {

                    }

                    field("Country/Region Code";"Country/Region Code")

                    {

                    }

                    field(City;City)

                    {

                    }

                    field(Comment;Comment)

                    {

                    }

                    field("E-Mail";"E-Mail")

                    {

                    }

                    field("Fax No.";"Fax No.")

                    {

                    }

                    field("home Page";"home Page")

                    {

                    }

                    field("Post Code";"Post Code")

                    {

                    }

            }

        }

        area(factboxes)

        {

        }

    }

    actions

    {

        area(processing)

        {

            action(ActionName)

            {

                trigger OnAction();

                begin

                end;

            }

        }

    }

}

pageextension 50040 "Order Processor Extension" extends "Order Processor Role Center"

{

    layout

    {

        // Add changes to page layout here

       

    }

    actions

    {

        // Add changes to page actions here

        addlast(Embedding)//Adding an action to our Role center Navigation pane

        {

            action("Seminar Rooms")// The new navigation menu item

            {

                RunObject = page "Seminar Room List";

            }

        }

    }

   

    var

        myInt : Integer;

}

Save and publish.
Restart your Dynamics NAV instance.
There you find a new navigation menu item.
Good luck