Recurring Journal Document Numbers

A very dry title about a very handy tip for users (or potential users) of Recurring Journals. This works in Microsoft Dynamics NAV 2009 and Serenic Navigator, for all versions going back for the last 10 years, so you don’t have to be running the latest and greatest to make use of this.

When using Recurring Journals, there are some ways you can have the document number or description be automatically updated. Let’s look at this example:

In the Document No. field, we have the odd looking setting 2011-%3-COMM. In the Description field, we have normal looking descriptions, but with an odd %4. (To see more about the Recurring Frequency formula shown in this example, please see our post DateFormula Part 1: Closing Tricks.)

When posted, that’ll look like:

%X options in those fields are substituted with Posting Date based information. Here’s the list of options:

Code

Result:

%1

Current day (for example, Monday)

%2

Current week (for example, 52)

%3

Current month number (for example, 1)

%4

Current month name (for example, January)

%5

Current accounting period name (for example, January)

 

The only small downside to the options is that you can’t do ’01’ instead of ‘1’ for the month, or padding on other numerical options. All in all, though, it’s a nice little extra touch to making your recurring entries crystal clear.

 

Please note this is a simple example and depending on your accounting practices, commissions may have to be handled with Accrual/Reversing Entries.

About the author

Jeremy Vyska Jeremy is a technology enthusiast and often plays the part of “wise old man” to his friends and peers.

Tags: