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
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.
Was this reply helpful?YesNo
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.
8
Share
Report
All responses (
Answers (
