-
NavClientInvalidCredentialException
I am unable to connect BC clients. I have a three tier Dynamics 365 Business Central 2026 on-prem installation, with sql, web server and nst on separate servers. I need help figuring out why the delegation fails I run all three services from dedicated domain accounts : sqlsvc, websvc, nstsvc SQL:…
-
Can you run AL code under a different user or permission sets?
Hi I'm developing some test code and want to run say posting of invoice under a different user so I can test permissions? Is this possible without using docker and test libraries as I do my testing directly in SaaS Sandbox?
-
upgrade from DYNAMICS C5 to Microsoft Dynamics NAV 2016.
Hi Guys, One of our customers want to upgrade from DYNAMICS C5 (NAVISION C5) to Microsoft Dynamics NAV 2016. I have upgraded Nav 4.0 to NAV 2016. So upgrade from DYNAMICS C5 to Dynamics is Same as we do normal NAV upgrade projects? or we we need to go for rapid implementation to get customer data in stander ed NAV 2016? I…
-
Change Log Setup empty after Migration to Dynamics.com (BC27) how to copy SETUP to other companies
After migration to dynamics.com the change log setup is empty. All old setup data is lost in the migration process. I want to create a decent setup and copy it to all other companies (>10) , but fail do do so by rapid start or other copy ideas I tried. Any ideas?
-
Full upgrade path from 22 to 23
What is the recommended way to do a full upgrade of a live system (On-Premise) from BC 22 to the latest release available now? May I know whether there is a step by step guide somewhere? I searched and came across only the Technical upgrade guidelines. My understanding is that this is different from a full upgrade ??
-
NAV 2009 to Dynamics 365 Business Central License Upgrade
Good Day everybody, I am actually using NAV 2009 R2 version at my company and I am planning to move to the latest version of Dynamics 365 Business Central. I would therefore like to understand how Microsoft converts my existing NAV 2009 BRL License when I upgrade same to Dynamics 365 Business Central. I currently have the…
-
XMLPort odd behavior
I'm executing a function that calls an XMLPort and then on Success it archives the file. Out of 800 files tested 6 archived the file without importing it. I'm not sure why it archived even though I only archive when Success of the XMLPort is TRUE. I'm thinking of using GETLASTERRORTEXT to see if that traps an error…
-
Invalid Date - Behaviour using Modify / Insert
Hi all, in the last days i stumbled upon a strange behaviour of our Navision2018 System. And i think(?) this behaviour is knew. I did not recognize that in the past. Situation: We use Nav2018. We have to Import data from a text file. One field is a date field and the value is "1102025". (The data was send by a customer.)…
-
Recref between companies
I'm using recref to copy data between companies not copying the key because I want that to be perform by the insert in the destination company but it looks like the insert it's working in the current company
-
Insert new line on second List Part - The view is filtered, and the entry is outside the filter
Hi Guys I have created a second list part on the Service order screen to show service item worksheet table rows, second list is filtered by the service item lines . same hierarchy such as sales lines and item tracking lines. all works when viewing records however I cannot insert a new record to the second list part (items…
-
Using RecordRef and FieldNo Instead of dependency to get fields from another extension
Hi All We can get fields from another extension by using something like below without delcaring dependency in app.json file. Are there pros and cons with just using recordref vs dependecy. Eitherway if the field is not there second ext wil fail local procedure TryGetFieldValue(RecRef: RecordRef; FieldNo: Integer; var…
-
Tenant media Growing Too Large
Hi, One of my clients' Tenant Media table sizes is growing quickly. The data in this table can be viewed or exported, but records with the MIME Type "application/octet-stream" cannot be read. This kind of record typically takes up a lot of room. I assume that this record is created in the Tenant Media table when an Excel…
-
Project/Resource Planning
So here is the problem I'm having (BC cloud, version 27.3): I have a project planning line with a single resource on it, and that resource is only available for 40 hours a week. If I enter a task that requires 160+ hours, the system doesn't seem smart enough to change the dates accordingly. This is confusing to me for…
-
How to embed RDLC format within the AL code and extension
Hi All When developing reports in AL you automaticlaly create and rdl fiel thats in xml but later in front end report editor we chnage the look and feel of the layout. Is there a way to convert the rdlc fiel back to xml and embed it in extension so when deploying theres no 2 steps, deplo extensions , import RDLC to the…
-
Missing table(s) when upgrading from BC 16.5 to 25.15
I am attempting to upgrade an on-premise instance of Business Central 16.5 to 25.15. However, when attempting to synchronize System Application, the following error occurs: Table 4152 Temp Media :: The table 'Temp Media' cannot be located. Removing tables is not allowed unless they are temporary or are being moved by…
-
Why doesn't copying project planning lines reset their picked quantity?
I noticed that when copying project tasks to a new project in Business Central 25.2, the copied planning lines won't reset their fields related to their warehouse pick ("Qty. Picked", "Completely Picked" etc). I thought this was a bug, but even 25.12 has this behavior. This occurs in the codeunit Copy Job, specifically the…
-
Block Warehouse Shipment Posting by Code- Event to use
Hi All We want to block warehouse shipment posting if all pick list lines are not picked. What's best event to subscribe. Found this [EventSubscriber(ObjectType::Codeunit, Codeunit::"Whse.-Post Shipment", OnBeforeCheckWhseShptLines, '', false, false)] local procedure ValidatePicksCheckedBeforePost( var…
-
OdataV4 Error : An error has occurred.
Environment: Windows, Microsoft Dynamics NAV 2018 I am writing here because I spend few hours for fighting with this error and hope will help someone in the future. In the Event log the error was registered as: Type: System.ArgumentException Message: <ii>An item with the same key has already been added.</ii> The error…
-
Lines in CSV is not breaking
Hi, I am facing issue while exporting the data in CSV and send it an auto email to respective user on click of a button. While creating a csv, header and line are coming in one single line instead of multiple lines. Unable to understand why it is coming in same line and not shifting the data to next line. If anyone has…
-
How I Use AI for Technical Documentation: Practical Experience
I decided to share a bit of my experience. I hope you’ll find it interesting and useful. How I Use AI for Technical Documentation: Practical ExperienceDocumentation is always a challenge. It’s rarely complete, hard to keep up to date, and any change in the system can trigger dozens of edits that no one makes. As a result,…
-
How do I download and use DotNet Packages in BC25
I need to transliterate non-latin characters and found a DotNet package in the package manager NuGet. I don't know how to download it from the command line and make a proper dotnet project yet, but I can download it manually, which gets me a ".nupkg" file. Is this usable in my AL project? Do I just put the it in the…
-
Showing new Dimension Set in Posting Preview
Problem: As part of posting of a Sales Order we generate G/L ledger entries and assign a new Dimension Set ID to them. When we run Preview Posting we see the generated G/L Entries but the dimensions are empty (Global Dimensions are filled out). Inspecting the line we can see a new Dimension Set ID is generated. If we post…
-
Can Flow field be used in Setrange outside the repeat loop
ChatGpt tolder me I cannot compare flowfields in setrange (after using calcfields) like below, is it true or inefficient salesheader.setrange(Flowfield1, Flowfield2) If salesheader findset() then repeat Until FlowFields Cannot Be Used in SetRange Filters FlowFields are calculated fields - they don't exist as physical…
-
[SOLVED] Can't download symbols on-premise, or compile
Seems I cannot see the server from VSCode, even though the BC Admin settings and the launch.json seem correct [2025-11-13 13:57:28.60] Sending request to…
-
AI Agent with tools
(good to see mibuso is still alive, but the categories could be updated a bit ;) ) I have an agent implemented based on MS guidelines - with tools implementing AOAI Function interface. One tool is to add new data, another is to read existing data. When I ask agent to use read tool - it reads the data as it should. When I…
-
Why does BC include this blank record in the API response when it's not saved to the database?
I created custom API pages for Service Management in Business Central (Service Order, Service Item Line, Service Order Line) using standard BC tables. The Problem When I do a deep insert (POST with nested child records), the API response includes an extra blank child record that doesn't exist in the database. Pattern:…
-
What are the main steps of a BC version upgrade in-house?
I am an old Navision dev now learning BC things, working in-house, not for a partner. I simply cannot find the tools or steps online about how to do an upgrade. Is it something reserved for partners? Also we have sandbox and productive environs on the same server. Can I run a test upgrade on the sandbox this way, or do I…
-
Opinion on Api strategy
We are moving from nav to bc. Our solution is heavily integrated to other solutions. One of the challenges is that all our integration is build on soap. But this will be deprecated in bc. After looking at standard ui pages, custom ui pages and odatav4, I found that these 3 technologies have limitations and issues. Odatav4…
-
Claude AI is surprisingly good at AL coding
I just tried the free version in a browser, not even registration is necessary. I have not tested it yet (don't have a working environment rn) but it looks about right. I can recommend it to consultants who are new to programming, even if it has bugs it seems to have the correct outline, and also for experience devs for…
-
XMLPort loop question
Hi, How do you create xmlport for the following output —> <?xml version="1.0" encoding="UTF-16" standalone="no"?> <Vendor> <Name>Vendor Name for vendor 1</Name> <Name>Vendor Name for vendor 2</Name> <Name>Vendor Name for vendor 3</Name> </Vendor> The closest I could get is: <?xml version="1.0" encoding="UTF-16"…