-
How can I automate work order creation in Dynamics 365 Field Service based on IoT sensor alerts?
Hi everyone, We’re currently using Microsoft Dynamics 365 Field Service and exploring ways to improve our preventive maintenance process. We have IoT sensors connected to equipment that can detect performance anomalies (e.g., overheating, unusual vibration levels). What we want is to automatically generate a work order in…
-
Connecting Copilot to Microsoft Dynamics 365 Business Central On-premise
Hello, I am looking for a solution to integrate Microsoft Copilot with Microsoft Dynamics 365 Business Central On-premise. I would appreciate your guidance on the specific steps required to establish this connection. Your expertise and detailed insights on this integration would be greatly appreciated. Thank you in advance…
-
Error in BC cloud migration when defining SQL database connection
We would like to know the reason of getting this error sometimes in the 1st steps of the BC Cloud Migration Setup (OnPrem to Cloud) ,when trying to establish connection to origin DB, after providing the SQL Connection String and the Integration Runtime Name. It seems to be completely random and related to the failure of…
-
E-Mails gets send but not moved to table Sent E-Mail
Hi, We have encountered a peculiar issue with one installation. It's a German BC 20 installation. From page 13 (Email Editor), the user sends an email. The body content is visible and is an MS Word document. The email is added to the table Email Outbox, sent to the customer, and then moved to the table Sent Email. The…
-
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
-
How can I design a scalable data pipeline for real-time AI model training ?
How can I design a scalable data pipeline for real-time AI model training when dealing with both structured and unstructured data sources? I'm currently building an AI system that needs to process large volumes of structured (SQL databases) and unstructured (social media text, images) data in near real-time. I’m struggling…
-
Work Order Not Auto-Assigning to Available Resources in Dynamics 365 Field Service?
Hi everyone, I'm currently working with Dynamics 365 Field Service, and I'm running into an issue where work orders are not being auto-assigned to available resources, even though I've configured Resource Scheduling Optimization (RSO) and set up the booking rules correctly. Here’s what I’ve checked so far:* Resources are…
-
Adding a new lookup field with a TableRelation to CRM Integration Table
Hello, I wanted to ask if anyone can explain to me how you properly add fields that have a table relation in business central for example "Sell-to Customer No." in "Sales Header" to a CRM Integration table, so that when the value of the lookup value in Business Central will properly be transfered to CRM and in CRM the…
-
Appending to the end of a file - BC v14, C/AL
Hello - I am trying to append lines to an existing file in BC v14 (although this could pertain to NAV 2018 as well). I am opening/creating a file as shown below: TempFileName := FileMgt.ServerTempFileName('txt'); OutputFile.WRITEMODE := TRUE; OutputFile.TEXTMODE := TRUE; IF EXISTS(TempFileName) THEN…
-
Planning Assignment Error
Hello, For our customers system we have two different servers where the specific services are running. Specifically, it deals with the problem that a service on server A, which has activated the TaskScheduler and is only responsible for the job queue, has an error in combination with a service on server B, which is only…
-
Filter Group
What is Filter Group In Navision what is the use of this filter group where should I use this one can you tell me one scenario and give proper example when i will use filter group in which one is will be reflected in frontend
-
How can I automate lead scoring and prioritize high-value opportunities in Dynamics 365 Sales?
I’m trying to optimize our sales pipeline using Dynamics 365 Sales, but my team struggles with manually identifying and prioritizing leads. I’ve heard about AI-driven lead scoring, but I’m unsure how to set it up effectively or customize the scoring model to fit our business criteria. Can anyone share step-by-step guidance…
-
A part of page 13 Email Editor is not shown for some users, but for others
Hi, We have encountered a peculiar issue with one installation. It's a German BC 20 installation. The user can open page 13 (Email Editor) and send an email, which is a standard Nav page. However, in their LIVE environment, the Message part of the page is not shown at all for some users. I experienced the issue with my own…
-
How to get Hash Certificate as Base 64 String in MS BC SaaS
Hi, I tried to get the hash certificate, but I keep failing to get what I want. Below is the Powershell command and what I have understood so far. //Powershell command$certPath = Read-Host -Prompt "Enter the path of your certificate file (*.pfx/*.p12)" $password = Read-Host -AsSecureString -Prompt "Enter the password for…
-
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…
-
Microsoft Dynamics 365 Field Service?
How can I integrate Dynamics 365 Field Service with Power BI for real-time service analytics and performance tracking?
-
Error with BC240 Email Setup - Microsoft App Registration
I am running into an issue with email within BC240. When setting up our Azure Application Registration on the 'Email Microsoft Entra Application Registration' page, I enter our Client ID, found under the Application (client) ID of our App Registration win Microsoft Azure. I also add the Client Secret value, provided when I…
-
Debug without delayed database operations on BC cloud
I get the error I get this rather often, but it is not reproducible. I get it for different kind of operations, related to warehouse receipt, warehouse shipment and pick. I have error call stacks for the case of warehouse receipt and warehouse shipment In the case of warehouse shipment, the error is triggered in "Item…
-
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.
-
Rendering output for the report failed and the following error occurred: the access path is denied
Hi everyone, i have a problem sometimes when editing a report with the following error : "Rendering output for the report failed and the following error occurred: the access path is denied" the problem is that the error is randomly generated for this ( it fails 1 or 2 times each 30 times when it is generated) in…
-
How can I create a fully automated lead qualification and scoring system using Power Automate ?
How can I create a fully automated lead qualification and scoring system using Power Automate and AI in Dynamics 365 Sales? Despite its advanced AI and automation capabilities, why do many enterprises still struggle with low user adoption and suboptimal ROI when implementing Microsoft Dynamics 365 Sales—and how can…
-
Download report file as XLS
I have two questions regarding a custom report in Business Central SaaS. Question 1: I am creating a custom report using the Aged Accounts Receivable report as a base. However, I want this new custom report to export directly to Excel—without any preview or PDF option. The only available output should be Excel. Is this…
-
What are the emerging trends in field service technology?
What are the emerging trends in field service technology, and how can Dynamics 365 Field Service adapt to stay ahead? How do you see advancements in AI, IoT, 5G, or automation shaping the future of field service? Are there any features or capabilities you’d like to see added to Dynamics 365 Field Service in future updates?
-
Control addin event arguments
Hi, According documentation the arguments in events within control addin must belong to an array. I can't understand how should this work with arguments. Here's my code: AL:trigger PreviewDocument(DocId: Text)
begin Message('Trigger PreviewDocument Invoked');
end; AL Control Addin:event PreviewDocument(DocId: Text); Js…
-
How to transfer Inventory Pick No to Sales Shipment
Hi All I'm struggling to find an event to transfer inventory pick header no (Record "Warehouse Activity Header") to the posted sales shipment header field. WHat happens is when using inventory picks the warehouse employee post the doc but then struggle find a relationship when looking at posted sales shipments so though…
-
Issues with NAV 2009 R2 RTC and Windows 11
Is anyone else having issues with NAV 2009 R2 RTC connecting when running Windows 11? Hopefully, everyone is well beyond NAV 2009, but I have some older Windows 11 builds that work fine with NAV but the newer ones are throwing an error that "The login failed when connecting to SQL Server XYZSQL". I suspect it has something…
-
Business Central - Login issue / Intermittent database connectivity issues / Running slow issue
Hi, I am using Microsoft Dynamics 365 Business Central, recently encountering the following issues, these three issues can happen on the same day, check in admin account showing Business Central is healthy, does anyone have any idea on what is causing these problems? Big thanks! Issue 1 When users first access BC, error…
-
Using a x-www-form-urlencoded Rest API with Business central (to get token)
Hi everyone, I'm trying to develop a function with AL that permits to Post a url encoded content. It works fine with postman. The following procedure that I've started developping doesn't work : procedure GetToken() ResponseText: text; Var client: HttpClient; cont: HttpContent; header: HttpHeaders; response:…
-
Preset number of copies from outside a report.
Hello, One of our customers uses a terminal solution, i.e. special reports are printed when documents are processed on a terminal. The reports can be printed interactively from BC as well as via the terminal. When printing via terminal, the reports are called from a codeunit. When printing via terminal, the reports should…
-
What Are the Strategic, Technical, and Operational Considerations for a Seamless Upgrade?
What Are the Strategic, Technical, and Operational Considerations for a Seamless Upgrade from Microsoft Dynamics NAV to Dynamics 365 Business Central in 2025 and Beyond? As businesses increasingly move toward cloud-based ERP solutions, upgrading from Microsoft Dynamics NAV to Dynamics 365 Business Central has become a…