Dynamics Community Forum Thread Details

Integration between CRM and ERP using Dual Writes on Usage in Subscription billing

Dears,

Please note that we have a scenario where we are integrating CRM entity to fill in the Usage Current Amount in the subscription billing Module in D365, the issue is that when we created Un-billed revenue for this Schedule and each time we enter the current reading, the system should create 2 entries one to reverse first Trx in un-billed revenue and second one to create a new Trx with Updated amount, however doing it in dual write will only Enter the Current reading amount with no effect to the Creation of the un-billed revenue amounts. Please advise if there is missing and how i can do this to trigger the system to automatically accept and enter the new date for the journal as if i am entering it manually.

Best

HAYAN

Hi Hayan,

Your scenario—integrating CRM with ERP using Dual Write to populate the Usage Current Amount in the Subscription Billing module—is a nuanced one, especially when it comes to triggering the correct behavior for unbilled revenue entries.

Here’s a breakdown of what’s happening and how you might address it:

Understanding the Issue

In Subscription Billing, when a new usage reading is entered manually, the system:

Reverses the previous unbilled revenue transaction.

Creates a new transaction with the updated amount.

However, when this is done via Dual Write, only the current reading is updated—without triggering the reversal and recreation of unbilled revenue entries.

Why This Happens

Dual Write is designed for data synchronization, not for triggering business logic or workflows. It synchronizes data between Dataverse and Finance & Operations, but it doesn’t automatically invoke the same internal processes that a manual entry would [1] [2].