Rashed Amini

| |

Using Enumerators in C/AL to iterate through files in a folder

Posted 1 month ago

by Rashed

Enumerators in .NET allow you to iterate through arrays and collections in your class. You can see this used for example in FOREACH Loop. Here is an example. DirectoryInfo di = new DirectoryInfo("c:\\temp"); FileInfo[] files = di.GetFiles("...
NAV 2013 Chart Add-in

Posted 2 months ago

by Rashed

NAV 2013 comes with a new Chart add-in. In NAV 2009 we had basic charts that are xml files that could be displayed on a page. In this blog I’ll show the steps required to build a basic Chart add-in. 1. Create a new Page of type CardPart. The source table...
How to remove Namespaces in XMLport in NAV 2013

Posted 5 months ago

by Rashed

MS in Dynamics NAV 5.0 created XMLPort datatype. It was a great tool to load xml files but it had trouble dealing with namespaces. MS released a workaround code for this that allowed removing all the namespaces of the xml file. The Code looked like this...
Upgrade from NAV 4.0 sp3 to NAV 2013 Beta

Posted 10 months ago

by Rashed

There are many clients that are still on an old version of Dynamics NAV and have not upgraded to 2009. Many of these clients decided to not invest in upgrading to a newer version because they didn’t see any value. I would agree with many of those customers...
Compressing Warehouse Entry in Dynamics NAV 2013

Posted 10 months ago

by Rashed

My last blog was about how to improve performance if you are NAV warehouse system. In my solution I used a sql script that summarizes the warehouse Entry table by Item,Variant,zone,bin,lot,serial,UOM and inserts the data into a new 50K range table and...
Compressing Warehouse Entry

Posted over 1 year ago

by Rashed

There have been many topics on compression/deleting subledger/ ledger in NAV. The table that I would like to talk about is the Warehouse Entry. If a location is setup with bins or zones, you can see entries recording every activity that has been performed...
NAV 2013 Beta Released

Posted over 1 year ago

by Rashed

Microsoft Today released on PartnerSource the beta release of NAV 2013. Here is the URL . It is released for the first 14 countries. I suggest to download it and start studying it.
Role Tailored Client Localization

Posted over 1 year ago

by Rashed

Recently I was asked to help with localization of Dynamics NAV for Korea. I was involved a couple of years ago with another project that we implemented in Korea and so I knew the process on how to localize NAV classic client. The project was on version...
Integrating with MSMS using dotNET data types in NAV 2009 R2

Posted over 2 years ago

by Rashed

With the release of NAV 2009 R2, we can now use dotNET data types. This allows CAL programmers to access .NET framework within CAL. There are many benefits on using dotNET data types as opposed to Automation data types. First is distribution of your CAL...
The Query returned no rows for the data set

Posted over 2 years ago

by Rashed

If you are using RTC and previewing certain reports you probably will run into this error. “An error occurred during local report processing.” The Hidden expression for the textbox ‘……’ contains an error: The query returned no rows for the data set. The...
Using ADO on RTC in NAV

Posted over 2 years ago

by Rashed

On one of my recent projects I had to build a solution to update a NAV table with quantity on hand by location. Writing a processing report to maintain update and maintain the table would have taken less than an hour. But for this project performance...
String Implementation in NAV

Posted over 2 years ago

by Rashed

If you have developed with any OCX or COM objects in Dynamics NAV, you have probably run into the following error. “The length of the text string exceeds the size of the string buffer.” The reason you would get this error is because you were passing a...
Downgrade 2009 sp1 objects into 5.x or older databases

Posted over 3 years ago

by Anonymous

Most of modification I do, I try to reuse them in other projects. I have built this generic integration objects that can be used in 80 % of the integration scenarios that NAV integrates with other systems. I’ve built it in 2009 sp1 and one of our clients...
Dynamics Add-in with WPF

Posted over 3 years ago

by Anonymous

I wrote previously about using WPF textbox for automatic spellchecking. In this blog, I will actually talk about a real WPF Visualization that I have been playing with for a while. I didn’t want to build a visualization from scratch, so I searched for...
Dynamics NAV Addin Example Large Button

Posted over 3 years ago

by Anonymous

Here is another example on how to create custom buttons in NAV and control events when they are pressed. In this example I’m actually using the WinForm Button controls and displaying them on a panel. When the button are pressed Nav code is triggered and...
Backing up/Transfering Company Specific Data through SQL for Dynamics NAV

Posted over 3 years ago

by Anonymous

Dynamics NAV client has a feature to backup and restore company specific. This process creates an (.fbk) file that contains just the data without indexes. The (.fbk) file can be used to restore in another database. For large database this is a slow process...
Automatic Spell Checker in Dynamics NAV

Posted over 3 years ago

by Anonymous

I saw some post on mibuso about asking for a spellchecker in Dynamics NAV. I thought it would be an interesting project to implement automatic spellchecking in NAV. I decided to implement it using Add-ins. After some googling, I found that I could use...
Replacing NAS with SQL Jobs and NAV Web service

Posted over 3 years ago

by Anonymous

Many companies, running Dynamics NAV, use NAS (Navision Application Server) to automate certain processes. Some companies use NAS to schedule to run many jobs at night. Others use it for integration where NAS periodically, using timer automation, checks...
Dynamics NAV 2009 Sp1 Client Add-ins

Posted over 3 years ago

by Anonymous

When Service Pack 1 was released for Dynamics NAV, it introduced a new feature: Add-ins. I had read the walk-through and was thinking of something useful to build that would utilize the Add-ins feature. Last week a salesperson emailed me and asked me...
Inventory Valuation in Dynamics NAV

Posted over 3 years ago

by Anonymous

One of the issues customers run into as their database gets bigger and bigger is that their reports take longer and longer to run. One of those reports is the Inventory Valuation report. I’ve always suggested customers to look at SQL reporting services...
Bing and Dynamics NAV

Posted over 3 years ago

by Anonymous

As some of you know MS has released new and rebranded search engine Bing. I really like their instant video search. The search results were pretty good. I search for VARIABLEACTIVE, and it showed MSDN documentation and that it no longer is supported in...
Faxing Reports from Dynamics NAV

Posted over 3 years ago

by Anonymous

I saw some question on mibuso forum on how to fax from Navision. This blog is about how to fax from Navision. This is method uses Microsoft Fax Services. You can use this to fax invoices etc to customers that prefer to receive Invoices by Fax. By default...
Dynamics Nav 2009 Sp1

Posted over 3 years ago

by Anonymous

I recently downloaded the CTP 2 for NAV 2009 NA version. There have many blogs on new features added. I wanted to talk about some of development changes. First change is that DBCS (Double Byte Character Set) is no longer part of fin.stx but rather part...
Encrypting Data in NAV using SQL with ADO

Posted over 4 years ago

by Anonymous

A lot of Dynamics NAV databases carry sensitive information that by law in some countries need to be encrypted. For example credit card number or social security number. There are many solutions available. The following solution utilizes SQL Server 2005...
Web service Proxy for NAV Web service

Posted over 4 years ago

by Anonymous

As many of you know Dynamics NAV 2009 is using windows authentication to allow any web services to be consumed. Currently Nav 2009 when it negotiates to negotiate it only uses Kerberos and doesn’t fall back on NTML. This creates connection issues...

Microsoft Dynamics NAV

About Rashed Amini