-
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.)…
-
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…
-
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…
-
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…
-
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…
-
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"…
-
[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…
-
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?
-
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…
-
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:…
-
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…
-
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?…
-
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.…
-
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…
-
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…
-
Codeunit.run vs TryFunction to record errors and contine
Hi All I'm trying to find when one is better than the other base on use cases. For example I want create job queue to release sales orders, if one of the SO fail to release , record the error on a error log table and continue. Here i'm committing after each sales order. Is there a difference if I use TryFunction like below…
-
How can I use two Media fields in a dynamic way to use on a Brick?
I have a record A with a Media field: "Specific Image". Then I also have a Media-flowfield, refering to some master data: "Master Image". Whenever I display this record A as a tile, I want to use Master Image to be used on my Brick, unless I have uploaded a Specific Image. Then I want to show that.
-
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,
-
Purchase Return Order Line Insert Issue: falls into a loop
If “Tax Area Code” is mentioned, even if there is 0 tax, when user tries to insert a purchase return line (strangely the issue only starts at 4th line), the underlying code starts from OnNewRecord Trigger, then after some time control goes to OnAfterGetCurrentRecord, here code attempts to modify existing purchase lines in…
-
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…
-
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…
-
Hitting from Postman API to nav 2013 r2 service order
need help, recently I have been working on a service order where I'm facing 500 error when trying to hit through postman to nav 2013 r2. Note: Service order contains select job types with mapping fields based on general job category and job type. The error you can see also has the same content in JOB TYPE MASTER Body of…
-
SUPER user facing Permission Issue
Hi All, I am (SUPER user) getting the error message -"Sorry, the current permissions prevented the action. (TableData 79 Company Information Modify:" while attempting to update the company Badge using code below in Business Central SaaS. Please help me to solve this issue. Thanks, Navuser1
-
Dynamics NAV 2018 web client suspending connection to server.
I have an issue with Dynamics NAV 2018 web client. Its loading the role center page, but while clicking on any page or anything its giving error as "The connection to the server was suspended." Have the same issue in multiple servers. Dynamics NAV 2018 CU23 version installed. SQL server 2016 Express Already tried with…
-
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…
-
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?