-
How to check the number of the cumulative update that is installed
Hello, is there a way to check the number of the cumulative update that is installed as for the navision version (About microsoft Dynamics Nav) ? ( version Navision 2018) Thank you.
-
This is a Test
This is a Test
-
Not able to edit transaction in web client business central
I am not able edit the transaction like edit a value in field in one company but the same company's field is editable when i use RTC, it works well in other companies on web client issue only in one company. Thanks in advance.
-
Filter on Customer Table with Fields from Customer 2
Hi, maybe someone have an Idea how to use this problem: I created a Table "Customer 2" (PK: Cust No (of Course)). In this table I added different Fields and show this Fields in the customer list (Page 22). Now I want to Filter on this fields. It unfortunately does not work because I have two different source Tables. I…
-
Create note - Record Link formatting problem when saving
With the same code and only changing the text it produces different results procedure FillNote() var Customer: Record Customer; RecordLink: Record "Record Link"; outStr: OutStream; MyInStream: InStream; begin Customer.GET('00000006'); Clear(RecordLink); RecordLink.Init(); RecordLink."Record ID" := Customer.RecordId();…
-
How to set permission to a field (super user)
Hello, Using Nav 2018, I'm trying to assign a field to be modified and edited by only super users. Not editable by other users Can you please share with me the code of how I can do this. Thank you in advance.
-
Report usign vs Code
I will design a Report in vs code, But i will like to know hwre to add the SETCURRENT KEY command. This is an example dataset { dataitem("Proyeccion Matteriales ";"Proyeccion Matteriales ") { DataItemTableView = sorting("Item No.") WHERE (Tipo = FILTER('PROYECCION REPORTE'));
-
The G/L Entry already exists. Identification fields and value:
Dear Friends, I am getting this error in NAV 2016 India database while trying to apply a payment to purchase invoice. The GL Entry No. in the Error is sometimes the 2nd last entry in the system or the next available entry number. Any idea why? Thanks Vineeth
-
Creating a second docker container for NAV2018
Hi, I have a BC 2020 wave 1 sandbox container up and running in my local docker. I would like to create another container for NAV2018. May I know what parameter I should specify so that the new container gets a different IP and it won't get messed up with my BC container?. I am using the following script to create the…
-
G/L description to contain same text as Invoice Line ?
Hello There, i want to change the description of the G/L Entry , when i post the purchase invoice i want to post the Purchase line description to the G/L Entry instead of "Posting Description". Working on Nav 2018
-
G/L description to contain same text as Invoice Line
I have a client that wants the following customization: - When the user posts an Invoice he inputs a particular description in the Invoice line. - When the invoice is posted and the user goes to 'Navigate' and chooses to see G/L entries, in the description field there is something like 'Invoice SIV07000010'. - This client…
-
NAS suddenly stopped using events
Hi folks I have a strange problem in Dynamics NAV 2018 CU27 (11.0.41203.0) until june 11 it worked as supposed but after that... We have (from a ISV) configured a separate instance that are running a special codeunit (cod123456), startupMethod = NAShandler and a startupparameter. for the selected parameter a second…
-
Find Engine
Hi Mibuso.com World :) ! In the Dev Environment - Object Designer - Find Functionality.... If I have Find as you Type switched on - I can find an Object one character at a time. So in my screenshot, typed in 'sta' and it has automatically found the Standard Text Table without adding an Enter Option or Pressing the Find…
-
Guaranteed run of code when record is inserted (invoice is posted)
I'm working on a legacy system (Nav 4.03). When sales invoices are posted, I need to make sure that certain code runs, regardless of what exactly triggers the posting of the invoice. I used to be able to handle this, having a place in the posting routine that would surely ALWAYS run during the posting of an invoice. But as…
-
Preferred connection cache hit rate very low
Hi The preferred connection cache hit rate on our NAV 2015 application server is very low. The data cache size on the service is 12, so 4GB cache for around 45 ursers. Our application server and sql server are both VM's hosted on a onprem VxRail. Any idea how we can improve this rate?
-
Create report to get/track the users who have login the NAV in Particular time(Jan 2020 to June 20).
Hi Everyone, Is it possible to track the user by report that who have(Or how many user) login the NAV in particular time eg. from Jan 2020 to June 2020. If it is then how can i proceed. please guide for the above query. Regards, Mani.
-
How to use "System.Runtime.Extensions" in C/AL
Hi I need some Math expresions, but when I try to create a "Math" variable I cant access the Math expresions - as no method list are visibe when opening the System.runtime.extensions.dll Somebody knows what is wrong?
-
Workflow User Group
Hi, We have setup a workflow user group where we added four users to the group, all with sequence 1. This now means that when the document is sent for approval any one of the four users can approve the document and it is then released. It does not have to be approved by all four users. I changed the Workflow step instance…
-
Document approval release before reaching the approver
hi i have problem with document approval in nav 2009, the system is releasing the document before reaching the approver
-
Date format DDMMYYYY and use as Date data type
I need to format the date into DDMMYYY. But want to use as Date, not a text. This gives me correct formate FORMAT(TODAY,0,'<Day,2>/<Month,2>/<Year4>'); but want to assign to date, when used EVALUATE again my date become DDMMYY. I am using RecRef therefore need to use same date formate IF (TableID = 271) AND…
-
Warehouse recepit from Transfer order
Good morning, I have an issue creating the warehouse recepit from Transfer Order action ribbon: once filled in all the required fields and clicking on the "warehouse receipt " button, any window opens, while clicking on the "warehouse shipment" button works perfectly. Could it depend on the Locations settings? Am I doing…
-
Insert data to MySQL-Server with assembly MySql.Data ADO.NET
Hello, I want to write data to a MySQL-Database with C/AL and assembly MySql.Data. This code works very fine: ... ADOMySQLCommand.CommandText := 'INSERT INTO t_ado VALUES(NULL,@PLZ)'; ADOMySQLCommand.Prepare(); ADOMySQLCommand.Parameters.AddWithValue('@PLZ', '99999'); ADOMySQLCommand.ExecuteNonQuery(); ... The code above…
-
records from 2 tables shown in 1 page
Hello everyone, Can anyone tell me if it is possible to make a temporary page with records from 2 different tables? And if so, how to do this? If it is not possible to do this, does anyone have a good idea too get records from 2 different tables into 1 page. My best idea is to use a temporary page or table, but I don't…
-
Can i catch error message without "GETLASTERRORTEXT" ?
I would like to track every error message and time of error message and save result into my table without GETLASTERRORTEXT, Can i do it?
-
Deserialize Json as an array/list of results
Hi, I am trying to call a Rest web service, which returns response in the form of a json "Result": [ {"id":"1", "firstname":"xyz"}, {"id":"2", "firstname":"abc"} ] I have created a dotnet dll and imported it into navision. I use the ApiResult := JsonConvert.DeserializeObject(Json,GETDOTNETTYPE(ApiResult)); to deserialize…
-
Adding global variables on a request form of a report
I have a report which uses 15 global variables, already initialized on the OnPreReport trigger. I need users to be able to change their pre-determined values on launching the report. I would thus like to add thoses 15 global variables on the request form. Sure, I can manually add 15 checkboxes/textboxes + 15 labels then…
-
How to catch changing of the variable?
Is it possible to realize smth like: IF (value changed) then ...
-
Report output is .CSV if you file the file it appears to be garbage
I have a NAV report (2017 on-Prem) that is set to save to a CSV file and placed on a seperate server from the NAV servers. When I run it manually it is fine. When we run the code unit that was created to run the Report the output looks like garbage. Towards the top of this garbage I have found the below bit of info that I…
-
SAVEASEXCEL in old format
Hi there I have client which is working on Dynamics NAV 2017. There is one function which is creating one of the reports in excel and send on their customer e-mail. The problem starts when some of the customers use old xls formats and they can open only xls formats. When I'm using SAVEASEXCEL function the format by default…
-
How to prevent closing the page after error?
Why page is closing after error and how to prevent this scenario?