web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Delete a field for mul...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Delete a field for multiple records

(1) ShareShare
ReportReport
Posted on by STP 1,080
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?
  • Suggested answer
    Adis Profile Picture
    Adis 6,997 Super User 2026 Season 2 on at
    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
     
  • STP Profile Picture
    STP 1,080 on at
    @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 6,997 Super User 2026 Season 2 on at
    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 445 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 309 Super User 2026 Season 2

#3
CU29091230-0 Profile Picture

CU29091230-0 192

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans