Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central is now official

Microsoft just released the new name for “Microsoft Dynamics 365 ‘Tenerife'”, where “Tenerife” was just a codename for the next version of “NAV-In-The-Cloud”. And as you might have figured from the title, that name is “Microsoft Dynamics 365 Business Central”

Generally available beginning April 2nd, Business Central offers businesses a single, end to end solution for managing finances, operations, sales and customer service, and an opportunity to easily upgrade from entry-level accounting software and legacy ERP systems.

Dynamics 365 Business Central will be generally available on April 2, 2018, in 14 countries – United States, Canada, United Kingdom, Denmark, Netherlands, Germany, Spain, Italy, France, Austria, Switzerland, Belgium, Sweden, and Finland, purchased through Cloud Solution Provider (CSP) partners.

Australia and New Zealand will be generally available beginning July 1, 2018.

Microsoft has given two interesting links for you to learn more about:

• Microsoft Dynamics 365 Business Central
• Microsoft Dynamics 365 Roadmap

You can read more about this exciting news on clicking here.

How to Kill Sessions in Dynamics NAV 2013 & above

In the older versions of Microsoft Dynamics NAV where the classic client was available you could go to the sessions table and just delete a session to kill it. This was very useful for a number of reasons but it does not work like that anymore in the windows client of version 2013 and above.

Fortunately this feature can easily be replicated by adding an action item to the ribbon on the sessions page in Dynamics NAV.

Here is how you can add a ‘Kill Session’ action item to the sessions page:

Open page 9506 in design mode through the development environment and add a ‘Kill Session’ action item. Something like below.

Then write the following code to the action item.

The above text constant Text50000 just says ‘Kill Session?’.

To make the action item look a bit better you might also want to set the Image and Promotion properties, like below.

That’s it! 🙂

Now when you run the sessions table you can use the new ‘Kill Session’ action item in the ribbon to kill a session. Useful if a session is hanging or has been idle for a while. Also very useful if you start the job queue with a client and you want to stop the background session that is running.

Hope you find above post helpful...

Comment and Uncomment Selection in Navision

One of the small features in Microsoft Dynamics NAV is the ability to comment a selection of code.

Now I am not a huge believer in putting comments in code. Actually I am of the school that think comments are evil, because code should be written so it explains itself. That aside I find the new feature handy when testing and you want to take something out just for a test run.

How does it work?

If you are in the code you can mark a few lines of Code like this


Then click “Comment Seletion…” under the Edit Menu or use the shortcut Shift+Ctrl+K and the marked lines will be commented out by setting 2 forward slashes in front of the code at the left margin.


There is also an “Uncomment Seletion…” with the shortcut Shift+Ctrl+O that will remove the comments again.

Absolutely a help to developers, but please consider how you use comments.

Comments should not be needed in the final version of great code.

List of Release for Dynamics Navision 2016 including Build No. & with localization.

