-
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…
-
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…
-
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 =…
-
Currency Exchange Rate Service - Remote Certificate is invalid according to the validation procedure
Hello all, I hope you can help me. I try set up the automatically Exchange Rate Service of Navision ( am running NAV2018 CU19). But when I try to enter the Service URL (that is also entered by default in the Cronus Company) https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml I always get the error message "The…
-
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…
-
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…
-
If I know the ID of the XmlPort, how can I know its name as text in a local procedure?
trigger OnInitReport() begin expXMLPORT(Xmlport::MyXmlportName); end; var XmlFileName: Text[30]; local procedure expXMLPORT(IDXml: Integer) var OutStreamVar: OutStream; begin XmlFileName := Here I need get "MyXmlportName" as text
-
Error "Table Product Group (5723) is obsoleted" during NAVDataUpgrade
This is an Upgrade from 2009 to BC 14 (on premise) by way of NAV 2015. Upgrade step UpdateItem failed with error: "Table Product Group (5723) is obsoleted ..." Isn't this the job of the data upgrade to transform the data stored there to "first level children of Item Categories" as stated as reason for obsoleting the table…
-
How to Add a Color Legend with Labels at the Bottom of a List Page in Business Central?
I want to display a color legend with labels at the bottom of a list page in Business Central, similar to the example in the attached image. The legend should contain colored squares followed by descriptive labels, aligned horizontally, to indicate different statuses or conditions of the records shown in the list. What…
-
MARK all the records from a table
Hi friends... does exist any way to select all the registers of a table and set them as Marked (TRUE)? Something similar to MODIFYALL but MARKALL or something like that... My issue is the following... I have a very big table. We have a page with two parts, on TOP User can apply filters on different fields. For a better…
-
Business Central v23 SignalR error OnDisconnectedAsync
Hello, I am at my wits end here. I have Windows server 2022 and Business Central v23 CU9 installed. I am getting SignalR error whenever browser client is closed. The below error is for Cronus with extensions that come out of the box. Same happens with another instance with just base application and couple of small…
-
BC Version 24 - specific error message concerning transfer orders + item tracking - SoLVED
Hello everybody, One of my important users just switched to BC 24 and was working fine with it – until today. We can not find the problem, but maybe you have an idea what this could be… funny wise this problem shows up only with some of the items. Not all of them! But there are no differences in the “setup” at all. BC…
-
Malaysia MyInvois Certificate Signature
Hi All, I am using cloud BC. by the way , does anyone know how to generate certificate signature in Myinvois Malaysia? https://sdk.myinvois.hasil.gov.my/signature/#document-signed-data i saw someone share for other language https://github.com/mokth/einvoice/blob/main/Step to Generate Signature (updated ).pdf but not sure…
-
Printing DataMatrix, QR and FNC1 barcodes in Business Central
We are starting the migration from NAV2013 to Business Central Saas. We produce many barcodes QR and DataMatrix using a VB.NET wrapper around a DLL purchased from OnBarcode. Is there a standard way pf producing these labels in Business Central or will we need to purchase a third party solution to acheive this?
-
Winscp archive files after uploading
I'm wondering how everyone is archiving their files with Winscp after uploading them to a SFTP site. I have everything working except I'm archiving the entire contents of a folder after the files in the folder are uploaded. The issue is the folder is actively having files inserted and I may archive a file before it gets…
-
FTP Transfer using WinSCP
Hi, here in the forum are some instructions how to do use WinSCP to transfer files. I downloaded the WinSCP-Automation package, which only contains the WinSCPnet.dll and WinSCP.exe I copied both files to the Addin Directory on my Client. If I create a DotNet Variable in my C/AL Dev Client, I see the WinSCPnet Assembly in…
-
Please help with Data exchange RBC ACH94 Amount format issues
Hi A client is on NAV 2018 and we are setting up Data Exchange Definitions for ACH94 for RBC (Canadian) and the amount format must be as follows: No thousand separator or decimal point and if the cents are zero, it should still show 00 Example : 20,000.00 should be shown as 2000000 Example : 210,150.23 should be shown as…
-
New obligation since 01.01.2025: euBP
Has anyone had anything to do with the “electronically supported tax audit of the German pension insurance”? Originally, only payroll accounting systems were affected, but from 01.01.2025, virtually every financial accounting system must be able to support this interface. Details can be found here:…
-
Post Sales Order From Job Queue
Hi All We have a process where sales shipment is created manually and a background job is scheduled to post shipped but not invoiced orders. I have used if codeunit.run method to capture errors and the use below codeunit for each sales order. Not sure if this is best codeunit as others such as sales-post yes/no have pop…
-
Full Rollback in Batch Posting
Hello, There is scenario where I make two sales orders during a process, and I have to post them right away. If the system fails to post any of them under any circumstances, I would like it to roll back entirely. How can I use the Business Central platform (AL Code) to accomplish this? Please share your knowledge about it.…
-
How to increase Client Session Timeout
Hi, We are using Business Central 18 Onpremises. In the server, I changed the "Idle Client Timeout to Max Value and "Keep Alive Interval" to 1 hr in Business Central administration. after that restarted the services. But still, the client system is getting a session timeout in 20 minutes. Client accessing ERP by using web…
-
PDF file size when saveas via Job Queue results in 100mb file
We have developed a report batch job that saveas a PDF file and send it via email. We observe that when set in a job queue, after running for > 2 hours (sending a lot of emails), the email server started rejecting the emails. Upon closer inspection, we found that the PDF attachments increased in size, up to 100MB per pdf…
-
Extend Retention Policy
Good morning everyone, We have to make a report/codeunit to clean up a table and we want to see if it is possible to add this table in the Retention Policy, so this cleanup report/codeunit runs automatically outside of Job Queue's. This would save a lot of time in configuration. The only problem now is that this table is…
-
Change field name in table
I need to change field name in custom table in BC OnPrem. ID remain same. When I try to install the new version of the app, the system tells me that removing a field is not allowed (even though the ID has remained the same). If I force the schema by synchronizing, the field is renamed, and the data remains in the table…
-
ScreenDisplay Dialog Customization
Hi, I'm trying to customize the pop-up dialog in Microsoft Dynamics NAV 2018 - LS Retail POS. I've attempted to debug the session, but I'm unable to determine the specific profile it's using in the POS Panel. Could you please guide me on where I can modify this pop-up? ScreenDisplay(pText : Text[250]) IF PosType =…
-
OnPrem-to-SaaS Cloud Migration Tool
Hi, I am trying to run the Cloud Migration Tool. However, I am getting the following error for a bespoke table: "Could not get the target table count.;Some records failed to be copied, most likely due to mismatch in the source and destination table schemas. Please make sure that fields in your on-premise table do not…
-
Event for on before entering sales line
Hi I have a requirement to check sales header fields entred before any line is inserted for example location on sale sheader bfore a user enters any lines. There is an event on the sales header - onBeforecreatesalesline but I cannot get it to work. Is there any better event or method to achieve this
-
Could not load file or assembly StreamJsonRpc
Happy new year to all. Today is my first day back from leave and I won an environment that doesn't allow users to connect. BC 25.1 - OnPrem When opening the web client, user is presented with: Event Log:Category: Microsoft.Dynamics.Framework.UI.WebBase.ClientExceptionStateProcessingStrategy
EventId: 0
ConnectionId:…