Synchronizing Business Central with Dynamics For Sales, Dataverse or Power Platform is a common need. For the ones who worked with the Business Central Connector, you may have some awful experience with it. However the underlying process to connect with it is not that complicated :Both OnPremise CRM and Dataverse have the same API capability […]
Category Archives: C/AL – AL Development
Get ride of App dependencies using References
If you ever worked on multiple Business Central extensions, you may know the struggle with dependencies. The Issue When we need to access a table, page or anything else that come from another extension, then you need to set your own app depending on it, and this happen quite often. This drive to two major […]
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 […]
Install Business Central OnPremise Sandbox in three simple steps
Do you know Docker and why it’s a powerfull software ? This software allow you to encapsulate overall heavy application in parallel OS (there is a very small latency but overall performance is same as your PC because it’s not running virtualized like VMWare does but truely in parralal than the host OS). This is […]