-
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();…
-
MBS Nav 2018 cu23 - Role Center starting page is empty
Hello all, I have created a database of MBS Nav 2018 cu23 with alot of customizations. When the database has no users, when I enter the rtc I see all menus and can search and find any object (in the search text box at the upper right corner). If I create a User and re-open the rtc client, the starting page is empty, and…
-
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.
-
Save XML to Sharepoint
Dear Friends, I need to save my XMLPort output to a SharePoint location. Can anyone give some hints, sample codes to achive this in Business Central CAL code? Thanks vineeth
-
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…
-
Setting Password on Files
Hello, is there any way to set password on some PDF files created from C/AL code, without any external DLLs? For example, I want to do something like Report.SAVEAS, but in addition I want that PDF file to be protected by a password and I cannot use any external dll, only standard C/AL methods. Thanks in advance. Cheers
-
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?
-
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…
-
Error accessing Website Microsoft Dynamics NAV 2015 Web Client
Dear Friends Recently we configured 3 tier architecture (NAVSERVER, SQLSERVER & IIS Server on separate machines). As per Microsoft documentation SPN registered & delegation setup done. SPN setspn - l domain\serviceaccount ServerInstance/navserver:7046 ServerInsatnce/navserver.domain.com:7046 Delegation DynamicsNAV…
-
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
-
Visual studio Code
Hi I am new in Navision NAV BC. I have installed Navision BC and Visual Studio Code on my mashine. So what now? I got this error. How can I solve this? /Javaid
-
D365 16.2.. upgrade?
Hi all, I want to upgrade from D365 13.0. to D365 16.2. Do you think this is easy and like cumulative updates or is it more complicated? Also is it possible? I downloaded it but I couldnt see any windows app? Is it only web based?
-
Document Date change when Posting Date changes?
Hi guys, I want to update this so that when posting date changes it doesnt change the document date. I debugged that for quite long time, but couldnt see exatly where it does that, as it's not something like x.docdate := y.postingdate Ideas?
-
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.
-
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?
-
Postman - write data in NAV using APIs (ISSUE)
Hi, i use POST method to write some data in NAV using APIs and everything was fine until i have changed ID of the destination table cause in the meanwhile that ID was taken in client's database. When i make the call ,request sees the old table ID and the problem is that table ID Destination is now different. i restarted…
-
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…
-
How to catch changing of the variable?
Is it possible to realize smth like: IF (value changed) then ...
-
Open Excel File Saved by reporting services, on BC14
Good Morning I can't open Excel files saved in xlsx format from Reporting services, it gives the attached error ExcelBuffer.OpenBook fails If I open the file manually with Excel and save it in xlsx format then the OpenBook does not give an error Anyone know if something can be done? Thanks in Advance
-
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…
-
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…
-
Pictures and Labels
Hi Mibuso.com World :) ! Is it possible on a Label Report (NAV 2018) to have an Image side by side? In NAV 2009 Reports they lived together no problems... But converting to NAV 2018 they're being pushed to the right? Thanks for your help :) !
-
NAV2018 System Tables modification
hello I am running a NAV2018 database with side-by-side development. I added a boolean field in the Company table through c/side (since these cannot be extended through Extensions). However when I am referencing to it through an extension, it is not visible. I've already generated symbols and tried with different tables,…
-
CSV file from a Report
I am trying to develop a report that the End User can initiate so that the Check Ledger Entry table is sorted by Check Date. I have all of my columns needed by the Bank, and I have been able to get all of the data exactly the way I want it. The issue I am having is I cannot figure out how to get the code written to export…
-
How to check if table is locked or not.
Dear All, Is there a way to find whether a table is locked before doing any update operation on it? For eg before I go on updating the records in the Table MyREC, I would like to know before hand whether the table is locked or not IF MyREC.FINDSET(TRUE, FALSE) THEN REPEAT ...... UNTIL MyREC.NEXT = 0 Thanks.
-
Open a Sales invoice page when open a database
Hi everyone, I need to open a sales invoice page automatically when i open a database from file database open. Please suggest me some answer Thanks in Advance
-
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.
-
Data Exchange Transformation Rule
Hello All, Setting up a Data Exchange Definition two transformation rules do not seem to work. Initially I want to remove - from the Bank Account Sort Code for example 20-55-77 should be set to 205577. Please can someone review the setup and give any suggestions to correct it. When I do a Test on the transformation rule it…
-
Blog Series Part 10: Automize process for Sales Transaction in MSDYN365BC
Hi Readers, I am sure you might be able to create the functionality in below mentioned blog.If you have not seen my previous blogs I have mentioned the links Continue reading Blog Series Part 10: Automize process for Sales Transaction in MSDYN365BC →