-
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
-
Tenant Media
Dear, I have an issue wrt datbase size. After 1 year of implementation, one of the database size has increased to 405gb, reason is the major change is size of tenant media table. What is suppose is that attachments of documents & auto email attachments are getting saved in db. I am thinking correct, if yes, how cani…
-
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.
-
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…
-
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…
-
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?
-
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…
-
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
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
2018 Export EFT IAT separate file per vendor on export - need one file to include all vendors
Hi everyone NAV 2018 Data exchange definition for ACH94 for RBC to use Export IAT is set up. All the formatting is completed and everything is is correct, except, the export (Generate EFT) creates a separate file for each Vendor in the Payment Journal. It seems that Code Unit 10320 (EFT Launcher) and Code Unit 10097…
-
Dynamcis 2018, A user does not see "all" the data.
Hello. I work with Dynamics 18 and almost 300 users. I have a user who, while working on their computer, cannot see all the data in a table, only up to a certain line, after which no more data is displayed. However, if they switch to a different computer, they can see everything correctly. The computer was replaced, and…
-
Home Page field in the Customer Card is still accepting 80 characters in BC24
We are upgrading BC On-Prem from 22 to BC24. I see the following code. When I go to the customer card, it allows me to enter only 80 characters instead of 255. I have downloaded the symbols. Please advise. #if not CLEAN24 field(103; "Home Page"; Text[80]) { Caption = 'Home Page'; ExtendedDatatype = URL; ObsoleteReason =…
-
Business Central - Send Invoice For Approval via API?
Hi, I know I can 'Post' an existing invoice in BC using the API endpoint /purchaseInvoices(InvoiceGUID)/Microsoft.NAV.Post , but is it possible to send an invoice for approval via the API? Many thanks, Jonathan
-
Starting BC Development from Scratch (again)
So, back in 2-tier, I used to be a pretty good developer (mid-mid-grade). But I haven't done any development since about... 2008? Now I need to get back into it, but it's changed quite a bit. I can still read AL for the most part, but the Visual Studio thing is really messing me up because I used to use object designer. I…
-
Navision 2016 RTC stop working after login when using public IP address
I have installed Dynamics Navision 2016 CU67 on a Azure VM (Windows Server 2019 Datacenter). In SQL Server 2019 I restored a back-up from the Dynamics NAV 2016 application that is running on-premises. The reason for the new server is that the customer wants to use the NAV 2016 environment as a reference/history…