Announcements
No record found.
Hi Experts,
If we want to update any master data we use data import export module or write job to fulfil that requirement .But my requirement is:
All the customers are there but i developed new fields on that customer master and importing data to it any solution ?? Can i write sql queries directly to SQL server db. Thanks in advance.
Best Regards,
Shabir Ahmad
Hi - if the new field value is going to be same for all the customer then you can write a runnable job and use update_recordset and update all the records
But if you want the new fields should be updated in future, then you need to add the new fields in the data entity as well
thanks
Hi Shabir,
SQL would be possible, but it would be better to write an x++ job or extend the data entity. Using an option within AX triggers cache refresh; direct SQL not.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 681
André Arnaud de Cal... 448 Super User 2026 Season 1
Syed Haris Shah 218 Super User 2026 Season 1
