"System message 28002" error when you clear the Allow posting to closed fiscal periods option on the GL Setup screen in Microsoft Dynamics SL
This article provides a solution to an error that occurs when you try to clear the Allow posting to closed fiscal periods check box on the GL Setup (01.950.00) screen.
Applies to: Microsoft Dynamics SL
Original KB number: 2550945
Symptoms
When you try to clear the Allow posting to closed fiscal periods check box on the GL Setup (01.950.00) screen, you receive the following error message:
System Message 28002 - 'Can not disable posting to prior periods because unreleased batches in prior periods exist'.
Cause
This problem occurs when a batch that has a prior period to post hasn't been released yet.
Resolution
To resolve this issue, delete or release the unreleased batch that has a prior period to post. To do it, follow these steps:
Run the following SQL statement in SQL Server Management Studio against your Microsoft Dynamics SL application database to identify the unreleased batch:
selectBatNbr,EditScrnNbr,Status,PerPost,Module,*fromBatchwhereSTATUSIN('B','H')
Identify the batches that have a value in the PerPost field prior to the current fiscal period. Delete or release the batches on the screen that are noted in the EditScrnNbr field.