Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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
  • 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,730 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,730 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans