-
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,…
-
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…
-
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…
-
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.)…
-
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"…
-
Change field name in table
I need to change field name in custom table in BC OnPrem. ID remain same. When I try to install the new version of the app, the system tells me that removing a field is not allowed (even though the ID has remained the same). If I force the schema by synchronizing, the field is renamed, and the data remains in the table…
-
Task recorder for BC ?
Hi, in D365 Finance you can use the "task recorder" to capture a process and this integrates with Business Process Modeler within LCS. Has anyone come across a way to replicate task recorder within BC? Thanks.
-
NAV 2018. How to export XML file
Hi! I am new here and also still learning NAV 2018, so my knowledge is limited. I have an issue: when I go to Sales Order and select a specific customer, then try to Post -> Invoice -> Ok, I get an error. I don’t understand why, but I heard that it’s possible to export an XML file to see what the problem is. Could you…
-
To Change alternative address automatically
Hi, In Sales Order page, I woul like to change the address option as Alternative Address when user validates the posting date and want to select available ship to address and apply to SO. Is there any ways to do this customization. Thanks in advance.
-
Why does AL:Go! stop at BC 16?
Old NAV hand now trying to learn BC dev. Docus say use the AL extension in VSC, type AL:Go! but it only targets BC 2 to 16? Is this outdated? Also please can anyone link to any up-to-date dev docs? Not the syntax, but more like how to compile and install and make an extension work live. Another doc I would be interested in…
-
What are the best AI coding IDEs for AL code
Hi All I have been playing with Windsurf/cursor for coding. I'm not sure if these are better than vs code with extensions. One problem I have so far is getting Windsurf to read the base app. So I can ask a question like, "read the base app "Sales Header" and extend it by creating table extension to do xyz. Basically I dont…
-
Starting BC Development from Scratch (again)
So, back in 2-tier, I used to be a pretty good developer (mid-mid-grade). But I haven't done any development since about... 2008? Now I need to get back into it, but it's changed quite a bit. I can still read AL for the most part, but the Visual Studio thing is really messing me up because I used to use object designer. I…
-
Does anyone know why the "Select Server" option is missing?
Hi, Our customer has a NAV 2016 Version 9. When I log on their solution, I have the option of selecting server: But when the customer logs on, the "Select Server…" isn't there. It has "Select Language" and Select Company" but nothing in between. The customer's user har SUPER permission set. Did anyone experience the same?…
-
NAV 2018 Planning: Different Lead Times for Same Vendor
Hi everyone! I need to differentiate different transportation modes in NAVISION 2018 planning for the same vendor, so that the system can calculate which mode is better based on different lead times. I’ve tried creating new vendors and linking them to the item, but in planning it only considers the default vendor. Example:…
-
Suggest Vendor Payments
There is a custom field on the Vendor Ledger Entry Table, so the requirement is to summarize by vendor by the new custom field. I cannot figure out how to add the extra loop for this to happen. Help anyone?
-
NAV 2018 - Expiration Date Reclassification Creates Inconsistencies Between Tables
Hello. NAV 2018 offers the possibility to change the expiration date of items using the Warehouse Reclassification Journal, which performs an outbound and inbound movement of the item, allowing the date to be updated. However, this feature cannot be used in the current scenario for two main reasons: Multiple expiration…
-
Advice on NAV 2017 Code efficiency
This code is taking hours to run but my earlier itterations of it were only taking minutes to run. No change in record count - loking for advice from more seasons developers as to what can i do to improove its runtime - my only thought is to create a temp table and store the records tehre before itterating…
-
What are the effects of the different license types (BC14)?
Hello, I'm currently trying to find out what the individual license types that can be specified for the user, i.e. Full User, Limited User, Device Only User, Windows Group, External User, External Administrator and External Account, actually do. I tried out the different license types with a test user, but nothing seems to…
-
Line Break when sending data through JSON
Hello, i am using Microsoft Dynamics NAV 2017 version. I am sending data through JSON. Variable: JsonTextWriter Datatype: DotNet Subtype: Newtonsoft.Json.JsonTextWriter.'Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' JsonTextWriter.WriteValue(TextField1 + '\n' + TextField2 + '\n'+…
-
Business Central - Send Invoice For Approval via API?
Hi, I know I can 'Post' an existing invoice in BC using the API endpoint /purchaseInvoices(InvoiceGUID)/Microsoft.NAV.Post , but is it possible to send an invoice for approval via the API? Many thanks, Jonathan
-
Autofocus on a row in the "Items Journal"
Hello, I have a troubleshooting with RTC on Dynamics 2009R2, only on one laptop. When i click on the row 1, the row 2 disappear, i have to scroll up to reappaer this row???? Anyone would to helping me? Regards,