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 TOO MANY...
Finance | Project Operations, Human Resources, ...
Answered

HOW TO DELETE TOO MANY " NO TRX." BATCHES IN SERIES POSITNG WINDOW

(0) ShareShare
ReportReport
Posted on by aMr Hash 65

Dear All

We have in our company an issue or problem related to

Batches which shown in series posting window

Which also don't contain any transactions inside

The problem exactly is we have in GP 2010 too many

Batches “almost thousands “in all modules (Purchasing, Sales, Inventory, Etc)

As the users have not cleared or deleted them

So please is there a fast & easy way to delete all thSeries-Posting-Batach_2D00_2.pngese batches just in one click

As it is forced to have users to deleted one by one

thanks ..

kindly find attached screenshot of bataches

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Verified answer
    DinB Profile Picture
    DinB 3,951 on at

    If you can Post all the necessary Batches and leave behind only the Batches that need to be deleted, then you can record Macro for deleting few batches and then expand it to delete 100 batches at a time for example.

    When recording Macro, Delete few Batches one by one from the Batch Window. Click on "Next Record" button of the Browse Buttons to delete next Batch. Edit the Macro in Notepad. Copy and Paste the Macro script to delete 100 at a time. Run the Macro in the Batch Window to delete the Batches. In any case, backup database before deleting and check data after running Macro. If you have any unposted Batches that should not be deleted, this method cannot be used.

    Best wishes!

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Are these recurring batches? Batches, when posted, should be removed automatically after posting provided they are not recurring batches. I would first run check links on all your modules to make sure these batches truly have no transactions. Then using SSMS create a query that deletes all records in the SY00500 of your company where NUMOFTRXS is zero. Perform a backup before doing anything of your company database. After deleting the batches run check links again to see if any batches return.

    DELETE SY00500 WHERE NUMOFTRX=0

    With no one in GP in any company you should check the the DYNAMICS..SY00800 AND DYNAMICS..SY00801 are empty as well.

  • aMr Hash Profile Picture
    aMr Hash 65 on at

    Thanks for your replies ..

    no these not recurring batches.. these normal bataches created by users inside 

    modules of GP (Purchasing, Sales, Inventory, Etc)

    but unfortunately when they posting these batches they posted them on trasactions level not batches level which leads to show bataches without transactions ..

    So. Please i would like to ensure that your menstioned code in SqL " DELETE SY00500 WHERE NUMOFTRX=0 "

    will be delete and will affect all bataches with no transactions in all modules whether Purchasing, Inventory,..

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Transaction level posting should not leave batches behind. SY00500 is the Posting Definition Master table and contains only the batch header information. All batch headers for all modules will be in this table. If these batches are truly empty they should not return after you delete run Check Links. Perform a backup before deleting them and run Check  Links.

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 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans