Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Migrate Revenue recognition to Subscription billing

(1) ShareShare
ReportReport
Posted on by 8
Hi All,

Has anybody managed to perform a data migration from Revenue recognition schedules to Subscription billing revenue and expense deferrals?

The available MS documentation https://learn.microsoft.com/en-us/dynamics365/finance/accounts-receivable/sb-revrecsubbillmigration is sketchy and I cannot execute it exactly as the steps imply.
I've managed to get some form of migration performing extract ETL, mapping and imports on top of what the documentation says but there still remains issues transacting on the migrated data.
To be clear, our configuration and processing of new orders under subscription billing works perfect.

I'll try summarise into 3 core issues after attempts to follow the documentation.
-    The revenue schedule and dates against sales orders on the old revenue recognition gets dropped and the blog does not explain migrating this data to the new deferrals template and dates on sales orders open or invoiced. The recommended migration approach only brings balances across and the order deferral details gets lost which can be important when managing old orders and corrections. There is no link created on the imported schedule back to the sales order, setting billing deferral number to sales order number is not sufficient as an import throws out duplicate error if there are multiple sales order lines
-    Performing a credit note against a sales order which had migrated deferrals per the blogs approach, then revenue/deferral information is lost on the sales order thus any credit note does not pick up any adjustment to a schedule or default deferral values from the sales order whose values were migrated. Small volumes of credit notes could be handled by the user in an effort in manually looking up and populating deferral details, but this could not be handled in larger volumes or without introducing human error.
-    Between steps 1 and 2 on the documentation does not explain the ETL exporting line detail (1) to importing header only (2). There are required fields missing; The import fails on sales orders with more than one line. Attempting to provide additional fields on import does not create any link between schedule or set deferral information to the originating order/invoice

Thanks
  • PH-04071037-0 Profile Picture
    PH-04071037-0 2 on at
    Migrate Revenue recognition to Subscription billing
    Hi Community:
     
    For those looking for a solution to automatically move existing Revenue recognition records to Subscription billing deferral schedules, please reach out to  https://binarystream.com/contact-us/ for our help.
     
    We have been able to migrate millions of Revenue recognition records with minimum down time.
     
    I hope you find this information useful.
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans