-
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
-
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.
-
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…
-
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
-
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…
-
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…
-
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…
-
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…
-
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:…