-
Change Log for records modified with a codeunit
1/ I made a codeunit to modify a record in a table with the function Record.MODIFY(TRUE); 2/ I added a setup in Chang Log setup to track al the modification in this table 3/ When I run the codeunit, nothing is added to the change log table, but when i change manually the record from the table, a change log is added. Any…
-
Get Word Layout from your classic report
You can get the Word layout from your classic report. 1. Transform your classic report to RDLC http://bit.ly/1uJOEk32. Save your RDLC report result to Word 3. Use created word document as Word layout template http://bit.ly/1uJOJUS Full blog post can be found here: http://bit.ly/1upIfZN. Paulius
-
Copy or Stream Word Documet into Email Body.
Hi guys, I've created a small tool that creates letters/word documents and attaches them as PDF on an email. However I want to give my users the ability to have the contents of the word document as the body of the email, but I can't wrap my head around how to do that. I am using: wdRange as 'Microsoft Word 12.0 Object…
-
Here is how to format XMLDOM output nicely
Gave me a hard time, so I thought I would share. If you don't do this, everything will be in one line... //Name DataType Subtype Length//Outs OutStream //F File //Reader Automation 'Microsoft XML, v6.0'.SAXXMLReader60 //Writer Automation 'Microsoft XML,…
-
How to solve this issue in Webservice?
Hi Friends, After publishing an Page in NAV, I gave the below URL in a browser. [url=http://]http://[/url]<Server>:7047/DynamicsNAV/WS/Nav_Company/Page/ItemTest I am getting this error. <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"> <s:Body> <s:Fault> <faultcode…
-
NAV RDLC Reports: How to Re-implement Page Number control
In NAV versions earlier than 2013, it was very common for Page Number Caption in reports to be developed as follows: 1. Text Constant was created (i.e. Text005 Page %1) 2. TextBox control with SourceExp STRSUBSTNO(Text005,FORMAT(CurrReport.PAGENO)) was added to Header Section In NAV versions starting from 2013 function…
-
NAV RDLC Reports: Using Dataset for Totaling Value Fields
I found out that seeing the Dataset of a report can be very helpful, because it shows all values for every Data Item‘s column in one table. Watch this video (https://www.youtube.com/watch?v=7-IpaGa6aCw) to see how the Dataset can be opened for reports in NAV. It‘s useful to export this table to Excel and, with the help of…
-
RDLC Report Designer tips collection
- Install that Web Developer Tools stuff for Visual Studio this gets you the following things: - can "Build Website" which tests for errors - Can go to View, Open With and open report in XML editor. This is very useful for 1) finding and extending Code.SetData 2) copy-pasting textboxes, because some bug does not let you…
-
How to compare dates with today's date?
Hi Friends, In a report I have declared 4 date variables dtA, dtB, dtC, dtD and assigning dates to these variables from 4 different tables. Case 1: For example: dtA = 25/08/2014 (from Vendor Ledger Entry) dtB = 01/09/2014 (from Purchase Header) dtC = 29/08/2014 (from Change Log Entry) dtD = 26/08/2014 (from Vendor - Last…
-
NAV 2013 R2: Bank Reconciliation
Dear All, I have uploaded a lumpsum amount as the opening balance in the Bank Account. Now I have the bank statement containing the cheques which were unpresented before the upload of opening balance, but included in this statement. How do I tackle this? Any idea? Best Regards, MMV
-
how to filter and mass update a set of records
Our department often gets requests from users: "Please, update this list of items with SOMECATEGORY" "Please, re-assign "Customer Posting Group" to SomeGroup, see attached file".. etc Usually, we solve this kind of requests by writing dataports or using Excel Import with mapping functionality, but these tasks takes more…
-
How to Format Duration Data Type
Hi. I struggled with this one a bit so when I found the answer I thought I would post it. -mostly so that when I forget I'll find it here to remind myself! The duration data type formats very nicely into words - MyDuration := (23.4 * 60000);MESSAGE(FORMAT(MyDuration)); gives a very nice "23 minutes 24 seconds". However, if…
-
The Power of......Batch Scripts!
Now, this may be common knowledge for all you veterans out there, but I didn't find too much information on the topic. Some of us may have loads and loads of documents/images/files outside of Navision that may need to be compiled or retrieved for other functions. For example, my company has loads of images that get…
-
Custom Progress Bars
I wrote a blog post about how to create custom progress bars in NAV: http://www.olofsimren.com/custom-progre ... v-2013-r2/ If you ever need to do something like the attached picture (or even cooler 8) ).
-
Export to Excel with Performance
So I'm not too sure what all is capable in NAV 5.0 regarding Excel. But this is a little something I managed to do with 4.0, so I thought I'd share. :D (If there is a better way, or simply if there is a way to pass an array to the excel Automation that I missed, please let me know.) The idea is to pass an array of data…
-
FIELDERROR sales line dsc% is <> Job planning line dsc%
Hi, I have a little problem with posting order. In Job planning i have dsc% with 2 decimal places but in sales line is 4 decimal places. In CU 1001 is field error: "IF SalesLine."Line Discount %" <> JobPlanningLine."Line Discount %" THEN SalesLine.FIELDERROR("Line Discount %",Txt);" To post i added printscreen of the…
-
How to get the path of the RoleTailored Client
Hi i know it's easy to get the path of the Classic Client with APPLICATIONPATH. But if you use this with RTC it returns the path of the Service-Tier. So how to get the path of the client?
-
Dynamics NAV - Learn - How Do I Video Series
How Do I Video SeriesHow Do I: Successfully Configure Outlook Synchronization with NAV 2009 SP1How Do I: Warranty Lots In Warehouse Management with NAV 2009 SP1How Do I: Revaluation Journal Process for Inventory in NAV 2009 SP1How Do I: Use Exact Cost Reversal with Dynamics NAV SP1How Do I: Use Expiration Lots in Warehouse…
-
.net interop for a better NAV, barcodes in RDLC
I wrote a blogpost showing you how to add barcodes to a rdlc report without the use of barcode fonts. http://www.erpfood.nl/2014/01/net-interop-for-a-better-nav-barcodes-in-rdlc/
-
Excel only allows upto 65000 rows error resolved in NAV 2013
When you run Analysis by dimension report & try to export the data in excel using the standard function & if the data is very large you get the error. Error Message:- "There are 65000 rows within the filter. Excel only allows up to 65000 rows". Now the error has been resolved from NAV 2013 onwards. Now when you use the…
-
Automated Keystokes
Hi, I am looking for some sort of a list that contains all the keystrokes in NAV. By Keystrokes I mean automated e.g. By running the following code you automatically close NAV : CREATE(lvWinShell); lvWinShell.SendKeys('%{F4}'); % = Crtl I am looking for the "ALT" Keystroke particularly. Thank you in advance.
-
Tip #20 - Save Report Usage
This is a hot subject for a lot of companies using Navision. When was a report last executed, by whom and how many times. The classic solution for this is to add code to every report to store this information in a table. But it can be solved more generic... The solution is in Codeunit 1. Here is a trigger FindPrinter that…
-
Report - Horizontal Columns using arrays
REPORT USING ARRAYS TO CREATE HORIZONTAL COLUMNS 2 Arrays with Dimension 12: MonthLabel SalesMthTotal ** Customer down the left with Sales Total by month along the top ** Customer - OnPreDataItem()//MESSAGE(FORMAT(CALCDATE('CM + 1D - 1M',150600D))); //TESTING//MESSAGE(FORMAT(CALCDATE('CM',TODAY))); //TESTING//Header…
-
How to build a NAV 2013 report using a query object
Much to my disappointment, I discovered that reports did not allow using query as a data item. So I started thinking on how to get around it. Then I remembered our old friend, the integer table. If you build a report using the integer as the data item, you can then build code to process a query one row at a time for each…
-
How to run SQL code in the same transaction as the Nav
Sometimes we have to use SQL in Nav for different actions including data modification. For example, we have to call a stored procedure to update a web-order status after release a sales order. Unfortunately, there are no way to run the stored procedure in a same transaction as a sales order released by using ADO. Different…
-
Show remaining time with a progress bar
I have further updated this code so that the time remaining is properly shown in a Minute:Seconds format I took the time to put it into a codeunit, so hopefully it will be moved into the tips and tricks section where others can benefit from it. I attached my codeunit, and I also attached my example usage of it. Let me know…
-
Running SMTP component from NAV 5.0 in older versions
This procedure explains how to run SMTP component from NAV 5.0 in older versions. This was tested in Navision 4.0 SP3. Not all countries had NAV 5.0 a localized release. If you don’t want this manual procedure of registering components you could also install NAV 5.0 client in same computer you are running NAV 4.0 SP3.…
-
Page Web Service with User Authentication
Hi all, Since mibuso's been such a huge help to me in the past, I want to share my recent NAV-solution with you guys. What I wanted was to publish a page as a web service from NAV, but I wanted to have user-authentication. NAV didn't provide a reasonable way to do this, and on the other hand I wanted to let specific users…
-
Table vs. Query | Performance Battle
Queries have two advantages when it comes to reading performance that tables don’t have. First you can limit the amount of data you retrieve from the server by defining only the specific columns you need and second you can join multiple tables into one query saving noumerous roundtrips to the server with our good old…
-
CaptionML with Language=Comment
Good morning, I just found something very interesting today: Did you know that you can create Comments in CaptionML? I found this when I merged some objects: @=WIP GUILDFORD, 10 CR;ENU=WIP %1'; @? I checked in the GUI and: You can enter this "Comment" in the Language field but you can choose it from the list VERY WEIRD…