-
Good Day,
How can I generate a template or report that shows what a user can do and cant do in NAV 2017. i.e a list of different functionality on the application and besides it a column that specifies whether permission is granted or not
-
Service header
I have to show in the page of Service Order the customer mail. My question is where I have to insert the code.. In the Service Header table? And if yes, in which trigger? Consider that when the Service Order is archived all fields are transferred to the archived service header... thank you!
-
Face recognition data capture in nav 2016
Dear Friends, Can you give me an idea, how to store employee Face recognition values in nav 2016 and and capture the employee id. also any idea how to relate to QR Warm regards Krishna
-
Implementing Monthly Payments as Extension
Hello. I'm a new member here. How is everyone? I'm doing great myself.
-
How to access text box value in SSRS using ReportItems
Today I am going to share little bit important lesson. But I will hope you have already know this. Most of the times you might be required to access another text box value in Dynamics NAV report layout. For instance, Some times, developers want to show total on the top of the report, Like Total Invoice Value. Also in the…
-
DYNAMICS NAV JOB QUEUE
Dynamics nav Job Queue allow users to schedule and run specific reports and codeunits. You can set up jobs to run one time or recurring. For instance , user wants to run customer statement report weekly then email to the customers, to obtain this you can use job queues. In the Dynamics Nav Job Queue Entries window, you…
-
credit limit
How do i put an expiring date on a credit limit
-
Error: An item with the same key has a already been added.
This is the 2nd time I've run into this and you would think I remembered the solution from last time. Not. Using PowerShell Merge-NAVApplicationObject to do an upgrade I get the error: Merge-NAVApplicationObject : An item with the same key has already been added. When I was finished cursing whomever coded that 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.)…
-
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,