Notifications
Announcements
No record found.
HI All, Wondering any one understand the process of changed data capture with main tables when we export data from F&O to datalake?
For example - this is the snapshot of LogisticsPostalAddress .csv file from the Datalake, I noticed each and every time when I change the data in the F&O -Custtable there will be an entry in this table. So this table holds the previous address and as well as the current address. I can easily write an sql query and get the latest address but my worry is if these table grows Is there any settings in F&O to delete the old entries from the Datalake CSV files. I'm mostly worried about the main Finance related tables as the volumes can grow rapidly on a daily basis. Any pointers will be highly appreciated.
Hi NewRookie,
When you change or delete addresses in Dynamics 365 F&O, the actual records will not be deleted, but they get a timestamp in the ValidTo field which makes the record not an active address. For that reason, there is no delete action triggered. The purpose of this behavior is to be able to do audits on address changes. Dynamics 365 F&O does not have an option to delete addresses from the application and also not for address storage in DataLake.
If you want to clean up older data in Data Lake for the addresses, you have to manage this yourself.
Thanks Andre . One last Query - Is it just the Customer got this behaviour or other master data tables as well? I'm mainly focused on transaction tables for example Ventrans and other GL related tables.
This behavior is with tables which do support date effectiveness. Addresses, currency exchange rates, and HR position assignments are some of the examples. The customer table itself is not supporting the date effective framework. That will trigger delete actions.
You also mentioned transaction tables. Customer, vendor and GL transactions are not deleted from the application.
Thanks Andre
Please don't forget verifying the answer (by using Did this answer your question? > Yes) on the reply (or replies) answering the question.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
