Dynamics NAV

Menu

Tag Archives: How to use deferrals

Deferral accounts, or Prepaid expenses accounts, as defined by Larson, Jensen and Carroll(2002) are asset accounts. These deferral accounts contain payments made for assets to be used in the near future. As these assets are used up, the costs of the used assets become expenses.

AccountingCoach.com website points out the difference between accruals and deferrals: “an accrual occurs before a payment or receipt. A deferral occurs after a payment or receipt. There are accruals for expenses and for revenues. There are deferrals for expenses and for revenues”.

A few examples where deferrals are usually employed are Office Supplies, Prepaid Insurance, Prepaid Rent, Tax Registration for cars in countries like Denmark or Singapore.

With NAV 2016, Microsoft allowed users to automate the process of deferring not only the expenses, but also the revenue over a pre-defined schedule. To set-up a deferral code is fairly easy. Just type: Deferral in the Search field in RTC, and launch Deferral Template List page. I will go into creating a deferral code a bit later in this article.

Accounting perspective

Let’s consider this leasing car example, in which an accounting employee at Goldman Bags Bank – Danish subsidiary – is recording an invoice for customer Henrik Jensen for the Danish registration tax for his newly acquisitioned Mercedes SLC, which amounts for 30,000.00 DKK payable in 6 months. The deferral schedule with the 6 monthly adjustments should look like below:

Car Leasing Registration Tax (PRT) Schedule

How would this use case be applied in NAV?

NAV 2016 RTC

Create a 6 months deferral code

Deferral Template

Open General Journal and post the transactions below(note the deferral code on the second transaction):

General Journal transactions

Alternatively you could assign Deferral Code = ‘Leasing’ to the G/L account 86000 by opening G/L Account card and filling up “Default Deferral Template” with the desired deferral code in which case the Deferral Code will be automatically populated in the Gen. Journal Line.

Open the General Ledger Entries to check the effect of the 2 transactions posted above (filter by Document No. and sort by Entry No.):

General Ledger Entries

Each month-end a deferred 5,000.00 DKK will be applied against G/L Account 86000. In the contra account(86100) an equal and opposite sign amount will get posted each month end.

What about my processes? How can I automate my processes to post to deferral accounts via C/AL code?

In CU80, at the end of FillInvPostingBuffer we find the following code snippet:

CU80 – Deferral posting

The highlighted method will populate buffers for 1701 (Deferral Header), 1702 (Deferral Line) and 1703(Deferral Post. Buffer), buffers that will be used by codeunit 12 to validate and post these buffers.

When coming in Codeunit 12, Sourcecode = Sale, therefore, the Deferral Post. Buffer(record 1703) is ready and will be processed as part of PostDeferralPostBuffer.

When coming from the General Journal, PostDeferral method will process 1701 and 1702 records to create deferred general ledger entries:

CU12 – Deferral Posting

Custom Deferral Posting:

For your customized processes, it is not enough to generate a general journal line and post it.

Below is an easy to follow template for injecting deferrals in your business processes:

populate the General Journal Line fields

“General Journal Line”.”Deferral Code” should be validated against the “Default Deferral Template Code”(if not empty) of G/L Account recorded in “General Journal Line”.”G/L Account No.”.

If “General Journal Line”.”Deferral Code” <> ” , you need to use something similar to what Microsoft did with the sales invoices:

populate deferral records(1701,1702)

populate deferral buffer(1703)

now everything is ready for processing and posting – in a similar fashion as it takes place with Sales Invoices with deferrals- as part of the Codeunit 12 RunWithCheck() method