-
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…
-
UPDLOCK when using a ISEMPTY
Hi, Recently one of our customers is having deadlock issues on their NAV 2018 environment. In one specific case we captured the deadlock trace using SQL Profiler. The victim process was trying to get an exclusive lock for performing a DELETE. The other process had this SQL command: SELECT TOP 1 NULL FROM "some…
-
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
-
Using OpenFileDialog to select multiple files (Multiselect)
I couldn't find a solution for this here on Mibuso, so now that I have one I wanted to share. As some may know, the problem with multiselect is that Dialog.FileName then only returns the path as it's actually a <NULL> separated list and NAV can't handle the <NULL> (considers it to be the end of the string). However there…
-
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…
-
Connect to BC web service from a windows console application using Oauth 2 for user authorization
Hi community, I am using following code to access business central web service using Oauth2 authentication from C# console application, the access token generated successfully but I'm unbale to access BC web service due to invalid credentials, problem is that the access token generated from below code is rather shorter…
-
Error: Failure while emitting method.
Hi, I've created this xmlport (csv import) in BC17: xmlport 50000 "Invoice Import" { Direction = Import; Format = VariableText; FieldDelimiter = '<None>'; FieldSeparator = ','; TextEncoding = UTF8; schema { textelement(Root) { tableelement(Integer; Integer) { UseTemporary = true; textelement(Field1) { } textelement(Field2)…
-
Rapidstart error during import
I'm trying to import some data with RapidStart, I receive an error when applying the package. The error reports that a field contains a value that cannot be found in the related table; debugging I realized that the code breaks during the "FieldRef.Validate" . Obviously I've already checked that the value is contained in…
-
Changing report dataitem in NAV 2017
We created a custom report with a single DataItem Sales Cr. Memo Line that runs fine. I changed the DataItem to Item Ledger Entry along with all the columns references, however when I try running the report, nothing happens and NAV exits. Do I have to change the Layout? If so, how? Many thanks!
-
BC17 Upgrade fails on Database Conversion
Doing an upgrade from V15.5 to V17.0 and it fails doing the database conversion with an SQL timeout after 1 minute. This is on an Azure VM ( Standard E4s v3 (4 vcpus, 32 GiB memory) ) connected to an Azure SQL db (31GB). Steps followed from here:…
-
connect to BC web service from a windows console application using Oauth 2 for user authorization
Hi Community, I need help, I want to connect to BC web service from a windows console application using Oauth 2 for user authorization. Previously I was using Basic auth but it is being depreciated. Can anyone guide/help in this regard? I have achieved that through postman but how to do it from windows console application…
-
Only 2 users can publish to Business Central Cloud from VS Code
Hi All, we have an issue that only 2-3 users can publish the customization from VS to BC cloud version. But all the users have same user groups and permissions assigned. please suggest the resolution. Thanks in advance, Srinivas.
-
Download Multiple File Failed (Using Stream)
Hi All, i want to generate file using stream but if i use repeat , in order to generate multiple files, it will generate the last one only any advise? here is my code procedure GenerateFile()
var
GJL : Record "Gen. Journal Line";
begin GJL.Reset;
if GJL.findset then
repeat DownloadFile(GJL."Document No.");
until GJL.next =…
-
NAS NAV Exception
Hello all, I'm getting this error . Server instance: BC140_WebServices Tenant: default The Microsoft Dynamics 365 Business Central Application Server session for tenant 'default' has failed and will be restarted in 30 seconds. Reason: Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLNotSupportedTypeException…
-
The server stopped the session (ID: *) because of a stop session request.
Client is facing issue that User's session is stopped automatically by Middle tire. Client version is BC14 Application CU11 Platform CU16. The scenario is user opens any page via RunModal and then remain inactive for certain time. Below details are logged in event viewer as Information. There is no issue if user remain…
-
Business Central product coupling to CRM in two companies
Hi experts!! I need to copy a product from company A to company B and at the same time in CRM, I also need to couple them (BC to CRM) in both companies. I manage to create the product in company B and also in CRM but at the time of making the coupling only in company A and I cannot do it in company B. This is my code:…