-
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…
-
Importing a xml with external DTD (NAV 2015)
Hi all, I am trying to import an xml file with an external DTD into NAV 2015. We are migrating from 4.03, in this version it was runnig well. Now I am getting: For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the…
-
How do I download and use DotNet Packages in BC25
I need to transliterate non-latin characters and found a DotNet package in the package manager NuGet. I don't know how to download it from the command line and make a proper dotnet project yet, but I can download it manually, which gets me a ".nupkg" file. Is this usable in my AL project? Do I just put the it in the…
-
BC (SaaS) Webhook for invoice fully paid (closed)
Hi, I'm looking to implement a webhook in Business Central (SaaS) to trigger a notification whenever a vendor invoice is fully paid (closed). However I've listed the supported webhooks using the /webhookSupportedResources endpoint, and I can't see any that are suitable. I tried using the "v2.0/vendorPayments" resource, but…
-
Sessions are not closed on SQL server
We are running BC20 cu7 OnPrem. We are having some issues with locks in our solution and we have discovered that many sessions are not "deleted" from SQL server even though it is several days since their connection were closed. If we go into Database locks in BC sometimes a user is shown and sometimes there is no session…
-
Save file to Server BC25 OnPrem
Is it still possible to save a file to a server location within Business Central 25 on-premise? Is anyone able to share a working example? Thank you. The current solution doesn't appear to save to the file path: FilePath := \\SomeServer\SomeFolder\File.txt
FileMgt.BLOBExport(TempBlob, FilePath, true);