-
SET DATA and GET DATA Function issue
hello Experts, I am using Navision 2013 R2 , I want to use SET and GET function in my Report, can anyone explain its Syntax and how to use , step by step.
-
FieldRef.TYPE webservice language <> En-Us
Hey guys, Quick question. The scenario: my webservice language is different from en-us (e.g. Finnish). In case of Type = Option(en-us), will the function FieldRef.TYPE return "Vaihtoehto"(Fin) or "Option"? Thanks in advance
-
"The metadata object Page 0 was not found."
In My customer card i click on Balance it's showing me error " The metadata object Page 0 was not found." In same table i have created new filed like existing Balance filed and it's working fine , but standard one is not working . why this happening ,i am not able to found out reason, i had compile all objects and check…
-
Tutorials on making of Reports in Microsoft Dynamics Nav 2016
Can anybody suggest some links related to tutorials on making of reports in Microsoft Dynamics Nav 2016?
-
Automated Dynamics NAV upgrade tools can save Dynamics partners time and money
In Simplanova new blog post, we will go deeper into Dynamics NAV upgrading challenges and the opportunities that automated Dynamics NAV upgrade tools offer. Enjoy the reading - Automated Dynamics NAV upgrade tools can save Dynamics partners time and money! Sincerely Ieva, Simplanova
-
Searching form
Hello. I'm new to NAV. Working from one week with NAV 2009. Can someone recommend me resources for creating a search filter in Forms.
-
Lab environment NAV 2016
Hi Guys, I want to do some test with NAV 2016. Currently we running NAV 2013 R2. Is it possible to have a licence to test all the new feature in a lab environement ? Thanks,
-
Is it possible to overwrite the limited table accessible by a client license?
Hi guys, I just want to know, is it possible to overwrite the limited table accessible by a client license? for example the client license can only access 10 customized tables, what if the customized tables exceed like, 15 tables. is there a way to edit the license to access the remaining 5 tables?
-
Index with ascending and descending fields
I want to create an index with 2 ascending fields and 1 descending field. Is this possible?
-
free space on page in visual studio reporting
Where Can I remove free space on bottom of page. I tried with report padding but nothing changes
-
Can I pass data from page to report?
I need to pass employeeId from page type card to report that is placed on ribon of that page
-
how disable button print pdf, word and excel in navision 2015?
how disable button print pdf, word and excel in navision 2015?
-
Can I make fasttab open by default?
I want to make fast tab containing picture to stay always open, it doesn't have any functionalities, just showing picture.
-
Cancel Button on the StandardDialog Page
Hi everyone! I faced with a problem: when I press a Cancel button on the StandardDialog Page I cannot understand what exactly action occurs. A breakpoint settled in the OnClose trigger doesn't work in this case as well as in the OnQueryClosePage trigger. Please, help me to find the trigger for this button. Thank you in…
-
Removing all usage of DotNet
Does somebody know or have some tips how to map all customized objects that use dotnet? Reason for this is converting code to AL. Thanks in advance!
-
How to merge PDF files using dotnet
Sometimes one needs to merge multiple PDF-files to one PDF file, e.g. to send it by email to your customer. This is how it could be done using dotnet and the PdfSharp.dll as an add-in (get it here) Two functions, MergePDFFiles and a local function AddPages function MergePDFFiles(PDFFile1 : Text;PDFFile2 : Text;NewPDFFile :…
-
Remove zero before exporting to Excel.
Hello everyone. Like the title says, how does i remove zero/blank lines before insert into excel. If you see the picture with test data, zero amounts in the column "budget amount"(column 3, from left) appearing many times. I want the accounts who has zero in budget amount not to be exportet into excel, by using a boolean…
-
How to solve problem with datediff function when sending datetime difference to navision from sql?
Datediff function returns miliseconds as unit no metter what are you calculating (day, hour... difference)
-
How to send SQL data type datetime to Navision fild (also datetime)?
When I do this Navision send me error that date is not correct. Also when I send datetime from NAV , SQL only receives date part and zeros instead of time.
-
Why can't I rename item no??
Hello. Why can't I rename the Item No. from 1000 to 1000x? If I change the number to 10001 its okay, but if I use string character (1000s), then its gives me error. I have debugged but didn't help. I use navision: 2017 The error:
-
Programmer Challenging Lookup
I'm trying to allow my user to dynamic lookup ability based on which table ID (table object) they select in the previous form. So the process would be create a record in Table 1: No., Description and table id (object table #) Table 2: Code, Name, etc I want the system to dynamically look at table 1 (table id field) and…
-
Calculator buttons Client Control Add-In Navision
Hi, I am trying to build a control add-in for NAV where I can have a basic calculator keyboard. I found this tutorial, I managed to see in Nav Client the actual page with the red buttons but nothing happens when I press a button.…
-
Three Things a Successful Microsoft Dynamics NAV Partner should focus on
Enjoy Simplanova new blog post - Three Things a Successful Microsoft Dynamics NAV Partner should focus on hope You will find useful information
-
Return multiple text lines into report
I am trying to use the "FIND" command to retrieve multiple comment lines, but I can only seem to get the first record: CLEAR(Comment_Line); Comment_Line.SETFILTER("No.", "Service Shipment Header"."Order No."); Comment_Line.SETRANGE(Type,2); IF Comment_Line.FIND('-') THEN BEGIN Fault_1 := Comment_Line.Comment; REPEAT UNTIL…
-
Find First 5 Posting Date of Customer
Hi Experts; I am Using Nav2013 , I want to Write Code For Finding First 5 Posting Date of Customer From Table Customer . Regards.
-
Using Navision 2015 Report Text Box Properties
I want to highlight the field under the FILL tab in Text Box Properties on a Navision 2015 report, if the field is a quantity field, and the value of the field is "0". I know I can highlight every other row using: =IIF(RowNumber(Nothing) Mod 2,"#efefef","White")
-
How to Add Current Date in Report
hello to all, i am using microsoft dynamics navision 2013 r2 as a technical . i want to know that how can i add current date at the beginning in report . i will wait for your suggestions . Regards.
-
How can I add unsupported language to Microsoft Dynamic Nav 2016 Client
Hello I'm new on this forum and I really need you help. I want to add polish lanuguage to Microsoft Dynamics Nav 2016 Client. I already check tens of sites but I dont find the solutions. (They demand to use unsupported toolkit etc.). I translate the CaptionML.
-
Import dataport and skipping the header line
Problem:you have a textfile with headers and you must import it with a dataport, but you want to skip the header line, because otherwise you get an error. How to do that? Put some code in trigger "OnPreDataItem()": (variable "cha" is CHAR)IF CurrDataport.IMPORT THEN BEGIN REPEAT CurrFile.READ(cha); UNTIL cha = 10; // of…
-
NAV Web service in Wordpress
Has anyone used web services, from Navision, in Wordpress ?