Posted inDynamics NAV & BC Tips & tricks
Finding duplicates with AL
In this video, I demonstrate a simple way to catch duplicate records during input. Check it out: Source : Hougaard.com Read more...
Posted inDynamics NAV & BC Tips & tricks
Dynamics 365 Business Central: How to find duplicates via AL (Filter for duplicate values)
I was asked an interesting question on LinkedIn yesterday, is there a way to find out duplicates via AL? So in this post I would like to briefly talk about this topic. First of all, as test data, I use the copy feature on the Item…
Posted inDynamics NAV & BC Tips & tricks
Forbidden Knowledge: How To Find Field Values from External Apps in Business Central
I was working on a report in Microsoft Dynamics 365 Business Central recently, and the client wanted the report to show a value from an extension that was not a dependency for my customizations app. Because I am lazy efficient, I did not want to go…
Posted inDynamics NAV & BC Tips & tricks
Learn how to use the right Find* Function
In this video, I talk about the different Rec.Find function. Source : Hougaard.com Read more...
Posted inData & Analysis
Find and Delete Duplicate Photos with Power Query
I was trying to clean up my hard disk drive on my PC the other day. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here). After running the…
Posted inDynamics NAV & BC Tips & tricks
Find the best price with Dynamics NAV
During a visit with a customer, we discussed the price/rebate functionality in Dynamics NAV, and it became apparent that there is some confusion about how it works. Dynamics NAV operates after a principle called Find the best price, which means that it will go through all…
Posted inDynamics NAV & BC Tips & tricks
Find and Replace Data in Dynamics NAV 2016 with RapidStart
Overview One of the powerful tools in the old Navision classic client was the ability to do a Find/Replace. For example, if you wanted to change the Salesperson Code on the Customer Card from one value to another, just go to the field you want and…