Using FTP over SSL/TLS (FTPS) in Business Central

I’ve made a .Net lib to access FTP over SSL/TLS functions from Nav/Business Central on Premise. It’s bases on limilabs Ftp.dll. This one is accepting all security certificate including self-signed. Do not confuse with SFTP that is FTP encapsulated in SSH. Download it here : FTPS-For-Nav.zip Install thoses two DLLs in service and roletailored client addin […]

Nav Objects Versionning Manager

This simple page allow you to manage massively Nav objets modified,date,time and version. Helpful to rset object modified and follow new modification to deliver. Original object made by Christian Gilles download link above Page 77000 Versionning Object Managment (6,02Ko)

Microsoft Nav 2018 CRM connector date conversion bug

If you’re using the Nav to Microsoft CRM connetor you can have a date transmission error with message about DMY2Date paramter out of range. I found out a function used in codeunit 5302 Outlook Synch. Type Conv called “TextToDate” handling conversion in MM/DD/AAAA format. The connector send to this function a FORMAT(Variant) so it can […]

Customize Dynamics 365 CRM connector for Nav

In this post we will see how to modify and add custom table to Nav connector for Dynamics 365 CRM (also working with Ms Dynamics CRM 2016). Since Nav 2017 Microsoft decide to integrate a CRM connection system directly in Nav. With this system all data integrations are managed Nav side for both “Nav to […]

International Core model migration audit for Business Central

Some Micrsoft Dynamics end users/companies start wondering about the future for their ERP when they heard talking about Business Central and cloud services incompatibiliy with C/AL. Specially when they invested huge amount of money in tuning their ERP. Extension technology is a great thing for Dynamics future and have plenty of long term benefits. But […]

Extension : Show invoice/cr. Memo from shipments and receipts

This extension help you to open invoice or credit memo fastly with a new action button from following pages : Posted Sales Shipment Posted Sales Return Receipt Posted Purchase Receipt Posted Purchase Return Shipment Item Ledger Entries The Invoice/Cr Memo is retrieved with the value entry linked to the item ledger entry. In case of […]

Http web request SSL validation

You may need to communicate with external web component in Nav, such API like E.commerce or other applications. To do that you can use code unit 1297 for simple page or Rest API and code unit 1290 for Soap API. I find out that Http Web request component from Microsoft .Net frame work don’t allow […]

Fast Nav URL encoder C/AL

If you need to send URL through external component such as web API or control Add-in, you may have to encode the text for ascii to ansii purpose (like replacing space by %20 and so on). Gunnar post a code unit for that here but it’s not working with latest version of Nav, I’ve correct […]

Exporting Nav object as text with C/AL code

Title say it all. I searched a way to export Nav object as text and only way I found is to call finsql.exe command with some arguments. I needed this functionnality to export independntly each object as text file for source code managment purpose. Please note that this code can’t be used if the user […]