Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I am loading a data warehouse. I am looking at the Item and inventory tables. I noticed my main table has a "MODIFIEDDATE" and "CREATEDDATE", but others don't. I do have RECID and RECVERSION columns in the tables that don't have modified and create date... Can I use these to determine the latest data? My coworker, who is much more knowledgable in AX mentioned they are random.
How can I get the latest data to load into the data warehouse without loading the whole table every night... I want to load only changes that occurred within the last day or week.
Any help appreciated.
You can enable CreatedDateTime and ModifiedDateTime for tables where its not enabled.
RecId is not random, it's always incrementing, but you shouldn't use it for this purpose. A long running transaction might have reserved some RecIds which are not yet committed, and if you fetch data to your warehouse during the transaction, new records with smaller RecId than the last one you just fetched to DW might appear into the table.
Business Applications communities