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 :
Finance | Project Operations, Human Resources, ...
Suggested answer

Cannot Delete Customer

(0) ShareShare
ReportReport
Posted on by

We are getting this error message:

"Customers cannot be deleted while dependent Customer balance statistics exist. Delete dependent Customer balance statistics and try again"

There are not transactions.  Why am i getting this message?

Thanks

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    297,316 Super User 2025 Season 2 on at
    RE: Cannot Delete Customer

    You didn't mention before that you imported the customers. Can you tell how this was done? Are you sure nobody else did try to create e.g. a journal line with this customer?

  • brianmaric Profile Picture
    on at
    RE: Cannot Delete Customer

    When does this table get populated?  Is there a way to prevent it?

    Also, I deleted the record from CredManCustBalanceStat.   Now getting a different error message: 

    The Customer 'CUSTXXXXXX' is used in one or more transactions of the following types: Ledger and cannot be deleted

    Also, credit management is not enabled.  Why, then, is the CredManCustBalanceStat table getting populated when we import.

  • Sheela Ningappa Profile Picture
    on at
    RE: Cannot Delete Customer

    Hi,

    This issue is already reported to the product team and please refer the below LCS link:

    fix.lcs.dynamics.com/.../Details

    Thanks,

    Sheela

  • Gaurangkumar Jani Profile Picture
    4,512 User Group Leader on at
    RE: Cannot Delete Customer

    Hi brianmaric,

    Can you please check is there any unposted transaction related to this customer? such as SO or Any Journal?

    Thanks,

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    297,316 Super User 2025 Season 2 on at
    RE: Cannot Delete Customer

    Hi Brianmaric,

    You can check if there are records for this customer in the table CredManCustBalanceStat. This table is part of the new credit management features. If there is a record in this table, you will get the error you encountered.

  • brianmaric Profile Picture
    on at
    RE: Cannot Delete Customer

    No

  • Suggested answer
    Ramit Paul Profile Picture
    22,780 Most Valuable Professional on at
    RE: Cannot Delete Customer

    Hi,

    Can you check in General section in action pane-> Statistics?

    Is there any value added there?

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 745 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 597 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 580 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans