-
Import attachment in Web Client is not working
Hi All, [Version: NAV 2016] In a customized page, I newly kept an feature for Importing, Exporting and Deleting an attachment. I can able to Import/Export/Delete without any issues in Windows client. When I try to import an attachment from web client, immediately the web page gets closed and am getting below error: An…
-
I can't evaluate a DateTime value
Hi, I'm trying to evaluate a value, however I am getting the following error: The value "2021-02-16T09:26:36.953" can't be evaluated into type DateTime. With what method can I solve the problem?
-
Quickentry not working?
hi All, hope someone can help. It seems like we don´t have nextcontrol anymore so I placed quickentry in few fields. However it seems not to work (it goes always to the next field and then to the top of the page). Do I have to set quickentry=false in all the remaining fields? Thanks. Edit: I will answer myself: On classic…
-
Convert DateFormula to text
Hi experts Is it possible to convert a DateFormula to text? Example: Input=3M, Output=3 Months Detail: FORMAT works, but returns just 3M as a text string. Documentation for FORMAT does not mention DATEFORMULA... Thanks in advance. Thomas
-
Multitenancy PowerShell Script not working
hi, we have this scenario: 1. Separate SQL and NAV Servers 2. Multitenancy enabled - trying to move companies from a single tenant to multiple tenants 3. SQL Server 2017 - SQL Server Management Studio 18 I'm working on the NAV Server, where I am importing the NAVMultitenancySamples.psm1 and running the…
-
Breaking change in Item Cross Reference BC18
Microsoft is going to replace the Item Cross Reference functionality with item Reference. https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/smb/dynamics365-business-central/write-longer-item-references Microsoft has created a migration feature for this The breaking change consists of that it migrates…
-
How can I install Test ToolKit on an existing Azure Container?
I have created a Business Central conatiner in Azure using az container create ` --resource-group 'RG-Container' ` --name 'democontainer’ ` --image mcr.microsoft.com/businesscentral/sandbox:13.1.25940.26323 ` --dns-name-label 'democontainer’ ` --port 80 Once installed, how can i now add / install the testtoolkit ? I dont…
-
Nav 2016 Web Services Pausing
We use Nav 2016's web services for various minor tasks. All has been working well for years, but yesterday we started getting random slowdowns that seem to consistently last 2 minutes. For example we'll send a command to update an order, let's say changing a checkbox from checked to unchecked. The response will take a…
-
Converting Unicode to UTF-8
Hello, I am trying to convert a simple text from Unicode to UTF-8 because our Webservice can't handle Unicode. I couldn't find any NAV native functions to do this and after trying to find a solution online for a couple hours I find my self here. NAV Version: BC14.12 Any help is appreciated
-
Business Central Codeunit 49 Global Events do not react
I have created a new codeunit with an event subscriber function to the event "OnAfterOnGlobalModify" in Codeunit 49. But when I make changes in a record, the event subscriber does not react. Properties of my subscriber: EventPublisherObject: Codeunit GlobalTriggerManagement EventFunction: OnAfterOnGlobalModify I tried also…
-
Permission error when upgrading from Business Central 16.1
Hello, I am trying to upgrade Business Central 16.1. I have tried upgrading to 16.2, 16.6 & 16.10. No matter the version, when I run the commandStart-NAVAppDataUpgrade -ServerInstance BC160 -Name "System Application -Version 16.10.21502.0" I get the following error: The "same" error, has also looked like this with later…
-
how to add AL code extension to a Condition
Hello Everyone, Good day. I'm having this problem right now adding AL Code extension to a condition. Please see screenshot below Does anyone have an idea on how to proceed ? Thanks and God Bless :) Regards,
-
Problems with Job Queue Entries and Task Scheduler in Business Central 14.0 OnPremise - C/AL
Hi everyone, In our team we are facing an issue with "Job Queue Entry" and "Task Scheduler": Every process enqueued in the "Job Queue Entry" is executed only once even if it's scheduled to execute more than once. The first time it runs only when the service associated with the task scheduler is starting or restarting. Here…
-
Merge PDF files
I am trying to merge two files (in1 and in2) and create a new file (ut1=outfile) and I have NO luck. Se coding example and error message below. Is there anyone who had success with the Merge function in Bullzip.PdfWriter? // test in1 := 'C:\Faktura1.pdf'; in2 := 'C:\default2.pdf'; ut1 := 'C:\Faktura2.pdf'; Datetime :=…
-
Matrix
How can I find the cell (column no.) that the cursor is currently in without having to click into the cell? (NAV BC)
-
How to connect to MVC application
Hello, How to connect to MVC application eg ASP.NET C# to import data from web service? From Business Central Cloud it is not possible to connect to the server due to restrictions, so I need to use an offline "bridge" to import data from the Web Service. Is there a way to do the above approach? The image above is a diagram…
-
Save report parameters as a blob
Is there a way i can save the parameters a report ran with into a log table? I have a log table with a blob field and in this field i need to store both the filters a report ran with and the options from the request page. For example, the job calculate wip report. In the log we want to know the posting date and document…
-
BC365 - Error You do not have the following permissions on Page Customer Card: Execute.\r\n\r\n
Hi having a question we want to insert a record in BC365. Authentication goes well, (with AAD registrerd application) we can make a connection but when we want to insert a record we are getting the error message "code": "Internal_ServerError", "message": "You do not have the following permissions on Page Customer Card:…
-
Lot Expiry Dates on Whse Item Journals
Hello, When items are booked in during the putaway, a lot number expiry date is applied. However we have a situation that Warehouse entries based upon Whse Item Journal lines are not carrying the expiry dates. Is this supposed to be this way, or is there missing setup to carry these dates? Thanks
-
NAV 2013 R2 with Azure AD authentication
I'm trying to configure app registration from Azure AD for NAV 2013 R2 using Access Control Service (ACS) credential. the web client is working well and can login using azure AD account, but the windows client having some error as below: Understand NAV Windows client does not fully support Windows Azure AD and we can only…
-
Required AD Functional Level for BC17
Hi, Setting up BC17 in a proper 3 tier environment. Service account has been provisioned and configured according to this. However, can still only access the web client from the web server. From other domain attached machines: The AD functional level is currently on 2008, will this suffice or what is the minimum…
-
SystemId, SystemCreatedBy, SystemCreatedOn etc. - SQL
Has anyone found where the new system fields are actually stored in SQL?
-
Task Scheduler: How to pass parameters to OnRun Codeunit
Hello there, the TaskScheduler.Createtask Function has the optional parameter of RecordId. How can I "access" the value of the specified RecordId when the task is executed? Is there some kind of parameter that's getting passed to the OnRun Trigger of the Codeunit that gets executed? There's almost zero documentation to the…
-
B365 Excel Buffer Autofit, BorderAround and GiveUserControl no longer exist in the Excel Buffer
We are recently upgrading a client to Microsoft Dynamics 365 Business Central from NAV 2013. The following functions no longer reside in the Excel Buffer table and I am wondering how these functionalities are being done in Microsoft Dynamics 365 Business Central. Any help would be appreicated. • ExcelBuf.AutoFit •…
-
Cannot login to Business Central mobile app after first login
Hi, When I restart IIS, I can login to BC mobile client in first attempt. But when I close app and try to connect again, app cannot connect to the server. This is valid for all users. First login is ok but further attempts always fail unless I restart IIS. Authentication is windows and certificate is from a trusted…
-
AL Code error AL0999: Internal error: System.AggregateException
Hi all, I'm working on some code merge pdf files (using the old code in C/AL ) on business central using AL Code. I got an error while compiling: and this is my code: Many thanks for your help!!!!
-
How to sort a report using a column on Dynamics NAV web client?
I can sort a report by a column in the desktop print preview by following the below tutorial. But can't sort in the web client. Is there some way to do so? Tutorial:- https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-interactive-sort-to-a-table-or-matrix-report-builder-and-ssrs?view=sql-server-2017
-
Payment Reconciliation Journal not Mapping the correct Text to relevant Sub-ledger Account
Hi All, Please may you kindly assist, The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account. When the CSV file (Bank Statement is uploaded) the transactions are populated. But only the G/L Accounts Map the text to the relevant account. All Sub-ledger accounts, Vendor and Customer are…
-
Outlook Add-In: Web Client Stored Credentials
I have a client I was help testing out the Outlook Add-in, by which I mean Contact Insights and the Document Links (not the Outlook Add-in for Sync -- can we get better naming?). We set it up with NavUserPassword logins, and when we logged in, it worked OK. Now he's changed his Nav password, but the stored credentials…
-
Federation Service endpoint login failed - BC16 to BC17 upgrade on Start-NAVAppDataUpgrade
Busy upgrading an environment to BC 17.1, and I'm at Task 8, step 1 - running data upgrade on System App and Base App. However, it basically just hangs - zero errors thrown in console. Zero app server CPU activity and nothing happening on sql server either. In the Event log, this immediately pops up:The Federation Service…