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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to Delete OPEN Rec...
Finance | Project Operations, Human Resources, ...
Unanswered

How to Delete OPEN Receivables Transaction?

(0) ShareShare
ReportReport
Posted on by claired 5

Hello! 

I really need to inactivate thousands of old customer accounts. However, when I select "Inactivate" in the Customer Maintenance window, I get the error "You cannot inactivate a customer record with unposted or posted transactions. When I go to Transactions by Customer, there are dozens of OPEN receivable transactions preventing the account from being inactivated. We had an error that resulted in dozens of false OPEN receivable transactions per customer for this customer list going back 2 years.

I know it's probably unusual, but I need to delete all the OPEN receivable transactions for a customer list of about 4,000. Or any other way to prevent my staff from using these old customer accounts. 

I can't find anything online on how to do this, so any expertise is greatly appreciated!

THANKS!

Claire 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: How to Delete OPEN Receivables Transaction?

    Hello,

    The community is correct that the supported method would be to create a credit memo to apply to them first, or write-them off, so they are all fully applied.   (This would also reverse the GL entry at the same time.)  Then you could move them to history and use the 'remove transaction history' sales utility to remove the documents from the sales module.

    Removing the records in SQL is possible but not supported.   

    Cheryl

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at
    RE: How to Delete OPEN Receivables Transaction?

    Maybe you could use the 'write-off documents' routine to close these open transactions first

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: How to Delete OPEN Receivables Transaction?

    You can also look into this.

    icancloudapps.com/.../

    I do have a copy of the scripts if you want to try this yourself.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: How to Delete OPEN Receivables Transaction?

    Does your current GL AR balance match your AR TB AR balance? If they match you can try running a macro that will create credit memos for all your open AR documents.

    I have used this in the past.

    https://mahmoudsaadi.blogspot.com/2018/04/move-ar-records-from-history-to-open.html

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 665 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 595 Most Valuable Professional

#3
Yng Lih Profile Picture

Yng Lih 558

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans