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 / Microsoft Dynamics GP (Archived) / How to use SQL to dele...
Microsoft Dynamics GP (Archived)

How to use SQL to delete many AR Invoices at one time?

(0) ShareShare
ReportReport
Posted on by Nickolyn Hansen 260

Does anyone now how to mass delete thousands of open AR Invoices from Dynamics GP using SQL script?  Also, what else needs to be taken care to make sure the AR Aging and Financials are correct after deleting the SQL records?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Wassim Rahme Profile Picture
    Wassim Rahme 5 on at

    It's safer to write a script that will move them all to one batch, then manually delete the batch.

    Regards

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    Doing it via SQL if you do not know all of the tables is very risky.

    You can record a macro to delete them in bulk via the front end. Once you have the recorded macro, you can mail merge a list of the invoices to be deleted into the macro.

  • Verified answer
    Nickolyn Hansen Profile Picture
    Nickolyn Hansen 260 on at

    Thanks for everyone's input.  I was able to create the SQL scripts to remove the 17,000+ posted invoices . The client is good to go.

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans