-
Adding new field to Base App Drop down field group view
Hi All I want to add a new field to a drop down such as sales order selecting item field group, I can only use addlast with existing field group. Is this a limitation so I cannot say set a custom field appear next to the Item No when selecting items for example?
-
How can I handle exceptions in Robotic Process Automation (RPA) workflows ?
How can I handle exceptions in Robotic Process Automation (RPA) workflows without stopping the entire bot? I'm currently developing an RPA workflow using UiPath to automate invoice data entry from emails into an ERP system. Occasionally, some invoices are missing fields like the invoice number or date, which causes the bot…
-
EURO Conversion Tool
Hello, we are working on NAV 5.1 and will need to convert our Croatian company to EUR soon. Could someone please share the latest available EURO conversion tool? Unfortunately we do not have access to the partner source. Thank you! laulas
-
"all of your selections were processed" BC message
Hi All, Has anyone seen a message like this one? It seems hard to debug, I haven't found any info. I suspect is some piece of code doing something and then BC when finishes shows this message a few times, so you have to click several times. Any ideas? thanks. Edit: it was the batch posting codeunit, there was a piece of…
-
How to implement OIOUBL 2.1 in NAV 2017 (codeunit 13609)
Hi experts, It seems to me that the newest version of OIOUBL has a lot of changes. Do any of you have the code in NAV 2017 codeunit 13609, so I (and everyone else) don't have to write it myself? Or can you please help me in any other way with this huge task? Best regards, Morten
-
Missing Codeunit 9998 and 9999 of Upgrade Routine NAV2017 to BC 14 Spring 19
Hi, I have to codeunits as part of the Upgradeprocesss. Codeunit 104000 UPG.DE and 1 Codeunit 104100 UPG Local Functionality. When I compile the objects I get the Errors: Codeunit 9998 does not exist. Coduenit 9999 does not exist. Where can I find these objects to to compile succesfully? These cu are not part of the…
-
How can I change my Mibuso E-mail address in my user profile?
I have tried to go to https://mibuso.com/account/user-profile then change the "E-mail adress" then type the "Current password" then click "Save changes" But nothing happens and I get redirected to this url. https://mibuso.com/account/user-profile?recaptcha-failed
-
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