Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Mass delete batches in...
Microsoft Dynamics GP (Archived)

Mass delete batches in Master Posting

(0) ShareShare
ReportReport
Posted on by Katie Pieczynski 3,225

Good morning,

I am wondering if there is a way to mass delete empty batches not using SQL?  For example every Monday we get over 30 orders via EDI.  Each order goes into its own batch.  Once the order is processed all the way through the batch status is "No Transactions".  As of right now I am going into each batch via the blue batch ID link and deleting it that way.  It would be nice if there is a way to select multiple.  I have Willowares Mass batch change but I cant seem to figure out if it has a mass delete.

Thank you,

*This post is locked for comments

  • Wassim Rahme Profile Picture
    Wassim Rahme 5 on at
    RE: Mass delete batches in Master Posting

    I guess Leslie's is the only solution so far.

  • Katie Pieczynski Profile Picture
    Katie Pieczynski 3,225 on at
    RE: Mass delete batches in Master Posting

    I just tried to build a new navigation list.  I was able to build it using table SY00500 but it doesn't appear that I can add the delete button into the actions.

  • Wassim Rahme Profile Picture
    Wassim Rahme 5 on at
    RE: Mass delete batches in Master Posting

    Hi Katie,

    If you have SmartList Builder you can create a Navigation List which will then allow you to filter Status=No Transactions and with 2 clicks delete all these batches.

    Good luck

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Mass delete batches in Master Posting

    You'll need to further filter this by Origin=1  to restrict it to Payables Trx Entry batches.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Mass delete batches in Master Posting

    You can create a macro to delete them. Your 'source' for the mail-merge would be a query of the SY00500 table that is attached to an Excel workbook. Limit the query to include on those batches that contain 0 transactions You need to decide if you want to delete all batches with no transactions, or just those from a certain source (like payables). You would then use mail-merge to build your macro. With the macro build all set up, you could use it over and over again. My query looked like this:

    SELECT SY00500.BCHSOURC, SY00500.BACHNUMB, SY00500.NUMOFTRX, SY00500.MKDTOPST, SY00500.BCHTOTAL

    FROM TWO16.dbo.SY00500 SY00500

    WHERE (SY00500.NUMOFTRX=0)

    Kind regards,

    Leslie

  • Katie Pieczynski Profile Picture
    Katie Pieczynski 3,225 on at
    RE: Mass delete batches in Master Posting

    0361.Capture.JPG

  • Katie Pieczynski Profile Picture
    Katie Pieczynski 3,225 on at
    RE: Mass delete batches in Master Posting

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans