Dynamics 365 Business Central mini tips: How to open the environments selection page

With Business Central online, you can easily get a safe environment where you can test, train, or troubleshoot without disturbing your company’s work processes or business data. Such a non-production environment is called a sandbox. Isolated from production, a sandbox environment is the place to safely explore, learn, demo, develop, and test the service without the risk of affecting the data and settings of your production environment.

Source : Dynamics 365 Lab
Read more…

“Field Selection” codeunit – how I select and record the ID of a field in Business Central

Recently I have been working on a customization for a customer with the goal of changing the out-of-the-box Positive Pay export for a Bank Account record.

While preparing the mapping for the positive pay details, I noticed the way Microsoft wrote the picking up of a field ID. They created a new codeunit: “Field Selection”.

Source : Business Central Musings
Read more…

Dynamic Column Selection In Custom Columns In Power BI/Power Query/M

When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you reference column values dynamically? For example, given the following input table:

Bron : Chris Webb’s BI Blog
Lees meer…

Application Design Pattern: Report Selection

From the PRS workshop at NAVTechDays 2014, this pattern was written by 2 work groups:
•Group 1: Dale Gauci & Kimberly Congleton
•Group 2: Jens Winberg, Tim Grant, Alen Tot

Thanks to Tim Grant for merging the two patterns, correct, send for review, and finalizing them!

Bron : Microsoft Dynamics NAV Team Blog
Lees meer…

Selection Filter to Clipboard

I have now seen three posts about using Excel to help create a Pipe Filter. The latest one from Mohana is similar to the way I normally do this. His post is a followup from the original video from Kerry Rosvold and an alternative from Mark Brummel.

If this is something you frequently need to do, why don’t use NAV and skip the Excel part ?

Bron : Gunnar’s Blog
Lees meer…