In this video, I tackle a question from a viewer on how to deal with odd accounting periods, in this case, how to get G/L Entries to be easier to query when you have 13 periods in a single year. Check out the video:
Tag Archives: Period
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.
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.
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.
NAV AS 101 Lesson 10: Comparison Period v. Comparison Date
NAV Account Schedules uses a curious convention to determine periods of time in the column layout. The default option if you open account schedules for the very first time is Comparison Date, but I always recommend NAV users use the other option, Comparison Period. Let’s talk about why.
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.
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