Generated by All in One SEO v4.9.1.1, this is an llms.txt file, used by LLMs to index the site. # Got C/AL? Inside C/Side, Tools and random thoughts ## Sitemaps - [XML Sitemap](https://gotcal.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Posts - [Table 2000000068: Record Link - almost great!](https://gotcal.com/index.php/2010/07/table-2000000068-record-link-almost-great/) - Since version 5 of Dynamics NAV there has been the new application wide functionality for Record Links. You know the little paperclip in the toolbar. In Microsoft words: "The Record Links feature in Microsoft Dynamics NAV enables you to link Microsoft Dynamics NAV records to relevant documents such as reports and spreadsheets. For example, you - [The Dynamics NAV developers Gospel of the Flying Spaghetti Monster](https://gotcal.com/index.php/2010/07/the-dynamics-nav-developers-gospel-of-the-flying-spaghetti-monster/) - As a NAV developer there are basically only 2 books to live by: Application Designers Guide (Also available in the F1 Online Help in the application) C/AL Programming Guide (Programming-, Naming-, Numbering-conventions in NAV) These books should be mandatory reading by any developer/person doing development, but real world experience unfortunately shows they aren't. Even for - [RIM for Styleheets in Dynamics NAV](https://gotcal.com/index.php/2010/07/rim-for-styleheets-in-dynamics-nav/) - Microsoft Office Integration from Dynamics NAV uses stylesheets to transfer data to Excel and Word. If you are on a v5 database or higher this is standard functionality. If you have upgraded your executables, you will notice the new buttons in the toolbar, but nothing happens when you click them. In order to get them - [Object Permission Report for Microsoft Dynamics NAV](https://gotcal.com/index.php/2010/07/object-permission-report-for-microsoft-dynamics-nav/) - Microsoft just released the latest version of the object permission spreadsheet. Compared to what i have seen before i think this is a brand new edition with more features in it. "The purpose of this report is to provide information on what ojbects are included within the modules for Microsoft Dynamics NAV" as follows: Search - [Testing App-V for Dynamics NAV RTC 2009](https://gotcal.com/index.php/2010/07/testing-app-v-for-dynamics-nav-rtc-2009/) - I recently got the test credentials for the Saasplaza RTC testdrive that i have blogged about earlier (App-V streaming of Dynamics NAV) and decided today to give it a quick spin. Along with the install there is a great installation guide for the software that provides very easy to follow step by step installation for - [What is in your Dynamics NAV toolbelt? NavObjectViewer!](https://gotcal.com/index.php/2010/07/what-is-in-your-dynamics-nav-toolbelt-navobjectviewer/) - In this series of posts "What is in your Dynamics NAV toolbelt", i will highlight some of the tools i find very usefull in my daily work, and couldn't live without. There are probably great alternatives to them out there, so please share your experiences with me. NAVObjectViewer by Gerd Hübner is one of simplest - [NAVication, back later in august!](https://gotcal.com/index.php/2010/08/navication-back-later-in-august/) - Enjoying my vacation with the family. See you later this month. - [Attachments are not released until the Microsoft Dynamics NAV client is closed when you use the SMTP mail codeunit (400)](https://gotcal.com/index.php/2010/08/attachments-are-not-released-until-the-microsoft-dynamics-nav-client-is-closed-when-you-use-the-smtp-mail-codeunit-400/) - As reported in multiple blogs and user forums, the SMTP component had an issue about locking the files that was attached to sent emails. This usually always caused issues, as you would clean up your temporarily generated files after having sent them with the email attachment. According to the released hotfix KB2280492, this was occurred - [User Menu Level, Object BLOB – Generator code](https://gotcal.com/index.php/2010/10/user-menu-level-object-blob-generator-code/) - Yesterdays post on assigning MenuSuite Menu's programatically got a lot of hits, and i have been getting a couple of emails about how to create the data for the blob field. In this post I will show how to build the BLOB generator i Dynamics NAV. The BLOB content is reverse engineered on Mayank's Extreme - [Cloning – Extending Data Templates in Dynamics NAV using TableFilter](https://gotcal.com/index.php/2010/09/cloning-extending-data-templates-in-dynamics-nav-using-tablefilter/) - Since Dynamics NAV version 5, when RIM was introduced there has been the functionality for Data Migration and Master Data Templates. I have never really used the Migration tool, as it just seemed to be too limited, compared to what you can accomplish with standard dataports. During my last go-live the customer was using the - [Yet another Dynamics NAV Splash Screen – YADNSS!](https://gotcal.com/index.php/2010/09/yet-another-dynamics-nav-splash-screen-yadnss/) - Yet another...! As a regular Dynamics NAV blog reader i am sure you have seen this before, in various flavors, but here is a simple yet powerful splash screen. The main purpose of this splash screen, has been to easily identify development, test and live database configurations, and also show information about the current object - [What is in your Dynamics NAV toolbelt? Downgrade Objects from ara3n](https://gotcal.com/index.php/2010/09/what-is-in-your-dynamics-nav-toolbelt-downgrade-objects-from-ara3n/) - Here is another useful tool made by Rashed Amini aka. ara3n, i often use, when i have to "retrofit" objects from a newer version of NAV into an older version. Im sure you have tried this plenty of times, importing a 2009 object into a version 5 database - causing a crashed client. This is - [Repost: Dynamics NAV and the ROT Table](https://gotcal.com/index.php/2010/10/repost-dynamics-nav-and-the-rot-table/) - After switching blogging software, due to a server crash i never really got the old posts reposted from the original blog. I have had a lot of requests for one particular post: Dynamics NAV and the ROT table. I started finding the old backup of the database, to restore the post and realized it is - [Assigning Menu Suites permission Automatically - Implemented!](https://gotcal.com/index.php/2010/10/assigning-menu-suites-permission-automatically/) - The other day i was reading Mayank's new blog Extreme Engineering Network. Especially his post about assigning menu suites automatically was pretty neat. Well it could be, as it basically just gave you the information on _how_ you could do it. Looking at a lot of hex-editor information, i decided to give it a spin! - [CRONUS and MSDN license permissions](https://gotcal.com/index.php/2010/10/cronus-license-permissions/) - Cronus was known as the leader and the youngest of the first generation of Titans to most people, but in the Dynamics NAV community it is known as the the demonstration company name for Dynamics NAV. It comes with its own CRONUS license, that allows you to testdrive the system. Most people think it only - [SQL script to create SA Super User in Dynamics NAV](https://gotcal.com/index.php/2010/10/sql-script-to-create-sa-super-user-in-dynamics-nav/) - Restoring SQL backups from customers is a easy process in SQL Server. But in order to standardize your logins for the databases, it is easier if all databases have the same database login. So after restoring your SQL backup, this little script inserts a SA user in the User table, and assigns SUPER permissions to - [Advanced String Replace Function](https://gotcal.com/index.php/2010/10/advanced-string-replace-function/) - Using the built-in string functions in Dynamics NAV usually gives you all the string manipulation options you need. But a common request is replacing a special char with a new string value. This example came from the previous post on SMTP Mail functionality in Pre Dynamics NAV 5 versions. Mads from Denmark, ran into an - [What is in your Dynamics NAV toolbelt? Find inconsistency in G/L Entries when posting](https://gotcal.com/index.php/2010/10/what-is-in-your-dynamics-nav-toolbelt-find-inconsistency-in-gl-entries-when-posting/) - One of the most difficult errors in NAV to troubleshoot is: "The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table". In a standard, unmodified database it is usually related to tax/rounding issues. And in customized databases, it can be all sorts of issues. I have seen all kinds of - [Dynamics Community Syndication of Got C/AL?](https://gotcal.com/index.php/2010/11/dynamics-community-syndication-of-got-cal/) - Last week Got C/AL? got syndicated on the Microsoft Dynamics Community site, under the NAV section. You can find the site here: https://community.dynamics.com/product/nav/default.aspx. For the new readers i will give you a quick introduction to the site here, in addition to what you already can find on the site. The site was originally founded back - [Replacing CRONUS logo with CompanyInformation Picture in Stylesheets](https://gotcal.com/index.php/2010/11/replacing-cronus-logo-with-companyinformation-picture-in-stylesheets/) - This post is a follow up to some of my previous posts about the Send to Word/Excel features of Dynamics NAV. As you know, it uses a stylesheet (xslt file), that is being read into memory and the codeunit 403 inserts values into the document. This is definitely one of the cool demo features, when - [What is in your Dynamics NAV toolbelt? Barcode Creator by Stijn Bossuyt](https://gotcal.com/index.php/2010/11/what-is-in-your-dynamics-nav-toolbelt-barcode-creator-by-stijn-bossuyt/) - Stijn Bossuyt has made a great function/codeunit for generating barcodes within Dynamics NAV without the need for any third party add-ons. You can find more information about it on this MIBUSO blog. Barcode as defined on Wikipedia: "A barcode is an optical machine-readable representation of data, which shows certain data on certain products. Originally, barcodes - [Send Dynamics NAV RTC reports and documents as PDF](https://gotcal.com/index.php/2010/11/send-dynamics-nav-rtc-reports-and-documents-as-pdf/) - Thanks to Microsoft Reporting Services PDF Rendering Extension, all RTC reports can be exported to PDF. At least that is benefit coming back to us, while struggling with the report creations (read post from Alex Chow: How to define Set/GetData). In order to get the PDF, that gets generated on the service tier, available on - [Beginners Tip: Creating and Handling Headers in Dataports](https://gotcal.com/index.php/2010/12/beginners-tip-creating-and-handling-headers-in-dataports/) - As "Dinosaur"-tech as it might seem these days with most blogs posting about RTC, dataports is still one of the easiest ways to import data into NAVision. Having to search my old databases for a quick way to handle headers in datafiles, i thought i would share this with you. Hopefully Google will answer you - [Hot Topic Videos released for upcoming Dynamics NAV R2](https://gotcal.com/index.php/2010/12/hot-topic-videos-released-for-upcoming-dynamics-nav-r2/) - While most children are watching the days to christmas, most NAV people are looking forward to December 15th, when the R2 release of Dynamics NAV 2009 is going to be released. A quick blog scan will give you loads of information about the new features, the hype and what not. But Microsoft also released these - [Copy/paste from Dynamics NAV to Excel Headache!](https://gotcal.com/index.php/2010/12/copypaste-from-dynamics-nav-to-excel-headache/) - Every time you copy/paste data from NAV to Excel, you always run into the "intelligent" way Excel handles data. Excel's default number format is "General". Unfortunately this has some drawbacks, especially when you paste in data from another application. Lets do this example, enter in a new cell with Number Format General, the value "001010", - [NAV Launcher - Open NAV with the right client version](https://gotcal.com/index.php/2011/01/nav-launcher-open-nav-with-the-right-client-version/) - This morning i was reading the blog post from Arend-Jan Kaufmann regarding opening Classic databases with the correct executable version. You can see his blog post here: Suggestion for Available Databases Form in Dynamics NAV It reminded me of a tool i basically use on a daily basis, as well as many other people in - [Web Based Dynamics NAV Object model from NavUtils.com](https://gotcal.com/index.php/2011/01/web-based-dynamics-nav-object-model/) - In my search for some information about getting Item Tracking via ADCS to work with MRP/MPS in Dynamics NAV i noticed, that when i searched for specific terms of functions in NAV objects a website kept popping up in the Google search results. For some reason i had not really seen it before, must have - [Dynamics NAV, first on the Azure platform?](https://gotcal.com/index.php/2011/04/dynamics-nav-first-on-the-azure-platform/) - Looking forward to reading some of the Convergence gossip from Atlanta, i got this link from a friend today. Definitely sounding interesting that Dynamics NAV will be the first Microsoft ERP product supported on the Microsoft Azure platform. The next major releases of Dynamics AX, GP, NAV and SL will be developed to run on - [Cookie cutters for Visual Studio Dynamics NAV 2009 RTC add-ins](https://gotcal.com/index.php/2011/05/cookie-cutters-for-visual-studio-dynamics-nav-2009-rtc-add-ins/) - You know the hoops you have to jump before you got Visual Studio setup for creating a RTC add-in. Well look no further Christian Abeln published a couple of great templates to use in Visual Studio, that will help you create your add-ins much faster and easier. Actually he already published tempates back in 2009, - [Dynamics NAV RTC Reports, BLOB fields, printing Notifications](https://gotcal.com/index.php/2011/05/dynamics-nav-rtc-reports-blob-fields-printing-notifications/) - Learn how to print the contents of the Notifications in the Role Tailored Client for Dynamics NAV 2009 (SP1 and R2). This small customization can be used on existing and new RTC reports. Simple VB.NET code to use. The notifications are stored in the table "Record Links". - [Contributions for the Directions Innovation Award](https://gotcal.com/index.php/2011/10/contributions-for-the-directions-innovation-award/) - If you are not at the NAV Directions 2011 in Orlando, you might not be aware of this new initiative for the NAV Directions Innovation Award. Entrants were to submit a 3-5 minute video to showcase their "innovation" for the board that will select the finalists. Voting will be done in the true spirit of - [NAV Launcher - download](https://gotcal.com/index.php/2011/10/nav-launcher-download/) - Back in January 2011 i wrote about the NAV Launcher, a project based on the Navision Starter v1.2 orignally created by Sergey Gazizyanov back in 2006. Well, i realized that i never put a download link on the site. Attached in this post is the installer for the .NET project. It requires, as far as - [Available objects in license report, re-visited](https://gotcal.com/index.php/2010/05/available-objects-in-license-report-re-visited-5/) - Run the report and select the object type and object range and the report will list the available areas that are not used in your license. - [Welcome to the Digital Age... and 2011!](https://gotcal.com/index.php/2011/01/welcome-to-the-digital-age-and-2011/) - 18 days into the new year of 2011, and still wondering where 2010 went? Since the last postings things have been busy with end of year tasks for customers, holiday with the family and here early 2011 a NAV 3.60 to NAV 2009 upgrade. With christmas time just a few weeks past, i think i - [Pinging the outside world, and updates on fellow bloggers](https://gotcal.com/index.php/2010/09/pinging-the-outside-world-and-updates-on-fellow-bloggers/) - Returning from vacation i was all ready to get back into the blogging. But as you know, returning from a vacation, there a usually a lot of loose ends to catch up on, so most of the first week went with that. Then traveling to Atlanta for a customer go-live, and back in Atlanta this - [Can't wait to get my hands on Dynamics NAV 2009 R2 with .NET Interop](https://gotcal.com/index.php/2010/10/cant-wait-to-get-my-hands-on-dynamics-nav-2009-r2-with-net-interop/) - Since the days of Visual Basic 6, where we were creating OCX (Custom Controls) for Navision, and up till now with COM Interop with .NET programming language, the .NET platform has become a great development platform. But because of the limitations of interoperability in NAV we haven't been able to use true .NET assemblies directly - [How to compare Records in Dynamics NAV?](https://gotcal.com/index.php/2010/10/how-to-compare-records-in-dynamics-nav/) - Last week while being onsite at a customers site, we suddenly needed the ability to compare 2 records to see if any changes were done to the data. We were using the Archive functionality for Purchase Headers, and due to some needed modifications (in the release function) we ended up storing a lot of versions - [Dynamics NAV RTC TAPI Integration without Office Communicator](https://gotcal.com/index.php/2010/10/dynamics-nav-rtc-tapi-integration-without-office-communicator/) - Today i learned that one of the requirements for having the small Phone icon (TAPI Integration) next to y0ur Phone No's in RTC, is depending on Microsoft Office Communicator to be installed. But my customer needed the TAPI integration, but doesn't use Office Communicator, instead they use a combination of Asterisk and ActivaTSP. First task - [How to track report usage in Dynamics NAV](https://gotcal.com/index.php/2010/06/how-to-track-report-usage-in-dynamics-nav/) - I was quoting an upgrade proposal for a client that had a lot of custom reports. Trying to identify which ones were actively being used today, the client did not have a definitive answer. So we needed an strategy to identify the reports that was being used. And at the same time we would like - [Read a random Dynamics NAV blog entry](https://gotcal.com/index.php/2010/07/read-a-random-dynamics-nav-blog-entry/) - Most of your hardcore blog-readers probably already have this link in your bookmarks, but for the pleasure of those that dont, i want to redirect you to this page of "NEXT = 0" author Ian Crocker (love the blog name :)): Read a random Dynamics NAV article Really a great little that links to the - [This message is not for C/AL programmers](https://gotcal.com/index.php/2010/05/this-message-is-not-for-cal-programmers-2/) - Oopsie, my old blog broke down due to some changes my web host was doing while migrating to new servers. Sometimes force majeure is a great way to start over and do things better, and that is our current goal here on GotCAL.com. We will revisit some of our old blog posts, along with new - [Saving filters in Dynamics NAV - Filter Selections: Practical usage of Rec.GETVIEW and Rec.SETVIEW. ](https://gotcal.com/index.php/2010/06/saving-filters-in-dynamics-nav-filter-selections-practical-usage-of-rec-getview-and-rec-setview/) - Over the years of working with NAV, users have always asked for ways to store their frequently used filters for reports and forms - eg. month end reports (A/R, A/P, Trial Balances), that often needs to be reported in multiple views. Most often the users have come up with a system of storing the filterstrings - [Dynamics NAV "How do I?" videos from MSDN](https://gotcal.com/index.php/2010/06/dynamics-nav-how-do-i-videos-from-msdn/) - I got a Google Alert today with some interesting news from MSDN. They are doing "How do I?" videos. They are meant to show you step-by-step instructions for Microsoft Products and Technologies. You can also subscribe to their RSS feed here: Dynamics NAV How do I? Take a look at these first videos for Dynamics - [SMTP Mail functionality in Pre Dynamics NAV 5 versions](https://gotcal.com/index.php/2010/06/smtp-mail-functionality-in-pre-dynamics-nav-5-version/) - Just a quick post here serving as shortcut for implementing Microsoft Navision Mail.SmtpMessage in older databases. All it requires is these objects: Table 409 SMTP Mail Form 409 SMTP Mail Codeunit 400 SMTP Mail And of course an updated license file for the customer, that adds the permissions for the new 5.0 objects. If they - [Evaluate Formulas in Dynamics NAV](https://gotcal.com/index.php/2010/06/evaluate-formulas-in-dynamics-nav-2/) - ERP software knows math, or do they? Dynamics NAV can do simple arithmetic in a decimal field, eg. type "14*50+10" and the system will evaluate this to the correct result "710". But if you start nesting your expression with parenthesis it gets a bit confused and tells you "Please specify a decimal or calculation expression". - [App-V streaming of Dynamics NAV RTC](https://gotcal.com/index.php/2010/05/app-v-streaming-of-dynamics-nav-rtc-2/) - Having seen the roadmap for Dynamics NAV, the next stop was the release of NAV 7 in 2011 - the follower to NAV 2009. But the breaking news from last weeks EMEA Directions conference in Prague, was the R2 release of NAV 2009 scheduled for Q42010 (see Waldo's post http://dynamicsuser.net/blogs/waldo/archive/2010/05/20/directions-emea-2010.aspx). Having worked with the "classic" ## Pages - [About](https://gotcal.com/index.php/about/) - About the author My name is Søren Nielsen and i am the author of this blog. I come from the land of Navision - Denmark, today i live in California working as a full time developer in southern California. I joined the Navision world back when cell phones had antennas: and social networks were maillists ## Categories - [Dynamics NAV](https://gotcal.com/index.php/category/navision/) - [Site news](https://gotcal.com/index.php/category/site-news/) - [Repost](https://gotcal.com/index.php/category/repost/) - [RTC](https://gotcal.com/index.php/category/rtc-2/) - [Basic C/AL](https://gotcal.com/index.php/category/basic-cal/) - [Toolbelt](https://gotcal.com/index.php/category/toolbelt-2/) - [.NET](https://gotcal.com/index.php/category/net/) - [Tips&Tricks](https://gotcal.com/index.php/category/tipstricks/) - [NAV Directions](https://gotcal.com/index.php/category/nav-directions/) ## Tags - [objects](https://gotcal.com/index.php/tag/objects/) - [license](https://gotcal.com/index.php/tag/license/) - [onenote](https://gotcal.com/index.php/tag/onenote/) - [blog](https://gotcal.com/index.php/tag/blog/) - [wordpress](https://gotcal.com/index.php/tag/wordpress/) - [report](https://gotcal.com/index.php/tag/report/) - [app-v](https://gotcal.com/index.php/tag/app-v/) - [virtualization](https://gotcal.com/index.php/tag/virtualization/) - [directions](https://gotcal.com/index.php/tag/directions/) - [rtc](https://gotcal.com/index.php/tag/rtc/) - [SaaS](https://gotcal.com/index.php/tag/saas/) - [sql](https://gotcal.com/index.php/tag/sql/) - [object](https://gotcal.com/index.php/tag/object/) - [ado](https://gotcal.com/index.php/tag/ado/) - [statistics](https://gotcal.com/index.php/tag/statistics/) - [upgrade](https://gotcal.com/index.php/tag/upgrade/) - [filter](https://gotcal.com/index.php/tag/filter/) - [how-to](https://gotcal.com/index.php/tag/how-to/) - [external](https://gotcal.com/index.php/tag/external/) - [video](https://gotcal.com/index.php/tag/video/) - [automation](https://gotcal.com/index.php/tag/automation/) - [formula](https://gotcal.com/index.php/tag/formula/) - [math](https://gotcal.com/index.php/tag/math/) - [script](https://gotcal.com/index.php/tag/script/) - [record link](https://gotcal.com/index.php/tag/record-link/) - [system table](https://gotcal.com/index.php/tag/system-table/) - [smtp](https://gotcal.com/index.php/tag/smtp/) - [application](https://gotcal.com/index.php/tag/application/) - [guide](https://gotcal.com/index.php/tag/guide/) - [programming](https://gotcal.com/index.php/tag/programming/) - [stylesheet](https://gotcal.com/index.php/tag/stylesheet/) - [tools](https://gotcal.com/index.php/tag/tools/) - [splash](https://gotcal.com/index.php/tag/splash/) - [vacation](https://gotcal.com/index.php/tag/vacation/) - [summer](https://gotcal.com/index.php/tag/summer/) - [sun](https://gotcal.com/index.php/tag/sun/) - [e-ship](https://gotcal.com/index.php/tag/e-ship/) - [downgrade](https://gotcal.com/index.php/tag/downgrade/) - [toolbelt](https://gotcal.com/index.php/tag/toolbelt/) - [POC](https://gotcal.com/index.php/tag/poc/) - [MenuSuite](https://gotcal.com/index.php/tag/menusuite/) - [cronus](https://gotcal.com/index.php/tag/cronus/) - [TAPI](https://gotcal.com/index.php/tag/tapi/) - [HTML](https://gotcal.com/index.php/tag/html/) - [RecordRef](https://gotcal.com/index.php/tag/recordref/) - [single instance](https://gotcal.com/index.php/tag/single-instance/) - [inconsistency](https://gotcal.com/index.php/tag/inconsistency/) - [GL Entry](https://gotcal.com/index.php/tag/gl-entry/) - [Community](https://gotcal.com/index.php/tag/community/) - [barcode](https://gotcal.com/index.php/tag/barcode/) - [pdf](https://gotcal.com/index.php/tag/pdf/) - [dataport](https://gotcal.com/index.php/tag/dataport/) - [R2](https://gotcal.com/index.php/tag/r2/) - [excel](https://gotcal.com/index.php/tag/excel/) - [Azure](https://gotcal.com/index.php/tag/azure/) - [nav](https://gotcal.com/index.php/tag/nav/) - [2011](https://gotcal.com/index.php/tag/2011/) - [orlando](https://gotcal.com/index.php/tag/orlando/) - [innovation](https://gotcal.com/index.php/tag/innovation/) - [award](https://gotcal.com/index.php/tag/award/) - [Dynamics NAV](https://gotcal.com/index.php/tag/navision/) - [.NET](https://gotcal.com/index.php/tag/net/)