-
Advising clients on using microsoft e-learning tools for NAV?
All- I have been searching and searching but to no avail. I need help with understanding the flow to get a new client started on using the NAV e-learning tools provided by microsoft. The navigation is very hard to understand and i cannot find anyway to assign courses to the client site admin. Please advise how I can get a…
-
Report Builder - Sum(Fields!Qty.Value * Fields!Price.Value) gives an error.
Hi All, I have query in reference to SQL Report Builder. I am trying to obtain the Total value using the below expression, but I am getting an #Error in the report. =Sum((Fields!MKG_Amt.Value) * (Fields!WeightQtyInvoiced_SalesInvoiceLine.Value)) Is their any way to resolve it in the report builder or should I have to…
-
How to use CDATA in a XMLPort
Suppose you have a XMLPort with a field that needs formatting, or it contains characters that would be invalid in an XML. For Example suppose you need to export a companyname "Cronus&Mibuso". This would only be possible by replacing the & with & OR you could use the CDATA option. But how? Maybe this is something already…
-
How to Merge customers Vendors, GL Accounts
Hello Here is an example on how to merge customers. This can be used and changed to merge vendors, GL accounts. The basic logic is this. CustA.get(A); CustA.Delete; CustB.get(B); CustB.rename(A); OBJECT Report 50044 Combine Customers{ OBJECT-PROPERTIES { Date=05/10/06; Time=[ 4:05:48 PM]; Modified=Yes; Version List=; }…
-
Finding the hidden fields in Visual Studio Reports - Example report 204
Hi, I have worked with the hidden field before when creating a report and connecting it with the header. However now I am going to change existing reports (204, 206 and 208). Lets take report 204 "Sales Quote" as an example. I can see the hidden field in visual studio. However I don't seem to be able to select it (seems to…
-
FREE Webinar: Smart Upgrade Options for Dynamics NAV
Does upgrading your customers’ NAV solutions distract you and your team from your core tasks - enhancing your solutions? Does your upgrade challenge seem to grow bigger and heavier with the more frequent, annual NAV releases? Join the webinar Smart Upgrade Options for Dynamics NAV and save time and effort by applying the…
-
Upgrading to NAV 2015 - some bonkers findings and some tips...
Hi All, I have spent a lot of time upgrading databases from NAV 2009 up to NAV 2015 and have found some findings and reviewed the Microsoft steps that you might find useful. I do not see these as documented by Microsoft, but such changes have helped us and can really speed up the upgrade process. I am referring…
-
Put error when user click print pdf, excel, or word and click open in excel in web client
how put error when user click print pdf, excel, or word and click open in excel in web client?
-
Migration Overview looses data after 1 day
Hello everybody, I am currently using NAV 6.0 R2 (6.00.32012) and have some troubles with the migration overview. When I import purchase prices with this tool and apply the data, it is listed in my purchase price table. But after one day the data is lost. It's only the data I was importing with the migration tool. When I…
-
Consuming Codeunits through SOAP
Hi All I have this problem in nav, when i publish a page to the web service using SOAP, i get an error when the message callback is sent by nav. I there a way where i can reply the message and continue execution in php .net
-
Need Help urgent
Hi all, I am trying to upgrade a db from NAV 2009 R2 to NAV 2013 R2. i had merged complied and all set to use the upgraded DB. But when i try to open my RTC client i get an error that "The following SQL error was unexpected. Invalid column name 'Credit'." I want help to solve this error. Awaiting reply eagerly....
-
Can you update a factbox from a subform?
I added code that calculates the Inventory on Hand at a certain location to the Sales Line Factbox. It works as expected, but I would like the factbox to update once the user enters the Item No. in the Sales Order Subform. It currently only updates once the line is selected. How can I update the factbox from the subform's…
-
Powershell & NAV Web Services
For me, it started off just to see if it was possible and to what extent I can use NAV Web Services in PowerShell. Here is an example to read, and update NAV. I published Page 5050 - Contact Card as a web service. Created an export for the list of Web Services, and export it to Settings.xml to use in my PowerShell script…
-
SELECT DISTINCT in C/AL
Hi all, This is maybe the biggest issue a C/AL Coder can face, and i've found lots of solutions some good some bad. This is how i do it and till now it is successful for me. in this code I want to SELECT DISTINCT "No." FROM Purchase Archive OBJECT Codeunit 50222 Test{ OBJECT-PROPERTIES { Date=05/14/11; Time=[ 4:22:54 PM];…
-
Closing Income Statement in NAV 2013 R2
Dear All, I have this problem. My client is using USD as additional reporting currency. but the problem is that he did this mistake that he mistakenly created some accounts into Balance sheet and then he changed them into income statement, taking into considerations that he has posted some entries before changing the…
-
Provide Check for Mandatory Fields
After struggling to find a succinct way to require certain fields on a card to be populated, I have come up with the following and it (so far) is working for me. I started to sense that NAV was not meant to have mandatory fields, but I need them for our business logic. Anyways, here we go... Step One: - We have a codeunit…
-
Extracting integers or decimals from a decimal value
Hi all, I'm sometimes stumbling in the different forums over the same question about how to extract the decimal places of a decimal value. There are some good solutions but if you take a closer look at the format function itself then you are getting a pretty nice solution for most of your request. 1) Extracting the decimal…
-
NAV autocorrects uppercase
Lets laugh together... Below two years I couldn`t even imagine that NAV IDE autoformats uppercase for system functions, object variables etc. (after saving and reopening object). And MANUALLY typed by best-practice, with all these shifts and capslocks. Feel my pain when I finally found it :o Maybe there is someone similar…
-
Easy unzip
Unzipping ZIP files in NAV from version 2009 is realy simple: Create function Paramaters: Var Name DataType Subtype Length No InFile Text No OutPath Text Create local variable: Name DataType Subtype Length ZipWorker DotNet System.IO.Compression.ZipFile.'System.IO.Compression.FileSystem, Version=4.0.0.0, Culture=neutral,…
-
Using ADO & Stored Procedures in C/SIDE
Source: my blog For a better edited version of this text I advice you to go to my blog. :wink: Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies. Furthermore, the companies were also spread over multiple databases. They wanted quick answers on questions like "What…
-
Multilingual NAV RDLC Reports: Labels vs Text Constants
Microsoft Dynamics NAV reports, starting from version 2013, contain multiple ways of storing captions and text constants to handle multilingual reports. There are certain types of reports which are printed cross-language. E.g., multiple sales invoices can be printed in several languages, depending on the customer they are…
-
color codes
Searching for an decent color but dont know the code? here are some codes i worked out for my project...hope this helps. 3268 - light magenta 32768 - green 255 - red 16711680 - dark blue 116687698 - light blue 165458 - light gren 5458 - brown 534458 - shade of red 90000 - light brown 50000825 - very light blue 50000890 -…
-
Autoimport fob objects
The company I'm working has more than 100 shops using Navision SQL client on localhost. We use MSMQ and Webservices to get online sales info but updates on Navision databases are very hard because we have to connect them through VNC clients and import fob objects manually. Finally I get the solution to autoimport fob…
-
UK - read HMRC Exchange rates from xml file on internet
Hi. This request from a customer turned out to be so simple I thought I would post it for all to use. The UK Tax authority , Her Majesty's Revenue & Customs (HMRC) publishes exchange rates to be used when reporting transactions in foreign currency on, for example, a VAT return. These rates are published in XML format.…
-
DBREINDEX or INDEXDEFRAG of a few indexes/window
I have a quite big database (150GB) that is running 24/24 7/7 with each day 2 windows of about 2 hours in which people are working little. So doing a complete indexrebuild during the weekend is not possible. The only option is the rebuild/defrag indexes is during those windows. Problem is:I can't do it on all tables…
-
Image processing, display online images, and google maps.
Some time ago i made a couple of posts in the forum concerning images. I wanted to display google maps whithin navision. Downloading them on the fly. This has proven to be quite difficult. First of al, navision cannot import an image from an URL, only from local drives. Next problem was that that the google maps images are…
-
In ML captions please use "fallback", "primary" languages
NAV works this way: if the current language is say DEA (German Austria) and there is no caption in this language, it falls back to DEU (German Germany) and if it still does not find one it falls back to ENU. But if the current language is DEU it does not fall back to DEA, it falls back to ENU. So there is a hierarchy of…
-
RapidStart Upgrade Tools
Check out why RapidStart Upgrade Tools simplifies your upgrade journey: http://www.1clickfactory.com/blog/posts ... ney/social Find out how Auto-Merge with RapidStart Tools work and how to make it the most useful for you: http://www.1clickfactory.com/blog/posts ... ols/social
-
Zetadocs: Failed to search for documents in Sharepoint
I wanted to use zetadocs on NAV 2013 R2. I already had a NAV 2015 zetadocs installation. On 2013 I was getting this error even though I had a Zetadocs Archive (not sharepoint) Turns out, if the zetadocs folder is from a newer zetadocs (v7.xx) and the fobs I had in the db was from an older installation (6.xx) it would give…
-
ADCS logging data btw. NAV2013 and VT100Plugin in 1 xml file
The VT100Plugin-Service has an option to output debug information (see here), but every transferred data package is stored in a single file (some with the extension .txt, some with .xml). So it is difficult to examine the traffic in all. To review a whole data session, I've written a function which outputs the incoming and…