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 software I noticed that I had stored photos from my phone in a few different places. Each of the 3 sections below are images from my phone stored in different locations.

Source : Excelerator BI
Read more…

How To: Setup Consolidations in Microsoft Dynamics Business Central or NAV

Consolidations can be performed:
•Across subsidiary companies with different charts of accounts
•With companies with different fiscal years
•Using either the full amount or a specified percentage of a particular company’s financial information
•With companies with different currencies

Source : ArcherPoint
Read more…

How To: Moon Power Make-Up – Working with Custom Report Layouts in Microsoft Dynamics Business Central or NAV

When we do Microsoft Dynamics Business Central or Dynamics NAV development, one of our goals is to minimize the work required during an upgrade. When it comes to report customizations, we can handle this by using a custom report layout instead of modifying an existing report. It’s easier to upgrade, and it’s not any harder than modifying the existing report layout. I’ll talk you through custom report layout limitations, how you can make a custom report layout, and why you would want one.

Source : ArcherPoint
Read more…

Integrating Dynamics 365 BC manufacturing with advanced warehousing

At my last Manufacturing course at eSeven in Stavanger, I promised to demonstrate the integration between the manufacturing module and advanced warehousing. I didn’t get around to demonstrate it because we ran out of time.

So, I thought, what better way to spend a Sunday afternoon still nursing the remainder of a flu and getting ready to catch the 18:10 to Stockholm.

Firstly, let’s start with the easy one:
•Production is in the same location as the warehouse
•There are only one set of bins for flushing
•All flushing is set to Manual

Source : Aphorisms about Microsoft Dynamics NAV
Read more…

Using Dynamics 365 Business Central APIs in Microsoft Graph

Dynamics 365 Business Central is now one of the available endpoints in Microsoft Graph and I think this is a great way (and alternative to standard APIs) for interacting with the platform.

To work with Dynamics 365 Business Central in Microsoft Graph, you first need to change your D365BC user’s permission in Graph and then enable the Financials.ReadWrite.All permission scope. Here I’m using the Graph Explorer tool:

Source : Stefano Demiliani
Read more…

Item Attributes in Business Central

I’ve never talked about this feature of Business Central (and NAV 2017) that I find interesting and that can be useful. It can be used to store and manage some information related to articles in a simple way; it is not a product configurator but can be useful and can be enhanced with some small customizations.

Source: Roberto Stefanetti NAV & Business Central Blog
Read more…