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

Notifications

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, ... / 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)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    You can also look into this.

    icancloudapps.com/.../

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

  • Deanne CWCO Profile Picture
    Deanne CWCO 250 on at

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

  • Cheryl Waswick Profile Picture
    Cheryl Waswick on at

    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

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans