Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Delete a field for mul...
Finance forum
Unanswered

Delete a field for multiple records

Posted on by 193
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,141 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 193 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,141 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
     

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans