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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Mass updates to Salesp...
Small and medium business | Business Central, N...
Suggested answer

Mass updates to Salesperson Code using Business Central Excel in Customer table, deletes customer information after publishing

(0) ShareShare
ReportReport
Posted on by Marissa M 15

When I make mass updates to Salesperson code in the Business Central customer records using the BC Excel add-in, after publishing, it clears customer data in business central, mostly the customer name and contact information.

Is this a bug? I'm baffled that it does this. It means we have to manually go back into the customer records and manually input the data that has been deleted.

Any input would be appreciated.

Thanks!

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 94,331 Super User 2025 Season 2 on at
    RE: Mass updates to Salesperson Code using Business Central Excel in Customer table, deletes customer information after publishing

    Hi, I did a simple test and didn't encounter the problem you mentioned. Is there any customization in your environment?

    pastedimage1684888724675v2.png

    pastedimage1684888750101v3.png

    pastedimage1684888758139v4.png

    pastedimage1684888770225v5.png

    pastedimage1684888789991v6.png

    Hope this helps

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,698 Moderator on at
    RE: Mass updates to Salesperson Code using Business Central Excel in Customer table, deletes customer information after publishing

    Please check if there is any customization done, during inserting or updating the reocords as you mentioned. Please try to uninstall that extension and try again.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,791

#2
YUN ZHU Profile Picture

YUN ZHU 2,091 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 2,090

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans