-
Windows Client Issue with Credential Type UserName
Changed ClientServicesCredentialType to Username. Web client works, but Windows client would complain: The ClientServicesCredentialType configuration setting cannot be parsed into a valid NavClientCredentialType Using NAV 2017. Any suggestion please. Thanks.
-
Can't download symbols for BC18 when including test
I would like to write custom test codeunits, but I have trouble accessing the necessary symbols. If I don't include"test": "18.0.0.0" in app.json, VS Code download all symbols just fine, but it can't reach the objects relevant for testing, such as Assert. If I do include the property, I can't download the symbols without…
-
Display Mediaset images in factbox
Hi I would like to create a factbox through which I can display all images in the Picture mediaset field in the Item record. Can anyone advise how I can achieve this? It seems by default only the first image in the Mediaset is displayed. Perhaps by having a Next and Previous action to iterate throu the mediaset images and…
-
Connecting middle tier to SQL using a service/single account?
Hi All I've seen this done and I really should have paid more attention at the time but didn't think I'd ever need it again. Basically they setup NAV to authenticate to SQL using a single service account rather than the usual multiple users. I assume the users connect to the middle tier and then the requests to SQL happen…
-
NAV 2013 R2 connect to external SQL Server
We use to have codeunit using Automation to get some data from another SQL server but now getting errors. We would like to re-write it if possible using other means connecting to SQL Server directly. However I've done some search for such info but no luck. Any link/info as how to connect to another sql server and grab…
-
AppObjectId from event log doesn't exist
Hi, I try to track down some performance issues and found an entry in the event log of the service tier with a long running SQL statement. However, it states AppObjectType: Page AppObjectId: 9599 But this page doesn't exist. What is going on there?
-
Upgradation
For one of our Customer we were supposed to upgrade to NAV 2018 from NAV 2013R2. We did the Application code upgrade to latest CU of NAV 2018 but I saw where in Microsoft is saying to upgrade to NAV 2018 CU 2 first. Is that really needed OR I can continue to the latest CU. Eventually we need to move to Business central.…
-
Export File to Azure Storage Location
Hi, From BC on prem, is it possible to export a file to an azure storage location? Regards,
-
SharePoint configuration issues in Nav 2017
Hi. I have a problem in Nav 2017 in standard SharePoint connection settings. I configured it a few years ago with my SharePoint site and it had never given me problems, but for a few months, just by hitting the Test connection button, I get the following error: Could not connect to the SharePoint site. SharePoint Server…
-
I am getting an error message while connecting NAV 2016 and power Bi via oData.
Hi, I am trying to connect power bi to NAV 2016 via odata. While trying i am having the below error. I tried to put below URL but cannot connect: http://<Server>:<OData Port>/<DB instance>/OData It give me below error: Dynamics NAV: Request failed: The remote server returned an error: (503) Server Unavailable. (Service…
-
How to encrypt and decrypt the password using RSA algorithm in NAV 2016
Hi All, I need to encrypt the password which uses "Public Key" and send the same using HttpWebRequest, it will give reponce which is encrypted. I can send and receive the data but cannot encrypt and decrypt. Please help to encrypt and decrypt the data using RSA algorithm. Thanks in Advance, Srinivas.
-
How can I prevent the web client from focusing on records that are inserted or modified?
I am building a custom price list page based on a custom temporary price list table. Due to high calculation time on a few price fields, the values of these fields are not calculated prior to the page loading. Instead, these fields are calculated and modified 100 at a time by a page background task. This works fine with…
-
Report issue
While i opening a report eg: report 1 using report builder, it automatically creating a new report as "report builder - backup" how to avoid this
-
Row not visible until sorted
Hi, I need your help in order to solve a boring issue. I had to migrate some huge data from an old DB (Nav 5) to a new DB (Nav 2017). I used ALTOVA MAPFORCE to open the 2 SQL DB , i choose the tables to migrate, mapped the fields, (created dumb value for the new fields in the new SQL NAV) Run the mapping and everything is…
-
I am faced with a problem when I try to install CU 22 Dynamics 365 Business Central Spring 19 Update
I am faced with a problem when I try to install CU 22 Dynamics 365 Business Central Spring 19 Update EN I have the following error: help me please Microsoft Dynamics 365 Business Central Build 46607 Error Report Server Administration Tool Client Components Fatal error during installation. Error reading from file:…
-
Size of field in mobile version of NAV2018
Hello, I have a problem setting up a development on the tablet version of nav 2018. I need a text field that takes the entire page on the iPad version so that the user can enter their text with the apple pencil. Currently on the Desktop version, the control takes up the entire page but not on the mobile version (check…
-
Reverse Finished Production Order
Hello, Please teach me how to reverse the effects of an erroneously finished production order. User accidentally posted more output and consumption than was necessary. We are running version 17. Thanks.
-
Workflow for multiplies levels of approves in NAV 2018
Hi Team, Please have similar issues where I have the following users 3 users - sequence 1,1,2 one approver per sequence, 4 users - sequence 1,1,2,2 one approver per sequence, 5 users - sequence 1,1,2,3,3 one approver per sequence, 6 users - sequence 1,1,2,2,3,3 one approver per sequence, 7 users - sequence 1,1,2,2,3,4,4…
-
Can we change Action Button Colour in NAV 2017?
How can we change Action Button Colour in Navision 2017? User wants same button in different colours for different operations.
-
Service "" was not found!
When I visit the local webservice page http://SERVER:7047/PROD/WS/ I get an error that service "" was not found. I went to each individual web service and did not find any errors. The error only is in our PROD instance, TEST (a copy of prod) works. I cannot see a blank service name or any other obvious problem. Do you have…
-
AL/Visual Studio Code/OnPrem: Debug Invoke-NAVCodeunit from Administration Shell
Hey there, hope you're all doing fine! I need to debug code that is been triggered by a "Invoke-NAVCodeunit" command from the Business Central Administration Shell. Neither my launch configuration with "breakOnNext": "Background", nor "WebServiceClient" is catching my breakpoints :-( When I publish the codeunit as SOAP…
-
REST Webservice
Hi, I am new to NAV developments. I have a third party application which has exposed REST webservice which has a ~100 records with 4 fields. I need to consume that webservice in NAV and read those records and import in NAV table. I tried to use the SOAP application to invoke the GET method and can view the ~100 records.…
-
BC365 An Internal Error has occured
Hello Guys. Im currently working on BC365 and still newbie. Im trying to publish my work to a remote server. see error below Any idea ? Thanks and God Bless
-
NAV 2018 Encryption Keeps Getting Enabled
Hi, We are upgrading from NAV 2016 to NAV 2018 (Business Central 14). Every time I reboot the server machine, the Encryption is being enabled, and I have to manually Disable it. I am wondering if anyone else has encountered this problem. I am wondering if it is because I had encryption enabled on the test database that we…
-
Creating Versions for different items
I want to create versions for different Items in Prod BOMs. If Version1 is existing, It should insert value as Version2. If Version2 is also existing insert Version3 and so.on.... Please help me with code how I can do this
-
SELECT TOP 1 with update lock
Hey, i was tracing the activities on our SQL Server to track down some performance issues. And my attention came to this SELECT TOP 1 NULL FROM <table> WITH(UPDLOCK) and this SELECT TOP (1) * FROM <table> WITH(UPDLOCK) ORDER BY "Entry No_" DESC The first snippet seems to be from a ISEMPTY statement while the second snippet…
-
FTP download azure function
I have function for uploading a file to ftp and I woud like to know the equivalent function for downloading and renaming the file. I have no experience with c# I only use this functions to post them to azure function and then consume them in BC. I would be thankful is anyone could show or guide me to have the equivalent…
-
XMLport Required attribute with MinOccurs = Zero
Busines Central I don't understand why it is asking me for the attribute if MinOccurs = Zero Thanks for advance
-
RUNREQUESTPAGE question
The RUNREQUESTPAGE is a great feature for NAV. This functions opens up request page for a report, and returns the full request page parameter in a XML file. @!!!! But, within a report it self, can you get this values for the request page in xml? E.g. In the CURRREPORT object, can we get the same request page in xml file?…
-
Hide and Show Records based on Group
Hi All, i am using cloud bc for my customer i am thinking is there a way that we can show / hide for certain records based on the group. for example user A,B,C is group 1 so he/she only can see the records for his/her own group meanwhile user X,Y,Z is group 2 so he/she also can see records that belong to group 2. but there…