Knowledge Base ID	Title	Release date	Build no.	Local versions included
4052194	Cumulative Update 25 for Microsoft Dynamics NAV 2016	November, 2017	49424	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4045670	Cumulative Update 24 for Microsoft Dynamics NAV 2016	October, 2017	49326	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4040571	Cumulative Update 23 for Microsoft Dynamics NAV 2016	September, 2017	49146	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4037308	Cumulative Update 22 for Microsoft Dynamics NAV 2016	August, 2017	48992	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4034491	Cumulative Update 21 for Microsoft Dynamics NAV 2016	July, 2017	48822	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4024641	Cumulative Update 20 for Microsoft Dynamics NAV 2016	June, 2017	48628	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4021395	Cumulative Update 19 for Microsoft Dynamics NAV 2016	May, 2017	48466	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4018438	Cumulative Update 18 for Microsoft Dynamics NAV 2016	April, 2017	48316	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4014100	Cumulative Update 17 for Microsoft Dynamics NAV 2016	March, 2017	48067	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
4011762	Cumulative Update 16 for Microsoft Dynamics NAV 2016	February, 2017	47864	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3216191	Cumulative update 15 for Microsoft Dynamics NAV 2016	January, 2017	47838	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3209072	Cumulative update 14 for Microsoft Dynamics NAV 2016	December, 2016	47444	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3202891	Cumulative update 13 for Microsoft Dynamics NAV 2016	November, 2016	47256	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3193868	Cumulative update 12 for Microsoft Dynamics NAV 2016	October, 2016	47042	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3188240	Cumulative update 11 for Microsoft Dynamics NAV 2016	September, 2016	46773	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3182131	Cumulative update 10 for Microsoft Dynamics NAV 2016	August, 2016	46621	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, IN, NA, NL, NO, NZ, RU, SE, UK
3172549	Cumulative update 9 for Microsoft Dynamics NAV 2016	July, 2016	46290	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3166287	Cumulative update 8 for Microsoft Dynamics NAV 2016	June, 2016	46045	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3157492	Cumulative update 7 for Microsoft Dynamics NAV 2016	May, 2016	45834	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3151017	Cumulative update 6 for Microsoft Dynamics NAV 2016	April, 2016	45480	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3145855	Cumulative update 5 for Microsoft Dynamics NAV 2016	March, 2016	45243	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3139364	Cumulative update 4 for Microsoft Dynamics NAV 2016	February, 2016	44974	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3130298	Cumulative update 3 for Microsoft Dynamics NAV 2016	January, 2016	44365	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3121038	Cumulative update 2 for Microsoft Dynamics NAV 2016	December, 2015	43897	AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3106089	Cumulative Update 1 for Microsoft Dynamics NAV 2016	November, 2015	43402	AT, AU, BE, CH, CZ, DE, DK, ES, FI,

Microsoft Navision 2013 and Microsoft Navision 2013 R2 has came to an end.

Today, Cumulative Update 56 for Dynamics NAV 2013 and Cumulative Update 49 for Dynamics NAV 2013R2 has been released. But these will be the last cumulative updates for this two Dynamics NAV versions with just a few platform and application hot fixes.

Why the last time? Well, from January 9th 2018, Microsoft will finish with the mainstream support for these NAV versions. Customers with active service plan can continue to use already released hot fixes and help via Customer Service. But I think that the best idea for all these customers is to upgrade their solution. And not only for owners of these versions. I think that the best solution for all clients is to stay current with new versions all the time.

And just to be precisely, Extended Support will continue with existing until :

January 10th 2023 for Dynamics NAV 2013
January 9th 2023 for Dynamics NAV 2013 R2

XMLPort Generator Tool for Navision

Recently, I need to import some flat text files into NAV into completely new tables. So first, I created a table containing all the fields in the correct order. Next I had to create an XMLPort to import the values. But, there were over 200 fields in my newly created table, and had 3 more tables with the same thing.

So, there is a little tool available created in .NET to read a table from navision & generate a XMLPort for the same while saving it as text file for importing into Development Environment.

Given below is the link for Downloading the XMLPort Generater Tool

https://drive.google.com/file/d/1dLcWqXWAxN4Araj6SUR3A-3S_xBcteQP/view?usp=sharing

Given below are the steps for how to Run the tool :-

1. Export your table to text file.
2. Run the XMLPort Generater Tool.
3. Copy all the text from the exported Table text file & Paste all of it on the left side of the Tool.
4. Please Mention some details like Table ID, Table Name, XML ID etc.
5. Now click on generate XML Port (It will generate a text onto the right side of the column on the tool)
6. Now finally click on Save to file for saving the generated text into a text file on to the required location.

Note - 
- XMLPort is always import, of type variable text (no xml)
- If you don’t supply anything in the fields, it will create an xmlport of type variable text to your       source table.
- XMLPort name is by default set to “IMPORT %1” with %1 being the source table name

Now Import that generated Text file of XML port into the Development Environment and we are good to go.


Hope this helps in most of the cases where it can save some time & effort...!!

Microsoft Dynamics NAV Keyboard Shortcuts

Keyboard	Action
Alt	Display shortcut keys in the ribbon
Alt+F2	Toggle to display/hide FactBoxes
Alt+F3	Filter to currently selected field (e.g. customer name)
Alt+F4	Close window or close program
Alt+F6	Collapse or expand the active frame (e.g. expand “Invoicing” section in sales order)
Alt+F12	Optimize space for the current page
Alt+Left Arrow	Go to the previous window in the navigation history
Alt+Right Arrow	Go to the next window in the navigation history
Alt+Enter	Move to the line below
Ctrl+F1	Collapse or expand the ribbon
Ctrl+F2	Create a new document
Ctrl+F3	Select Search pages
Ctrl+F4	Open related list editor (e.g. open posting group when field selected in sales order)
Ctrl+F7	View entries
Ctrl+F9	Release document
Ctrl+F11	Reconcile or split lines
Ctrl+F12	Select the address bar
Ctrl+C	Copy
Ctrl+G	Go to
Ctrl+E	Export to Microsoft Office Excel
Ctrl+L	Show links
Ctrl+N	Create a new record
Ctrl+O	Open the company
Ctrl+P	Print
Ctrl+V	Paste
Ctrl+W	Export to Microsoft Office Word
Ctrl+X	Cut
Ctrl+Z	Undo
Ctrl+Page Down	Display next document or card in a list
Ctrl+Page Up	Display previous document or card in a list
Ctrl+Up Arrow	Move up while the selected line stays selected
Ctrl+Down Arrow	Move down while the selected line stays selected
Ctrl+Left Arrow	Move to the first field on a line
Ctrl+Right Arrow	Move to the last field on a line
Ctrl+Alt+F1	Open the About this Page/Report window (shortcut is commonly used by other programs e.g. Intel graphics. You may have to disable these first.)
Ctrl+Delete	Delete the selected line
Ctrl+Home	Move to the first line in a list
Ctrl+End	Move to the last line in a list
Ctrl+Enter	Save and close window (equivalent to choosing the OK button)
Ctrl+Insert	Insert new line
Ctrl+Shift+F3	Select Limit totals to (e.g. chart of accounts)
Ctrl+Shift+A	Clear all filters (e.g. when opening report)
Ctrl+Shift+C	Copy Rows
Ctrl+Shift+D	Show dimensions
Ctrl+Shift+E	Edit list
Ctrl+Shift+R	View list
Ctrl+Shift+Q	Collapse/expand a line in a hierarchy
Ctrl+Shift+V	Paste rows
Ctrl+Shift+W	Open current page (e.g. sales orders) in a separate window
Ctrl+Shift+Enter	Save and close the window (e.g. saves new item being created) and opens a new window (e.g. new item)
F1	Open Help
F2	Edit
F3	Select Type to filter (field filter)
F4	Drop-down or look up to select
F5	Refresh the active window
F6	Go to the next frame
F7	Display statistics
F8	Copy the field above
F9	Post
F10, Alt	Select the menu bar and display access keys
F12	Select the navigation pane
Shift+F1	View error message
Shift+F3	Select Show Results (FlowFilter)
Shift+F4	Open a lookup window (from an ellipsis button)
Shift+F6	Go to the previous frame
Shift+F7	Open the related card
Shift+F8	Drop-down or look up to view
Shift+F9	Post and print
Shift+F10	Display a shortcut menu
Shift+F11	Apply entries, get source documents, or get warehouse documents
Shift+F12	Open the Role Center from the navigation pane
Shift+Tab	Move to the previous field
Tab	Move to the next field on non-line FastTabs
Delete	Clear selected text
Esc	Close the window or undo the data entry
End	Move to the last field on a line
Home	Move to the first field on a line
Enter	Move to the next editable field