9 Feb’18

Dynamics NAVDeferral of Income & Expenses in Navision

Introduction:

Microsoft Dynamics NAV allows you to set up deferrals of income and expenditure. These allow you to post transactions into a particular month but then spread the financial effect over a number of periods in a way you can specify. This article explains how to set up and use this functionality.

Set up:

First, you need to create a Deferral Template which will define how the deferral will work. To do this, type “deferral template” in the top right hand corner of the screen and open the Deferral Template list. You should see a screen like the following:-

Deferral Template List

Either click on Edit to modify an existing template or New to create a new one.  You should then see the following screen:-

Deferral Template Card

Fill in the fields as follows:-

  • Deferral Account – This is the GL Account code the deferral will initially be posted to.  This would normally be a Balance Sheet account;
  • Deferral % – How much of the initial posting is to be deferred (can be from 1% to a maximum of 100%);
  • Calc. Method – How the deferral will be calculated.  This can be one of:-
  • Straight-Line, where an equal amount will be applied per period from the Starting to Ending Dates specified in the schedule;
  • Equal per Period, where an equal amount will be deferred per period;
  • Days per Period, where the amount deferred per period is based on the number of days in that period as a proportion of the total number of days in the whole deferral period;
  • User-defined, where the amounts for each period are entered manually.
  • Start Date – This can be one of:-
  • Posting Date, the Posting Date of the document that generates the deferral;
  • Beginning of Period, the beginning of the period in which the document is posted;
  • End of Period, the end of the period in which the document is posted;
  • Beginning of next period.
  • No. of Periods – How many periods the deferral will be spread over.

These are only default values, as we shall see later they can be amended on individual transactions if necessary.

The next step is to assign the template to transactions. The simplest way to do this is to assign it to either a G/L Account, Resource or Item.  To assign it to a G/L Account, open the Chart of Accounts list, click on the account you wish to set the template for and click on the Edit button.  You should see the following screen:-

Chart of Accounts List - Assigning the Template to Transactions

On the Posting tab, set the Default Deferral Template as required.

You can now start to use the Deferral functionality.  We will use a purchase order as an example.  Create a new purchase order and add a line for the G/L Account code you assigned the Default Deferral Code to.  Add a Quantity of 1 and a Direct Unit Cost.

Use the Choose Columns functionality to make sure you can see the Deferral Code field.  By default, you should able to see the code as in the screen shot below. You can add, delete or change the code if you wish.

Deferral - Purchase Order

To see the effect the posted deferral will have over time, drill down on the Line button below the Lines caption on the page and click on the Deferral Schedule option. The following screen should appear:-

Edit Deferral Schedule

You can amend the deferral amount and dates and change the spread of the amounts over time if needed.  If you do make any changes, you may need to click on the Calculate Schedule button at the top of the page to recalculate the deferral amounts.

Now receive and invoice the order. Note: You will need to set the Posting Date range on either your User Setup record or the General Ledger Setup date range to allow you post up to the last period the deferral will cover. If you do not, you will see an error message that a Posting Date is not within the allowed posting date range.

Now bring up the Posted Purchase Invoice you created when you invoiced the order and click on the Navigate button.  If you view the G/L Entries for the invoice you should see something like the following:-

General Ledger Entries - Deferrals

As you can see, the cost has been posted to the deferrals g/l account rather than the account specified on the purchase order and the first month has then been reversed out and posted to the original account in accordance with the deferral schedule.

Note that you cannot see the reversals of the deferral over the subsequent month of the schedule. To display these, remove the filter of the Posting date by clicking on the red x button immediately to the left of it.  You should now see the following screen:-

General Ledger Entries - Repairs and Maintenance

Conclusion:

As you can see, this shows the original entries and the entries that reverse out the deferral over the period of the deferral schedule.

This Feature of Deferral is Available after NAV 2016 version only.

Written by

Sunil Dhing

ERP Team Leader

Leave a Reply

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

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Commands to Import .bacpac file to D3FOE SQL Server

    14 May’ 2018

    Introduction: This blog article will explain how to import a .bacpac file to Microsoft SQL Server which is created from ...

    Read more
  • [Solved] – Backspace not working in HTML Web Resources

    11 May’ 2018

    Issue: When we use a HTML web resource in Dynamics 365 CRM forms or even as a separate navigation, we sometimes face is...

    Read more
  • Dynamics 365 Tip: Sending Emails using Unified Interface

    10 May’ 2018

    Introduction: The unified client which was released D365 V9 had a very refreshing UI and lots of features. One of the b...

    Read more
  • Filtering Records on BPF unlike on Form – D365

    10 May’ 2018

    Introduction: Working with D365 is best when you’re trying to use as much OOB stuff as possible. Simplest configurati...

    Read more
  • Filter records in gallery control based on value selected in other gallery control in PowerApps.

    10 May’ 2018

    Introduction: This blog explains how to Filter records in gallery control based on value selected in other gallery cont...

    Read more