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 […]
Category Archives: Dynamics Nav
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 […]
Microsoft “Query with ID 1850 could not be found” bug
In Nav 2017 and 2018 you can be faced to this error “Object of type Query with ID 1850 could not be found” in several case, most common and user-blocking is when opening a released purchase order or purchase invoice : This is caused by the standard extension installed in the base provide by Microsoft […]