Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

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

Posted on by 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

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: HOW TO DELETE TOO MANY " NO TRX." BATCHES IN SERIES POSITNG WINDOW

    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.

  • aMr Hash Profile Picture
    aMr Hash 65 on at
    RE: HOW TO DELETE TOO MANY " NO TRX." BATCHES IN SERIES POSITNG WINDOW

    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,730 on at
    RE: HOW TO DELETE TOO MANY " NO TRX." BATCHES IN SERIES POSITNG WINDOW

    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.

  • Verified answer
    DinB Profile Picture
    DinB 3,812 on at
    RE: HOW TO DELETE TOO MANY " NO TRX." BATCHES IN SERIES POSITNG WINDOW

    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!

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans