Dynamics User Group
Dynamics User Group
  • Site
  • User
  • Site
  • Search
  • User
Dynamics 365 Business Central/NAV User Group
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
  • Dynamics NAV Build 29113 - Two bugs

    Marq
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
>
  • DUG Home
    • Contact DUG
  • Dynamics 365 for Finance and Operations/AX User Group
    • Forums
    • Blogs
  • Dynamics 365 Business Central/NAV User Group
    • Forums
    • Blogs
    • Wikipedia
    • Events
  • About DUG
    • Announcements
    • Frequently asked questions about DUG
    • Membership service
    • Advertise on DUG
    • Become a DUG sponsor
    • Follow us on LinkedIn
    • Follow us on Facebook
    • Follow us on Twitter
  • More
  • Cancel
  • Microsoft Dynamics 365 User Groups

  • Dynamics 365 Business Central
  • Dynamics 365 Customer Engagement
  • Dynamics 365 for Finance and Operations
  • Power Platform
  • Microsoft Dynamics User Groups

  • Dynamics AX
  • Dynamics CRM
  • Dynamics NAV
  • About
  • Contact us
  • Frequently asked questions
  • Terms of use
  • Privacy policy
Copyright 1995-2021 Dynamics User Group, all rights reserved.