June 2019 – Pardaan.com

How To: Handle Files in Microsoft Dynamics Business Central Online: A 4-Part Series

I recently attended the Microsoft Directions Asia Conference for the first time. Eight employees from ArcherPoint participated in or attended nearly 80 sessions presented by Microsoft and ISVs. Team members went to different sessions and shared that knowledge. The experience was awesome. Source : ArcherPoint Read…

28 June 2019

Data & Analysis

Power BI APIs for Non-Programmers

There was an announcement made a few weeks ago by Microsoft that nearly slipped under my radar. I don’t always read the more technical announcements because I don’t have a highly technical background. Luckily I read this particular announcement as it contained a nugget of gold…

27 June 2019

Dynamics NAV & BC Tips & tricks

NavXtender Drag-and-Drop for NAV

NavXtender from Insight Works is a free utility that enables users to attach documents to any Microsoft Dynamics NAV record with a simple drag and drop. With NavXtender, you’ll easily associate customer POs to orders; invoices to POs; quality documents to receipts; or any other file…

26 June 2019

Dynamics NAV & BC Tips & tricks

How to Adjust a GST Difference in Microsoft Dynamics 365 NAV Business Central

GST amounts that are automatically calculated in General, Sales, and Purchase can be manually adjusted in Microsoft Dynamics 365 NAV Business Central. A manual GST adjustment maybe required, in cases such as, an invoice received from a vendor does not match to the GST amount calculated…

25 June 2019

Dynamics NAV & BC Tips & tricks

How To: Use Purchase Order Dates in Microsoft Dynamics NAV 2017

Date fields on NAV 2017 purchase orders can be confusing, but used correctly, they will improve your purchase order processing. The dates are designed to allow you to schedule the receipt of product in time to meet your shipment commitments and your customer’s delivery expectations. Source…

24 June 2019

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central: using OData V4 Bound Actions

I’ve promised this post to some attendees of my last Dynamics 365 Business Central development workshop in Microsoft Italy (c/o Microsoft House) last week. Question was: How can I call Dynamics 365 Business Central logic from an external application? Simple answer given by all: you can…

21 June 2019

Data & Analysis

Removing HTML Tags From Text In Power Query/Power BI

Recently I found I needed to remove all the HTML tags from some text in Power Query. I searched and found a great – if complex – function from Marcel Beug here, but I realised that since that post was written the Html.Table M function has…

20 June 2019