Month End Tasks to Close Accounting Period with Dynamics 365 Business Central or NAV

In standard Microsoft Dynamics 365 Business Central or NAV there is not a “hard-close” for a month-end. However, there are many month-end activities that can be completed. This blog provides a high level of elective processes and tasks for closing period within Business Central or NAV.

Source : Evolution Business Systems
Read more…

Toggle Overlapping Time Periods using the Calendar Table

I had a great question pass my way last week while I was at the Microsoft Business Application Summit. The problem presented by Matt (a different Matt, not me) was that he had around 200 measures already written, but wanted to be able to toggle the report pages between YTD and Full Year data. For the sake of this article I will be using Year to Date (YTD) and Moving Annual Total (MAT) as the 2 toggle events.

Bron : Excelerator BI
Lees meer…

Dynamic Period variance with DAX in #PowerBI

One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once I got it; I came to know it was not at all tricky. In fact, it was far too simple to admit the time spent ?

When I showed PARALLELPERIOD and SAMEPERIODLASTYEAR measures to my business user, he asked me if he can select random quarters and measure should always get the variance from the earlier period based on the slicer choice than Time intelligence.

Bron : Prathy’s blog
Lees meer…

Fiscal period related autotext codes in column headers for Microsoft Dynamics Management Reporter

Management Reporter offers a variety of formatting tools to automate reporting and quickly put reports in the hands of stakeholders. This video introduces the ability to add dynamic report headers to calculated columns to avoid having to manually edit report headers prior to generating a report.

Bron : Microsoft Dynamics NAV
Lees meer…

Lot Accumulation Period vs Rescheduling Period for Dynamics NAV Manufacturing

With the release of Dynamcis NAV 2013 and NAV 2013 R2 (Navision 8.0 and 8.1 respectively), there has been a few improvements in the existing functionality. One of the more notable ones that I’ve been meaning to write about is the enhancement to how NAV create the planning worksheet

Bron : Confessions of a Dynamics NAV Consultant
Lees meer…