-
Barcode 128 with fonts + sample
Barcode 128 with fonts + sample With this font and encode function you can create a barcode in Navision. The CODE 128 barcode is an alphanumeric barcode with a checksum. It is widely used an can be read by most scanners. The TTF is freeware. http://www.mibuso.com/dlinfo.asp?FileID=405 Discuss this download here.
-
How to Access XML Nodes and Retrieve Attribute Values After Loading XML into InStream Variable?
In the context of an AL extension for Dynamics 365 Business Central, I have a scenario where I need to select an XML file using the code provided below and then parse its nodes to extract attribute values. Here's the code snippet for loading the XML into an InStream variable: if UploadIntoStream(DialogTitle, '', 'XML…
-
How to import data from an XML file to BC tables?
Hello everyone, I already have the data from the XML file in InStream, I need to access each node to obtain the data and insert it into a BC table. XML has several levels, in addition to being very extensive. How can I do it? I have seen a method (y2u.be/x8AOo9j-ifE), however I have not managed to access the nodes. This is…
-
Amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry
I have a situation where the amount on Check Ledger Entry does not match amount on Bank Account Ledger Entry. The are off by approximately $7000. The amount on the check ledger entry does match what was printed on the check. However the Bank Account Ledger Entry and the corresponding G/L Entries are off. The Vendor Ledger…
-
GST calculation issue
Hi, If any item is having sales price lines with price inclusive of tax then gst is getting calculated & if not that gst is not calculating on statistics & nor gst ledger entry or detailed gst ledger entry is getting created. Business central on prem version is 23.4 Thanks in advance.
-
Deepinserts not working
I have been trying to create an api page with subpage that allows deepinserts, but have failed in doing so. I have seen many other working examples, but could not get mine to work. I have been looking at https://github.com/manjusree16/AL-Demos/blob/master/CustomAPIorderExample/Table/Call_API.http and was able to duplicate…
-
To provide Vendor Payment Bank upload file
Hi Everyone, I would like to export payment journal lines in a format accepted by our bank. I have the required file format and have tried using Data Exchange Definitions, but I’m not getting the output as expected. Could you please advise how I can customize the export format? Are there any recommended approaches for…
-
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.
-
consume an external web service from navision
Hello, I would like to consume an external web service from navision, my current version is BC 14 and i try to do it using codeunit. thank you in advance.
-
Codeunit.Run no working when triggered from event subscriber
Hi All I have a requirement to copy fields from one record to another - not a simple copy so cannot use transferfields. Something like sales order to Sales Invoice transfer of fields. I'm finding it difficult find a trigger for below [EventSubscriber(ObjectType::Table, Database::"Service Item Line", OnAfterValidateEvent,…
-
BC 365 cloud use VPN to access OnPrem webservice
1. Is it possible to configure VPN (or use existing Azure VPN) access to local webservice? 2. If it is possible, how to do that? Our customer want to POST and GET data to/from local web API. Customer has already configured VPN tunnel in Azure platform and migrating Dynamics NAV to BC 365 Saas. Any help needed. Thanks in…
-
Rollback in bulk Insert using API calls
Hi, Inserting multiple records into the Business Central database using API calls is possible. We can also combine several operations at a single request. However, if any part of the request fails, I may need to roll back the entire operation. How can I achieve this? Additionally, how can I test it in Postman? I attempted…
-
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…