-
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);
-
Business Central chocolatey docker install
Hi All, I've spent a while trying to make this work but unfortunately it's a dead end. As you may know docker desktop requires a licence if you are going to develop with it, most likely everyone is ignoring this... Following microsoft's help:…
-
Issue with default user e-mail from Outlook - BC14
Good morning everyone, In the past few days, we have been experiencing an issue with the email associated with a BC14 user account. Specifically, there has been a domain change in the email address associated with the Windows/Microsoft account: for example, from test@XXXX.com to test@YYYY.com. The Windows account settings…
-
How to Disable table trigger in Business Central with AL extension
Hi, I want to disable table trigger on item category table for Parent Category field(2; "Parent Category"; Code[20]) { Caption = 'Parent Category'; TableRelation = "Item Category"; trigger OnValidate() var ItemCategory: Record "Item Category"; ItemAttributeManagement: Codeunit "Item Attribute Management"; ParentCategory:…
-
How can we create a zip archive with several files in business central, wave 2, cloud extension?
I'm downloading four xml files generated in nav. I'm working with bc15. Does anyone know how to create a zip archive with several files in bc15 cloud extension?
-
Weird NAV2017 behaviour in XMLport with Reserve characters
In XML, the characters &, <, > and % are XML reserve characters, and is supposed to be "escaped". I observer different behaviors on the same version of NAV2017 10.0.30172, that some instance escapes XML reserved characters, and some instances do not. They are of the same version and build. What gives?
-
Remove Bulk Assembly Orders
A client is requesting the ability to remove bulk Assembly orders at once via selection. Would that be possible?