Updated NAV 2016: Deferred Postings – close but flawed

Update – I’ve had multiple conversations with the product team at Microsoft from the day after I posted this and the issues I highlighted have been recognised and I’ve been assured they will be fixed. I meet up with the guys responsible for financials functionality last week at Directions US and it was obvious from the questions they are well advanced with the detail of the solutions. If I was a betting man I’d put money on a cumulative update fixing it, one month soon.

You have to give respect to Microsoft, for such a huge company with such a successful product to respond at the rate they did is remarkable. Makes me very confident about the future.  I’ll post another update as soon as I know more.

So Microsoft have almost eliminated one of the most common customisations in Dynamics NAV 2016 and enabled both sales and purchase transaction to be posted with the revenue or cost spread across multiple accounting periods. By selecting a Deferral Code on the line of sales or purchase documents you can spread the posting across as many periods as the transaction line applies to.

For companies that are selling or purchasing a services such as warranties, contracts, subscriptions or insurances this correctly represents the cost or revenue in the month the service was for rather than the month it was sold or purchased.

Why the almost in that first sentence? Well they got lots right but two fatal flaws mean its not really useable for most as it is.

The Good : Lots of flexibility

So Microsoft did a great job of giving lots of options about the spread of how the cost is spread. First you have select a deferral template code on the line and that code defines how many periods the account is spread over as well as when it starts.

You have a calc. method that determines how the cost or revenue is split across the different periods – most will be straight line I suspect but you do have equal per period, days per period and user defined if all else fails.

That start can be relative to the posting date of the originating transaction and you can make it the beginning or end of the period. If it’s the posting date it takes an amount into that period, that represents the number if days left in that period.


Even better the template is applied as soon as selected and you can manually adjust it by selecting the Line, Deferral Schedule option – really good so it you have an initial and ending ‘documentation fee’ for instance you can do the split correctly.


The Bad: It’s all pretty useless as it is

So having done all that good work Microsoft left two massive issues which makes me believe that this will need two significant customisations every time before its useable. To quote a customer who I went through this with last week, ‘like this it’s about as much use as a chocolate teapot’.

Standard Date Restrictions still apply

The first and most significant is that the standard posting date restrictions still apply to the deferred postings! That means that if you operate best practise and restrict your users to not posting past the end of the current period they will never be able to use deferrals at all!

What this really needs is a separate date restriction in the general ledger setup for deferral postings. Then you need to make calls to check these new dates in two places in in codeunit 12 and a few more in the new Codeunit 1720 for Deferral Utilities.

The same Deferral Templates apply to both sales and purchase transactions

The second issue is that on the deferral templates you define the control account you want the deferral to. No issue with that except that you can select any of the templates from either the sales or purchase transactions. That means your accrual and reserves are going to get mixed up if your input people are not very careful in deed.

Now I’m not an accountant but I am aware of how sensitive accountants are about their what’s accrued and what’s reserved. The whole point is that they mean you correctly represent your current financial position so having the possibility of posting one to the other just doesn’t bare thinking about.

There should be a type field on the deferral template with a filter on the lookup from the sales and purchase lines so they can only select the correct templates.

What especially annoying is that the customisations needed to put this right are invasive ones that cannot, as far as I can see, be done using the new NAV extensions. Its modifications to some of the most commonly modified objects line sales line as well.

So in summary showed promise with this Microsoft but lost it at the final run in. Please get it right in ‘Madeira’ (the version that will be released in 2017) please.

Author: James Crowter

I’m passionate about how businesses can improve their efficiency by getting process optimal more of the time. For the last twenty five years I’ve worked to help organisations of all sizes and types implement the ERP & CRM software that typically they decide they need when things are going wrong. I’ve seen that work unbelievably well and enabled those organisations to rapidly grow but I’ve also had some hard projects over that time where it’s felt more like warfare at times. Since 1996 (and version 1.01) I’ve been working with a small Danish product called Navision that’s now become Microsoft’s Dynamics NAV and I’ve also been using and consulting around Microsoft CRM since 2005. As managing Director of one of the longest established first Navision and now Microsoft Dynamics partners I’ve been involved in the complete history including numerous product councils and system design reviews. It’s my privilege to know many of the key Microsoft executives and product designers and have insight into both where the products are now and their future direction. So colleagues & clients have asked me to start this blog to share some of the insight that both this knowledge (obviously where not restricted by NDA’s or client confidentiality) and experience can help. Specifically I want to concentrate not on the specifics of how (there are some great blogs already for that) but why. If any user helps their business make better decisions or consultant can give better advice then that will be objective achieved. I founded Technology Management in 1992 and have led from the front ever since. Helping clients use technology to grow their business is my passion through explaining technology in terms that everyone can understand. My interest in computing began at the age of eight, long before my school had the equipment to cope. Throughout school and university I developed software commercially. I hold many IT certifications, such as Microsoft Dynamics NAV (for over 17 years), Microsoft Dynamics CRM (for over 10 years), as well as Microsoft Windows Server, Exchange and SQL. In October 2015, I was awarded the title of Most Valuable Professional (MVP), a title given to a select few individuals (31 currently) across the world specifically for Dynamics NAV. After years of working with a range of distribution and manufacturing software for hundreds of organisations, I focus on understanding the business requirements of an organisation, what it will take to deliver the systems required to maximise their potential. Follow me online via my other social channels: - Twitter: @jamescrowter - LinkedIn: linkedin.com/in/jamescrowter Or email me directly at james[.]crowter[@]tecman.co.uk.

Leave a Reply

Your email address will not be published. Required fields are marked *