Announcements
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 these batches just in one click
As it is forced to have users to deleted one by one
thanks ..
kindly find attached screenshot of bataches
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.
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,..
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.
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!
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156