Dynamics User Group
Site
Search
User
Site
Search
User
Dynamics 365 Business Central/NAV User Group
Mark Brummel
Forums
Blogs
Resources
Wikis
Events
Leaderboards
Members
Mentions
Tags
More
Cancel
New
Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)
Mark Brummel
By Mark Brummel - Author of Microsoft Dynamics NAV 2013 Application Design
Home
Contact author
Subscribe by email
More
Cancel
Posts RSS
Atom
More
Cancel
Monthly archive list
July 2020
(3)
June 2020
(1)
May 2020
(14)
April 2020
(1)
March 2020
(1)
February 2020
(1)
January 2020
(2)
December 2019
(6)
November 2019
(6)
October 2019
(7)
September 2019
(6)
August 2019
(4)
July 2019
(3)
June 2019
(2)
May 2019
(1)
April 2019
(3)
December 2018
(2)
November 2018
(2)
May 2018
(6)
April 2018
(8)
March 2018
(6)
December 2017
(2)
July 2017
(1)
May 2017
(3)
April 2017
(3)
March 2017
(1)
February 2017
(1)
November 2016
(5)
October 2016
(1)
September 2016
(6)
August 2016
(2)
July 2016
(2)
June 2016
(4)
May 2016
(1)
April 2016
(1)
March 2016
(2)
December 2015
(12)
November 2015
(12)
October 2015
(8)
September 2015
(8)
August 2015
(7)
July 2015
(6)
May 2015
(2)
April 2015
(3)
March 2015
(3)
February 2015
(5)
January 2015
(10)
December 2014
(12)
November 2014
(9)
October 2014
(1)
March 2014
(1)
November 2013
(1)
October 2013
(1)
September 2013
(6)
June 2013
(2)
April 2013
(2)
December 2012
(3)
November 2012
(3)
October 2012
(4)
September 2012
(5)
August 2012
(2)
March 2012
(3)
January 2012
(2)
November 2011
(8)
October 2011
(2)
September 2011
(2)
August 2011
(1)
May 2011
(2)
April 2011
(1)
March 2011
(1)
February 2011
(2)
January 2011
(3)
October 2010
(3)
September 2010
(12)
August 2010
(4)
June 2010
(3)
May 2010
(4)
March 2010
(1)
January 2010
(2)
December 2009
(14)
November 2009
(17)
October 2009
(4)
September 2009
(5)
August 2009
(1)
June 2009
(14)
May 2009
(2)
April 2009
(7)
December 2008
(1)
September 2008
(3)
August 2008
(1)
June 2008
(1)
May 2008
(1)
December 2007
(1)
October 2007
(1)
September 2007
(1)
August 2007
(2)
July 2007
(1)
June 2007
(1)
May 2007
(1)
April 2007
(2)
October 2006
(1)
July 2006
(1)
June 2006
(6)
Related
Related Tags
Book
BusinessCentral
design patterns
Design Patterns - General
Directions
Directions USA 2009
Dynamics NAV
Events
General
NAV 2009
NAV 2009 SP1
NAV 2013
NAV2016
Pages
Performance
Product News
PRS
Role Center
RTC
SQL
SQL Server
Tip
Tips & Tricks
Tips and tricks
Upgrade
Blog post list
Tags
Contact author
Subscribe by email
More
Cancel
By date
By view count
By comment count
Descending
Ascending
Dynamics NAV Build 29113 - Two bugs
Marq
A short while ago I informed you about an important hotfix for Navision 4.0 SP3 and 5.0 SP1. At one of my larger customers in Germany we implemented this build. It is really working great and solves a lot of problems caused by the Dynamics cursors introduced in build 26410. However we have managed to find two strange issues with it. 1. Adding SQL indexes NAV forgets a filter on Sell-to Cutomer No. in a Select Statement: We found a bug where NAV creates a wrong select statement which is missing...
2009-6-28
Original post
SQL
Perfomance
Hotfix
Dynamics NAV
29113
5203 views
0 comments
over 11 years ago
More
Cancel
NAV 2009 SP1 - Run pages from objectdesigner | Pros and Cons
Marq
For this blog entry I would like to refer to Eric Wauters (Waldo) blog entry . One thing he describes about NAV 2009 SP1 is the possibility to start pages from the object designer, simply by clicking the run button. This saves you the trouble of running Dynamicsnav:////runpage?page=70000 from the windows run menu or the internet explorer. BUT. Let's see what happens add a record to the table, which page 70000 is based on... And run the page again... The new data is not showing.... ...
2009-6-28
Original post
7695 views
0 comments
over 11 years ago
More
Cancel
Tip #14 - Autoincrement Interaction Log Entries
Marq
Interaction Log entries are a very powerfull feature of Dynamics NAV. From everywhere in NAV you can add an interaction log entry if you print a report and from withing the CRM part of NAV you can register all other interactions like emails, phonecalls, mailings etc. Interactions can be related to a path of multiple to-do's that can be sinchronised with Outlook. Technicaly the interaction log entry table is clustered by an entry no. Like al Entry tables in NAV this handled manualy by C/AL code...
2009-6-28
Original post
6565 views
0 comments
over 11 years ago
More
Cancel
Tip #13 - Shift F2 on indexkeys...
Marq
This was also a great tip for me. I saw someone do it when I was onsite at an enduser. Everyone who works with the key's in NAV tables hassled with this, I am sure. When you hit F6 on a key you get the field list. This is only usefull when you add a key on one field. What you want is to go to the form that allowes you to add more than one keyfield. This (seems to be) able to achieve with shift+F2.
2009-6-28
Original post
Keys
Functionkeys
4581 views
1 comments
over 11 years ago
More
Cancel
Tip #12 - Migrate from Native to SQL Server - Keys
Marq
It has been almost two years since I presented a successfull session at Directions USA about migrating from the Navision Native (C/Side or Classic) database to SQL Server. This session was repeated in EMEA half a year later. You can download the slides here . It was only recently that I found another thing you have to realise when you migrate. It was related to table 49 Invoice Post. Buffer. Some of you might know that it is used in both codeunit 80 and 90 to combine G/L entries by (VAT) posting...
2009-6-28
Original post
SQL
Migration
Keys
Native
8137 views
3 comments
over 11 years ago
More
Cancel
SQL Transactional Locking
Marq
Another blog entry about locking in SQL Server. I really hope this is not getting boring. I just like to get some myths and roumors out of the way, that's all... Hopefully my older blog entries clarified the LOCKTABLE command resulting in SQL Server locking either records or ranges of records. For this post to be clear I would like to start writing some code. This codeunit contains two functions. Bot functions have their own local variable for the Customer table. Please note that the first...
2009-6-28
Original post
SQL
locks
4775 views
2 comments
over 11 years ago
More
Cancel
Tip #11 - The 'page' variable
Marq
When NAV2009 was released, a new variable type was introduced called page. As most of you know, page and form numbers are transparent in NAV. This means that every page should have a form and vice versa. Depending of the client it will show the page or form with that number. For example: The table 21, customer ledger entry has a DrillDownFormID. This refers to form 25. But if you drilldown in the Role Tailored Client it will show page 25. I've created a new Table with a Form and a Page,...
2009-6-28
Original post
Navision 2009
Tips & Tricks
NAV 2009
Page
4449 views
0 comments
over 11 years ago
More
Cancel
Tip #10 - NAV2009 Drop Down List
Marq
Following the blog of Claus about drop down lists I would like to add some follow which is new for most developers. Claus' blog give a very accurate description about how to work with this new cool feature of NAV2009 but when I was explaining it for a developers class I found a little mistery. The blog describes that, when you do not specify it, NAV will show the primairy key. But how does that explain the drop down of the Currency... Please note that it shows Code and Description... ...
2009-6-28
Original post
DropDown
Navision 2009
Tips & Tricks
NAV 2009
5643 views
1 comments
over 11 years ago
More
Cancel
Tip #9 - Gain access to a database without a password
Marq
This is often an issue when you get a SQL Backup from a customer to analyse. Off course you can create a user on SQL and change the password, but it is easier. Navision stores the users into two tables. User and 'Windows Login', The first table is for database logins, the latter for Windows Logins. When you delete all records from both tables Navision will no longer ask for passwords and allowes blank access. So to all end users: Protect your backupfiles!
2009-6-18
Original post
Forgot Password
Tips & Tricks
Backup
Passwords
Database access
5196 views
2 comments
over 11 years ago
More
Cancel
Tip #8 - SQL Server Script button
Marq
This tip is about the SQL Server Management studio again. Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL. The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users. Let's look at one of those (Backup); With this wizard we can easily create a full, incremental or transaction log backup of the database. Without going in the details about this wizard I would like to point out the script button This button exists on a lot of SQL Server wizards. When you push…
2009-6-18
Original post
Script
Dynamics NAV
Tips & Tricks
Management Studio
SQL Server
4689 views
0 comments
over 11 years ago
More
Cancel
>