-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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,
-
Is there a way to see report request form when emailing documents?
Reproduction: in BC, open a posted invoice and click on either eimail or attachment. It just generates the PDF without the request form. Google told me to use "document handling setup", but no such thing inm BC 18. Is it at least possible by code? Is there an event for this to set reportrequestform?
-
How to save an ANSI file from Business Central?
Hi experts, This is regarding Business Central cloud. When I make a file, I can set the encoding to Windows, UTF-8, UTF-16 and MSDOS. Our customer need a file with ANSI encoding. How do I do that? Hope, you can help. Morten
-
When sending a document per e-mail, showing request page
Reproduction: open any posted invoice, click either on "send email" or "attach a copy", in both cases, no request page. It just runs. It is important if you have on the request page options about how it should look like. I have heard it can be changed maybe in "document handling", but my BC v18 shows no results for the…
-
Why does BC (on prem) have multiple SQL tables where NAV had one?
We have like 5 Sales_Invoice_Line_fsdfdws8. 250GB DB, maybe split up for performance, dunno. It makes SQL queries impossible, and I want to use SQL queries because I need reports over multiple different software and databases, servers. That is because we have basically 2 different ERP solutions for different subsidiaries.…
-
Problem with Base64 conversion and Excel files
Hello, I have an application that gets Excel files encoded in Base64 I try to decode the Base64, put the obtained text into a blob to download it later with DownloadFromStream But I get corrupted Excelfiles I developped a little procedure (see link) to see if Base64-coding and Base64-decoding is altering the data. The…
-
Business central AL using Rendering for report layout
Hi Mibuso's, I'm using the new rendering possibilities in BC for the layout, but, I cannot select them through code. If I create a selection in a MenuItem, how to select the desired layout as it's in a [Report Layout List] Table and not as a custom layout in [Report Layout Selection] Thankx a lot for you help BR, Chris
-
Create New Server Instance and New Web Instance in BC On Prem 27
Hi All.. I want to create 2 Server Instances and 2 Web Server Instances pointing to the same database. some using windows, some using navuserpassword. 1st Windows was created from installation so i need to create 1 more for navuserpassword. created successfully… and already used cert thumbprint using self signed…