Error when running a Manufacturing Standard Cost Rollup/Replace cost in GP: Revaluation in process

Hi Everyone,

If you receive the following error "Revaluation in process", this means that there is currently another user running a rollup/replace cost or there was a rollup/replaced cost that is locked in the system.

Steps to Correct:

Step 1

Run the below scripts:

select * from mops0100 where REVAL_IN_PROCESS_I = 1
select * from mops0100 where RECONCILE_IN_PROCESS_I = 1

If the fields are set to 1, everyone exit Great Plains, make a backup and update the table to show 0 for those two fields.

update mops0100 set REVAL_IN_PROCESS_I =0 where REVAL_IN_PROCESS_I = 1

Step 2

Contact the support desk.