-
Automatic select rows NAV 2013 R2
Hi all, Iam new on this forum, do you have idea how can i make automatic select rows ? User select one row in Page1 and some rows automaticly select in Page2 row based on some condition
-
Calculate date.
Hello. Im new to Navi and i have a question: How do i calculate date så every time i add a number it will print the same line X times with different date I will use it when an employee is sick for 5 days, i should be able to print out new line for each day employee is sick. example: StartDate: 01/01/2016 I want to add 5…
-
Set Control ID Range for forms
If you add a textbox, the ID for that control starts at 1 billion. Is there a way to change this to a different number range? I just want to be able to identify my changes by maybe going another 50000 higher or something. So not a big deal if it can't be done programatically. Just curious... From what I see this only…
-
Proper use of the Documentation() function?
In customizing some of our objects and seeing how some of our third party apps document their code, I was wondering if there is a proper way to use the Documentation() function found in the C/AL code of objects. What I've been doing is adding something like this:MYCOMPANY1.0 MyInitials change made to the code
MYCOMPANY1.1…
-
DotNet DataType Unable to create Instance
Hello Guys, I created a DLL using C# with .Net framework 4.0 and I have also deployed it in the add-ins folder on both client and server folder. However, it still prompts me the message "Cannot create an instance of the following .Net Framework. . ." (Please see the image). What am I missing? I am using Microsoft Dynamics…
-
Initvalue day of the week
Hello, I would like to set a table field as todays day of the week, how do I do that?
-
XML get elements with same name
In CAL NAV2013, I want to get all elements with the same name (in this case codMsg and txtMsg). At the moment I'm trying only with the codMsg. Example XML nodes:<alerta> <actCount> <num>0001</num> <tipo>3</tipo> </actCount> <codMsg>ae11</codMsg> <txtMsg>description11</txtMsg> <codMsg>ae12</codMsg>…
-
Creating a sub form for lines
Hello, I am trying to find information on how to create a page with a subform. So headers at the top in the form of a card page and a list page at the bottom with the lines, the data comes from two tables. Its like the sales order page with the header at the top and the lines at the bottom. How do I create a subpage or…
-
When exported to excel template, template layout changes?!
Hi guys. I created processing only report that exports my document to excel template (attachment "1.xls"). But when it exporst, it completely changes my template (atachment "2.xls"). Not only does it spread this excel file to 2 pages in excel, but it also removes borders and field coulouring. Latter 2 i do not mind so…
-
Codeunit Execution
Good Day Folks, I'm new here. I'd like to ask about the execution of the Codeunit in Dynamics NAV. When I create a codeunit, does all the clients connected to it execute these codeunits on their terminal or on server side? Is there a way to set the execution mode of the codeunit to the server side only? Looking forward for…
-
retrieve data model
Is there a tool that can import objects/txt-exported file structure, to show the data model of NAV?
-
Web service - OData option field
Hello, we have an external program, that is communicating with navision through OData webservice. We have a problem while trying to create a comment record, where we have to define the "table data" field which is an option field. This is the payload that we send:{ "Table_Name": "Vendor", "Line_No": "2", "No": "S00001" }…
-
"Position: Absolute" in VS Report builder
Is it possible to create a text box that does not affect other boxes when made visible. What I have: Invisible text box. The page looks normal. Visible text box. Everything gets pushed down, and looks wrong. What I want: Invisible text box. The page looks normal. Visible text box . Everything stays in place, and the text…
-
Filtering data on form using OnFindRecord and OnNextRecord
Filtering data on the form by “virtual” fields using OnFindRecord and OnNextRecord triggers Purpose of this publication is to describe opportunity of filtering data on the form by “virtual” fields using OnFindRecord and OnNextRecord triggers. You can find many solutions of this problem on many forums on the Internet, but…
-
How to implement Transheader and Transfooter into arbitrary Wordlayout
Many have come to the conclusion, that this is impossible, but finally, I found a way... https://massivedynamicsblog.wordpress.com/2016/09/22/how-to-implement-carryover-in-wordlayout-reports/
-
Page header/footer in NAV 2016 Reports
Hi, my question is if it's possible to hide/show page header/footer dinamicly. I should migrate report from NAV 2009 to NAV 2016. The report is 206 (Sales Invoice). After printing all copies of the invoice they printed some additional information about Sales Shipment. In this last page, I don't want to show page…
-
What object locked the table?
Hello guru, NAV 2009 I have a problem, in our logs I'm frequently see that something is locking tables. I want to found out what object does that. first, I made a simple codeunit which uses : MyTable.LOCKTABLE; MyTable.FINDFIRST; SLEEP(30*1000); MyTable."Version No." += 1; MyTable.MODIFY; SLEEP(30*1000); I have made a lock…
-
How to get nested repeaters and dynamic formatting started in Wordlayout+
Some features are painfully missed in NAV Wordlayout reporting. But now there is a way to get all those things work, like for example:* Nested Repeaters around more table rows or whole tables and/or paragraphs * Correct handling and dynamical sizing of images * Manual line breaks within plain text or rich text controls *…
-
how do I check for a fieldvalue before the user has left the record in a page ?
NAV is new to me :) I have a field that I want to check before the user leave the record. the field must not be empty. I have tried with Error('something') but without look.
-
Report Navision 2009 R2
Hello, Good day. I'm a newbie developer here in navision. I have this problem that everytime I put anything even a label in SECTION then show it in layout but it doesn't show anything in runtime. anyone can help me ? thanks in advance.. have a nice day a head.
-
how I can get delivery date in sales order form
When I add a new field in sales order form as a name delivery date how I can get delivery date when I click on post button
-
TABLE 204 (Unit of Measure)
Good day, I'm still a newbie developer in Microsoft Dynamics Nav, My problem is: I want to add a column in table 204 but every time I want to save it, it says my program license not allow me to create the Column I want to add. but the irony is, im using developers license. can somebody have any idea about it ? thanks in…
-
Json reader - google maps api
Hello, I am looking for a solution on how ro read the json response i get from the google maps api. I want to send address information to the api, and based on the response i get in the status field, then I know if the address is valid or not. this is a response I recieve from a non valid address:{ "geocoded_waypoints" : […
-
Sending other documents as pdf
Sales Invoices , sales credit notes etc have nice feature which allows user to send email as attached as pdf but purchase documents are attached as html. How I can have the purchase documents attached as PDF as well? I am using NAV 2016, please help
-
Table Relation Filter depends on another column
Godd day, I need help, im a newbie in development here in navision, My problem is, I want to show All Data in one column from another table but the data depends on what I choose in one of the columns in the same page. See attach Photo. Please, I badly need help. Godbless
-
When I run a setup in Microsoft dynamic NAV 2013 R2, so this type of error generate!!
Hello, Everyone When I run a setup in Microsoft dynamic NAV 2013 R2, so this type of error generate .. plz give a solution....
-
How to save Navision Reports as PDF
Hello There are a lot of topics on creating pdf documents from Navision reports. Here is an example on how to do it. There are a lot of windows pdf printers out there. The one I've used is a free open source version. To use this example please do the following. Go to sourceforge.net and download PDFCreator Here is a direct…
-
How to rotate an image in a report
Hi everybody, I need to rotate an image, in my case is a barcode. I tried to create the following function in Custom Code section into the report:Public Sub RotateFlip ( rotateFlipType As System.Drawing.RotateFlipType ) End Sub Dim PictureBox As System.Windows.Forms.PictureBox Public Function RotateImage(ByVal Barcode As…
-
Logging Report Version and Changed Flag
Hey Guys, is there a way to log the Versionoverview and the Changed-Flag of a Running-Report? I already got this: https://blogs.msdn.microsoft.com/nav/2011/06/23/updated-how-to-log-report-usage/ this is a nice way to log the used Reports. You can still differentiate betwenn RTC and Classic-Client Reports. But is it…
-
trick to send multiple attachments with mail codeunit
I have found a trick to send multiple attachments with the standard mail codeunit (397). The only thing you need to do is to create and send a new message to a non existing mailaccount and attach the first attachment. You can repeat this step to add more attachments. Then you create a final mail to the right mailaccount…