A Recurring batch is being created or a Rollback is being Performed 1

[wizwoman]

I get this error message when I try to open batch invoicing "A recurring batch is being posted or a rollback is being performed. Existing records my not be edited at this time" what can I do to correct this error.

 

[Luvsql]

Typically errors such as "being edited by another user" etc can be fixed by the following:

Get all users out of GP.
Run the following sql script;

use tempdb
DELETE DEX_LOCK
DELETE DEX_SESSION
GO
use DYNAMICS
DELETE SY00800
GO

 

[wizwoman]

This didn't resolve the problem. I still get the error message when trying to edit existing records

 

[Luvsql]

Look in the SY00500 table for that batch. What is the BCHSTTS and the MKDTOPST field values?

 

[wizwoman]

The values for BCHSTTUS and MKDTOPST are zero (0) for all bathches.
To duplicate the problem, you do the following:

Transactions:
Sales:
Batch Invoicing:
Reoccuring Maintainance

Then the user cannot click forwards or backwards, and manually type in a batch number.

 

[wizwoman]

does anyone know how to resolve this issue?