<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

A few years ago, when Microsoft launched its ‘Evergreen’ approach, they were really taking on board the version lag that has plagued companies for many years. It allowed Dynamics 365 to update monthly, so the solutions, including all new functionalities, are automatically kept up to date.
There’s no argument that these are challenging times for discrete manufacturers. The pandemic has brought with it a complex set of challenges, and manufacturers are facing a growing skills gap for workers, among other issues. With problems ranging from erratic supply-chain disruptions to employee shortages, charting a steady course can be harder than ever. Manufacturers need all the visibility, intelligent manufacturing processes and visibility to navigate in this business climate.
Careful management of allergens and organics is increasingly important in the food and beverage industry. Manufacturers must closely manage and track both in the production process to avoid cross-contamination, label properly, and meet the expectations of customers, consumers, and regulators. Considering the growing consumer demand for organic and allergen-free products, the payoff of investing time and resources in proper management is worth it. People are paying more attention – and a higher dollar amount – looking for specific products that meet their dietary and lifestyle preferences. If you can reliably produce products that meet those preferences, you can capture their business, build customer loyalty, and remain competitive in your market. Today, properly managing allergens and organics doesn’t have to be a complex, multi-system process. An Enterprise Resource Planning (ERP) with industry-specific features can centralize key aspects of food and beverage manufacturing, saving manufacturers time, reducing risks, and helping them make consistent, quality products with every batch.
Microsoft power platform release plans and Dynamics 365 release plans introduce news features. Numerous new features have been added to the Dynamics 365 applications in this edition. These enhancements include user experience upgrades that will be enabled automatically for users in production environments beginning in October 2021.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down