Multi-companies solution designing in Business Central

Some of you might have struggled against Business Central companies architecture. For exemple you can need to build a page showing aggregation of table across all companies, or create a process that will run on Company A and then post something in Company B. The C/AL and AL code allow us to use “CHANGECOMPANY” on […]

Nav XSD Paser patch for XMLPort generation

If you plan to work arround an huge xml file import/export and help yourself with the standard XML schema viewer, you should know about the useful “Generate XMLport” function : Two problem I’ve been hurted with this : – With repeating node name a number is added surrounded with < >, the variable can’t be […]

Automate your C/Side to AL Data transfer (Business central v14)

If you plan to read this post you’ve probably already worked or planned to on C/AL to extension convertion. This post does not treat about the base update or AL convertion but only about the data transfert from c/al to extension. AL extension data are stored differently than C/AL : adding fields on customer table […]

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-2 Visual studio C# source project here FTPS-For-Nav-SOURCE Install thoses two […]

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 […]