Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Delete a field for mul...
Finance | Project Operations, Human Resources, ...
Unanswered

Delete a field for multiple records

(1) ShareShare
ReportReport
Posted on by STP 213
If the customer addresses is imported but found the state is not required, how to clear state for all customer addresses?
Can we achieve it by Data management?
  • Adis Profile Picture
    Adis 2,429 on at
    Delete a field for multiple records
    Hey,
     
    Sorry, I misunderstood. 
     
    I would suggest the following features, depending on your scenario\requirement:
     
    1.: Excel Add-in
    For smaller changes, use the excel add-in. Its limited, but designed for users to use it as well as for admins.
     
    2.: DMF
    For bigger changes, you may consider the Data export\import framework. A bit of setup is necessary here, so it pays off if it is a tasks that you will be doing periodically. Changing the data is based on your input and not on a logic\algorithm,
     
    3.: Custom scripts
    Coding is necessary, but you can do it without downtime or a necessary release. If the logic\algorithm is still valid, you can re-use it multiple times - although you need to do it from different companies 
     
    Kind regards, Adis
  • STP Profile Picture
    STP 213 on at
    Delete a field for multiple records
    @Adis,
     
    This is just an example, I meant what if I wanna delete 1 field for multiple records, it could be Customer Classification Group, Credit limit, etc. How could I delete it?
  • Adis Profile Picture
    Adis 2,429 on at
    Delete a field for multiple records
    Hi,
     
    I would try the following but havent tried myself.
     
    Delete the address field (5) and update the addresses (6).  That should resolve the issue for all customers from the country where this address format is valid. 
    In my screenshot below you find the list which address format is linked to which country.
     
     
     
     
     
     
    Kind regards, Adis
     

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.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans