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

(0) Share

Report

Posted on by aMr Hash

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

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (3)

Verified answer

Richard Wheeler 75,730 on at

Like (0)

Report

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 65 on at

Like (0)

Report

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 75,730 on at

Like (2)

Report

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 3,812 on at

Like (2)

Report

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!