<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

Microsoft released the Revenue Recognition module as part of its 2019 Wave 2 release. In this blog, we will walk through the nuances of enabling this module in Dynamics 365 Finance and Operations. A word of advice here—For the module to work optimally, you’ll need to have the 10.0.5 version of Dynamics 365 Finance and Operations—at the least. If you are on an older version, upgrading to this or the latest version is recommended.

Let’s start with the initial configuration of the module:

  • Three new posting types in sales order postings:
    Microsoft-Dynamics-365-Sales-Order-Posting
  • If revenue recognition is to be used on projects, additional project ledger posting setup:
    Microsoft-Dynamics-365-project-ledger-posting
    Microsoft-Dynamics-365-project-ledger-posting-2
  • Rev rec > Setup > GL parameters:
    • Add new rev rec journal name
    • Add revenue reallocation ID number sequence
      Microsoft-Dynamics-365-general-ledger-parameters
  • Rev rec > Setup > Revenue schedules
    • Automatic hold – Will not recognize revenue until actual occurrence happens. User will manually take off hold and update date if necessary
    • Automatic contract terms – Will automatically set the contract dates on the line item to the SO header delivery date
    • Can set up monthly by days (%s based on # of days in each month) or monthly (evenly over # of months)
    • Can define additional schedules as necessary
      Microsoft-Dynamics-365-revenue-schedules
  • Ability to set up default revenue setup by item group (this will default onto new items setup with this item group)
    Microsoft-Dynamics-365-default-revenue-setup
  • Update existing items:
    • Add revenue schedule to revenue fast tab
    • Update is revenue allocation active = yes, if item should be included in revenue allocation calculation
      Microsoft-Dynamics-365-add-revenue-schedule
    • Sell > Revenue recognition > Revenue prices:
      Microsoft-Dynamics-365-default-revenue-prices
    • Set up revenue price (can be different from sell price based on FMV et
      • If revenue allocation is inactive, there is no need to set up this field. Revenue price will auto-default to be the sales price on the line item
        Microsoft-Dynamics-365-set-up-revenue-priceMicrosoft-Dynamics-365-set-up-revenue-price-2

Let’s now create and confirm a new Sales Order that will use revenue recognition:

  • Item 1000 does not have a revenue recognition schedule and will be recognized at the time of invoicing
    • Unit price and revenue price = $1,900
  • Item A0007 has a 12-month revenue recognition schedule
    • Unit price = $300
    • Revenue allocation price = $400
  • Item S0001 will be recognized at three occurrences
    • Unit price = $250
    • Revenue allocation price = $220
  • The revenue schedule for each item is defaulting from the item setup and can be updated at the time of SO creation:
    Microsoft-Dynamics-365-so-creation
  • Confirm the sales order
  • Select Manage > Revenue recognition > Revenue price allocation
    • You only need to view this form if revenue allocation was set to active on the item (if revenue price does not equal sales price)
    • All three items are included in the calculation (even if they are not on a revenue schedule) because they are part of the contract; also because we need to take all of the revenue prices into account to determine what revenue amount to recognize and what to defer
      Microsoft-Dynamics-365-revenue-price-allocation
    • Total unit price = $2,450
    • Total allocation price - $2,520
    • Unit price/allocation price = Factor of .97
    • Allocation price x .97 = Allocation amount
      Microsoft-Dynamics-365-revenue-allocation
  • Manage > Revenue recognition > Expected revenue recognition schedule:
    • Only items with a revenue recognition schedule will be shown here
      Microsoft-Dynamics-365-default-revenue-recognition-schedule

Invoice the sales order:

  • There is no change to the packing slip postings for the sales order
    Microsoft-Dynamics-365-invoice-sales-order
  • When the invoice is posted:
    • The packing slip is reversed as normal
    • The cost and revenue for any items with a revenue schedule is posted to the deferred accounts setup in the new item posting profiles
      Microsoft-Dynamics-365-posting-profiles

There are periodic tasks in order to post the deferred revenue:

  • Revenue recognition > Periodic tasks > Revenue recognition schedule
    • Can update info here:
      • For installation update to take first occurrence off hold and update date to today
        Microsoft-Dynamics-365-revenue-recognition-schedule-first-occurence
        Microsoft-Dynamics-365-revenue-recognition-schedule-first-occurence-1

      • Users can manually update amount to release, which will auto-update remaining account
      • Can update contract terms from this form; will update schedules and dates. If revenue has already been posted, D365 will create reversing entries and new entries for the updated amounts
    • Can post revenue journal from this form:
      • Create journal
      • Update parameters
        Microsoft-Dynamics-365-update-parameters

    • A journal is created in Revenue recognition > Journal entries > Revenue recognition journals
      • This will create a journal for all revenue within the dates from the parameters
      • Invoice 821 shows the deferred revenue for Item A0007 and S0001, as well as the deferred cogs for A0007
      • Journal will pull in any financial dimensions from the sales order (not just original entry)
        Microsoft-Dynamics-365-financial-dimensions-for-sales-order

Let’s say there is a new contract that has got signed for the same work as the previous sales order. You can create a new sales order for the same customer/contract or update an existing order:

  • Revenue price allocation is blank because there is only one line item
  • Manage > Revenue recognition > Reallocate price with new order lines
  • Select the sales orders to reallocate
    Microsoft-Dynamics-365-sales-order-to-reallocate
  • Click update reallocation
    • Reallocation amounts are now updated as if four lines were in the original sales order
      Microsoft-Dynamcis-GP-original-sales-order
  • Click expected voucher
    • This reverses original invoice and creates new accounting
    • Since AR does not change, the variance between the invoice amount and deferred revenue will be posted to the partial invoice revenue clearing account (new setup in item posting profiles)
      Microsoft-Dynamics-365-expected-voucher
  • Click process to post reallocation
    • This will post to the AR module
        • Reverses original invoice and creates a new invoice – the total AR hasn’t changed but offset revenue accounts has
        • Automatically settles original invoice and reversing, and only new invoice is now open
        • If payment has already been applied, it will get unsettled and resettled against new invoice
          Microsoft-Dynamics-365-ar-module

The revenue recognition module is a flexible framework that helps companies move away from multi-element orders. Instead, it enables them to recognize revenue price and schedule based on a set of company-specific and industry-specific guidelines.

Next read: How to purchase a fixed asset through a PO with Dynamics 365

 

Topics

Discuss this post

Recommended posts

Regulations on the meat industry are higher than many other ones due to the potential risks associated with pathogens stemming from contamination.
Organizations across the world are looking for ways to revamp their businesses with renewed urgency today—thanks to the massive disruption the pandemic has caused (primarily) to their supply chains.
For the healthcare industry, the year 2020 was one of the most demanding ones in recent memory. But the medical device sector did not buckle under the pressure the pandemic created. Instead, it rose to this unprecedented challenge by arresting the dip in its growth to a single-digit figure.
Food manufacturing companies have been having a tough time during the COVID-19 pandemic; primarily in sustaining their day-to-day operations while ensuring food and employee safety.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down