<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

You’re undoubtedly aware of the constant stream of new features and release updates from Microsoft for your Dynamics GP solution. And you’ve probably seen a fair share as well on presentations, articles and social media conversations about the need to upgrade. But how does that affect you?
Is upgrading to Dynamics 365 a priority element of your digital strategy, but you're unsure if now is the right time to do it? Moving to any new technology can be an intimidating decision for an organization because it includes additional costs, infrastructure, working hours and other resources. These common roadblocks do not necessarily apply to the transition to cloud ERP.
It’s no secret that ransomware attacks are increasing. In fact, a business is hit with ransomware every 40 seconds. If ransomware does get a hold of your data, you can pay a large amount of money hoping that you will get your data back. The alternative is to not pay anything and begin your recovery process. Whether you pay the ransom or not, your enterprise loses time and resources dealing with the aftermath.
Manufacturing companies face complex challenges when managing their supply chain processes. Dynamics GP can address most of your industry- and process-specific needs. Have you been able to thoroughly leverage Dynamics GP Manufacturing modules? If you are new to GP or feel like you should be getting more from it, these GPUG classes are for you.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down