-
Cloud environment
Hi, I have a question regarding permission on report designer. We have Microsoft Dynamics Nav on cloud environment. Our license is allowed to have access to report designer, form designer etc. area from development ,to change or create some reports. Now with changes made from the server provider , we can't have access to…
-
Database size
Our clients are using Nav 2015. Our database size is around 600 – 700 gb and system is running slow. What can we do to improve the performance of the database? What do you recommend?
-
Automate C/AL to AL upgrades
Simplanova invites Dynamics Partners to join our webinar introducing a unique proposition for NAV to BC code upgrade automation – SALT (Simplanova AL Tools). Webinar Date and Time: Wednesday, 11th of May, 2022, 04:00 PM CEST (Central European Summer Time). Register now:…
-
Report Execution Error using German Language
Hello All, I have created a Navision report and the output is Excel format, when I run the report using English Language, it works fine, but using the German Language, I'm getting below error message. Can anyone please advise how to fix below error. Also I apologize, I can't read the error message. "Die Wahlmöglichkeit…
-
API Calls PATCH/DELETE not allowed for table.
Hi, so i built an API Page for the customer bank account table and i cannot modify or delete entries i created ( Error says those calls are not allowed for customerBankAccount with EdmType „Collection“ . How do i solve this?
-
page not searchable
hello, i am encountering the following problem - page is not searchable when i search for it however, if I go to the waffle menu i can see it there. this only happens on certain role centres I have application area and usagecategory filled in in the code any ideas?
-
Filters on Queries
hello, I created a simple query that returns some data from table 36 and others from table 37, so far so good. Now I would like to filter the data, and I would like to let the user do that. I thought it would be an idea to call a page from the query's OnBeforeOpen trigger where you can enter the values and then have them…
-
Dynamics NAV 2016/2017 + problem to login UPN (Email ID) with ADFS integrated setup
Hi, I am testing Dynamics NAV 2016/2017 to integrate with ADFS (4.0 on Windows server 2019) to login users with UPN (Email ID). I followed this article: https://docs.microsoft.com/en-us/dynamics-nav/authenticating-users-with-active-directory-federation-service-2017 1. Created SAML 1.0 & JWT tokens in Claim Issuance Policy.…
-
Error when start running Business Central
Hi I create a new instance and a new webclient instance server with the command New-NAVWebServerInstance. I can download symbols in VC but can't run Business Central. Appears the error below: Already see some configurations, database... but I'm a rookie in BC so I don't know if I'm doing something wrong. Any suggestion?…
-
Download AL symbols not found error, how to change my connection url?
Why my Visual Studio is connecting tohttp://adrianbc/BC/dev/metadata?tenant=default ? I'm able to connect by browser to Business Central: When I try to download AL symbols I get Not Found error:[2022-02-11 13:20:58.02] Using reference symbols cache path: c:\Users\dimitri\OneDriveArqui\AL\Pan\./.alpackages
[2022-02-11…
-
How generate file txt in Navision?
Hi, good afternoon I am new in the world navision and I have question's My buddie has me asked creating a file txt from navision but the example shared is a txt with algoritm what is the most recommended way to do this process? best regards, Javier.
-
Is there any way to get information about the local session?
I have an issue that requires that I know which station/computer a user is logged in with. The user itself isn't important, but I need to know if they are using computer A, B or C. Is there any way of achieving this with Business Central 19 CU 1? Some sort of session metadata that includes information about the computer…
-
How to exchange files between SFTP and Nav 2009
I got an project that, we are using Navision 2009, we are about to exchange some files with SFTP, how should we do? Is there some sample coding I can refer to?
-
New Purchase Job Price list screen, costs are not picking in the purchase lines.
Hi, Enabled the New sales price feature from feature management. Here is my Purchase Job Price List, with Job JOB00020, Item 1908-S, Min Qty 3, Cost 45 and Discount 10%. Trying to create the purchase invoice with Vendor 20000, Job JOB00020, Item 1908-S, Min Qty 3, but it didn't picked the cost 45 from the new purchase job…
-
Unapply Payment Via API
Hi All, is there a way that we unapply payment via web services? is there any standard api? or must be customized? Thanks.
-
Retain Dimensions field error
I'm trying to troubleshoot an ongoing issue that is happening when Adjust Cost is being processed. We have created a Codeunit that processes Adjust Cost at night after posting has been completed. This has been running for over 10 years but occasionally, we have an issue where the system will crash when Adjust Cost is…
-
Show undelivered Drop Shipment order lines in posted shipment
Hi, When posting a shipment from a sales order, all order lines are copied to the posted shipment. Also the ones you did not ship any quantities for. This could be seen as a 'backorder' funtionality. However, when using Drop Shipments, only order lines on which has been actually shipped/received are transferred to the…
-
Developer's Toolkit function "Where Use" didn't find call of function
Hi guys, I used NDT v3.01.410. Today I tried to find all of some function calls (function at form). I know one place where it is exactly called - the function is located in the subform and is called from the main form. I wanted to know if the function is being called from somewhere else. But when I call "Where Use" on this…
-
Print 2 consecutive reports using Business Central
I have a requirement where the client wants multiple(2) reports to print automatically when the status is changed on a form. I have been able to successfully print all the reports from code individually, and they download on the downloads folder, However when I try to run more than 1, only the last report goes in the…
-
Underscore character in the API page (extension)
Dear all, I need to create an API page with some fields with the underscore character (like "_id", etc.). When publishing the extension I'm getting compiler Error AL0528: "The name of field controls in pages of the type API must be alphanumeric." As a result, I can't publish my extension. In my case the sender can not…
-
Text Constant
Hello, I have to search a wording beetween TEXT CONSTANT in all object. can you suggest me how to do that? tnx
-
Nav Events
how to track changes of Nav table through the Events
-
HttpClient and TLS compatibility
Hi, Currently I have been trying to integrate a website with Business Central 19 saas. The website doesn't have a SSL certificate, so I need to skip its verification when sending https GET request. Earlier I used ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 to use TLS protocol while calling a…
-
How to send email with 1 email account ? (not SMTP)
Hi all, I have customized something that send notification to vendor using SMTP account. so no matter who click send email, it will be sent using SMTP email account. (let's say : admin@abc.com) understood that SMTP is no longer can be used in BC 20, so we should use email account. but how do we set only this email account…
-
The date is not valid
Hi all, We are going through an issue where we can't "View" or "Edit" one of the customers due to the following error I tried to debug it and here is where it's complaining Does anyone know what is the reason behind such an error message and how it could be resolved? NAV Version is
-
Missing Horizontal Scroll Bar - NAV 2015
Hi, Got a really strange issue for one user. Within Sales Orders (only this page), they have no vertical scroll bar on the subpage so cannot see all the columns (need to scroll right). Oddly if they page is opened very large (so it spans both monitors) the scroll bar appears. Shrink it down to 1 monitor and it disappears.…
-
Display all sessions under Database information
I'm running NAV 2009 R2 (Build 32012) classic client under SQL-2008 R2, simple security model, no traceflag. I can't manage do display all sessions for a non-sysadmin sql-database login with traceflag 4616 set off (with traceflag set on, it works). My database login TEST has got "VIEW SERVER STATE" permissions. (Each sql…
-
OAuth2.0 Redirect URL for Field Service
Hello everyone, We have a Business Central On-Premise version connected with Field Service web. The basic authorization was depreciated and we are trying to configure the connection with Dataverse, but we are having issues with the Redirect URL for Field Service. Does someone know the correct generic Redirect URL? Do you…
-
Display Guid on Page and Report in AL
Business Central SAAS Hi hope someone can help, I have added the SystemModifiedBy field to a page and it returns the GUID of the user. Is there a way I can change the value returned so that it shows the user value as it seems to show it if I hover over the returned GUID on the page. field(SystemModifiedBy;…
-
"Could not create SSL/TLS secure channel"
Trying to fetch data from external web service using BC client, but keep on getting the error "Could not create SSL/TLS secure channel". When using web browser the service response is OK. Any idea? Regards