-
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…
-
Advanced Integration of IoT and Predictive Maintenance in Dynamics 365 Field Service?
In recent months, I’ve been exploring ways to integrate IoT devices into our Dynamics 365 Field Service environment to improve our predictive maintenance processes. Specifically, we want to leverage the real-time data from IoT-enabled equipment to automatically trigger preventive maintenance tasks before equipment failure…
-
Identify which field has been modify in table
Hi can any body help me out in finding the paticular modified field in table.(i.e if i modify UOM then changed field (i.e unit of measure )is reflect on modify trigger.)
-
Generate QR Code for a report
I am trying to save a report output in qr code format; so that when users scan the qr code, the report shows. Any advise?
-
LS Retail Statement Closing Issue - Unposted Transaction
Dear LS Retail Experts, My client is running POS in offline mode. Transactions are generated in POS, replicated to HO, Statement is calculated & posted at HO & Item ledger entries are replicated to POS. There are transactions which are not posted by Statement and remain as unposted in "Transaction Header" & "Trans. Sales…
-
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…
-
How to make a field mandatory...newbie question
Hi, I'm quite new with Navision so please don't shoot me :-) I want a field in a table to be mandatory (let's say 'Email Adress'). Also when creating a new record in that table through a form and the user forgets to fill in the 'Email Address' and wants to enter another new record or closes the form I want to inform the…
-
Merging PDF Documents
Does anyone have any experience of merging a PDF document with another one. I basically have a PDF document that i want to use as a watermark and want to place this document on top of the PDF document that i generate. I am using Amyuni as my PDF converter?
-
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…
-
To call Nav Webservice from Nav CAL Codeunit code
Hi friends... I need help to find a solution with an issue.... I need to call a Nav webservice from a Nav codeunit... I have searched in many posts on internet but I don't find what I'm really looking for. Let me to explain: I have published a Nav codeunit as webservice. It is supposed to be call from external source (this…
-
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…
-
Website Cache Pages
HI, we updated our website recently and since then the page is not dispalying correctly on our Tills when i use the Navigate Command. When i changed the page I want to navigate to from our own site to Google i have to refresh the page on the till before Google opens. This is leading me to believe there is a hard cache…
-
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…
-
Help needed for research on Data migration
Hi, I am doing research on data migration with Dublin City University. If you're a consultant involved in data migration or a business user who implemented D365 Business Central please help me by filling the research survey. Thank you very much for your help…
-
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…
-
Edit custom field on Sales Invoice Header easy way?
Hi All To edit a field I have to follow how MS done with codeunit 1409 "Sales Inv. Header - Edit" and special page (update) . I'm wondering if there is an easier way to create a field that can be edited from front or back end like in sales order
-
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:…
-
TableSync 'move' fails
In an updated 2013 (to 2016) database I'm having issues with a table sync upgrade. I've copied the original table to a new temporary table. Removed all code and variables from the new table. All fields are the same and so is the PK (even ran a text compare to confirm). By my upgrade CU is throwing this error:Sync-NAVTenant…