Copy Microsoft Dynamics NAV company by SQL script into another database v2

Because the first script I have released was “two step job” and it is too complicated to use it in some automated way, I have prepared this new script, which is only modification of the original. This new script directly copy the data in one go, you do not need to save the script and execute it in second step. This SP do not need to be marked as system.   -- ============================================= -- Author: Kamil Sáček -- Create date: 18.10.2013 -- Description: Function for copying comany...
Posted by Kine | 5 comment(s)

Copy Microsoft Dynamics NAV company by SQL script into another database

After Microsoft Dynamics NAV 2013 R2 release, there are complains about impossibility to copy company from one database to another (you can copy company inside database through standard NAV client interface). Thus I spent some time creating stored procedure which will do it for you… or, this stored procedure will generate script for you, which will do it for you… of course, you can modify the script as you wish to fix possible bugs or extend the functionality and I will be happy when...

Microsoft Dynamics NAV 2013 R2–What’s new?

Long time passed since my last blog article and many things happened. We have bought new flat (which we are now preparing for us to move there), I have lot of work with our developers to make the development more smooth and more and more… But today is big day for Microsoft Dynamics NAV 2013, because new release (R2) is right now presented to public on Directions EMEA. Because that, NDA is dropped and I want to show you the main changes which it brings. And some of them are not only some “facelifts”...

Microsoft Dynamics NAV 2013 Tip 2

After long time I have found some free time and subject worth to write something. During my work on my DynamicsNAVProtocolHandler (with some help from Daniel Steiner from redIT) I have found one thing I didn’t know about in NAV 2013. Do you need to know server, instance or some setting of the NAV Server you are connected to? If you need something regarding the NST you are just using in the NAV Win client, you can be inspired by code from codeunit 9500. There is one DotNet class you can use for this...
Posted by Kine | 1 comment(s)

Microsoft Dynamics NAV 2013 Tip 1

NAV 2013 is bringing many changes from technological point of view, but even from end-user view. I will try to give you few interesting tips about features, which could be very useful, but could be easily overlooked. First tip, which is very small and hardly to find, because it is nothing “new”, with some new Action button, but rather re-worked standard functionality. In NAV 2009 RTC nearly all users were missing possibility to Copy&Paste records. In classic client, users were used to copy records...
Posted by Kine | 1 comment(s)
Filed under: ,

DynamicsNAV protocol handler

Now, when NAV 2013 beta was released, many partners could struggle from the problem of side-by-side installation of the NAV clients. Problem is, that the development environment is using the URI (hyperlinks) to open the objects in RTC. Because the protocol is handled by default only the latest installed version, you can have problem if you need to use it with more versions. And because that, I have created this handler for you. Download v1.0.2.0 After you copy the files somewhere and run the exe...

Microsoft Dynamics NAV 2013 beta–installation and configuration tips

If you are installing Microsoft Dynamics NAV 2013 beta, you can struggle from some problems. There are some tips for you: Ports If you are installing the NAV server on computer, where are already some NAV services, you need to use different ports for the NAV 2013 services. NAV 2013 beta is not supporting Port Sharing. You need to think on it when configuring the installation. Function not supported When you successfully installed the NAV 2013 client with development environment on PC, where the NAV...
Posted by Kine | 2 comment(s)
Filed under: ,

NAV 2013 beta–What’s new

It is time to look at new features in NAV 2013 C/Side. This will be quick overlook of new commands and functionality in the developers environment, which is replacement of the classic client and is intended only for developing now. New commands [Ok :=] xRec.SETAUTOCALCFIELDS([Field1] ,...)[Ok :=] xRec.SETAUTOCALCFIELDS([Field1] ,...) Using this command you tell NAV to automatically calc the FlowFields after new record is read into the variable. You do not need to call CALCFIELDS in the repeat-until...
Posted by Kine | 1 comment(s)
Filed under: ,

Directions EMEA day 1

Ok, it is late and I am tired. But I will pack the day into few sentences: Page preview in page designer – interactive preview of the page directly in C/SIDE, clicking on the object in the page select the corresponding line in the designer or you can open properties for the object (action/field) “Find” function is back – you can again instantly search for specific data in the actual column Variable filters – when filtering in the RTC, you can use “variables” like “%mycust”, which will be “expanded...
Posted by Kine | with no comments

Garbage Collector in NAV 2009

Today I learned one new thing: Garbage collector in NAV 2009 is set to DISABLED by default. Do not ask me what does it mean and why it is disabled. I do not know. Regardless the value DISABLED, this settings just means that Workstation mode is used for GC. Microsoft NAV team have learned, that by enabling it, you can speed up the NAV Server! Are you asking how you can enable it? It is easy, you need only to add this into the Microsoft.Dynamics.NAV.Server.exe.config file: <configuration> <runtime>...
Posted by Kine | 2 comment(s)

Possible new way to install NAV 2013

Just now, I am in Rome, waiting for tomorrow, when Directions EMEA 2012 begins. Whole Directions will be somehow connected to NAV 2013, and it seems that it will be beginning of blog articles about NAV 2013 and new technologies/functions inside it.   ClickOnce First new feature you can use in connection with 2013 is ClickOnce install. This way of installing and distributing of applications exists since .NET 2. But it was not possible to use it for previous versions of NAV. Now, with upcomming...
Posted by Kine | with no comments

E-Book Give away winners

Hello all, thanks to all for the e-mails regarding the e-book give away. I made small overview of most hated/loved feature of NAV 2009 and feature of NAV “7” you are looking for most. I must say, that from the e-mail I can see, that expectation from NAV “7” are very “biased” by rumors and wrong information about what will be in NAV “7”. There are not much info released, but I highly recommend to spend some money and be on events like Directions (Directions EMEA), Convergence, or NAV TechDays. You...

“Microsoft Dynamics NAV 2009: Professional Reporting” book give away

Thanks to the kind people of Packt Publishing, I'm able to give away 3 e-copies of the book “ Microsoft Dynamics NAV 2009: Professional Reporting ” written by Steven Renders. What you need to do for that? Send me e-mail to kamil.sacek at gmail dot com with these info: Subject: Book giveaway Body: Your Name: What you like and hate most on the NAV 2009 from technical point of view: What you are looking for most on NAV “7”: I will randomly select 3 winners which will receive...
Posted by Kine | 3 comment(s)

NAVTechDays 2012!

For all technical people around Microsoft Dynamics NAV: Be informed, that next NAV TechDays will be THIS YEAR! Who wants to learn new things and see many interesting tools/applications/hints/tips etc. – mark the date September 27.-28. 2012 in your calendar! Place will be same, Antwerpen, Belgium. Who missed the last conference, do not hesitate and plan your trip! It is a must for everyone to be there at least once… Sorry for so many exclamation marks in a so short text, but I am excited…   Thanks...
Posted by Kine | with no comments

Barcodes “magic” revealed

I just wants to forward you to my hosted articles about the barcodes there and there . I wrote it for the Microsoft Dynamics NAV blog and is focused not so technically, how you can expect from me. But I tried my best. Thanks for the feedback…
Posted by Kine | 1 comment(s)
Filed under: ,
More Posts Next page »