Latest Posts
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 […]
Integrate Business Central data (Onprem&SaaS) in PowerPlateform through CDS
Already eard about Microsoft CDS ? Since Business Central V16 + you can synchronise Business central data into the CDS entities on Microsoft cloud, in order to use them with the power plateform tools collection (power automate, virtual agent, power BI …) and it’s also working with Onpremise Business central NB : it was in […]
Upgrade Business central base V14 to V15 (wave 2)
You got a Business Central V14 with extension and/or data you want to bring in Business central V15 ? Let’s take a look at the microsoft guideline : Technical Upgrade to Dynamics 365 Business Central 2019 Wave 2 I personally followed Microsoft process but it turns out that several details and step are missings so […]
Social features lack in ERP software
I’m not hearing a lot about the social ERP subject yet we are the more and more people working together remotly, I think this deserve more attention. My insipiration come from social network, Monday.com, Asana, Yammer, Teams and so on. Project managment system like Monday.com got very nice social oriented features. Using this idea for […]
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 […]
Global Dimensions Change “Incomplete” Problem
Today I found two problems in the function”Change Global Dimensions” (available on “General Ledger Setup” Page) who let an general update of all table containing field about those global dimensions. Roberto Steffaneti wrote a how to use here. Very simple. Though there is two major problem with this function in NAV 2018 Microsoft code describe […]
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 […]