Applies to Product – Dynamics 365 Finance
What’s happening?
The customer reported that a deleted record from the inventjournaltrans table did not appear in the Azure Synapse data lake. The specific journal ID in question was provided along with a screenshot of the data lake and an export from the source system for reference.
Reason:
This was identified as a bug in the customer's code. Specifically, the deleted record did not have a RecID, which was being used in a join, causing the record not to be reflected in the data lake.
Resolution:
- The customer was advised to check the model.json file, confirming that the field "isdelete" exists for the table inventjournaltrans.
- It was suggested to track changes with the deleted record when exporting using CSV format by following steps mentioned in the relevant documentation.
- The customer was informed that the data might take a few hours to sync and was encouraged to verify the join method in their code to ensure it correctly handles deleted records.
- A follow-up call was scheduled to further investigate the issue and confirm if the problem persists after creating a new profile in the UAT environment.